Oracle Fusion Technical Consultant

Summary

Designs and builds Oracle Fusion Cloud reports, integrations, and technical customizations using BI Publisher, OTBI, SQL, and REST/SOAP APIs in Hyderabad.

Job Description:

We are looking for an experienced Oracle Fusion Technical Consultant with strong expertise in Oracle Fusion Cloud technical development, BI Publisher (BIP), OTBI, SQL, and reporting. The candidate should have hands-on experience in developing reports, integrations, and technical customizations within Oracle Fusion Applications.

Required Skills:

  • Strong experience in Oracle Fusion Technical development.
  • Hands-on experience with BI Publisher (BIP) report development.
  • Experience in developing OTBI (Oracle Transactional Business Intelligence) analyses and dashboards.
  • Expertise in SQL, PL/SQL, and Oracle Database.
  • Experience with BIP Data Models, RTF templates, Excel templates, and bursting.
  • Knowledge of Fusion Security Roles and Data Security.
  • Experience with Oracle Fusion Web Services (SOAP/REST APIs).
  • Hands-on experience with File-Based Data Import (FBDI) and HDL/HSDL (preferred).
  • Experience with Oracle Integration Cloud (OIC) is an added advantage.
  • Good understanding of Fusion Business Objects and reporting architecture.
  • Experience in troubleshooting report performance and data issues.
  • Excellent analytical and communication skills.

Roles & Responsibilities:

  • Design and develop BI Publisher reports and data models.
  • Develop OTBI reports, dashboards, and analyses.
  • Create SQL queries and optimize report performance.
  • Develop custom technical solutions based on business requirements.
  • Work with functional consultants to gather reporting requirements.
  • Develop and support Fusion integrations using REST/SOAP services.
  • Perform unit testing, deployment, and production support.
  • Prepare technical design documents and maintain technical artifacts.
  • Resolve production issues related to reports and technical objects.

Nice to Have:

  • Oracle Integration Cloud (OIC)
  • FBDI/HDL
  • Visual Builder Studio (VBS)
  • Oracle Analytics Cloud (OAC)
  • XML Publisher
  • ADF knowledge (preferred)

Mandatory Skills:

  • Oracle Fusion Technical
  • BI Publisher (BIP)
  • OTBI
  • SQL
  • Oracle Fusion Reports
  • REST/SOAP APIs