Role: Technical Consultant – OFSAA ERM Suite
Location: Bengaluru/ Mumbai
Role Overview:
The IC4 Technical Consultant for the OFSAA Enterprise Risk Management (ERM) suite is responsible for delivering end-to-end technical implementation, customization, performance optimization, and production support for OFSAA ERM modules such as ALM, LRM, Basel, FTP, PFT, and related components. The role demands strong technical depth, hands-on delivery capability, and the ability to work independently while guiding junior team members.
Required Skills & Experience
Technical Skills
- Configure and deploy OFSAA ERM applications (ALM, LRM, FTP, Basel, PFT) including metadata setup, data model extensions, staging-to-FCT mappings, business rule configuration, and scenario orchestration.
- Implement ALM/IRRBB, Liquidity, Basel, and other ERM scenarios including cash flow engines, model configurations, behavioral assumptions, shock parameters, scenario definitions, and reporting frameworks.
- Customize OFSAA Rule Framework components such as allocation rules, transformation rules, and business rules using SQL/PLSQL.Strong SQL and PL/SQL programming (complex merges, analytic functions, performance tuning).
- Deep understanding of OFSAA architecture: FDM, DIM, FCT tables, metadata, rule framework, cash flow engines.
- Experience with OFSAA modules such as ALM, LRM, Basel, FTP, and PFT.
- Experience with ETL tools (ODI, Informatica, PL/SQL-based ingestion).
- Strong performance tuning skills on Oracle 12c/19c (partitioning, parallel processing, indexing).
- Exposure to OFSAA on OCI, Exadata, or Linux-based deployments.
- Good understanding of banking/finance data (loans, deposits, liquidity, capital, interest rate risk).
Soft Skills
- Ability to work independently with minimal oversight (IC4 level expectation).
- Strong communication skills for client interaction and requirement clarification.
- Ability to guide junior team members and conduct code/design reviews.
- Strong analytical ability and structured problem-solving approach.
Preferred Qualifications
- 8–12 years of overall experience, with significant exposure to OFSAA ERM suite.
- Certification in OFSAA ALM/LRM/Basel/FTP is a strong plus.
- Experience implementing multi-entity, multi-currency configurations.
- Experience with regulatory reporting frameworks (IRRBB, Basel III LCR/NSFR, ICAAP).
- Experience integrating OFSAA with reporting applications (OFSAA FSDF, OAS/OAC, Power BI, Tableau).
Work Location: In person
