OFSAA ERM Technical Consultant

Role Overview We are looking for a highly skilled OFSAA ERM Technical Consultant with hands-on expertise in Basel and Liquidity Risk Management (LRM) modules. The role focuses on technical development, data integration, and customization within OFSAA to support regulatory and risk management requirements.

• Design, develop, and maintain OFSAA ERM solutions (Basel / LRM)
• Perform data integration, ETL development, and data mapping into OFSAA (FSDF)
• Develop and optimize T2T (Table-to-Table) transformations
• Configure and support Basel computations (Credit Risk, Market Risk, Operational Risk)
• Implement and support Liquidity Risk Management (LRM) processes
• Write and optimize complex SQL, PL/SQL scripts
• Troubleshoot and resolve data, performance, and application issues
• Support regulatory reporting and compliance requirements
• Work closely with functional teams for requirement clarification and solution design
• Participate in UAT, deployment, and production support

Requirements Required Skills & Experience

• Strong hands-on experience in OFSAA ERM (Basel / LRM)
• Expertise in:
• FSDF (Financial Services Data Foundation)
• Data modeling and data lineage within OFSAA
• T2T, Data Mapping, and OFSAA metadata configuration
• Strong proficiency in:
• Oracle SQL / PL-SQL
• Performance tuning and query optimization
• Experience with Basel regulatory frameworks (Basel II / III / IV)
• Solid understanding of Liquidity Risk Management concepts

• Banking / Financial Services domain experience is mandatory
• Good understanding of:
• Regulatory reporting
• Risk and finance data flows
Soft Skills
• Strong analytical and troubleshooting skills
• Ability to work in a fast-paced, data-intensive environment
• Good communication and collaboration skills
• Ability to work independently and manage deliverables
Nice to Have
• Exposure to other OFSAA modules (ALM, FTP, PFT)
• Experience with OFSAA Infrastructure (OFSAAI)
• Familiarity with Unix/Shell scripting