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

ZipRecruiter; London; On-site; GBP 40,000 - 70,000; Full time

Job summary

Une entreprise de premier plan recherche un QA Tester spécialisé en tests ETL et ingénierie des données Azure. Le candidat idéal possédera une solide expérience en test de pipelines de données cloud, en particulier avec Informatica et les outils Azure. Vous serez chargé de valider les processus ETL et assurer la qualité des données tout en participant à des cérémonies Agile. Ce rôle offre l'opportunité de travailler sur des projets innovants dans un cadre dynamique à Londres.

Qualifications

• 3-7 ans d'expérience en tests logiciels, avec au moins 2 ans en testing ETL.
• Excellente connaissance de la rédaction et l'exécution de requêtes SQL complexes.
• Expérience dans des environnements de données basés sur Azure souhaitée.

Responsibilities

• Effectuer des tests ETL en utilisant Informatica et valider les processus de loading de données.
• Écrire et exécuter des requêtes SQL pour valider les transformations de données.
• Collaborer étroitement avec les développeurs et les analystes de données.

Skills

ETL Testing

SQL Queries

Data Validation

Data Quality Standards

Agile Methodology

Education

Diplôme en Informatique ou domaine connexe

Tools

Informatica PowerCenter

Azure Data Factory

JIRA

Azure DevOps

Job description

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.

/ 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.