Oracle Cloud Consultant

Company Name:

Job Title:

Experience:

Location:

Work Mode:

Salary:

Employment Type:

Role Overview

The Application Developer - Oracle Cloud Middleware will design, build, and support integrations across Oracle Fusion Cloud using Oracle Integration Cloud (OIC). The role focuses on creating reliable REST/SOAP and file-based integrations, leveraging Oracle application adapters and strong SQL/PL/SQL skills for data management. The developer will troubleshoot and optimize OIC flows, ensure secure connectivity, and enable batch and real-time data movement with Fusion ERP/HCM/SCM and external systems. The position requires hands-on ownership of integration lifecycle activities including design, development, testing, deployment, monitoring, and continuous improvement.

Required Qualifications

• 5+ years of experience in Oracle Fusion Cloud technical development with strong hands-on Oracle Integration Cloud (OIC)
• Proven experience integrating Oracle Fusion Cloud modules (ERP/HCM/SCM) with external systems using OIC adapters and APIs
• Strong proficiency in REST/SOAP web services, API design/consumption, and Oracle application adapters
• Advanced SQL and PL/SQL for queries, procedures, performance tuning, and data troubleshooting
• Experience with Oracle ETL tools (e.g., Oracle Data Integrator - ODI) for data migration and batch integrations
• Understanding of Oracle Fusion Cloud architecture, configuration, and customization capabilities
• Hands-on with data formats and transformations: JSON, XML, XSD, XSLT, and OIC mapper
• Familiarity with integration patterns: app-driven, scheduled, file-based, and publish/subscribe events
• Security implementation for integrations: OAuth2, Basic Auth, certificates/keystores
• Monitoring, alerting, and error-handling frameworks within OIC
• Version control and environment promotion practices (e.g., export/import, packages, Git)
• Strong communication, documentation, and stakeholder collaboration skills

Responsibilities

• Design, develop, and maintain integrations using Oracle Integration Cloud (OIC) connecting Oracle Fusion Cloud with external applications
• Configure OIC connections/adapters (ERP/HCM/SCM, REST/SOAP, FTP/SFTP, database) and implement orchestration flows
• Build mappings and transformations (JSON/XML/XSLT) and implement robust error handling and retry logic
• Implement secure authentication/authorization (OAuth2, certificates) and manage connectivity credentials/keystores
• Develop and optimize SQL/PL/SQL for data extraction, validation, and transformation related to integrations
• Plan and execute batch data migrations and ETL jobs leveraging Oracle ETL tools (e.g., ODI)
• Monitor integrations, troubleshoot incidents, perform root-cause analysis, and improve reliability/performance
• Collaborate with functional/technical teams to analyze requirements and translate them into scalable integration designs
• Prepare technical documentation, test cases, and support SIT/UAT and production cutovers
• Manage versioning and deployment of integrations across environments and support change management processes