ETL TEST LEAD

About the role

We are seeking an experienced ETL Test Lead to lead quality assurance and data validation activities across Enterprise Data Warehouse (EDW), ETL, and data integration environments. The ideal candidate will have strong expertise in ETL testing, complex data transformation validation, SQL-based data reconciliation, and end-to-end data quality testing.

Responsibilities

• Lead ETL and EDW testing activities across data integration and data warehouse projects.
• Design and execute comprehensive ETL test strategies, test plans, and test cases.
• Validate complex data transformations, mappings, integrations, and business rules.
• Perform source-to-target data validation and data reconciliation using advanced SQL queries.
• Identify data quality issues, investigate discrepancies, and perform root-cause analysis.
• Validate data completeness, accuracy, consistency, integrity, and transformation logic.
• Coordinate end-to-end testing across source systems, ETL processes, data warehouses, and downstream applications.
• Collaborate with data engineers, developers, business analysts, and stakeholders to resolve data-related defects.
• Support regression, integration, and data migration testing activities.
• Contribute to automated data testing and test automation framework development where applicable.
• Track defects, testing progress, risks, and issues and communicate status to stakeholders.
• Support large-scale data modernization and transformation initiatives.

Requirements

• Strong experience in ETL Testing and Enterprise Data Warehouse (EDW) Testing.
• Extensive experience with data validation, data reconciliation, and data quality testing.
• Strong understanding of ETL processes, data integration, and data transformation.
• Advanced proficiency in SQL for complex queries and data validation.
• Experience validating complex transformation logic, mappings, and business rules.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Experience working in large-scale data or enterprise testing environments.

Preferred Skills

• Experience with test automation frameworks and automated data testing.
• Experience supporting data modernization, migration, or transformation initiatives.
• Knowledge of data warehouse architecture and dimensional modeling.
• Experience with ETL/data integration tools and modern cloud data platforms.
• Familiarity with Agile/Scrum testing methodologies.