Hybrid Informatica ETL Test Engineer (UK)

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

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.