ETL Database Tester

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

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

    6 days ago

    Gurugram, Haryana, India Virtusa Full time

    Role: ETL Tester 1) Minimum 5+ years of work experience in ETL testing in MDM and SQL hands-on. 2) Preferred Cloud experience 3) Extensive analytical skills and Good communication skills 4) Good to have knowledge in Healthcare Insurance **About Virtusa** Teamwork, quality of life, professional and personal development: values that Virtusa is proud to...

  • Etl QA Tester

    2 weeks ago

    Gurugram, Haryana, India Appzlogic Mobility Solutions Full time

    Job description **Responsibilities -** We are hiring for an ETL QA who has experienced with testing ETL workflows and is well versed with ETL testing procedures. Experience with Informatica.Good Experienced of various types of testing like Functional testing, Database testing, Integration Testing, Regression Testing, Performed Database Testing Using SQL...

  • Sql Tester

    2 weeks ago

    Bengaluru, Delhi, Gurugram, NCR, India Kezan Consulting Full time ₹ 9,00,000 - ₹ 12,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

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

    2 weeks 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 US$ 60,000 - US$ 1,20,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 Tester

    2 weeks ago

    Gurugram, Haryana, India Virtusa Full time

    1) Minimum 8+ years of work experience in ETL testing in MDM and SQL hands-on. 2) Preferred Cloud experience 3) Extensive analytical skills and Good communication skills 4) Good to have knowledge in Healthcare Insurance **About Virtusa** Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you...

  • DataStage Developer

    1 day ago

    Gurugram, India SMARTWORK IT SERVICES Full time

    DataStage DeveloperLocation : Gurgaon, IndiaExperience : 4-9 YearsEmployment Type : Full-timeJob Overview :We are seeking a skilled DataStage Developer with 4-9 years of experience to join our team in Gurgaon. You will be responsible for developing, optimizing, and supporting complex ETL jobs using IBM DataStage. This role requires strong hands-on experience...

  • ETL/Data Warehouse Consultant

    2 days ago

    Gurugram, India Winning Edge Full time

    Job Description :Primary Duties/Responsibilities : - Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.- Recommend and implement processes to improve data quality, data reliability, and database performance.- Employ variety of ETL and integration tools for system and data integrations.- Architect...