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.