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

Job Title: QA Tester – ETL Testing (Informatica) & Azure Data EngineeringLocation: Westminster, London Type: Full-time Department: Quality Assurance / Data Engineering Reporting to: Data Engineering LeadJob 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 StorageAzure SQL DatabaseAnalyze 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 DatabaseAzure Blob StorageAzure Data FactoryFamiliarity 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.