ETL Test Engineer

4 hours ago

Hyderabad Telangana India, Telangana 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 Test Engineer

    4 hours ago

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

    Role: ETL Test EngineerExperience range: 7-10 yearsLocation: HyderabadNOTE: Relevant experience in ETL must 7 yearsJob description:Min 7 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...

  • ETL Test Engineer

    4 hours ago

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

    Role: ETL Test EngineerExperience range: 7-10 yearsLocation: HyderabadNOTE: Relevant experience in ETL must 7 years 5+ yrs - SQL - Expert level of knowledge in core concepts of SQL and query, Informatica, Talend and Ab initio, BI concepts - OLAP vs OLTP, Data warehouse and data modelingJob description:Min 7 to 10 yrs of Exp in ETL Testing.1. SQL - Expert...

  • ETL Testing Engineer

    5 days ago

    Hyderabad, Telangana, India Primera Medical Technologies Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    The primary role of an ETL tester is to ensure that the data integration process is functioning correctly, and that the data being transformed and loaded meets the expected quality standards. Here are some key responsibilities and activities performed by an ETL testerRole & responsibilities :The primary role of an ETL tester is to ensure that the data...

  • ETL Test Engineer

    2 weeks ago

    Hyderabad, Telangana, India PalTech Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Data Warehouse (DWH) / ETL Test EngineerOverview: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...

  • Etl Test Engineer

    2 weeks ago

    Hyderabad, Telangana, India Ltimindtree Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Hi,Please share your updated resume with below details :Total Exp in ETL Automation Tester:5-8 years of expETL Testing Validation.Design develop and executetest plans test cases and test scriptsfor ETL workflowsValidatedata extraction transformation and loadingprocedures across staging DWH and DataMart layersPerformdata reconciliation row count checks and...

  • ETL Testing Role

    5 days ago

    Hyderabad, Telangana, India Talent Worx Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Position: ETL Testing RoleWe are excited to announce an opening for an ETL Testing Role at Talent Worx. The successful candidate will focus on validating ETL processes to ensure high data quality and integrity throughout our data pipelines. You will collaborate with data teams to ensure that data is accurately extracted, transformed, and loaded from a...

  • Sr - ETL Test Engineer

    1 week ago

    Hyderabad, Telangana, India hiReign Innoways Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Experience: Minimum YearsShift: 5PM - 2 AM (US Shift)Mode of work: REMOTE - Work from HomeLocation: Hyderabad OnlyBackground Verification of the candidates will be done.Strictly NO moonlighting.Qualifications:Experience years in Quality Engineering, particularly in data/ETL testing; leadership in Data Modernization initiatives preferred.Technical...

  • ETL Senior Test Engineer QA

    3 days ago

    Hyderabad, Telangana, India Adv Techminds Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Title: ETL Senior Test Engineer QARole: Remote ConsultantLocation: RemoteShift: 8 am 5 pmNumber of Positions: 2Key Responsibilities:ETL testing experience with Unix command tools (WinSCP, Putty)Upstream and downstream application testing for online web services/APIs and batch processes (Autosys)File manipulation (delimited, fixed width,...

  • ETL Testing Developer

    2 weeks ago

    Hyderabad, Telangana, India Wipro Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Strong ETL testing experience Experience writing SQL queries Experienced with TOAD Strong knowledge of software QA methodologies, tools and processes Ability to create detailed, comprehensive test plan and test cases/scripts based on Stories Execute manual test casesFamiliar with the life cycle of projects (DEV, SIT, UAT) Open and manage defects to closure...

  • ETL Data testing

    3 days ago

    Hyderabad, Telangana, India People's Growth HR Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Title: ETL Data TestingLocation: RemoteNotice Period: (Immediate Joiner - Preferred)Experience: 5+ YearsWhat youll do:Key Responsibilities: Select and integrate data tools and frameworks to provide requested capabilities. Provide technical guidance to software engineers in designing, coding, reviewing, and testing enterprise software. Collaborate with...