IC2 Technical Consultant OFSAA ERM

Role: IC2 Technical Consultant OFSAA ERM

Experience : 4-6Years

Location: Bangalore/Mumbai

Overview:

Supports implementation and maintenance of OFSAA ERM modules (ALM, LRM, Basel, FTP, PFT) through SQL/PLSQL development, data load support, rule configuration, testing, and issue resolution under guidance from senior consultants.

Key Responsibilities:

• Assist in configuring OFSAA rules, metadata, hierarchies, and batch executions.
• Develop SQL/PLSQL scripts for data transformation, validation, and reconciliation.
• Support ETL/data loads using ODI, Informatica, or PL/SQL pipelines.
• Execute unit testing, SIT/UAT validations, and defect tracking.
• Troubleshoot basic batch, rule, and data issues; escalate complex problems.
• Maintain technical documentation, mappings, and deployment trackers.
• Collaborate with functional and technical teams while learning OFSAA best practices.

Required Skills:

• Strong SQL/PLSQL fundamentals and Oracle database basics.
• Basic understanding of OFSAA architecture (DIM/FCT, metadata, rule framework).
• Exposure to ETL tools, Linux commands, and batch execution concepts.
• Awareness of banking/ERM concepts such as ALM, Liquidity, Basel, or FTP.
• Good analytical, communication, and learning skills.

Experience: 23 years in OFSAA or financial data warehousing preferred.

Success Metrics:

• Accurate and timely delivery of assigned tasks.
• Improved data quality and reduced defects.
• Ability to independently handle medium-complexity tasks with guidance.

Profile To: careers@manuhindia.com