QA Tester – ETL Testing (Informatica) & Azure Data Engineering

Job Title: QA Tester – ETL Testing (Informatica) & Azure Data Engineering
Location:

Westminster, London
Type:

Full-time
Department:

Quality Assurance / Data Engineering
Reporting to:

Data Engineering Lead

Job Summary:
We are looking for a skilled and detail-oriented QA Tester with hands-on experience in

ETL testing (Informatica

or Microsoft Fabric) and a strong understanding of

Azure Data Engineering tools

such as

Azure SQL Database ,

Azure Blob Storage , and

Azure Data Factory . The ideal candidate will possess

good hands-on knowledge of writing and executing SQL queries

to validate data across systems. Experience in

Microsoft Fabric

is considered a strong bonus.

Key Responsibilities:
Perform

ETL/data pipeline testing

using

Informatica PowerCenter

or

IICS .
Validate

data ingestion ,

transformation , and

loading processes

across Azure services.
Execute

source-to-target data validation , data profiling, and data reconciliation.
Write and execute complex SQL queries

to validate data transformations, aggregations, and business rules in

Azure SQL Database

and other relational platforms.
Test data flows and integrations involving:
Azure Data Factory (ADF)
Azure Blob Storage
Azure SQL Database
Analyze data mapping specifications and support data quality and audit initiatives.
Log, track, and retest defects using tools like

JIRA

or

Azure DevOps .
Collaborate closely with developers, data engineers, and business analysts.
Contribute to daily Agile ceremonies and maintain clear and detailed QA documentation.

Required Skills & Experience:
3–7 years

of software testing experience, with at least

2+ years in ETL testing using Informatica .
Strong hands-on experience in

writing and executing complex SQL queries .
Experience testing cloud-based data pipelines built on

Azure , specifically:
Azure SQL Database
Azure Blob Storage
Azure Data Factory
Familiarity with

data warehouse testing ,

data transformation logic , and

data quality standards .
Exposure to

test planning ,

test case design , and

defect management .
Strong analytical skills and attention to detail.

Preferred / Bonus Skills:
Experience with

Microsoft Fabric

(OneLake, DirectLake, Data Warehouse, Data Activator) is a significant plus.
Knowledge of

Azure Synapse Analytics ,

Databricks , or

Power BI .
Experience with

automated data validation

or scripting (e.g., Python, PowerShell).
Familiarity with

CI/CD processes

in data environments.
Relevant certifications (e.g.,

Microsoft Certified: Azure Data Engineer Associate ,

Informatica Developer/QA ) are advantageous.