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.