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.