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,

📌 INTERNAL Oracle Technical Consultant (Pune)
🏢 Jade Global
📍 Pune