ETL Tester

PRI INDIA IT SERVICES PRIVATE LIMITED; Bengaluru; On-site; INR 600,000 - 1,200,000; Full time

Job summary

PRI INDIA IT SERVICES PRIVATE LIMITED is seeking an ETL Tester to join our Bengaluru team. The role requires 3-5 years of experience in ETL testing, strong SQL/PLSQL, and hands-on use of test management tools such as Client ALM, Synapse RT, and Jira.

You will contribute to testing strategies and ensure quality across multi-system integrations. You'll collaborate with BAs and developers, create and maintain test data, and participate in SDLC/STLC processes, with emphasis on accurate defect life

Qualifications

• Bachelor's degree in a relevant discipline.
• Minimum 4 years' experience in Testing/Validation role.
• Hands-on ETL testing with strong SQL/PL/SQL.

Responsibilities

• Author and execute test cases for large-scale systems within testing strategy.
• Develop test cases for multi-system integrations and ensure coverage.
• Create and maintain test data and reusable data repositories.
• Execute tests, log defects, and re-test fixes.
• Perform peer reviews of test cases for quality and accuracy.
• Use automated testing tools for planning, management, and defect tracking.
• Review SDLC deliverables for test script readiness.
• Collaborate with BAs, developers and stakeholders.
• Ensure traceability between requirements and test cases.
• Mentor junior team members.

Skills

ETL Testing

SQL PL/SQL

Test Management Tools

ETL Concepts

SDLC/STLC

Test Plans

Defect Lifecycle

Analytical Skills

Communication Skills

Education

Bachelor's degree in a relevant discipline

Tools

Client ALM

Synapse RT

Jira

Job description

• Good knowledge and experience in SQL (Strong in SQL & PL/SQL)
• Hands-on experience with Test Management tools such as Client ALM, Synapse RT, and Jira
• Strong knowledge of ETL concepts
• Strong understanding of SDLC/STLC processes and Testing Concepts
• Knowledge of Test Plans, Test Strategies, and other test deliverable documents
• Understanding of the Defect Life Cycle
• Strong analytical skills
• Excellent verbal, written, and communication skills

Job Description

Must Have Skillset

• 3-5 years of Experience in ETL Testing
• Good knowledge and experience in SQL (Strong in SQL & PL/SQL)
• Hands-on experience with Test Management tools such as Client ALM, Synapse RT, and Jira
• Strong knowledge of ETL concepts
• Strong understanding of SDLC/STLC processes and Testing Concepts
• Knowledge of Test Plans, Test Strategies, and other test deliverable documents
• Understanding of the Defect Life Cycle
• Strong analytical skills
• Excellent verbal, written, and communication skills

Good To Have Skillset

• Experience with Clinical Data / Clinical Domain
• Experience working in Agile and Lean SDLC environments
• Hands-on experience with Trifacta (Data Wrangling Tool), Denodo, and K2View
• Exposure to Big Data tools and applications
• Experience with Test Automation

Key Responsibilities

• Author test cases for large-scale computer systems within the scope of a defined testing strategy and contribute to test strategy development for projects and systems.
• Develop test cases for complex multi-system integrations and collaborate with project teams to gather inputs and implement revisions to ensure comprehensive testing coverage.
• Create and maintain test data required for test execution and support reusable test data repositories.
• Execute test cases, identify defects, log issues, and perform re-testing to validate fixes.
• Conduct peer reviews of test cases before and after execution to ensure accuracy, quality, and completeness.
• Utilize automated testing tools for test planning, test management, test case authoring, execution, and defect tracking.
• Review SDLC deliverables produced by IT teams to ensure specifications are complete, detailed, and suitable for test script development.
• Participate in technical discussions with Business Analysts, Developers, and other stakeholders as required.
• Review requirements specifications for testability and ensure traceability between requirements and test cases.
• Demonstrate a strong understanding of requirements elicitation, analysis, and specification processes, including User Requirement Specifications (URS) and Functional Specifications (FS) for complex applications.
• Participate in project planning activities and provide effort estimates when required.
• Proactively communicate project status, testing progress, risks, and concerns to senior SVT team members, Project Managers, and management.
• Serve as a Test Lead for projects when required.
• Mentor and support junior team members.

Minimum Required Education And Experience

• Bachelor's degree in a relevant discipline.
• Minimum of 4 years of experience in a Testing and/or Validation role.