ETL Test Engineer

1 week ago

Hyderabad, Telangana, India PalTech Full time

Data Warehouse (DWH) / ETL Test Engineer

Overview:

We are seeking a highly motivated and skilled Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience to join our data team. The successful candidate will be responsible for ensuring the accuracy, completeness, and integrity of data flowing through our Extract, Transform, Load (ETL) pipelines and residing in our enterprise Data Warehouse. This role requires expertise in complex SQL queries, a strong understanding of dimensional modeling, and a commitment to data quality assurance.

Key Responsibilities

  • Test Strategy & Design:
    Design, develop, and execute detailed test plans and test cases for ETL processes, data migrations, and DWH reports/dashboards.
  • Data Validation:
    Perform comprehensive data validation and reconciliation between source systems, staging areas, and the target data warehouse/data marts.
  • Complex SQL Querying:
    Write and execute complex SQL queries (including multi-table joins, subqueries, and aggregate functions) to validate data transformations and business rules.
  • DWH Testing:
    Verify data modeling (star, snowflake schemas), fact and dimension table loading, historical data maintenance, and slowly changing dimensions (SCDs).
  • Pipeline & Tool Testing:
    Test data flow across various ETL tools and technologies (on-premise or cloud-native services).
  • Performance Testing:
    Execute tests to validate ETL job execution performance, ensuring data loads meet defined service level agreements (SLAs).
  • Defect Management:
    Identify, log, track, and retest defects using defect management tools (e.g., JIRA, Azure DevOps, ALM) and communicate status updates clearly to stakeholders.
  • Collaboration:
    Work closely with ETL Developers, Data Architects, Business Analysts, and BI teams to understand requirements and resolve data quality issues.

Required Qualifications (3-6 Years)

  • Experience:
    3-6 years of professional experience dedicated to Data Warehouse (DWH) and ETL testing.
  • SQL Mastery:
    Expert-level proficiency in writing and troubleshooting complex
    SQL
    queries for data comparison, validation, and manipulation.
  • DWH Fundamentals:
    Strong conceptual knowledge of Data Warehousing principles, including dimensional modeling, schemas (star and snowflake), OLAP/OLTP concepts, and data mart design.
  • ETL Testing Lifecycle:
    Proven experience in the full software testing lifecycle (STLC) specific to data projects, including requirement analysis, test planning, execution, and reporting.
  • Tooling:
    Hands-on experience with at least one major ETL tool (e.g., Informatica PowerCenter, Talend, DataStage) OR cloud-native ETL services (e.g.,
    AWS Glue
    ,
    Azure Data Factory
    , or
    GCP Dataflow/Cloud Composer
    ).
  • Communication:
    Excellent written and verbal communication skills, with the ability to explain technical issues to both technical and non-technical audiences.

  • Etl Testing Engineer

    2 hours ago

    Hyderabad, Telangana, India Mouri Tech Full time

    Desired Job attributes:Bachelors degree in computer science, Engineering, or a related field.Proven experience as a ETL/SQL QA Tester or similar role.Thorough knowledge with ETL (extract, transform, load) process and validation points within the processExperience in executing jobs in ETL software, such as Databricks or DataStage.Data testing, Testing in...

  • ETL Testing

    2 weeks ago

    Hyderabad, Telangana, India Virtusa Full time

    Design and execute test plans for ETL processes, ensuring data accuracy, completeness, and integrity.Develop automated test scripts using Python or R for data validation and reconciliation.Perform source-to-target data verification, transformation logic testing, and regression testing.Collaborate with data engineers and analysts to understand business...

  • ETL Test Engineer

    1 week ago

    Hyderabad, Telangana, India ProArch Full time

    About ProArch:Founded in 2006, ProArch began as a tight-knit team of business-minded IT professionals passionate about delivering exceptional cloud-based technology solutions. Today, we've grown into a global force spread across US, UK and India into multidisciplinary experts spanning cloud, infrastructure, data analytics, cybersecurity, compliance, and...

  • ETL Test Engineer

    1 week ago

    Hyderabad, Telangana, India ProArch Full time

    About ProArch:Founded in 2006, ProArch began as a tight-knit team of business-minded IT professionals passionate about delivering exceptional cloud-based technology solutions. Today, we've grown into a global force spread across US, UK and India into multidisciplinary experts spanning cloud, infrastructure, data analytics, cybersecurity, compliance, and...

  • Etl Testing with Python programming

    2 weeks ago

    Hyderabad, Telangana, India Hucon Solutions Full time

    Job Description:We are seeking a talented and detail-oriented Data Engineering and Testing Specialist to join our dynamic team. In this role, you will utilize your expertise in data engineering, Python, BI reporting, ETL processes, and testing methodologies to ensure the quality and integrity of data across our systems and applications. The ideal...

  • ETL Testing Lead

    2 weeks ago

    Hyderabad, Telangana, India, Telangana Tata Consultancy Services Full time

    Role: ETL Testing LeadExperience range: 8-12 yearsLocation: HyderabadJob description:Min 8 to 10 yrs of Exp in ETL Testing.1. SQL - Expert level of knowledge in core concepts of SQL and query.2.Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.3.Create and review...

  • Senior ETL QA Engineer with SQL

    1 week ago

    Hyderabad, Telangana, India hiReign Innoways Full time

    Role DescriptionThis is a full-time hybrid role for a Senior ETL Test Engineer - SQL and Databricks, based in Hyderabad, allowing some work-from-home flexibility. The Senior ETL Test Engineer will play a critical role in designing, executing, and automating efficient testing frameworks. Responsibilities include developing and analyzing test cases, performing...

  • ETL / Dataware House Testing

    11 hours ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    We are hiring forETL / Dataware House Testing .Role: ETL / Dataware House TestingExperience: 5 years to 9 yearsLocation: Hyderabad/ChennaiInterested candidates can send their resume on below mail ID along with below details-Please share below details-Full Name:Email:Contact Details:Total Experience:Current location:Preferred location:Relevant...

  • ETL Tester

    2 weeks ago

    Hyderabad, Telangana, India Virtusa Full time

    ETL Tester is responsible for validating the accuracy, completeness, and reliability of data as it moves through the Extract, Transform, Load (ETL) processThey ensure that data integration workflows and pipelines meet business and technical requirements through rigorous testing and quality assurance practicesETL Testers play a critical role in maintaining...

  • Etl Tester

    2 weeks ago

    Hyderabad, Telangana, India Spadtek Solutions Full time

    Job Description: ETL Test Engineer (Role is on ContracttoHire (C2H): 3month contract, fulltime conversion based on performance )Note: Our client is a leading multinational company (MNC). Specific details about the organization and project will be shared during the interview process.Position OverviewWe are seeking an experienced ETL Test Engineer with strong...