ETL Tester

7 days ago

Gurugram, India Fractal Full time

It's fun to work in a company where people truly BELIEVE in what they are doing

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 clickingin 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

    3 weeks ago

    Gurugram, India Kezan Inc Full time

    Position:ETL Tester(Python+Fast API Experience:4–8 years Location:(Gurugram / Bangalore ) Joining:Immediate / (Specify Notice Period) Budget-14 LPA Job Summary We are looking for a skilledETL Testerto ensure the quality, integrity, and performance of our data integration processes. The role involves validating ETL jobs, verifying data accuracy between...

  • ETL Database Tester

    3 weeks ago

    Gurugram, India SMARTWORK IT SERVICES Full time

    ETL Database TesterLocation : Gurugram / Bangalore, IndiaExperience : 5-10 YearsEmployment Type : Full-timeJob Overview :We are looking for a highly skilled ETL Database Tester with 5-10 years of experience, including 5+ years of dedicated database testing. You'll be instrumental in ensuring the quality and integrity of our data pipelines and...

  • Etl Tester

    1 week ago

    Delhi, Gurugram, NCR, Pune, India Iris Software Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    ABOUT IRIS SOFTWAREIRIS Software Inc is a CMMI ML 5 professional software services organization offering high-quality, cost-effective solutions to businesses. It has helped meeting the IT requirements of companies ranging from those among the Fortune 100 to medium-sized firms by utilizing best-of-breed technologies, rapidly deployable solutions and flexible...

  • ETL Tester

    1 week ago

    Gurugram, Hyderabad, India Zensar Full time ₹ 1,50,000 - ₹ 28,00,000 per year

    Minimum of 6 years of experience in ETL testing, data validation, and quality engineering.Strong expertise in SQL and experience writing complex queries for data validation and analysis.Proficient in ETL tools (e.g., Informatica, Talend, Apache NiFi) and data warehousing concepts.Experience with data quality tools and techniques for data profiling and...

  • Etl Tester

    2 weeks ago

    Delhi, Gurugram, NCR, Noida, India Infosys Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Job description:Hiring etl testing with experience range 4 years & aboveMandatory Skills: etl testing>selenium>etl testingEducation: B.Tech ->BCA -> B.sc

  • Etl Test Engineer

    3 weeks ago

    Gurugram, India Hire Hub It Solutions Full time

    Job Description We are seeking a highly skilled ETL Tester with strong SQL and Python experience to join our data engineering team. In this role, you will be responsible for validating data pipelines, ensuring data quality, and supporting data integration processes by writing robust tests and automations. Responsibilities: Design and execute ETL test cases...

  • Etl Tester

    3 weeks ago

    Gurugram, India Sun Life Global Solutions Full time

    Role & responsibilities Develop, support, deploy and/or test basic technology solutions of limited scale. Understand the software requirements and ensure its translated into good quality production - ready code basis provided design & instructions. Understand the defined scope and timelines and deliver quality deliverable within the estimated time. ...

  • Etl QA Tester

    4 days ago

    Gurugram, Haryana, India Appzlogic Mobility Solutions Pvt Ltd Full time

    Hands-on experience with ETL testing tools, frameworks, and automation (e.g., Clarity with database systems (e.g., Oracle, SQL Server, MySQL) and data warehousing concepts. - Experience in troubleshooting data-related issues, identifying root causes, and proposing effective solutions. - Strong analytical and problem-solving skills, with attention to detail...

  • Big Data Tester

    1 week ago

    Bengaluru, Gurugram, India Kezan Consulting Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    **ONLY FOR IMMEDIATE JOINERS**Position: Big Data TesterExperience: 4+ YearsLocation: ( Gurugram / Bangalore )Joining: Immediate JoinerJob Summary:We are seeking an experienced Big Data Tester with a strong background in HDFS, Hive, ETL testing, and SQL. The ideal candidate will have a experience in Big Data ecosystems, ETL/SQL testing, and in the...

  • Big Data Tester

    3 weeks ago

    Gurugram, India Kezan Inc Full time

    Job Title:Big Data Tester (SQL) Experience:3+Years Location:(Gurugram/Bangalore) Employment Type:Full-Time Job Summary: We are seeking a highly skilledBig Data Tester with strong SQL expertiseto join our team. The ideal candidate will be responsible for validating, testing, and ensuring the quality of large-scale data pipelines, data lakes, and big data...