ETL Test Lead

• Title: ETL Test Lead
• Experience: 12 + Years
• Skills: ETL processes, Snowflake, Power BI, Tableau
• Location: Windsor CT

Summary:

We are seeking a highly experienced and technically proficient ETL Test Lead with 12+ years of experience in software testing, specializing in ETL processes, Snowflake data warehousing, reporting/BI validation, and test automation. This leadership role will drive the QA strategy, execution, and governance across complex data ecosystems, ensuring data accuracy, performance, and business alignment.

Responsibilities:

Test Strategy & Planning

• Define and implement robust test strategies for:
• ETL pipelines (data ingestion, transformation, and loading)
• Snowflake data warehouse (schema validation, data integrity, performance)
• BI/reporting tools (Power BI/Tableau/QlikView)
• Automation frameworks for data and API validation
• Develop detailed test plans, test cases, and test data aligned with business and technical requirements.
• Estimate testing efforts, allocate resources, and manage timelines across multiple concurrent projects.

Test Execution & Quality Assurance

• Lead and oversee the execution of:
• Functional testing
• Integration testing
• Regression testing
• Validate data accuracy, completeness, and consistency across source systems, staging layers, and Snowflake.
• Ensure business logic is correctly implemented in reports and dashboards.
• Perform root cause analysis of defects and coordinate with development and data engineering teams for resolution.

Automation & Optimization

• Design and implement automated test suites for:
• Data validation using SQL, Python.
• Integrate automated tests into CI/CD pipelines to support continuous testing and faster releases.
• Continuously evaluate and improve test coverage, efficiency, and reliability.

Stakeholder Collaboration

• Collaborate with cross-functional teams including data engineers, BI developers, product owners, and business analysts.
• Participate in Agile ceremonies such as sprint planning, reviews, and retrospectives.
• Provide regular updates on test progress, risks, and quality metrics to stakeholders and leadership.

Required Skills & Experience:

• 12+ years of experience in software testing, with a strong focus on data and analytics platforms.
• Proven expertise in ETL testing, data validation, and data quality assurance.
• Deep hands-on experience with Snowflake – including querying, performance tuning, and schema validation.
• Advanced SQL skills for complex data validation and transformation logic.
• Experience testing BI/reporting tools such as Power BI, Tableau.
• Proficiency in test automation tools:
• Python/SQL scripts for data testing
• Familiarity with data integration tools like Informatica, Talend Etc.
• Experience with test management tools Jira

Strong understanding of data warehousing, data modeling, and data lake architectures