Oracle Cloud Technical Consultant (OIC, VBCS, BIP & OCI)5

Oracle Integration Cloud (OIC)

• Design and develop integrations using Oracle Integration Cloud (OIC).

• Build orchestration integrations and process flows.

• Integrate Oracle Fusion Applications, Oracle EBS, and third-party systems.

• Work with REST APIs, SOAP services, and file-based integrations.

• Configure and use OIC adapters, such as:

  • ERP Cloud Adapter

  • REST Adapter

  • SOAP Adapter

  • FTP Adapter

  • Database Adapter

• Perform data transformation using XML, JSON, and XSLT.

• Monitor integrations and troubleshoot errors.

Application Development (VBCS)

• Develop web and mobile applications using Oracle Visual Builder Cloud Service (VBCS).

• Design UI components, pages, and layouts.

• Create business objects and service connections.

• Integrate VBCS applications with REST APIs and Oracle Fusion services.

• Develop custom dashboards and workflow applications.

• Use JavaScript, HTML, CSS for UI customizations.

Reporting (BI Publisher / BIP)

• Develop and maintain BI Publisher (BIP) reports.

• Create data models using SQL queries.

• Design report templates using:

  • RTF templates

  • Excel templates

  • PDF templates

• Generate financial, operational, and transactional reports.

• Work with Fusion OTBI and BI Publisher reports.

• Schedule and manage report jobs.

Oracle Cloud Infrastructure (OCI)

• Basic to intermediate experience in Oracle Cloud Infrastructure services.

• Manage and configure:

  • OCI Compute Instances

  • Object Storage

  • Virtual Cloud Network (VCN)

  • Load Balancers

• Deploy and manage Oracle Cloud resources.

• Monitor applications using OCI monitoring and logging services.

• Work with OCI Identity and Access Management (IAM).

• Support cloud deployments and integrations with OIC.

Required Skills

Oracle Integration Cloud

• OIC integrations and orchestrations

• REST / SOAP integrations

• File-based integrations

• Data transformation (XML, JSON, XSLT)

Oracle Visual Builder Cloud Service

• UI page development

• Business objects and service connections

• JavaScript / HTML / CSS

• REST API integration

BI Publisher

• Data model creation

• SQL query development

• RTF / Excel template design

• Report scheduling

Oracle Cloud Infrastructure

• OCI architecture fundamentals

• VCN networking concepts

• Object storage management

• Compute instance management

• IAM policies and security

Preferred Skills

• Experience integrating Oracle Fusion Finance, SCM, or HCM.

• Experience in EBS to Fusion migration projects.

• Knowledge of Oracle Integration patterns and API management.

• Experience with OTBI reporting.

• Exposure to DevOps and CI/CD in Oracle Cloud.

Educational Qualification

• Bachelor’s degree in Computer Science / IT / Engineering.

Certifications (Preferred)

• Oracle Integration Cloud Certification

• Oracle Visual Builder Certification

• Oracle BI Publisher Certification

• Oracle Cloud Infrastructure Certification