Test Lead (ETL Testing)

Role Summary
The QA Lead - ETL Testing is responsible for leading end-to-end quality assurance activities across data integration, ETL/ELT, data warehouse, and analytics platforms. This role oversees test strategy, planning, execution, stakeholder communication, and release governance while ensuring data accuracy, integrity, and compliance. The QA Lead will drive testing excellence across Agile delivery teams and support successful product releases without compromising quality. Lead quality assurance across the full data lifecycle, including sourcing, ingestion, extraction, transformation, Common Data Model mapping, business review and User Acceptance Testing, publication, and downstream consumption.

Key Responsibilities

• Lead end-to-end QA activities across data integration, ETL/ELT, data warehouse, analytics and AI-enabled solutions, ensuring data quality, accuracy, integrity and compliance.

• Define and drive test strategies, plans, quality gates, risk assessments and release readiness across Agile delivery teams.

• Lead testing across the full data lifecycle, from source data and ingestion through transformation, CDM mapping, publication and downstream consumption.

• Oversee functional, integration, regression, UAT, performance and automation testing, ensuring appropriate coverage and traceability.

• Establish and govern data validation, reconciliation, data quality controls and Ground Truth datasets to ensure reliable and reproducible test results.

• Lead defect management, root-cause analysis and quality improvement, working closely with Development, Product, Business and Architecture teams.

• Manage QA resources, workload and priorities across multiple releases and sprint cycles, providing mentoring and guidance to QA team members.

• Define and evolve ETL test automation and data validation frameworks, including reusable regression solutions and CI/CD integration.

• Ensure appropriate test evidence, data lineage, observability and auditability throughout the testing lifecycle.

• Lead non-functional testing of data pipelines, including performance, scalability, resilience, recovery and data-processing reliability.

• Support validation of financial and regulatory data, working with Business and Accounting SMEs to assess expected results, mappings and exceptions.

• Define and execute QA approaches for AI/LLM and agentic AI workflows, including output validation, hallucination detection, traceability, human-in-the-loop controls and reproducibility.

• Provide clear quality status, risk and release-readiness reporting to stakeholders and leadership.

Required Experience & Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

• 10+ years of experience in Software Testing with at least 5+ years in QA leadership roles.

• Proven experience leading ETL/Data Testing programs in Agile delivery environments.

• Strong stakeholder management, communication, and leadership skills.

• Experience managing geographically distributed teams and cross-functional programs.

• Strong analytical, problem-solving, and decision-making capabilities.

Preferred Certifications

• ISTQB Advanced Test Manager / Test Analyst

• Certified Scrum Master (CSM) or SAFe Agile Certification

• Microsoft Azure Data Engineer Associate

• Databricks Fundamentals Certification

• AI/ML Testing or Data Quality related certifications