Software Test Engineer

4 - 9 years

Hyderabad Pune Mumbai

Posted:1 week ago

Apply

Job Description


ETL Testing Engineer

Job Title

ETL Testing Engineer / Data Warehouse Tester

Experience

3 -10 Years

Job Summary

We are seeking a skilled ETL Testing Engineer to validate data extraction, transformation, and loading processes in data warehouse and business intelligence environments. The ideal candidate should possess strong SQL skills, hands-on ETL testing experience, and expertise in data validation and quality assurance.

Key Responsibilities

  • Analyze business and technical requirements related to data migration and ETL processes.
  • Design and execute ETL test cases, test plans, and test scenarios.
  • Validate data extraction, transformation, and loading from source systems to target databases.
  • Perform data integrity, completeness, and reconciliation testing.
  • Verify data mappings, transformation rules, and business logic.
  • Execute database testing using complex SQL queries.
  • Identify, document, and track defects through defect management tools.
  • Perform regression, integration, system, and UAT support testing.
  • Validate data quality and consistency across multiple platforms.
  • Collaborate with developers, data engineers, business analysts, and stakeholders.
  • Prepare test metrics, reports, and test execution status updates.

Required Skills

  • Strong knowledge of ETL Testing concepts and methodologies.
  • Hands-on experience with ETL tools such as:
    • Informatica
    • SSIS (SQL Server Integration Services)
    • Talend
    • DataStage
    • Ab Initio
  • Advanced SQL skills for data validation and reconciliation.
  • Experience with Data Warehouse concepts including:
    • Star Schema
    • Snowflake Schema
    • Fact and Dimension Tables
    • Slowly Changing Dimensions (SCD)
  • Experience with database platforms such as Oracle, SQL Server, MySQL, PostgreSQL, or Teradata.
  • Expertise in data quality and data migration testing.
  • Familiarity with defect tracking tools (JIRA, Azure DevOps).

Preferred Skills

  • Automation experience using Python, Selenium, or ETL automation frameworks.
  • Experience with cloud data platforms:
    • Azure Data Factory (ADF)
    • Azure Synapse
    • AWS Glue
    • Snowflake
    • Databricks
  • Knowledge of Big Data technologies (Hive, Hadoop, Spark).
  • Understanding of CI/CD and DevOps practices.
  • Performance and volume testing experience.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
  • Certification in ETL, Data Warehousing, or Database technologies is a plus.

Skills Required

DWH Testing ETL Testing Data Warehouse ETL Testing Data Warehouse Testing Software testing 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

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

P

Software Test Engineer

Praveetech Pvt Ltd

Pune

B

Software Test Engineer

Blue Pearl Health Tech Pvt Ltd

Pune

Easemytrip logo

India

Avya Technology Pvt. Ltd. logo

Software Test Engineer

Avya Technology Pvt. Ltd.

Noida

G

Software Test Engineer

Global Tech Byte Private Limited

Chennai

Calix India logo

Bengaluru

Codewalla logo

Chennai

H
J

Bengaluru