Etl Tester

6 - 11 years

5 - 13 Lacs

Pune

Posted:4 hours ago

Job Description

Job Summary

ETL Tester

Key Responsibilities

  • Validate

    ETL processes

    from source systems to target data warehouses/datamarts
  • Perform

    data validation, data reconciliation, and data quality checks

  • Develop and execute

    ETL test cases, test scenarios, and test plans

  • Perform

    source-to-target mapping (STTM) validation

  • Validate

    data transformations, aggregations, and business rules

  • Write complex

    SQL queries

    for backend data testing and analysis
  • Identify, log, track, and follow up on

    data defects

    using defect management tools
  • Perform

    end-to-end data testing

    , incremental load testing, and regression testing
  • Validate

    batch jobs, schedules, and workflows

  • Work with large datasets and ensure performance and scalability validation
  • Coordinate with cross-functional teams for requirement understanding and defect resolution
  • Prepare

    test execution reports and data validation summaries

Required Skills

  • 511 years of hands-on experience in

    ETL / Data Warehouse Testing

  • Strong expertise in

    SQL (complex joins, subqueries, aggregation functions)

  • Good understanding of

    ETL tools

    such as:
    • Informatica, Ab Initio, Talend, DataStage, SSIS (any one or more)
  • Experience with

    Data Warehousing concepts

    :
    • Star / Snowflake schema
    • Fact and Dimension tables
    • Slowly Changing Dimensions (SCD)
  • Strong understanding of

    ETL testing types

    :
    • Source-to-target testing
    • Transformation testing
    • Incremental and full load testing
  • Experience with

    Unix/Linux commands

  • Knowledge of

    test management and defect tracking tools

    (JIRA, ALM, etc.)

Skills Required

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

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 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

Hyderabad, Pune, Bengaluru

ADROITENT logo

Etl Tester

ADROITENT

Hyderabad, Pune, Bengaluru

Hyderabad, Pune, Bengaluru

Hyderabad, Pune, Delhi

Hyderabad, Pune, Bengaluru

ADROITENT logo

Etl Tester

ADROITENT

Hyderabad, Pune, Bengaluru