Role description: The ideal candidate is an excellent tester, effective communicator, comfortable interacting with stakeholders, with a solid background in testing complex data projects, motivated to contribute to Oracle-based reporting, and excited about migrating to next-generation cloud data platforms. 

Responsibilities  

Analysis & Planning: 

Analyze business and technical requirements to gain a deep understanding of data flows and business logic. 

Contribute to the creation and implementation of the overall Test Strategy and Test Plans, while taking ownership of defining specific test scenarios. 

Contribute to test effort estimation and proactively identify risks. 

Design & Execution: 

Design, write, and maintain Test Cases to validate data integrity, transformation logic, and the accuracy of reporting outputs. 

Cover all aspects of testing, including functional, integration, regression, and End-to-End

Create and manage the test data required to validate complex scenarios. 

Rigorously execute testing activities, analyze, and document the results in detail. 

Defect Analysis & Reporting: 

Identify, troubleshoot, and document defects in JIRA, providing clear information for the development teams. 

Retest corrections to ensure defects are fully resolved. 

Coordinate testing activities with internal teams, third-party vendors, and business users

Leadership & Continuous Improvement: 

Organize monthly demo sessions to present project status to stakeholders. 

Contribute to the continuous improvement of development and testing processes. 

Skills  

Technical Requirements & Experience: 

Minimum of 3-5 years of experience in software testing, with a demonstrated focus on data-centric projects. 

Solid technical experience with the data lifecycle for reporting, including: 

Database Testing Expertise: Strong, hands-on experience testing Oracle Databases. This must include: 

Data Integrity & Quality Validation: Verifying data accuracy, consistency, and correctness against business rules. 

Database Objects Testing: Testing stored procedures, functions, triggers, and views to ensure they function as expected. 

Source-to-Target Validation: Performing detailed checks to ensure data is transformed and loaded correctly into reporting tables. 

Advanced SQL: Excellent skills in writing complex queries for data extraction, validation, comparison, and anomaly detection. 

Methodologies & Tools: 

Proven experience with Agile methodologies and the Software Development Lifecycle 

Excellent knowledge of testing techniques

Hands-on experience with test management and defect tracking tools

Preferred Experience (Nice to have): 

Experience in the financial services industry, with knowledge of Wealth Management or other financial products. 

Experience in coordinating  (User Acceptance Testing) activities. 

An openness and desire to learn and adapt to new technologies, specifically cloud data platforms. 

An interest in or basic knowledge of Test Automation and related tools. 

.