ETL Database Tester

3 weeks ago

Gurugram, India SMARTWORK IT SERVICES Full time

ETL Database Tester

Location : Gurugram / Bangalore, India

Experience : 5-10 Years

Employment Type : Full-time

Job 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 warehousing solutions. This role requires strong proficiency in PL/SQL, complex query writing, a solid understanding of DWH concepts, and experience with ETL tools like Informatica. You'll work on understanding intricate requirements, designing robust testing strategies, and contributing to high-quality data deliveries.

Key Responsibilities :

- Perform strong hands-on database testing for ETL processes and data warehouse solutions.

- Utilize advanced PL/SQL skills to read and write stored procedures, functions, and complex SQL queries involving arithmetic and aggregate functions.

- Apply knowledge and understanding of Snowflake for data validation and testing activities.

- Develop and execute scripts using Python programming for data analysis, validation, and test automation.

- Work extensively on DWH (Data Warehouse) projects, demonstrating clear understanding of DWH concepts, including Kimball/Inmon methodologies.

- Possess a deep understanding of ETL tools like Informatica to effectively test data transformations and loads.

- Analyze complex data requirements and design comprehensive testing strategies tailored to those requirements.

- Demonstrate excellent knowledge of the testing life cycle and apply hands-on experience in testing deliveries, from test planning to execution and reporting.

- Conduct API testing for data integration points, specifically familiar with REST and SOAP protocols.

- Collaborate with ETL developers, data architects, and business analysts to ensure data quality and consistency.

- Identify, document, and track defects, ensuring timely resolution and retesting.

Required Skills & Experience :

- 5+ years of relevant experience in Database testing.

- Strong PL/SQL skills, including the ability to read and write stored procedures, complex queries, arithmetic functions, and aggregate functions.

- Knowledge and understanding of Snowflake data warehouse.

- Proficient in Python programming for data analysis and testing.

- Experience in a DWH project with clear DWH concepts and understanding of ETL Tools like Informatica.

- Able to understand complex requirements and draft comprehensive testing strategies around them.

- Excellent knowledge of the testing life cycle and hands-on experience in testing deliveries.

- Familiar with API testing (REST and SOAP).

Experience Required :

- Experience in reporting tools like PowerBI.

- Experience with Snaplogic and AWS cloud services.

- Experience in job scheduling with tools like Control-M / NiFi.

- Sound knowledge of the finance domain.

- Automation knowledge will be good to have.


(ref:hirist.tech)

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

  • Database Tester

    2 weeks ago

    Gurugram, Gurugram, India Kezan Inc Full time

    Job Description Position: Database Tester Experience: 4+ Years Location: ( Gurugram / Bangalore ) Joining: Immediate Joiner Budget: 11 LPA Role Overview: We are looking for a highly competent Database Tester with strong hands-on experience in SQL-based backend testing and Selenium automation for UI validation. The ideal candidate should be capable of...

  • ETL Tester

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

  • Sql Tester

    2 weeks ago

    Bengaluru, Delhi, Gurugram, NCR, India Kezan Consulting Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description: SQL TesterPosition: SQL TesterExperience: 48 YearsLocation: Gurgaon / BangaloreRole OverviewWe are seeking an experienced SQL Tester with strong expertise in database testing and SQL query validation. The ideal candidate will be responsible for ensuring data integrity, accuracy, and reliability across multiple applications and...

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

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