Informatica ETL Test Engineer | Data Warehouse

Public Sector Resourcing CWS; Lancashire; Hybrid; GBP 36,000 - 60,000; Full time

Job summary

Public Sector Resourcing CWS is recruiting X3 Informatica Test Engineers for a 12-month Inside IR35 contract across UK offices (Blackpool, Leeds, Newcastle, Birmingham). The role is hybrid, with duties in testing ETL, data warehouses, and data integration projects for the Department for Work and Pensions (DWP).

You will review requirements, execute test scenarios, manage defects, and report progress to senior stakeholders. Strong SQL/Oracle and Informatica experience are essential.

Qualifications

• Strong SQL and Oracle knowledge and data warehouse concepts.
• Experience testing Informatica PowerCenter or IICS.
• Experience testing SAS data pipelines and ETL processes.
• Familiar with Azure DevOps or JIRA for defect mgmt.

Responsibilities

• Review requirements and define test conditions.
• Execute test scripts across test stages.
• Facilitate test planning, estimation and risk assessment.
• Perform defect management, triage, and resolution support.
• Produce clear test reports for stakeholders.
• Validate data mappings, transformations, and migrations.
• Design synthetic test data to validate data quality.

Skills

SQL & Oracle

ETL/ELT testing

Informatica testing

SAS testing

Data warehouse testing

Test mgmt tools

Test automation

Tools

Azure DevOps

JIRA

Job description

Public Sector Resourcing CWS is recruiting X3 Informatica Test Engineers for a 12-month Inside IR35 contract across UK offices (Blackpool, Leeds, Newcastle, Birmingham). The role is hybrid, with duties in testing ETL, data warehouses, and data integration projects for the Department for Work and Pensions (DWP).

You will review requirements, execute test scenarios, manage defects, and report progress to senior stakeholders. Strong SQL/Oracle and Informatica experience are essential.