Job Description
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.
Key Responsibilities
- 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
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
Domain Experience
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
