ETL Tester
PRI INDIA IT SERVICES PRIVATE LIMITED • Bengaluru, Karnataka, India
**Role & seniority: ** Software Testing / Validation Engineer; 4+ years (includes 3–5 years ETL testing). May act as Test Lead and mentor juniors.
**Stack/tools: **
-
SQL & PL/SQL
-
ETL concepts
-
Test management: Client ALM, Synapse RT, Jira
-
(Nice-to-have) Trifacta, Denodo, K2View
-
(Nice-to-have) Big Data tools
-
(Nice-to-have) Test automation tools/frameworks
-
Top 3 responsibilities:
-
Author and review test cases for large-scale systems and multi-system ETL integrations; contribute to test strategy.
-
Prepare/maintain test data and execute tests; identify defects, log in tooling, and re-test fixes.
-
Ensure traceability (requirements ↔ test cases) and review SDLC deliverables for testability/coverage.
-
-
Must-have skills:
-
ETL testing experience (3–5 years)
-
Strong SQL/PLSQL
-
Knowledge of SDLC/STLC and testing concepts (test plans/strategies, deliverables)
-
Understanding of defect life cycle
-
Strong analytical and communication skills (verbal/written)
-
-
Nice-to-haves:
-
Clinical data/clinical domain
-
Agile/Lean SDLC experience
-
Hands-on with Trifacta, Denodo, K2View
-
Exposure to Big Data
-
Test automation experience
-
-
Location & work type: Not specified in the provided text.
Full Description
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.