ETL Data Tester

1 day 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

    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

    1 day 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 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

    1 day 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

    3 days ago

    Pune, Maharashtra, India Ashra Technologies Pvt Ltd Full time

    Greetings from Ashra Technologies we are hiring Job Role: ETL Tester Experience Required: 5+ Years Location: Pune, Mumbai Notice Period: Immeditae to 15 Days 5 + years of experience in ETL Testing/DWH Testing. - Strong understanding of data migration / transformation and its methodologies. - Extensive experience in Database/ETL data validations,...

  • ETL Tester

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

  • 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...

  • ETL Tester

    3 days ago

    Pune, India Impetus Career Consultants Full time

    Job Description Designation: - ETL Tester Location: - Gurgaon/Pune (Remote) Skills: - ETL Testing, Database testing, SQL, Azure devops Job 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...

  • Etl Tester

    2 weeks ago

    Hyderabad, Mumbai, Pune, India Artech Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Work Location: Pune -MHSkill Required: Digital : Data Migration TestingExperience 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...

  • Etl Tester

    6 days ago

    Pune, Maharashtra, India Ashra Technologies Pvt Ltd Full time

    Proficiency in SQL and experience with Snowflake. - Strong understanding of data warehousing concepts and ETL processes with **8+ years’ experience**: - Experience with data modeling and database design. - Familiarity with cloud platforms such as AWS, Azure, or Google Cloud. - Excellent analytical and problem-solving skills. - Strong communication and...