Etl Test Engineer

ETL Testing Engineer Job Description (JD) Job Title ETL Test Engineer / ETL QA Engineer / Data Warehouse Tester 410 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: Informatica Talend SSIS DataStage Ab Initio Knowledge of Data Warehousing concepts: Fact Tables Dimension Tables Star Schema Snowflake Schema Experience 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 Redshift Azure Synapse Snowflake Google BigQuery Exposure to Big Data technologies: Hadoop Hive Spark Knowledge 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. Recruiter Short JD ETL Test Engineer 3+ years of experience in ETL Testing/Data Warehouse Testing. Strong SQL and database testing skills. Experience validating ETL workflows and source-to-target mappings. Hands-on experience with Informatica, SSIS, Talend, DataStage, or similar ETL tools. Knowledge of Data Warehousing concepts (Fact, Dimension, Star Schema). Experience in data reconciliation and data quality validation. Exposure to Cloud Data Platforms (Snowflake, AWS, Azure) is a plus. Experience working in Agile environments. Strong analytical and problem-solving skills. Experience: 4 10 Years Common ETL Testing Interview Keywords ETL Testing Data Warehouse Testing SQL Source-to-Target Validation Data Integrity Data Quality Testing Informatica SSIS Talend DataStage Snowflake AWS Redshift Azure Synapse Fact & Dimension Tables Star Schema Data Reconciliation Regression Testing JIRA Agile Scrum Database Testing Provide your feedback on BizChat Explain Source-to-Target ValidationHow to validate data integrity?What is regression testing in ETL?Drop your files here