ETL Data Tester

3 weeks ago

Pune, India ITC Infotech Full time

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

    3 weeks ago

    Pune, India Tekskills Full time

    ETL Tester Work Location: Pune -MH Experience Range : 6-8 Years Job 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

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

    3 weeks ago

    Pune, India Savi Technologies Full time

    We have urgent position with our client. Title: ETL Tester with ADFLocation: Pune.Experience:5-6 years Job 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

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

    3 weeks ago

    Pune, India Synechron Full time

    Good day, We have immediate opportunity for ETL Tester Job Role: ETL Tester Job Location: Pune Experience- 8 Years+ Notice Period: Immediate to 30 days. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver...

  • Etl tester

    11 hours ago

    Pune, India Synechron Full time

    Good day, We have immediate opportunity for ETL Tester Job Role: ETL Tester Job Location: Pune Experience- 8 Years+ Notice Period: Immediate to 30 days. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to...

  • ETL Tester

    3 weeks ago

    Pune, India Synechron Full time

    Good day,We have immediate opportunity for ETL TesterJob Role: ETL TesterJob Location: PuneExperience- 8 Years+Notice Period: Immediate to 30 days.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading...

  • ETL Tester

    2 weeks ago

    Pune, India Synechron Full time

    Good day,We have immediate opportunity for ETL TesterJob Role: ETL TesterJob Location: PuneExperience- 8 Years+Notice Period: Immediate to 30 days.About Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital...

  • ETL Tester

    4 days ago

    Pune, India Synechron Full time

    Good day, We have immediate opportunity for ETL Tester Job Role: ETL Tester Job Location: Pune Experience- 8 Years+ Notice Period: Immediate to 30 days. About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading...

  • ETL Data Warehousing Tester

    2 weeks ago

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

    Position - ETL Tester with Banking Domain Exp.Location PUNE &Must have Banking domain Exp.Candidates have at least 3-4 years of experience.Key Responsibilities:3 years of ETL tester, data warehouse testing experience,Strong understanding of data marts and data warehouse conceptsExpert in SQL with the ability to create source-to-target comparison test cases...