Fusion Technical Consultant

LTM; Dadri, Hyderabad, Chennai District; Hybrid; INR 1,500,000 - 1,900,000; Full time

Job summary

LTM is seeking a skilled Oracle Fusion Technical Consultant with deep expertise in BI Publisher, REST/SOAP web services, SQL/PLSQL, and FBDI-based data conversions for AP/FA & GL. Exposure to VBCS will be an added advantage.

You will design BI Publisher reports, develop integrations, perform data conversions, write optimized SQL, and support end-to-end Fusion deployments.

Qualifications

• Extensive experience with BI Publisher and report design.
• Hands-on REST and SOAP web services development and integration.
• Strong SQL/PLSQL development and data extraction skills.
• Experience with Oracle Integration Cloud (OIC).
• FBDI data loads/conversions for AP/FA/GL preferred.
• Knowledge of Oracle Fusion architecture and cloud implementations.

Responsibilities

• Design and develop BI Publisher reports, data models, templates, and layouts.
• Develop and consume REST & SOAP web services for Oracle Fusion integrations.
• Perform FBDI-based data conversions for AP, FA, and GL.
• Write and optimize complex SQL/PL/SQL queries for data extraction and reporting.
• Work on Oracle Fusion integrations, extensions, and technical components.
• Develop lightweight UI/customizations using VBCS where applicable.
• Support end-to-end implementation, enhancements and production support.

Skills

BI Publisher

REST/SOAP Web Services

SQL/PLSQL Development

OIC

FBDI Data Loads

Oracle Fusion

VBCS

Tools

VBCS

Job description

Role Summary

We are looking for a skilled Oracle Fusion Technical Consultant with strong expertise in BI Publisher (BIP), REST/SOAP web services, SQL/PLSQL, and hands-on experience in FBDI-based data conversions for financial modules (AP/FA & GL).

Exposure to VBCS will be an added advantage.

Key Responsibilities

• Design and develop BI Publisher (BIP) reports, data models, templates, and layouts.
• Develop and consume REST & SOAP web services for Oracle Fusion integrations
• Perform FBDI-based data conversions for modules such as Accounts Payable (AP) ,Fixed Assets (FA) and General Ledger(GL).
• Write and optimize complex SQL and PL/SQL queries for data extraction, validation, and reporting.
• Work on Oracle Fusion integrations, extensions, and technical components.
• Develop lightweight UI/customizations using VBCS (preferred).
• Support end-to-end implementation, enhancements, and production support activities.
• Collaborate with functional teams to convert business requirements into technical solutions.
• Prepare technical documentation (MD050, design docs, test cases, etc.) and ensure quality delivery

Required Skills

• Strong hands-on experience in:
  • BI Publisher (BIP)
  • REST / SOAP Web Services
  • SQL / PLSQL development
  • OIC
• Experience in FBDI data loads/conversions (AP/FA preferred)
• Good understanding of Oracle Fusion architecture & data models
• Experience in Oracle Cloud implementations and support
• Strong debugging, troubleshooting, and performance tuning skills

Preferred Skills (Good to Have)

• Experience with VBCS (Visual Builder Cloud Service
• Knowledge of OTBI, OIC integrations
• Exposure to ERP Financials (AP, FA, GL)
• Familiarity with Agile tools like JIRA