ETL Test Lead

Test Lead will oversee the validation of data pipelines, reporting, and analytic models to ensure accuracy, integrity, and performance.
They lead testing teams to develop test strategies, automate ETL validation, and verify complex data transformations, bridging the gap between technical data engineering and business intelligence.

Key Responsibilities

• Strategy and Planning: Develop comprehensive test strategies, test plans, and test cases tailored for data warehousing, ETL processes, and analytics reporting.
• Data Validation (ETL/BI): Verify data accuracy, completeness, and consistency across source systems, ETL layers, and target data warehouses.
• Automation and Technical Leadership: Implement automation frameworks for testing ETL jobs and data validation, using SQL and scripting languages.
• Team Leadership: Guide a team of analysts/testers, prioritize testing efforts, and ensure project milestones are met.
• Defect Management: Identify, document, and track bugs to closure, conducting root cause analysis for data discrepancies.
• Stakeholder Collaboration: Collaborate with developers and business analysts to define functional requirements and validate UAT (User Acceptance Testing).

Required Skills and Qualifications

• Technical Expertise: Strong proficiency in SQL (queries, procedures, views), ETL tools (Informatica, Talend, etc.), and data warehouse concepts.
• Test Methodologies: Proven experience in data integration testing, regression testing, and data quality testing.
• Analytical Skills: Ability to analyze large datasets to identify patterns or inconsistencies.
• Experience: Several years of experience in data testing or QA, with previous experience leading teams.

Qualifications

• Bachelor's degree in computer science, IT, or a related field.
• Experience with cloud platforms (AWS, Azure, GCP) and BI tools (Tableau, Power BI) is highly valued