Informatica Test Engineer X3

Department for Work and Pensions (DWP); Lancashire; Hybrid; GBP 83,000 - 101,000; Full time

Job summary

Department for Work and Pensions (DWP) seeks X3 Informatica Test Engineers for a 12 month Inside IR35 contract, based hybrid in Blackpool, Leeds, Newcastle or Birmingham. You will review requirements, execute ETL and data validation tests, and manage defects across stages.

Key responsibilities include planning, data quality assessment, and reporting to stakeholders. Experience with Informatica PowerCenter or IICS, SQL, and data warehousing is essential; UK-based working is required.

Qualifications

• Experience testing Informatica PowerCenter or IICS data integration solutions.
• Strong SQL and database knowledge (Oracle, data warehouse).
• Experience with ETL/ELT testing and data warehouse testing principles.

Responsibilities

• Review business requirements and specifications; define appropriate test conditions.
• Execute test scripts, scenarios, and cases across test stages; document results.
• Facilitate test planning, estimation, and risk assessment; manage defects to resolution.
• Design and create synthetic test data to validate data quality, mappings and ETL processes.

Skills

SQL

Oracle

Data Warehousing

Informatica PowerCenter

Informatica IICS

SAS

ETL Testing

Test Automation

Azure DevOps

JIRA

Tools

JIRA

Azure DevOps

Informatica PowerCenter

Informatica IICS

Job description

On behalf of DWP, we are looking for X3 Informatica Test Engineers for a 12 month (Inside IR35) contract based Hybrid in Either Blackpool, Leeds, Newcastle or Birmingham office. The Department for Work and Pensions (DWP) is responsible for welfare, pensions, and child maintenance policy. As the UK's biggest public service department, it administers the State Pension and a range of working age, disability and ill health benefits to around 20 million claimants and customers. As such, we operate on a scale that is almost unmatched anywhere in Europe and most people in Britain come into contact with us at some point in their lives. Working with DWP, you will be helping us to drive our priorities to:

• Help people to move into work and support those already in work to progress, with the aim of increasing overall workforce participation Help people to plan and save for later life, while providing a safety net for those who need it now Provide effective, efficient, and innovative services to the millions of claimants who rely on us every day, including the most vulnerable in society.
• Improve experience of our services while maximising value for money for the taxpayer. As a Informatica Test Engineer, your main responsibilities will be: Review business requirements, 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. Experience identifying, analysing, and resolving data quality issues including completeness, accuracy, consistency, and integrity.
• 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. Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident As a member of the Disability Confident Scheme, DWP guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

Armed Forces Covenant DWP guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

In applying for this role, you acknowledge the following 'this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different'.