Technical Consultant - Oracle Integration Cloud Module (3-8 yrs)

Job Title : OIC Technical Consultant (PL-SQL)

We are looking for an experienced Oracle Integration Cloud (OIC) Technical Consultant with a strong background in integration patterns and hands-on experience with OIC activities.

The ideal candidate should possess expertise in OIC connections, integration configurations, fault handling, and Oracle SQL/PLSQL.

As an OIC Consultant, you will be responsible for managing integration projects, ensuring seamless operations, and collaborating with cross-functional teams to ensure that integrations run smoothly.

Key Responsibilities :

- Implement and configure Oracle Integration Cloud (OIC) activities such as Stage file, Local integration invoke, Wait, and Fault activity.

- Configure and manage different OIC connections, including SOAP, REST, DB, FTP, and ERP integrations, ensuring that they are set up properly for different integration scenarios.

- Develop and configure FTP-based operations, including file downloads, file listing, and error handling.

- Design, develop, and implement integrations using OIC and ensure their smooth operation through monitoring and debugging.

- Manage OIC fault-handling processes, including the configuration of Fault Handlers to address and resolve integration issues.

- Troubleshoot and resolve integration issues promptly to minimize downtime and service disruption.

- Integrate OIC with various external systems, including databases (DB), ERP applications, FTP servers, and SOAP/REST-based web services.

- Leverage OIC for orchestrated integrations, ensuring seamless data flow between systems.

- Implement FBDI-based or web service-based integrations to handle data exchanges with Oracle Cloud applications.

- Oversee the migration of OIC components, ensuring that the components are properly deployed and the integration scenarios work as expected in different environments.

- Monitor integration tasks and address issues proactively using OIC monitoring and debugging tools to resolve any operational challenges quickly.

- Configure and manage Lookup activities and troubleshoot related issues in integrations.

- Support certificate and key management, ensuring secure integrations in the cloud environment.

- Handle large file manipulations and optimize integrations for efficient data processing (e., segment reads).

- Ensure data security and integrity in integrations, specifically managing encryption and decryption processes for FTP connections and Stage file activity.

- Implement secure integrations by using appropriate encryption protocols and handling certificates securely.

- Develop and manage SQL and basic PL/SQL code for OIC integrations, ensuring data accuracy and integrity across systems.

- Provide support for database-related activities, such as querying data, modifying tables, and implementing logic in the integration process.

- Work closely with business analysts, project managers, and cross-functional teams to understand business requirements and translate them into technical solutions.

- Communicate effectively with clients and stakeholders regarding the status of integrations, changes, and updates.

- Experience with BIP (BI Publisher) Reports and their integration with Oracle systems.

- Familiarity with Kafka and OCI Streaming for streaming data integration.

- Knowledge of Library configuration in OIC for reusable integration components.

Experience :

- 3-8 years of hands-on experience in Oracle Integration Cloud (OIC), including designing, implementing, and managing integration solutions.

- Minimum of 2-6 years of experience with OIC activities, such as Stage file, Local integration invoke, Wait, and Fault handling.

- Strong experience with SOAP, REST, DB, FTP, and ERP connections in OIC.

- Proven experience with FBDI-based integrations or web service-based integrations (Oracle applications experience is a plus).

- Good understanding of OIC migration, monitoring, and debugging of integration components.

Technical Skills :

- Hands-on experience in SQL and basic PL/SQL.

- Understanding of Lookup configuration and handling security elements such as certificates and keys.

- Experience with FTP, including file operations like downloading, listing files, and managing encryption.

- Strong analytical and troubleshooting skills for OIC and related integration tools.

- Experience in handling large file manipulation and segment reads