ETL Test Lead

TechDigital Group; Frisco (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

TechDigital Group is seeking a Test Lead in Frisco, Texas, to oversee the validation of data pipelines, reporting, and analytic models. Responsibilities include developing test strategies, automating ETL validation, and ensuring data integrity while leading a team of testers. Candidates should have a Bachelor's degree in computer science or IT, strong SQL skills, and several years of experience in data testing and team leadership. Knowledge of cloud platforms and BI tools is highly valued.

Qualifications

• Strong proficiency in SQL for data manipulation.
• Experience with ETL tools and data warehousing concepts.
• Proven track record in data integration and quality testing.
• Several years of experience in data testing or QA, ideally with team leadership.

Responsibilities

• Develop comprehensive test strategies for data processes.
• Verify data accuracy and consistency across systems.
• Implement automation frameworks for testing ETL jobs.
• Guide and prioritize team testing efforts.
• Document and track bugs through to resolution.
• Collaborate with developers and business analysts on requirements.

Skills

SQL proficiency

ETL tools knowledge

Data validation experience

Test methodologies expertise

Analytical skills

Education

Bachelor's degree in computer science or IT

Tools

Informatica

Talend

AWS

Azure

GCP

Tableau

Power BI

Job description

Overview

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