Etl Tester

4 - 8 years

Hyderabad

Posted:6 days ago

Job Description

ETL Testing / Data Warehouse Testing / Big Data Testing

Experience:

Location:

Key Responsibilities

  • Analyze business requirements, Source-to-Target (S2T) mappings, and data models.
  • Design and execute ETL test cases, test plans, test scenarios, and test strategies.
  • Validate ETL workflows, mappings, transformations, and data pipelines.
  • Perform Source-to-Target validation and Data Reconciliation testing.
  • Execute Database Testing using complex SQL queries.
  • Validate data quality, completeness, consistency, accuracy, and integrity.
  • Perform Data Warehouse (DWH), Data Migration, and BI/Reporting testing.
  • Validate Fact Tables, Dimension Tables, Star Schema, and Snowflake Schema.
  • Verify Full Load, Incremental Load, Batch Processing, and Scheduling Jobs.
  • Identify, log, track, and retest defects using JIRA/ALM/Azure DevOps.
  • Collaborate with Developers, Business Analysts, and Data Engineers to resolve issues.
  • Perform End-to-End Testing across ETL, DWH, and Reporting environments.
  • Participate in Agile/Scrum ceremonies.

Mandatory Skills

  • 4 to 8 years

    of experience in ETL Testing and Data Warehouse Testing.
  • Strong expertise in writing and validating complex SQL queries.
  • Hands-on experience with

    Informatica, DataStage, Talend, SSIS, Ab Initio, Pentaho

    or similar ETL tools.
  • Experience in

    Source-to-Target Validation, Data Reconciliation, Data Validation, and Transformation Validation

    .
  • Strong understanding of ETL workflows, mappings, and business transformation rules.
  • Knowledge of

    Data Warehousing Concepts, Fact & Dimension Tables, Star Schema, Snowflake Schema

    .
  • Experience with databases such as

    Oracle, SQL Server, Teradata, Snowflake, PostgreSQL, MySQL, DB2

    .
  • Experience in

    Full Load and Incremental Load Testing

    .
  • Strong experience with

    JIRA, HP ALM, Rally, Azure DevOps

    .
  • Good understanding of

    SDLC, STLC, and Agile methodologies

    .

Preferred Skills

  • Big Data Testing using

    Hadoop, Hive, HDFS, Spark, Databricks, PySpark

    .
  • Exposure to

    Azure, AWS, or GCP

    .
  • Experience with

    Azure Data Factory (ADF), Azure Synapse, Snowflake, Redshift, Data Lake

    environments.
  • Data Migration and Cloud Migration Testing.
  • BI Testing using

    Power BI, Tableau, Cognos, Business Objects, MicroStrategy

    .
  • Python or Shell Scripting for ETL validation and automation.

Skills Required

DWH testing Big Data Big Data Testing Data Testing Data warehousing Data Warehouse Testing SQL 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

Work from Office

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