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

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:

• OIC integrations and orchestrations
• REST / SOAP integrations
• File-based integrations
• Data transformation (XML, JSON, XSLT)
• UI page development
• Business objects and service connections
• JavaScript / HTML / CSS
• REST API integration
• Data model creation
• SQL query development
• RTF / Excel template design
• Report scheduling
• 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