01Overview
ETL Testing Engineer Job Description (JD)
Job Title
ETL Test Engineer / ETL QA Engineer / Data Warehouse Tester
1-13 Years
Job Summary
We are seeking a skilled ETL Test Engineer with experience in Data Warehouse, ETL processes, and database testing. The ideal candidate will be responsible for validating data extraction, transformation, and loading processes to ensure data accuracy, integrity, completeness, and consistency across source and target systems.
Key Responsibilities
Analyze business requirements, source-to-target mappings, and ETL specifications.Design and develop ETL test plans, test cases, and test scenarios.Validate data extraction, transformation, and loading processes.Perform Source-to-Target Data Validation (S2T).Verify data completeness, accuracy, consistency, and integrity.Execute database testing using SQL queries.Validate data warehouse, data mart, and reporting systems.Perform data reconciliation between source and target systems.Identify, track, and report defects using JIRA or Azure DevOps.Collaborate with ETL Developers, Business Analysts, and Data Engineers.Perform regression, functional, integration, and end-to-end testing.Ensure compliance with data quality standards and business rules.Participate in Agile/Scrum ceremonies.Required Skills
Strong experience in ETL Testing and Data Warehouse Testing.Strong SQL skills for writing complex queries.Experience with ETL tools such as:InformaticaTalendSSISDataStageAb InitioKnowledge of Data Warehousing concepts:Fact TablesDimension TablesStar SchemaSnowflake SchemaExperience validating large volumes of data.Hands-on experience with Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.Experience with defect management tools such as JIRA.Understanding of Agile methodologies.Preferred Skills
Experience in Cloud Data Platforms:AWS RedshiftAzure SynapseSnowflakeGoogle BigQueryExposure to Big Data technologies:HadoopHiveSparkKnowledge of API Testing.Experience with automation tools and scripting.Data Quality Testing experience.Qualifications
Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.Relevant experience in ETL/Data Warehouse Testing.Experience: 1- 13 Years
Common ETL Testing Interview Keywords
ETL TestingData Warehouse TestingSQLSource-to-Target ValidationData IntegrityData Quality TestingInformaticaSSISTalendDataStageSnowflakeAWS RedshiftAzure SynapseFact & Dimension TablesStar SchemaData ReconciliationRegression TestingJIRAAgile ScrumDatabase Testing .
