Apply in 3 Minutes! QA Tester - ETL Testing (Informatica) & Azure Data Engineering...

Job Description

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.