ETL Tester

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.