OFSAA LLFP Consultant

Unison Group; New Delhi; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Unison Group seeks an experienced Oracle OFSAA Consultant specializing in LLFP and LRM to implement, configure, and support regulatory reporting, IFRS 9/CECL, liquidity risk, and enterprise risk management. The candidate will work on OFSAA infrastructure, data model, and related ETL processes.

The role requires strong Oracle SQL/PLSQL skills, Linux scripting, and hands-on OFSAA experience with LLFP and LRM modules, data mapping, and batch workflows in a banking context.

Qualifications

• Experience implementing OFSAA LLFP and LRM modules.
• Experience with IFRS 9 / CECL ECL calculations.
• Strong Oracle SQL and PL/SQL skills.
• Proficiency with Linux/Unix scripting.
• Experience with ODI/OFSAA ETL and data foundations.

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 transformations, Data Mapping, Business Rules, Batch workflows.
• Perform IFRS 9 ECL implementation using LLFP.
• Configure PD, LGD, EAD, staging, provisioning logic.
• Configure liquidity gap analysis, LCR, NSFR, cash flow projections, stress testing in LRM.
• Develop SQL, PL/SQL, and shell scripts for data processing and automation.
• Troubleshoot production issues and optimize performance.
• Coordinate with business, testing, and infrastructure teams.
• Prepare technical documentation and deployment artifacts.

Skills

Oracle OFSAA

LLFP IFRS9 CECL

LRM

Oracle SQL

PL/SQL

ODI/OFSAA ETL

Data Foundation FSDF

Batch Framework

Linux/Unix scripting

Oracle Database

Education

Bachelor's degree in Computer Science or related field

Tools

ODI

ODI/OFSAA ETL Tools

FSDF Data Foundation

Batch Framework Tools

Job description

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.