OFSAA EPM Technical Consultant

5 - 10 years

0 Lacs

Posted:4 weeks ago| Platform: Shine logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

You have an exciting opportunity to join our team as an experienced OFSAA Technical Consultant. You will be responsible for the successful implementation and configuration of Oracle Financial Services Analytical Applications (OFSAA) for our financial institution clients. **Key Responsibilities:** - Configuration of rules for cost and revenue allocation in OFSAA for profitability calculation. - Configure FTP rules in OFSAA and write T2Ts to transform data. - Develop procedures using PL/SQL based on business requirements and implement technical solutions within OFSAA efficiently. - Test OFSAA configurations, troubleshoot technical issues by analyzing OFSAA log files, and fix defects as appropriate. - Understand complex SQL queries, analyze data-related issues, identify root cause of defects, and develop/implement performance optimal systems. - Maintain the end-to-end OFSAA batch and provide technical support. - Develop/configure rules for LCR, NSFR, Basel Regulatory Capital, IFRS9, and write T2Ts to transform data. - Develop adhoc procedures using PL/SQL. - Testing in support of projects and creation of project artifacts as required by the project life cycle. **Qualifications:** - Bachelors degree in computer science or information systems. - 5+ years of Hands-on experience in OFSAA v6.1 Profitability, FTP, and GL Reconciliation modules. - Good expertise in configuring allocation rules in OFSAA for cost allocation and revenue allocation for profitability management. - Good expertise in configuring Transfer pricing rules in OFSAA FTP module. - Good expertise in building T2T (Table to Table) transformations in OFSAA. - 3+ years of expertise in developing forms with the help of OFSAA forms framework. - 6+ years of experience writing and debugging complex SQL queries and Stored Procedures in Oracle database. - In-depth understanding of Dimensions, hierarchies, and attributes as it applies to OFSAA profitability modules. - In-depth understanding of Data Warehousing concepts and dimensional modeling. - Good understanding of functional aspects of profitability calculations. - Working knowledge of OFSAA Run-Rule framework as it applies to Credit Risk application is a plus. - 6+ years of experience working in the financial industry. - Flexible in managing competing priorities and objectives.,

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
JMR Infotech logo
JMR Infotech

IT Services and IT Consulting

Bangalore Karanataka

RecommendedJobs for You