Test Lead - ETL and SQL

Job Summary

Test Lead

Key Responsibilities

• Lead and manage QA teams across multiple projects, ensuring timely and high-quality delivery.
• Define and execute test strategies for ETL workflows using tools like IBM DataStage, Azure Data Factory (ADF), or Informatica.
• Perform advanced SQL testing across databases such as Oracle, Snowflake, BigQuery, Synapse, and SQL Server.
• Validate data transformations, data loads, and reconciliation across source and target systems.
• Drive automation initiatives for data validation and regression testing.
• Collaborate with cross-functional teams including data engineers, analysts, and business stakeholders.
• Conduct root cause analysis of data issues and manage defect lifecycle.
• Mentor junior testers and foster a culture of continuous improvement.
• Ensure compliance with data governance, security, and audit requirements.

Required Skills & Qualifications

• 13+ years of experience in software testing, with significant focus on ETL and SQL testing.
• Strong hands-on experience with ETL tools: DataStage, ADF, or Informatica.
• Proficient in writing and optimizing SQL queries across multiple database platforms.
• Proven experience in leading and mentoring QA teams.
• Familiarity with Agile methodologies and DevOps practices.
• Experience with test management tools (e.g., JIRA, TestRail, HP ALM).
• Excellent communication, analytical, and stakeholder management skills.
• Bachelors or Masters degree in Computer Science, Information Systems, or related field.

Preferred Qualifications

• Experience with cloud data platforms (Azure, GCP, AWS).
• Exposure to data observability and monitoring tools.
• ISTQB or equivalent certification.
• Experience in regulated industries such as finance, healthcare, or telecom.