Etl Test Engineer

4 - 9 years

Hyderabad Chennai Bengaluru

Posted:1 week ago

Apply

Job Description

ETL Tester

Job Title

ETL Tester / Data Warehouse Tester

Experience

3 to 10 Years

Job Summary

We are looking for an experienced ETL Tester to validate data extraction, transformation, and loading processes across enterprise data warehouse platforms. The candidate will be responsible for ensuring data accuracy, completeness, consistency, and integrity while testing ETL workflows, databases, and reporting systems.

Key Responsibilities

  • Analyze business requirements, source-to-target mappings, and ETL design documents.
  • Create and execute ETL test cases, test scenarios, and test scripts.
  • Validate data extraction, transformation, and loading processes.
  • Perform source-to-target data validation and reconciliation.
  • Conduct database testing using SQL queries.
  • Identify, log, track, and retest defects through closure.
  • Validate data quality, data integrity, and data consistency.
  • Execute regression, integration, system, and UAT support testing.
  • Collaborate with ETL developers, business analysts, data engineers, and stakeholders.
  • Validate data warehouse and reporting data against business requirements.
  • Prepare test execution reports and testing metrics.

Required Skills

Technical Skills

  • Strong experience in ETL Testing and Data Warehouse Testing.
  • Proficiency in SQL for complex queries, joins, subqueries, and data validation.
  • Experience with ETL tools such as Informatica, Talend, DataStage, SSIS, AWS Glue, or Azure Data Factory.
  • Strong understanding of Data Warehousing concepts, Star Schema, and Snowflake Schema.
  • Experience in source-to-target mapping validation.
  • Knowledge of database systems like Oracle, SQL Server, PostgreSQL, MySQL, or Teradata.
  • Experience with defect tracking tools such as Jira or Azure DevOps.
  • Understanding of data migration and data quality testing.

Preferred Skills

  • Experience in Big Data testing (Hadoop, Hive, Spark).
  • Exposure to cloud platforms such as AWS, Azure, or GCP.
  • Knowledge of automation testing tools and scripting.
  • Familiarity with CI/CD processes and DevOps practices.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
  • Relevant experience in ETL/Data Warehouse Testing.

Skills Required

Data Warehouse Testing DWH Testing ETL Testing Software testing Data warehousing ETL Data Warehouse

Learn the skills this job asks for

See your skill gap for QA / Test Engineer →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Infosys logo
Infosys

IT Services and IT Consulting

Bangalore Karnataka

RecommendedJobs for You

Chennai, Bengaluru, Mumbai

Expleo logo

Navi mumbai

Hyderabad, Chennai, Bengaluru

Hyderabad, Chennai, Bengaluru

Hyderabad, Pune, Mumbai

Hyderabad, Pune, Bengaluru

Chennai, Bengaluru, Mumbai

Expleo logo

Navi mumbai

Hyderabad, Chennai, Bengaluru