Etl Tester

4 - 8 years

Hyderabad Pune Bengaluru

Posted:1 week ago

Apply

Job Description

ETL Tester - Job Description

Job Title:

Experience:

Job Summary

We are seeking a detail-oriented ETL Tester to validate data extraction, transformation, and loading processes across enterprise data warehouse and reporting systems. The ideal candidate should have strong experience in ETL testing, SQL, data validation, and data warehousing concepts.

Key Responsibilities

  • Analyze business requirements, source-to-target mappings, and data models.
  • Create and execute ETL test cases, test plans, and test strategies.
  • Validate data extraction, transformation, and loading processes.
  • Perform source-to-target data validation and reconciliation.
  • Develop SQL queries to verify data accuracy, completeness, and integrity.
  • Validate data warehouse, data marts, and reporting systems.
  • Perform functional, regression, integration, and system testing.
  • Identify, document, and track defects using tools such as JIRA.
  • Work closely with ETL developers, data engineers, business analysts, and stakeholders.
  • Generate test execution reports and provide testing status updates.

Required Skills

  • Strong experience in

    ETL Testing

    .
  • Hands-on expertise in

    SQL

    (complex queries, joins, subqueries, stored procedures).
  • Experience in testing ETL tools such as

    Informatica, Talend, DataStage, SSIS, Ab Initio

    , or similar.
  • Knowledge of

    Data Warehousing

    concepts including Facts, Dimensions, Star Schema, and Snowflake Schema.
  • Experience in source-to-target data validation.
  • Understanding of data migration and data quality testing.
  • Familiarity with defect tracking tools such as JIRA.
  • Experience working in Agile methodologies.

Preferred Skills

  • Exposure to

    Big Data Testing

    (Hive, Hadoop, Spark).
  • Experience with cloud platforms such as

    AWS, Azure, or GCP

    .
  • Knowledge of BI/reporting tools such as Power BI, Tableau, or Cognos.
  • Basic automation skills using Python or SQL scripting.
  • Experience with data lake and data pipeline validation.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • ISTQB certification is an added advantage.

Key Competencies

  • Strong analytical and troubleshooting skills.
  • Excellent understanding of data flows and transformations.
  • Attention to detail and data accuracy.
  • Good communication and stakeholder management skills.
  • Ability to work independently and collaboratively.

Keywords for Resume Screening

ETL Testing, SQL, Data Warehousing, Informatica, SSIS, Talend, DataStage, Ab Initio, Source-to-Target Validation, Data Migration Testing, Data Quality Testing, Hive, Hadoop, Spark, AWS, Azure, GCP, JIRA, Agile, BI Testing, Tableau, Power BI.

Must-Have Skills:

Skills Required

DWH Testing ETL Testing Big Data Testing Data Warehouse Testing BI Testing Big Data Data Testing Data warehousing

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

Hybrid

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Big Data 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

Hyderabad, Pune, Delhi

Hyderabad, Pune, Bengaluru

Hyderabad, Pune, Delhi

Hyderabad, Pune, Bengaluru