Senior OFSAA / FSDF Test Analyst

Job Title: Senior OFSAA / FSDF Test Analyst
Location: London
Start Date: November
Job Type: Contract - Inside IR35

We are seeking an experienced Senior OFSAA / FSDF Test Analyst to support functional and database testing across complex financial services applications.

The successful candidate will have strong SQL and data validation expertise, combined with knowledge of Oracle Financial Services Analytical Applications (OFSAA), Financial Services Data Foundation (FSDF) and financial data structures.

Key Responsibilities

• Perform functional, integration, regression and end-to-end testing across financial applications and workflows.
• Develop and execute complex SQL queries to validate financial data, calculations and business rules.
• Conduct source-to-target data reconciliation, identifying discrepancies and data integrity issues.
• Validate data mappings, transformations and database processes.
• Investigate defects, document findings and collaborate with development teams to resolve issues.
• Prepare test scenarios, test cases and supporting documentation, ensuring comprehensive test coverage.
• Support UAT activities and work closely with business analysts, developers and stakeholders.

Required Skills & Experience

• Strong experience working with Oracle OFSAA and FSDF environments.
• Excellent hands-on SQL and database testing skills, ideally using Oracle databases.
• Experience with data validation, reconciliation, ETL testing and financial data transformations.
• Strong financial services domain knowledge, ideally covering investment management, banking, capital markets, risk or regulatory reporting.
• Proven experience in functional, integration and database testing.
• Understanding of SDLC, STLC, Agile methodologies and defect management tools such as Jira or Azure DevOps.

Desirable Experience

• Testing stored procedures, data migrations or data warehouse processes.
• API testing using Postman or similar tools.
• Functional test automation experience.

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.