OFSAA LLFP Consultant

LocationNew Delhi, Delhi, India
Typefull-time
SenioritySenior
DepartmentJonali
Company size1,001–5,000 people
PostedJul 17, 2026 · 2mo ago
Verified live1d ago
At a glanceSummarised by Seekless from the posting.
Experience with Oracle OFSAA Infrastructure
Hands-on experience with LLFP (IFRS 9 / CECL)
Hands-on experience with LRM (Liquidity Risk Management)
Strong Oracle SQL and PL/SQL skills
Experience with ODI/OFSAA ETL
Experience with Data Foundation (FSDF)
Experience with Information Domains
Experience with Batch Framework
Experience with Metadata Configuration
Experience with Data Quality
Knowledge of Linux/Unix scripting
Experience with Oracle Database
Skills
Oracle OFSAA
LLFP
LRM
Oracle SQL
PL/SQL
ODI
OFSAA ETL
FSDF
Linux/Unix
Oracle Database
About the role
We are seeking an experienced Oracle OFSAA Consultant with strong expertise in Loan Loss Forecasting & Provisioning (LLFP) and Liquidity Risk Management (LRM). The candidate will be responsible for implementing, configuring, customizing, and supporting OFSAA solutions for regulatory reporting, IFRS 9/CECL, liquidity risk, and enterprise risk management. Experience with the OFSAA infrastructure and data model is essential. LLFP supports expected credit loss calculations for IFRS 9/CECL, while LRM provides liquidity risk analytics, stress testing, and regulatory reporting.
Key Responsibilities
•
Implement and support Oracle OFSAA LLFP and LRM modules.
•
Gather and analyze business requirements from banking stakeholders.
•
Configure OFSAA metadata, dimensions, hierarchies, assumptions, and rules.
•
Develop and customize:
•
T2T (Table-to-Table) transformations
•
Data Mapping
•
Business Rules
•
Batch execution workflows
•
Perform IFRS 9 Expected Credit Loss (ECL) implementation using LLFP.
•
Configure Probability of Default (PD), Loss Given Default (LGD), Exposure at Default (EAD), staging, and provisioning logic.
•
Configure liquidity gap analysis, LCR, NSFR, cash flow projections, behavioral assumptions, and stress testing in LRM.
•
Develop SQL, PL/SQL, and shell scripts for data processing and automation.
•
Troubleshoot production issues and optimize application performance.
•
Coordinate with business, testing, and infrastructure teams.
•
Prepare technical documentation and deployment artifacts.
Required Skills
•
Strong experience with Oracle OFSAA Infrastructure.
•
Hands-on experience with:
•
LLFP (IFRS 9 / CECL)
•
LRM (Liquidity Risk Management)
•
Strong Oracle SQL and PL/SQL skills.
•
Experience with:
•
ODI/OFSAA ETL
•
Data Foundation (FSDF)
•
Information Domains
•
Batch Framework
•
Metadata Configuration
•
Data Quality
•
Knowledge of Linux/Unix scripting.
•
Experience with Oracle Database.