What are the responsibilities and job description for the ETL Test Lead position at CloudIngest?
Position: ETL Test Lead
Location: Atlanta, GA / Charlotte, NC / Raleigh, NC (On-Site)
Rate: $38/hr on W2
Required Skills:
- SQL (Advanced)
- Snowflake
- ETL/Data Warehouse Testing
- Data Validation & Reconciliation
- Test Automation
- Strong knowledge of Test Lifecycle (TDLC) Deliverables
- Test Planning
- Test Case Design & Execution
Job Description:
- Lead end-to-end ETL/Data Warehouse testing strategy for SAS to Snowflake migration and Talend pipelines.
- Design and develop comprehensive test plans, test cases, and test scenarios based on business and technical requirements.
- Perform data validation and reconciliation between source (SAS/ETL) and target (Snowflake) systems.
- Validate complex data transformations, aggregations, joins, and business rules across ETL pipelines.
- Ensure data integrity, accuracy, and completeness throughout the data lifecycle.
- Develop and implement test automation frameworks for ETL/data validation processes.
- Execute and manage UAT cycles, collaborating with business stakeholders for sign-off.
- Track, manage, and resolve defects and data discrepancies, performing root cause analysis.
- Ensure adherence to Test Lifecycle (TDLC) deliverables, including documentation and reporting.
- Collaborate with Developers, Data Engineers, and UAT teams to ensure smooth releases and production stability.
Salary : $38