Informatica Test Engineer

Salary: £36,000 - 60,000 per year

Requirements:

• Strong SQL and database knowledge, particularly Oracle and data warehouse structures
• Experience testing Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS) data integration solutions
• Experience testing SAS data pipelines, batch processes, and data transformations
• Strong understanding of ETL/ELT testing methodologies and data warehouse testing principles
• Knowledge of test management and defect management tools such as Azure DevOps, JIRA, or equivalent
• Experience with test automation approaches for data and ETL testing

Responsibilities:

• Review business requirements and functional specifications, and define appropriate test conditions
• Execute test scripts, test scenarios, and test cases across various test stages
• Facilitate test planning, estimation, and risk assessment activities
• Perform defect management, triage, investigation, and support resolution activities
• Produce clear and concise test reports for stakeholders and senior management
• Validate source-to-target mappings, data transformations, reconciliation, and data migration activities
• Design and create synthetic test data to validate data quality, business rules, mappings, and ETL processes
• Identify, analyse, and resolve data quality issues including completeness, accuracy, consistency, and integrity

Technologies:

• Azure
• Cloud
• Data Warehouse
• DevOps
• ETL
• Informatica
• Support
• JIRA
• Oracle
• SAS
• SQL
• Security

More:

We are seeking X3 Informatica Test Engineers for a 12-month Inside IR35 contract, working hybrid from our Blackpool, Leeds, Newcastle, or Birmingham offices. This role is with the Department for Work and Pensions (DWP), the UKs biggest public service department, supporting welfare, pensions, and child maintenance policy and helping millions of claimants and customers every day. We are committed to improving services, supporting people into work, helping people plan and save for later life, and delivering effective, efficient, innovative services while maximising value for money. This role can only be worked within the UK and not overseas. We also support the Disability Confident Scheme and the Armed Forces Covenant, with interview guarantees for eligible candidates who meet the essential criteria.

last updated 39 week of 2026