Role Overview
We are looking for an experienced QA Engineer specialising in Data and ETL Testing to support the validation of a metadata-driven Data & AI platform.
The role will focus on validating data accuracy, ETL pipelines, XML-to-JSON transformations, metadata-driven processing, integrations, auditability and end-to-end functionality across a modern Azure data environment.
You will work across Azure Data Factory, Databricks, Azure Data Lake, SQL and Microsoft Foundry AI services, supporting integration, system testing, UAT and go-live activities.
Key Responsibilities
- Review business requirements, source-to-target mappings, metadata specifications and solution designs.
- Develop test strategies, test plans, scenarios, test cases and traceability matrices.
- Identify testability gaps, risks and data requirements.
- Perform source-to-target data validation and reconciliation.
- Validate XML ingestion, parsing and XML-to-JSON transformations.
- Validate field mappings, business rules and transformation logic.
- Perform record count, completeness and data quality checks.
- Test metadata-driven processing across different file types and data sources.
- Validate Azure Data Factory orchestration workflows.
- Test Databricks notebook execution and processing logic.
- Validate control tables, processing statuses and audit trails.
- Test pipeline restart, recovery and error-handling mechanisms.
- Perform end-to-end validation across ingestion, processing and output layers.
- Validate AI-generated JSON content against defined business expectations.
- Test integrations between ADF, Azure Storage, Databricks, Microsoft Foundry AI services and control tables.
- Validate error, duplicate and successful record routing.
- Support compliance evidence, UAT and business validation.
- Log and manage defects through to resolution.
- Perform root cause analysis, retesting and regression testing.
- Produce quality status reporting.
- Support go-live readiness and hypercare.
Required Technical Skills
Data & ETL Testing
5+ years of Data / ETL Testing experience.
ETL / Data Warehouse Testing.
Source-to-target validation.
Data reconciliation and data quality testing.
Strong SQL query development.
Data profiling.
Azure / Data Technologies
- Azure Data Factory (ADF).
- Azure Databricks.
- Azure Data Lake Storage (ADLS).
- Azure SQL / SQL Server.
- Control table validation.
- Understanding of cloud-based data pipelines.
File & API Testing
- XML validation/testing.
- JSON validation/testing.
- API testing.
- CSV and Excel data validation.
- XML-to-JSON transformation testing.
Test Management
- Jira.
- Xray and/or Azure DevOps.
- Test planning and traceability.
- Defect lifecycle management.
- Agile/Scrum testing experience.
Experience Required
- 4+ years' overall Software Testing experience.
- 5+ years' Data Testing / ETL Testing experience.
- Strong experience testing Azure-based data platforms.
- Strong SQL skills, including complex queries for data validation.
- Experience with API, XML and JSON testing.
- Experience working within Agile/Scrum delivery environments.
- Strong understanding of integration and end-to-end testing.
Nice to Have
- Life Sciences / Pharmaceutical experience.
- Pharmacovigilance domain experience.
- Experience working within regulated environments.
- Knowledge of GxP / CSV / Computer System Validation.
- Azure certifications.
- ISTQB certification.
- Experience validating AI / Generative AI outputs.
Reference: CR/136237_1786612342
Date: 13 Aug 2026