We are seeking a skilled and experienced OFSAA Technical Consultant with deep expertise in the Oracle Financial Services Analytical Applications (OFSAA) EPM suite. The ideal candidate will work closely with business and functional teams to implement, customize, and support solutions in areas such as Profitability Management, Liquidity Risk Management, Funds Transfer Pricing, and Loan Loss Forecasting and Provisioning (LLFP).

You will play a key role in bridging business requirements with technical execution, ensuring optimal system performance, regulatory compliance, and data integrity.

Key Responsibilities :

- Develop, optimize, and maintain complex SQL and PL/SQL queries/scripts to support OFSAA modules and reporting needs.

- Customize and configure OFSAA EPM applications, including :

1. Profitability Management (PFT)

2. Liquidity Risk Management

3. Funds Transfer Pricing (FTP)

4. Loan Loss Forecasting and Provisioning (LLFP)

- Translate business and regulatory requirements into technical designs and workflows.

- Implement data sourcing strategies using Oracle Data Integrator (ODI) and other ETL/middleware tools.

- Perform data mapping, extraction, transformation, and loading between source systems and OFSAA environments.

- Monitor and optimize ETL workflows for performance and scalability.

- Configure OFSAA components, including metadata, allocation rules, rule balances, hierarchy setups, and batch processing jobs.

- Develop custom reports, dashboards, and data visualizations within the OFSAA reporting layer.

- Troubleshoot and resolve technical issues across development, testing, and production environments.

- Work closely with functional consultants, data teams, and finance stakeholders to ensure alignment of system functionality with business objectives.

- Maintain comprehensive documentation for system design, customizations, and troubleshooting procedures.

- Participate in testing cycles, including unit testing, SIT, UAT, and performance testing.

Required Qualifications :

- Minimum 5+ years of hands-on experience with the OFSAA EPM suite, specifically in modules such as PFT, FTP, LRM, and LLFP.

- Strong command over SQL, PL/SQL, Oracle RDBMS, and performance tuning techniques.

- Experience with Oracle Data Integrator (ODI) or other ETL tools.

- Proven experience in delivering technical solutions within a financial services or banking environment.