Etl Testing Engineer

4 - 9 years

Hyderabad Chennai Bengaluru

Posted:1 week ago

Apply

Job Description

ETL Testing Engineer

Job Title

ETL Testing Engineer / ETL QA Analyst

Experience

3 -10 Years

Job Location

As per business requirement

Job Summary

We are seeking a detail-oriented ETL Testing Engineer with strong experience in Data Warehouse (DWH), ETL processes, and database testing. The candidate will be responsible for validating data extraction, transformation, and loading processes, ensuring data accuracy, completeness, and integrity across source and target systems.

Key Responsibilities

  • Analyze business requirements, data models, source-to-target mappings, and ETL specifications.
  • Design and develop ETL test strategies, test plans, test cases, and test scenarios.
  • Validate data extraction, transformation, and loading processes.
  • Perform source-to-target data validation and reconciliation.
  • Execute database testing using SQL queries.
  • Identify, document, track, and resolve data quality issues and defects.
  • Verify data integrity, data completeness, and data consistency.
  • Perform regression, integration, system, and performance testing for ETL workflows.
  • Validate data warehouse and data mart implementations.
  • Collaborate with ETL developers, business analysts, and data architects.
  • Participate in test execution cycles and provide status reports.
  • Ensure compliance with data governance and data quality standards.

Required Skills

Technical Skills

  • Strong experience in

    ETL Testing

    and

    Data Warehouse Testing

    .
  • Excellent SQL skills with experience in:
    • Complex joins
    • Stored procedures
    • Views
    • Functions
    • Data validation queries
  • Experience with ETL tools such as:
    • Informatica
    • Talend
    • DataStage
    • SSIS
    • Azure Data Factory (ADF)
    • AWS Glue
  • Strong understanding of:
    • Data Warehousing concepts
    • Star Schema
    • Snowflake Schema
    • Fact and Dimension Tables
  • Experience in Data Quality Testing.
  • Knowledge of Unix/Linux commands.
  • Exposure to API and file validation testing (CSV, XML, JSON).

Database Skills

  • Oracle
  • SQL Server
  • PostgreSQL
  • Teradata
  • Snowflake
  • MySQL

Cloud Skills (Preferred)

  • Azure Data Factory
  • Azure Synapse
  • AWS Redshift
  • AWS Glue
  • Google BigQuery

Testing Tools

  • JIRA
  • HP ALM
  • Quality Center
  • Azure DevOps

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Strong analytical and problem-solving skills.
  • Excellent verbal and written communication skills.
  • Ability to work in Agile/Scrum environments.

Preferred Qualifications

  • Experience with Big Data Testing (Hadoop, Hive, Spark).
  • Experience in cloud-based data migration projects.
  • Knowledge of automation frameworks for ETL testing.
  • Certifications in ETL, Data Engineering, Azure, AWS, or Snowflake.

Skills Required

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

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

Hyderabad, Chennai, Bengaluru

Hyderabad, Chennai, Bengaluru