The OFSAA ERM Technical Consultant is responsible for developing OFSAA ERM solutions, integrating data, optimizing SQL scripts, and supporting regulatory compliance in a banking context.
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
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
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
Top Skills
Basel
Data Mapping
ETL
Liquidity Risk Management
Ofsaa
Pl/Sql
SQL
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Senior Marketing Manager will lead India's TMT marketing strategy, executing integrated programs to enhance customer engagement and business growth through effective campaign delivery and stakeholder collaboration.
Top Skills:
Msft DynamicsPower BI
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The Team Leader administers STD claims, reviews new claims, makes eligibility decisions, and interacts with various stakeholders to manage leave types and ensure compliance.
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

