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 • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
Design and optimize SQL scripts, develop Java applications and APIs, lead collaboration sessions, and ensure solutions adhere to RDBMS principles.
Top Skills:
Aws RdsCore JavaGitOciOracle DbPl/SqlRest ApisSQL
Artificial Intelligence • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
The Business Data Analyst II will design and optimize SQL and PL/SQL scripts, develop Java applications and RESTful APIs, gather requirements, and ensure solutions maintain data integrity and security.
Top Skills:
Aws RdsCore JavaGitOciOracle DbPl/SqlRest ApisSQLSql Developer
.png)
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Lead the development of AI-powered customer support solutions, guiding a team to build scalable, reliable, and secure systems using LLMs and third-party integrations.
Top Skills:
AIAWSGoKubernetesLangchainLlamaindexLlmsMlRubyVector Databases
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
