ETL Test Engineer

2 days ago

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

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

    2 weeks ago

    Hyderabad, Telangana, India Bilvantis Technologies Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Description: ETL Testing - Test LeadWe are looking for a highly skilled and experienced ETL Testing as a Test Lead.Technical Expertise:Experience should have 5 to 7 years into ETL testing.Strong expertise in SQL (writing complex queries, joins, aggregations).Hands-on experience in testing ETL processes (Informatica, Talend, SSIS, DataStage, or...

  • Etl Test Engineer

    49 minutes 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 Test Automation

    1 week ago

    Hyderabad, Telangana, India Bilvantis Technologies Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Description: ETL Test Automation - Senior Test EngineerWe are looking for a highly skilled and experienced ETL Test Automation as a Senior Test Engineer.Technical ExpertiseExperience should have 3 to 5 years into ETL testing.Strong expertise in SQL (writing complex queries, joins, aggregations).Hands-on experience in testing ETL processes (Informatica,...

  • Etl Test Engineer

    2 weeks ago

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

    ETL TesterExp 4 – 7 yearsKey skills – ETL Testing, power BI testing, dashboard testingStrong in analytical skills

  • ETL Testing

    1 week ago

    Hyderabad, Telangana, India Growel Softech Pvt. Ltd. Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    ETL Testing Location- Hyderabad Grade- B2/C1 MOI- L1 -Virtual, L2- F2F Key Responsibilities:Candidate should have experience in ETL Automationand able to understand all DB complex queries and Joins and able to Automate. He should have strong knowledge on JAVA ,OOPSconcepts and Selenium skills. Familiar with Selenium Frameworks/ETL. Knowledge on...

  • ETL Senior Test Engineer QA

    2 weeks ago

    Hyderabad, Telangana, India Adv Techminds Full time ₹ 12,00,000 - ₹ 36,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,...

  • Senior ETL Testing

    1 week ago

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

    Writing and executing test plans and cases for manual and ETL testing.Manages defect tracking, communicates with leads and developers, and ensures QA artifacts are delivered per process.Skilled in automating tests and executing end-to-end QA activities.Expertise in ETL/DW testing, SQL scripting, and structured/unstructured data validation.Familiar with AWS...

  • Etl Testing with Python programming

    1 week ago

    Hyderabad, Telangana, India Hucon Solutions Full time ₹ 5,00,000 - ₹ 10,00,000 per year

    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 Developer

    2 hours 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

    2 weeks 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...