ETL Test Engineer

4 days ago

Gurgaon, Haryana, India Capgemini Full time ₹ 6,00,000 - ₹ 18,00,000 per year

Role & responsibilities

Role Overview

  • We are looking for an experienced Software Development Engineer in Test (SDET) with strong expertise in ETL testing, database validation, and Python-based automation.
  • The ideal candidate will ensure data integrity and accuracy across ETL pipelines and data warehouse systems, while leveraging deep technical and analytical skills.
  • Exposure to the banking domainespecially Corporate & Institutional Banking and Personal Bankingwill be a strong advantage.

Key Responsibilities


• Design and develop Python-based automation frameworks and reusable utilities for ETL validation and data reconciliation.


• Conduct end-to-end ETL testing, including source-to-target validation, transformation logic verification, and data completeness checks.


• Write, review, and optimize SQL queries (joins, CTEs, window functions) to validate complex business rules and data transformations.


• Execute Unix/Linux commands and shell scripts for ETL job monitoring, file validation, and log analysis.


• Work with Mainframe systems for flat file validation, dataset checks, and job executions in ETL processes.


• Test data warehouse components such as staging, fact, and dimension tables, including Slowly Changing Dimensions (SCDs).


• Integrate automated validation into ETL CI/CD pipelines (Jenkins, GitHub Actions).


• Collaborate with ETL developers, data modelers, and business analysts to investigate issues and ensure accurate data flow across banking systems.


• Prepare test evidence, automation reports, and dashboards for traceability and coverage metrics.

Must Have


• Strong proficiency in Python (pandas, pyodbc, data comparison and validation frameworks).


• Expertise in SQL — complex joins, aggregations, subqueries, and analytical functions.


• Strong understanding of Oracle databases/datawarehouse and relational data modeling.


• Proficiency in Unix/Linux commands (grep, awk, sed, shell scripting).


• Basic knowledge of Mainframe systems for dataset handling.


• Good understanding of Data Warehousing concepts — staging, data marts, fact/dimension modeling, and SCD handling.


• Familiarity with test management tools (Rally, JIRA, Qtest) and CI/CD tools (Git, Jenkins).

  • ETL Testing

    2 weeks ago

    Gurgaon, Haryana, India Talent Worx Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Position: ETL Testing EngineerLocation: RemoteExperience: 3-6 yearsWe are seeking a skilled ETL Testing Engineer to join our team. In this role, you will be responsible for validating the ETL processes and ensuring that data is accurately extracted, transformed, and loaded from various sources to data warehouses. You will work closely with data analysts and...

  • ETL Testing

    2 weeks ago

    Gurgaon, Haryana, India Talent21 Full time ₹ 2,00,000 - ₹ 6,00,000 per year

    ETL TestingGurugram LocationExperience Range Min 3-5 YearsOnly Immediate -15 Days JoinerRequired Skills: Testing, PL/SQL & Python.Detailed JD:testing retirement is for Pl/SQL experience with Python knowledge. Data is not mandatory.They are even ok for 1-2 years experience associate also with real project experience doing testing.Customer wants these...

  • Mobility - Senior ETL Test Engineer

    2 weeks ago

    Gurgaon, Haryana, India Appzlogic Full time ₹ 8,00,000 - ₹ 20,00,000 per year

    About the Role : We are seeking an experienced ETL Test Engineer with strong expertise in cloud-based ETL tools, Azure ecosystem, and advanced SQL skills. The ideal candidate will have a proven track record in validating complex data pipelines, ensuring data integrity, and collaborating with cross-functional teams in an Agile environment. Location...

  • ETL Tester

    1 week ago

    Gurgaon, Haryana, India Adescare Technologies INC Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Job Title:ETL TesterLocation:Gurugram, IndiaExperience:3 – 6 YearsWork Mode:Onsite / Hybrid (as per project requirement)Employment Type:Full-time / ContractAbout the RoleWe are looking for a detail-orientedETL Testerwith strong hands-on experience inSQL, API testing, Linux, andSOAP UI. The ideal candidate should be able to validate data across multiple...

  • ETL - Pyspark Testing - Strong SQL Professional

    1 week ago

    Gurgaon, Haryana, India IDESLABS PRIVATE LIMITED Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    At least 6-8 yrs of experience in ETL Testing with Automation Testing Expert in database testing using SQL. Must have worked on Databricks and aware of Databricks related concepts Check the data source locations and formats, perform a data count, and verify that the columns and data types meet the requirements. Test the accuracy of the data, and its...

  • Automation Test Engineer

    1 week ago

    Gurgaon, Haryana, India Innova ESI Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Role: Automation Test Engineer - PlaywrightExperience: 8 to 12 YearsLocation: Gurugram / Delhi NCR / BangaloreNotice: Immediate Joiners OnlyMust-have skillsProgramming languages ( Java, Python, JavaScript )Automation frameworks – Playwright (Preferably) or SeleniumExpertise with API testingExperience integrating tests with CI/CD tools like...

  • ETL Developer

    4 days ago

    Gurgaon, Haryana, India Flairdeck Consulting Full time ₹ 4,28,000 - ₹ 13,00,000 per year

    Job Summary:We are seeking a skilled and experienced ETL Developer with strong proficiency in Informatica PowerCenter, Teradata, and end-to-end ETL processes. The candidate will be responsible for the design, development, testing, and maintenance of scalable ETL workflows to support enterprise data integration, warehousing, and reporting solutions.Key...

  • Test Lead

    2 weeks ago

    Gurgaon, Haryana, India Incedo Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Company Overview Incedo is a US-based consulting, data science and technology services firm with over 3000 people helping clientsfrom our six offices across US, Mexico and India. We help our clients achieve competitive advantage throughend-to-end digital transformation. Our uniqueness lies in bringing together strong engineering, data science, anddesign...

  • Sr Test Automation Engineer

    1 week ago

    Gurgaon, Haryana, India Weekday AI Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    This role is for one of the Weekday's clientsMin Experience: 8 yearsLocation: NCR, Gurgaon, Delh, New Delhi, NoidaJobType: full-timeWe are seeking a highly skilled Senior Test Automation Engineer with strong expertise in Python, ETL testing, cloud technologies, and automation frameworks. The ideal candidate should excel in hands-on testing, data validation,...

  • Sr Test Automation Engineer

    6 days ago

    Gurgaon, Haryana, India Weekday AI Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    This role is for one of the Weekday's clientsMin Experience: 8 yearsLocation: NCR, Gurgaon, Delh, New Delhi, NoidaJobType: full-timeWe are seeking a highly skilled Senior Test Automation Engineer with strong expertise in Python, ETL testing, cloud technologies, and automation frameworks. The ideal candidate should excel in hands-on testing, data validation,...