ETL Tester
Core
Lead QA/ETL testing for large-scale enterprise data systems, validating data mappings, transformations, and loading processes to ensure data quality and integrity.
Role type
Senior QA/ETL Testing Lead
Builds
Enterprise data warehouse systems and ETL pipelines
Domain
Data Warehousing / E-commerce
Deliverable
production ML models | dashboards & analysis
Required skills
ETL testing, Data warehouse concepts (Dimensional modeling, Star/Snowflake schemas), SQL, Data validation, Test planning, Team leadership, Onsite-offshore coordination
Preferred skills
E-commerce domain experience, Large-scale data platforms
Responsibilities
Review business and technical requirements to prepare detailed test plans; Develop and execute ETL test plans, test cases, and test scripts; Validate data mappings, transformations, and loading processes; Perform metadata, completeness, accuracy, transformation, and quality testing; Conduct initial and incremental load testing; Validate data using SQL queries and verify results against business expectations; Perform data reconciliation between source and target systems; Collaborate with data architects and engineering teams; Provide regular status reports and act as a proactive problem solver; Coordinate between onshore and offshore teams for smooth testing execution.
Seniority
Senior, hands-on IC with leadership responsibilities
