OFSAA Funds Transfer Pricing (FTP) Techno-Functional Consultant

Carnation Infotech; Bengaluru; On-site; INR 1,200,000 - 2,300,000; Full time

Job summary

Carnation Infotech is seeking an experienced Oracle OFSAA Funds Transfer Pricing Techno-Functional Consultant to support implementation, configuration and production support of FTP solutions in a banking context.

The role requires hands-on OFSAA FTP experience, strong SQL/PL/SQL skills, and familiarity with ETL, batch processing, data transformation, and Unix/Linux scripting. Collaboration with Treasury, ALM, and Risk teams is essential.

Qualifications

• Must have hands-on OFSAA FTP experience and strong FTP configuration knowledge.
• Experience with Oracle SQL/PLSQL, ETL, batch processing and data reconciliation.
• Familiarity with banking processes, Treasury and ALM concepts preferred.

Responsibilities

• Implement, configure, enhance and support OFSAA FTP solutions.
• Configure FTP rules, pricing methods, curves and assumptions.
• Handle data integration, including T2T, transformations, staging and reconciliation.
• Develop, execute and troubleshoot Oracle SQL/PL/SQL scripts.
• Support ETL workflows and data loading tasks.

Skills

OFSAA 8.x

Funds Transfer Pricing (FTP)

Oracle SQL and PL/SQL

ETL and Batch Processing

Unix/Linux and Shell Scripting

Data Warehousing Concepts

FTP Configuration and Curves

T2T and Data Transformation

Job description

Job Title: OFSAA Funds Transfer Pricing (FTP) Techno-Functional Consultant

Location: Bangalore
Employment Type: Full-Time Fixed Term
Experience:

• L2: 36 years
• L3: 610+ years
  Notice Period: Immediate to 15 Days

Job Summary

We are looking for experienced Oracle OFSAA Funds Transfer Pricing (FTP) Techno-Functional Consultants with strong hands‑on experience in OFSAA 8.x, FTP configuration, implementation and production support.

The candidate should have a combination of technical expertise in Oracle SQL/PLSQL, ETL and batch processing, along with functional knowledge of Funds Transfer Pricing methodologies and banking processes.

Key Responsibilities

• Implement, configure, enhance and support Oracle OFSAA Funds Transfer Pricing solutions.
• Work on FTP rule configuration, pricing methodologies, curves and assumption management.
• Handle data integration activities, including T2T, data transformation, staging and reconciliation.
• Develop, execute and troubleshoot Oracle SQL and PL/SQL scripts.
• Support ETL workflows, batch processing and data loading activities.
• Work with Unix/Linux environments and Shell scripting for application and batch operations.
• Analyse and resolve functional and technical issues related to FTP processing.
• Work with banking, Treasury, ALM, Finance and Risk teams to understand and support FTP requirements.
• Ensure accurate data processing, FTP calculations and reporting.

Mandatory Technical Skills

• Oracle OFSAA 8.x
• Funds Transfer Pricing (FTP)
• Oracle SQL and PL/SQL
• ETL and Batch Processing
• Unix/Linux and Shell Scripting
• Data Warehousing Concepts
• FTP Configuration, Rule Setup, Curves and Assumption Management
• T2T, Data Transformation, Staging and Reconciliation

Mandatory / Preferred Domain Knowledge

• Matched Maturity FTP
• Pool-Based and Advanced FTP Methodologies
• Liquidity Premium and Optionality Costs
• Profitability, Net Interest Margin (NIM) and Margin Attribution
• Banking, Treasury, Asset Liability Management (ALM), Finance and Risk Reporting

Experience Expectations

L2 Consultant (36 Years)

• Hands‑on OFSAA experience with exposure to Funds Transfer Pricing.
• Experience in FTP configuration, rule setup and data processing.
• Good working knowledge of SQL/PLSQL, ETL, T2T and batch processing.
• Experience in implementation, enhancement or production support.

L3 Consultant (610+ Years)

• Strong hands‑on experience in Oracle OFSAA FTP implementations.
• Experience leading or independently handling FTP implementation activities.
• Strong understanding of FTP methodologies, curves, assumptions and configurations.
• Ability to handle complex technical and functional issues.
• Good understanding of banking, Treasury, ALM and profitability concepts.

Important: Candidates with strong hands‑on Oracle OFSAA FTP implementation and support experience will be given priority.

Candidates with generic Oracle SQL/PLSQL or banking experience without OFSAA FTP exposure may not be suitable.