What are the responsibilities and job description for the ETL Test Lead position at Coforge?
- Title: ETL Test Lead
- Experience: 12 Years
- Skills: ETL processes, Snowflake, Power BI, Tableau
- Location: Houston TX
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