Software ETL Tester - Noida, India - nirvanaHealth | RxAdvance

    nirvanaHealth | RxAdvance
    nirvanaHealth | RxAdvance Noida, India

    1 week ago

    Default job background
    Technology / Internet
    Description

    Job Summary:

    The Software ETL Tester is responsible for understanding data flow and test strategy for ETL, writing advanced SQL queries, and using their testing experience to make a lasting impact on the organization.

    Qualifications:

    Education and/or Training:

    • Bachelor's degree required

    Professional Experience:

    • 8+ years of strong experience in ETL testing.
    • Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing.
    • Understand data flow and test strategy for ETL, Data warehouse, and Business Intelligence testing.
    • Design Test Strategy, Test Plans for ETL functionalities implemented across variety of custom scripts, jobs, and packaged solutions.
    • Write, design, and execute automated tests by creating scripts that run testing functions automatically.
    • Data warehouse testing involving the testing of stored procedures, slowly changing dimension tables, Change Data capture etc.
    • Ability to go through the User stories and understand the technical aspects required for aspects of ETL/Data process.
    • Excellent in creating/analyzing simple to complex SQL for data validation.
    • Good experience in Oracle/Mongo/RDBMS/Big Data.
    • Identify test cases which has to be automated. Prepare test automation strategy.
    • Perform partial E2E validations of the ETL scenarios with multiple test scenarios and test data.
    • Experience in Agile projects (Scrum, Kanban etc.).
    • Good communication skills.
    • Good analytical & problem-solving skills.
    • Document testing results in detail, including screenshots where applicable, and ensure any issues are escalated as appropriate.
    • Apply Strong knowledge of testing methodologies such as black box, white box, Functional, Regression, Integration and E2E Testing.

    Must have:

    1. SQL scripting experience

    2. Experience with ETL Testing/Database Testing/Datawarehouse Testing concepts

    3. Oracle(preferred)/SQL server/any other database experience

    4. Understanding of Quality Assurance process (Test Strategy/Test cases/Test scripts)

    Nice to have:

    1. Unix

    2. Communication Skills

    3. Test Automation

    4. Reports validation