Oracle Financials Technical Consultant - Banking Domain

Job Title : Oracle Financial Technical Consultant - Banking Domain.

Role Overview :

We are seeking an experienced Oracle Financial Technical Consultant with strong hands-on expertise in Oracle E-Business Suite (EBS) or Oracle Fusion Financials and a solid understanding of banking and financial services operations.

The ideal candidate will be responsible for customizing, integrating, and supporting Oracle Financial modules to meet the complex transaction processing, reconciliation, treasury, and compliance needs of the banking sector.

This role requires a combination of technical proficiency, domain knowledge, and the ability to collaborate with functional, treasury, and compliance teams.

Key Responsibilities :

Technical Development & Customization :

- Develop and support RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) for Oracle Financials modules :

- General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), Subledger Accounting (SLA).

- Design and develop custom interfaces between Oracle Financials and :

1. Core Banking Systems (e.g., Finacle, T24, Flexcube).

2. Treasury platforms (e.g., Murex, Calypso).

3. SWIFT integrations for MT940/MT950 and ISO20022 formats.

- Customize Bank Statement Import, Auto Reconciliation, and Payment File Formats as per bank standards.

Banking-Specific Integration & Automation :

- Build integrations with external banking systems for:

1. Daily transaction imports.

2. Interbank settlements.

3. Interest accruals, fund transfers, and charge postings.

- Automate reconciliation processes with scripts and scheduled jobs.

- Work on bulk data loading tools (FBDI, ADFDI) and APIs for master and transaction data import/export.

Data Analysis & Reporting :

- Create and maintain custom reports using :

1. BI Publisher / XML Publisher.

2. Oracle Reports.

3. OTBI / Smart View.

- Support audit, regulatory, and financial reporting requirements : RBI, Basel III, IFRS, internal audit.

Support & Issue Resolution :

- Provide technical production support for Oracle Financial modules.

- Investigate and resolve integration and data reconciliation issues.

- Perform root cause analysis (RCA), system enhancements, and bug fixes.

- Work closely with DBAs, infrastructure, and security teams to ensure uptime and compliance.

Security, Workflow, and Control :

- Implement bank-level security (payment file encryption, PGP, digital signature).

- Maintain role-based access control in alignment with banking compliance (SOX, SOD, ITGC).

Experience :

- At least 2 projects in Banking or Financial Services sector with proven integration experience.

- Strong understanding of financial workflows in banking, including intercompany settlements, suspense clearing, and bank reconciliations.

Technical Skill Set :

- Languages/Tools: PL/SQL, Shell scripting, Oracle Forms, Reports, Workflow Builder, BI Publisher.

- Data Integration: FBDI, ADFDI, UCM, Web Services (SOAP/REST), Oracle Integration Cloud (OIC).

- Banking Standards: SWIFT MT940/950, ISO20022, BAI2 file formats.

- Security: PGP encryption, digital certificates, AME workflows.

- Other Tools: EPM Automate (if working with EPM ARCS), Smart View, OTBI.

Soft Skills:

- Strong analytical and debugging skills.

- Ability to translate functional requirements into technical solutions.

- Good written and verbal communication skills, especially for stakeholder collaboration.

- Team player with a proactive, delivery-focused mindset.

Certifications (Preferred) :

- ITIL Foundations (for incident/change management familiarity).

- Banking domain certifications (e.g., FinTech, CAIIB) are a plus.

Banking-Specific Expertise (Preferred) :

- Treasury & liquidity platform integration.

- Regulatory reporting automation (RBI, IFRS, Basel III).

- Exposure to reconciliations automation tools like Oracle ARCS or BlackLine.