ETL Test Lead (W2 ONLY)
Posted 5 days ago by SumasEdge Corporation
Negotiable
Undetermined
Remote
Remote
Summary: The ETL Test Lead role involves developing and implementing test strategies for data warehousing and ETL processes, ensuring data accuracy and consistency. The position requires technical leadership in automation and team management, along with collaboration with stakeholders for functional requirements and UAT validation. Candidates should possess strong SQL skills and experience in data testing and QA. A bachelor's degree in a related field is required, with additional experience in cloud platforms and BI tools being advantageous.
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).
Key Skills:
- 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.
- Bachelor's degree in computer science, IT, or a related field.
- Experience with cloud platforms (AWS, Azure, Google Cloud Platform) and BI tools (Tableau, Power BI) is highly valued.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Description
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, Google Cloud Platform) and BI tools (Tableau, Power BI) is highly valued