Oracle Technical Consultant - Reporting, Integration and ERP

Jade Global Software Pvt Ltd; Pune District; On-site; INR 1,300,000 - 2,100,000; Full time

Job summary

Jade Global Software Pvt Ltd in Pune seeks an experienced Oracle Technical Consultant to design and implement cloud-to-cloud and cloud-to-on-premise integrations using OIC, REST/SOAP APIs, and FBDI. You will create scalable interfaces and automate tasks with ESS jobs, while ensuring quality through documentation and testing.

Responsibilities include reporting with BI Publisher, OTBI, and FRS, writing complex SQL/PL/SQL, and building templates for invoices, POs, and compliance outputs.

Qualifications

• Bachelor’s degree or equivalent practical experience in CS/IS/Software Engineering.
• 4–7+ years of hands-on Oracle Technical Consulting experience.
• 2 full-lifecycle Oracle Cloud ERP implementations.

Responsibilities

• Integrations design, development, and data migration using OIC and REST/SOAP APIs.
• Developing BI Publisher, OTBI, and data models for reporting and analytics.
• Translate specs to LLDs, support releases, testing, and SLA-compliant issue resolution.

Skills

Oracle Integration Cloud (OIC)

SOA Suite

REST

SOAP

JSON

XML

FBDI

ADFdi

Oracle WebCenter Content (UCM) APIs

BI Publisher

OTBI

SQL

PL/SQL

Oracle Cloud ERP data models

Education

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or equivalent practical experience

Tools

OIC

SOA Suite

Job description

INTERNAL Oracle Technical Consultant (Reporting, Integration, ERP) INTERNAL Oracle Technical Consultant (Reporting, Integration, ERP)2

Key Responsibilities

Integration & Data Migration: Design, develop, and maintain cloud-to-cloud and cloud-to-on-premise integrations using Oracle Integration Cloud (OIC) . Build scalable interfaces utilizing REST/SOAP APIs, FBDI (File-Based Data Import), and ADFdi templates for inbound/outbound batch and real-time processing. Configure custom ESS (Enterprise Scheduler Service) jobs to automate technical tasks, data loads, and interface processing. Monitor OIC instances, diagnose interface errors, handle payload failures, and maintain technical documentation.

Reporting & Analytics: Design and maintain operational reports, layouts, and data models using BI Publisher (BIP) , OTBI (Oracle Transactional Business Intelligence) , and FRS (Financial Reporting Studio) . Write, optimize, and test complex SQL queries and PL/SQL procedures against Oracle SaaS/PaaS database structures. Develop custom BI Publisher templates (e.g., eText, RTF, XSL-FO) for invoices, purchase orders, payment files, and compliance outputs.

Technical Delivery & Support: Translate functional specifications into Low-Level Technical Design (LLD) documents (e.g., RICEFW objects). Assist with quarterly Oracle Cloud release patch analysis, regression testing, and interface validation. Troubleshoot production issues, identify root causes, and resolve ticket escalations adhering to established SLAs.

Qualifications & Requirements

Education: Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or equivalent practical experience.

Experience: 4–7+ years of hands-on experience as an Oracle Technical Consultant, with at least 2 full-lifecycle Oracle Cloud ERP implementations.

Technical Skills: Oracle ERP Modules: Deep technical familiarity with Oracle Cloud ERP (Financials, Procurement, SCM) data models and standard APIs. Integrations Platform: Hands-on experience with Oracle Integration Cloud (OIC), SOA Suite, and web services protocols (REST, SOAP, JSON, XML). Reporting Architecture: Advanced skills in Oracle BI Publisher, OTBI, SQL, and PL/SQL. Data Load Tools: Hands-on usage of FBDI, ADFdi, and Oracle WebCenter Content (UCM) APIs.

Soft Skills: Strong problem-solving and analytical skills with high attention to performance tuning. Excellent written and verbal communication skills to collaborate effectively with functional teams and external stakeholders.

Experience Level Senior Level