OFSAA Technical Consultant

Job Purpose:We are seeking an experienced OFSAA Technical Consultant to lead the technical implementation, integration, optimization, and support of Oracle Financial Services Analytical Applications (OFSAA) solutions. The role is responsible for designing scalable and high-performing OFSAA environments, managing data integration frameworks, supporting regulatory reporting requirements, and ensuring seamless integration with enterprise banking systems.Key Accountabilities:Lead the technical architecture, implementation, and customization of OFSAA solutions.Design and develop OFSAA data models, metadata structures, and processing frameworks.Implement and manage OFSAA Infrastructure, Data Foundation, F2T (File-to-Table), T2T (Table-to-Table), and ODI components.Design, develop, and optimize ETL processes and data integration workflows.Lead integration activities between OFSAA, enterprise data warehouses, and banking source systems.Develop advanced SQL and PL/SQL components for data processing, validation, and reconciliation.Troubleshoot and resolve complex technical, application, and database performance issues.Ensure data quality, security, governance, and compliance requirements are met.Support production deployments, upgrades, patching activities, and environment management.Perform performance tuning, database optimization, and batch performance improvements.Provide technical leadership, mentoring, and best-practice guidance to engineering teams.Prepare and maintain technical documentation, architecture documents, and operational procedures.Support continuous improvement initiatives across OFSAA platforms and data management practices.

Minimum Qualifications

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.Oracle Database or OFSAA certifications are considered an advantage.Strong understanding of banking data platforms, analytics, and regulatory reporting solutions.Minimum Experience:7+ years of experience in OFSAA technical implementation and banking data platform projects.Proven experience delivering OFSAA implementation, integration, and data management initiatives.Experience leading technical teams and complex enterprise banking projects.Hands-on experience with Oracle Database technologies and enterprise data integration solutions.Job-Specific Skills:Oracle Financial Services Analytical Applications (OFSAA).OFSAA Infrastructure.OFSAA Data Foundation.F2T (File-to-Table).T2T (Table-to-Table).Oracle Data Integrator (ODI).OFSAA Metadata Management.OFSAA Processing Frameworks.OFSAA Environment Management and Deployment.Advanced Oracle SQL Development.PL/SQL Programming and Optimization.Database Performance Tuning.Query Optimization.Data Validation and Reconciliation.Oracle Database Administration Concepts.Data Quality Management.ETL Design and Development.Enterprise Data Integration.Data Warehousing Concepts.Banking Data Models.Source System Integration.Enterprise Reporting Data Architecture.Batch Processing and Data Transformation Frameworks.Linux Administration.Shell Scripting.Application Deployment and Release Management.Environment Setup and Configuration.Patch and Upgrade Management.Production Support and Incident Resolution.Banking Analytics Platforms.Regulatory Reporting Solutions.Financial Services Data Architecture.Risk and Finance Data Management.Enterprise Banking Systems Integration.Data Governance and Compliance Requirements.Technical Solution Design.Team Leadership and Mentoring.Stakeholder Management.Problem Solving and Root Cause Analysis.Technical Documentation and Knowledge Transfer.Project Coordination and Delivery Support.