ETL Data Tester

1 day ago

Pune, Maharashtra, India ITC Infotech Full time US$ 90,000 - US$ 1,20,000 per year

Below is the JD.

We are seeking a highly skilled ETL Data Tester with strong experience in ETL testing, Data Warehousing, and automation using Python. The ideal candidate should also have hands-on expertise in Cloud Data platforms (AWS/Azure) with exposure to Glue, Redshift, Synapse, or equivalent technologies. This role involves validating end-to-end data pipelines, ensuring data accuracy, quality, and performance across complex ETL processes.

Key Responsibilities

  • Perform ETL testing for data pipelines, staging, transformation, and target tables.
  • Validate data extraction, transformation, and loading processes from multiple sources to Data Warehouse.
  • Conduct data quality checks, reconciliation, and validation between source and target systems.
  • Develop automation scripts using Python for data validation and regression testing.
  • Work with AWS Glue, Redshift (or Azure Synapse/ADF) to test and validate cloud data pipelines.
  • Analyze and debug ETL jobs, identify root causes of failures, and validate performance.
  • Collaborate with Data Engineers, Developers, and Business Analysts to understand data mapping and transformation logic.
  • Write SQL queries for data validation, profiling, and reconciliation.
  • Contribute to test strategy, test planning, and reporting for data migration and transformation projects.
  • Support CI/CD pipeline integration for automated data quality testing.

Required Skills & Experience

  • 4 + years of experience in ETL Testing & Data Warehouse Testing.
  • Strong expertise in SQL (complex queries, joins, aggregations, validations).
  • Proficiency in Python scripting for test automation, data parsing, and validation.
  • Hands-on experience in AWS services (Glue, Redshift, S3, Lambda, Athena) or Azure (Data Factory, Synapse, Databricks).
  • Experience in Data Lake, Data Warehousing concepts, and Big Data testing.
  • Strong knowledge of ETL tools (Informatica, Talend, Glue, ADF, etc.).
  • Familiarity with CI/CD pipelines (Jenkins, Git, etc.) for test automation integration.
  • Knowledge of Agile/Scrum methodologies and experience working in data-centric projects.

Good to Have

  • Exposure to PySpark or Pandas for data validation.
  • Experience in performance testing of ETL jobs.
  • Knowledge of data governance and data quality frameworks.
  • Cloud certification in AWS/Azure/GCP.

Education

  • Bachelors/masters degree in computer science, Information Technology, or related field.

  • ETL Tester

    11 hours ago

    Pune, Maharashtra, India Tekskills Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    ETL TesterWork Location: Pune -MHExperience Range : 6-8 YearsJob Description:The ETL Tester will be responsible for validating data movement, transformations, and data quality across different stages of the ETL (Extract, Transform, Load) process. Requires strong SQL skills, analytical thinking, and hands-on experience with ETL tools (Informatica, Talend,...

  • Etl Tester

    1 day ago

    Pune, Maharashtra, India Savi Technologies Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    We have urgent position with our client.Title: ETL Tester with ADF Location: Pune. Experience:5-6 yearsJob Description: The ETL Tester will be responsible for validating data movement, transformations, and data quality across different stages of the ETL (Extract, Transform, Load) process. Requires strong SQL skills, analytical thinking, and hands-on...

  • ETL Tester

    4 weeks ago

    Pune, Maharashtra, India Iris Software Inc. Full time

    Iris Software is looking to hire ETL Tester for Noida, UP/ Gurugram HR / Pune MH location.Job Title: ETL TesterLocation - Noida UP/Gurugram HR/Pune MH (3 days hybrid/week)Experience: 5-10 yearsShift Timing: 1:00 PM to 10:00 PMInterview Mode: Final Interview is In-PersonMajor Skills: ETL, Data Warehousing Testing, Database Testing, SQL (Need strong experience...

  • ETL Tester

    10 hours ago

    Pune, Maharashtra, India Impetus Career Consultants Full time

    Job DescriptionDesignation: - ETL TesterLocation: - Gurgaon/Pune (Remote)Skills: - ETL Testing, Database testing, SQL, Azure devopsJob description:- 5+ years of experience in QA (ETL Tester)- Excellent SQL Skills.- Basic understanding of CI/CD and integration of automation into CI/CD- Effective communication skills and ability to collaborate with developers...

  • Senior ETL Data Tester

    3 days ago

    Pune, Maharashtra, India beBeeEtl Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Role DescriptionOur organization seeks a seasoned ETL professional with expertise in testing and data analysis to join our team. As an ETL tester, you will be responsible for ensuring the accuracy and quality of data processed by our systems.Data Analysis and Quality AssuranceDeveloping and executing test plans, scripts, and cases for ETL...

  • Etl Tester

    1 day ago

    Pune, Maharashtra, India Vedant Consultancy Services Full time US$ 90,000 - US$ 1,20,000 per year

    Position - Lead ETL Tester with Banking Domain ExpLocation - Pune and KolkataMust have Banking domain Exp.Candidates have at least 5 years of experience.ThanksRajat KumarSavi Technologies Inc. -Health insuranceProvident fundOffice cab/shuttle

  • Data Tester

    4 days ago

    Pune, Maharashtra, India Gravity Infosolutions Full time

    Position: Data Tester - Snowflake Experience Required: 6+ Years Type: Full Time Location: Bangalore/Pune/Chennai and Hyderabad About the Role We are seeking a Data Tester with strong hands-on expertise in Snowflake and proven experience in validating data migrations, transformations, and pipelines . This role is critical to ensuring data accuracy,...

  • Data Tester

    6 days ago

    Pune, Maharashtra, India Gravity Infosolutions Full time

    Position: Data Tester - SnowflakeExperience Required: 6+ YearsType: Full TimeLocation: Bangalore/Pune/Chennai and HyderabadAbout the RoleWe are seeking a Data Tester with strong hands-on expertise in Snowflake and proven experience in validating data migrations, transformations, and pipelines. This role is critical to ensuring data accuracy, quality, and...

  • Data Tester

    5 days ago

    Pune, Maharashtra, India Gravity Infosolutions Full time

    Position: Data Tester - Snowflake Experience Required: 6+ Years Type: Full Time Location: Bangalore/Pune/Chennai and Hyderabad About the Role We are seeking a Data Tester with strong hands-on expertise in Snowflake and proven experience in validating data migrations, transformations, and pipelines.This role is critical to ensuring data accuracy, quality, and...

  • ETL Tester

    6 days ago

    Pune, Maharashtra, India Fractal Analytics Full time US$ 90,000 - US$ 1,20,000 per year

    It's fun to work in a company where people truly BELIEVE in what they are doingWe're committed to bringing passion and customer focus to the business.Job Summary: We are seeking a detail-oriented and experienced Testing Engineer to join our team. The ETL Testing Engineer will be responsible for designing, executing, and automating test cases to ensure the...