Oracle Technical Consultant (OIC-BIP)

Location: Offshore
Experience: 6+ years

Role Overview

Seeking an experienced Oracle Technical Consultant with strong hands-on expertise in Oracle Integration Cloud (OIC) and BI Publisher (BIP) for Oracle ERP Cloud. The role requires expertise in complex integrations, outbound reporting, payment-related solutions, performance optimization, and scalable integration frameworks.

Key Responsibilities

• Design, develop, test, deploy, and support OIC integrations for Oracle ERP Cloud.

• Develop and maintain complex BIP reports using RTF, Excel, and other formats.

• Build outbound integrations and reporting solutions, including bank payment/payment-related reports.

• Design scalable, reusable, and common OIC integration frameworks.

• Troubleshoot and optimize OIC integrations and BIP reports across environments.

• Optimize BIP performance across SQL queries, data models, and report templates.

• Work with REST/SOAP APIs, XML, SQL, and Oracle ERP Cloud interfaces.

• Support technical design, SIT/UAT, deployments, and production issues.

• Clearly explain technical architecture, design decisions, implementation, and troubleshooting approaches.

• Follow Oracle development standards, best practices, and reusable design patterns.

Required Skills

• 5+ years of Oracle technical development experience.

• Strong hands-on experience with OIC and BIP.

• Expertise in BIP RTF/Excel reports and performance optimization.

• Experience with complex outbound integrations and reporting.

• Bank Payment or payment-related reporting experience is mandatory.

• Strong knowledge of scalable and reusable OIC frameworks.

• Proficiency in REST/SOAP, XML, SQL, and Oracle ERP Cloud.

• Strong troubleshooting and technical solutioning skills.

• Experience with Oracle ERP Cloud integration and technical development patterns.

Good to Have

• Oracle Cloud technical certification.

• Experience with OTBI and Oracle Visual Builder.

• Knowledge of Oracle ERP Cloud Financials and payment processes.

• Exposure to enterprise integration architecture and reusable frameworks.