ETL Tester

6 hours 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 doing

We'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 quality and integrity of data extracted, transformed, and loaded into data warehouses and other data repositories. This role involves working closely with developers, data engineers, and analysts to validate data transformations, business rules, and performance across the ETL process.

Key Responsibilities:

ETL Testing:

  • Design, develop, and execute test cases for ETL processes to verify data extraction, transformation, and loading.
  • Validate data at different stages (source, transformation, and destination) to ensure the accuracy and completeness of data.
  • Identify and report data discrepancies, errors, and anomalies during the ETL process, ensuring that they are addressed promptly.
  • Verify data quality rules, business logic, and mappings used in the ETL processes.

Data Validation:

  • Perform data validation and reconciliation between source and target systems to ensure data integrity.
  • Create SQL queries to validate data transformations and conduct data profiling to identify data quality issues.
  • Validate ETL performance, including the efficiency of data loads and transformations, and ensure that SLAs are met.

Test Automation:

  • Develop and maintain automated test scripts to streamline the ETL testing process, using tools and frameworks.
  • Work closely with development teams to integrate automated tests into continuous integration/continuous deployment (CI/CD) pipelines.

Defect Management:

  • Track, manage, and report defects and issues related to the ETL process using defect management tools.
  • Collaborate with the development and data engineering teams to resolve issues and ensure that fixes are applied effectively.

Test Planning and Documentation:

  • Develop detailed test plans, test cases, and test scripts based on business requirements, ETL specifications, and data models.
  • Document test results, test coverage, and data validation processes to ensure comprehensive testing.
  • Provide regular updates on test progress, results, and any issues to project stakeholders.

Collaboration:

  • Work closely with data engineers, developers, business analysts, and QA teams to understand business requirements and technical specifications.
  • Participate in project meetings, provide input on data quality, and contribute to discussions about ETL process improvements.
  • Ensure thorough communication with team members to foster a collaborative environment and solve complex data quality issues.

Continuous Improvement:

  • Continuously review and refine testing processes to improve accuracy, efficiency, and coverage.
  • Stay up to date with industry trends, best practices, and emerging technologies related to ETL testing and automation.

Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 10+ years of experience in ETL testing, data quality assurance, or a similar role.
  • Strong proficiency in SQL for data validation, querying, and analysis.
  • Hands-on experience with ETL tools (e.g., Informatica, Talend, SSIS, AWS Glue, or similar).
  • Familiarity with data warehouse concepts, data models, and database management systems (DBMS) such as Oracle, SQL Server, or PostgreSQL.
  • Experience with test automation tools and frameworks is a plus (e.g., Selenium, JUnit, or custom scripting for data tests).
  • Strong analytical and problem-solving skills with attention to detail.
  • Knowledge of CI/CD pipelines and experience integrating testing in DevOps environments is a plus.
  • Excellent communication and collaboration skills.

Preferred Skills:

  • Experience working with large-scale data environments, data lakes, or cloud platforms like AWS, Azure, or Google Cloud.
  • Experience with BI reporting tools like Power BI, Tableau, or Looker.
  • Knowledge of scripting languages (e.g., Python, Shell scripting) for test automation.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us

Not the right fit?  Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest


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

    6 hours ago


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

    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, DataStage, SSIS, etc.), and good knowledge of data warehouse...

  • Expert ETL Tester

    1 week ago


    Pune, Maharashtra, India beBeeEtl Full time ₹ 15,00,000 - ₹ 28,00,000

    Job Opening: Expert ETL Tester.We are currently seeking a skilled and experienced professional to fill the position of an ETL Tester. The ideal candidate will have a strong background in testing data pipelines, specifically with SQL, as well as automation experience using Java or Python with Selenium.Required Skills:ETL Testing with SQLAutomation using Java...

  • ETL Tester

    5 hours ago


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

    Design, develop, and execute test cases for ETL workflows and data pipelines.Validate data transformations, data quality, and data integrity across multiple systems.Write and run complex SQL queries to verify data extraction, transformation, and loading.Work closely with data engineers and business analysts to understand data requirements and ensure data...

  • Etl Tester

    1 week ago


    Pune, Maharashtra, India E Solutions Full time

    Job Description- Experience onSnowflake, Azure Cloud and DWH- Good Experience in SQL queries- Analyse and understand the Business requirements and ability to convert that to test cases of functional and non-functional components- Identification, Preparation, documentation and execution of Smoke, functional, non-functional, Automation Regression and E2E test...

  • Data Tester

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

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

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

  • Software Tester

    1 week ago


    Pune, Maharashtra, India LTIMindtree Full time

    Hi All, We are conducting Face-to-Face Interview on 20th September at PUNE LTIMindtree . Below skillset candidates can apply (Share updated cv at ) ETL TESTER WITH SQL is Mandatory skill along with that - Automation Java Selenium OR Python Automation Skills Selenium Java Selenium Python with API Automation AWS Cloud data Testing, Cloud Testing, Data...

  • Software Tester

    1 week ago


    Pune, Maharashtra, India LTIMindtree Full time

    Hi All,We are conducting Face-to-Face Interview on 20th September at PUNE LTIMindtree.Below skillset candidates can apply (Share updated cv at chandrani.gupta@ltimindtree.com)ETL TESTER WITH SQL is Mandatory skill along with that -Automation Java Selenium OR PythonAutomation Skills Selenium Java Selenium Python with API AutomationAWS Cloud data Testing,Cloud...