Oracle Integration Cloud (OIC) and ODI

Role & responsibilities

• Requirement Analysis, Design, development
• Prepare Business Requirement Documents
• Build and maintain

  integration solutions using Oracle Integration Cloud (OIC) and Oracle Data Integrator (ODI)

  , ensuring seamless data flow across multiple enterprise systems.

• Design, develop, and optimize PL/SQL code

  , including packages, procedures, functions, and triggers, to support business applications and integration requirements.
• Develop, document, and manage

  REST and SOAP APIs

  , enabling secure and scalable application integrations.
• Collaborate closely with cross-functional teamsincluding business analysts, architects, and operationsto

  gather requirements, troubleshoot issues, and deliver robust, scalable solutions

  .
• Ensure

  performance, security, and scalability

  of database and integration components through proactive monitoring, tuning, and optimization.
• (Optional) Design and implement

  data pipelines using Apache NiFi

  , incorporating custom Java processors for advanced ETL and data orchestration workflows.
• Contribute to solution architecture discussions and best practices, focusing on reliability, maintainability, and alignment with enterprise standards.

Preferred candidate profile

• 10+ Years of experiences.
• Create and/or update specification documents to meet the buisness requirements.

• Strong expertise in PL/SQL

  : development of complex packages, procedures, functions, and query optimization within Oracle databases.

• Hands-on experience with Oracle Integration Cloud (OIC)

  and

  Oracle Data Integrator (ODI)

  for building robust integration workflows.
• Proven ability to design and consume

  REST and SOAP APIs

  , with a thorough understanding of integration patterns, authentication (OAuth2, JWT), and error handling.
• Experience with shell scripting.
• Experience with

  version control systems (Git, GitLab)

  and implementing

  CI/CD pipelines

  for automated builds, testing, and deployments.
• Working knowledge of

  message brokers

  such as

  ActiveMQ or RabbitMQ

  for reliable asynchronous messaging and event-driven architectures.
• Understanding of

  advanced integration concepts

  like message throttling, webhook patterns, retries, compensation, and data enrichment.
• Provide suggestions to customize Oracle applications for optimal performance.
• Resolve technical and operational problems in a timely fashion.
• Respond to customer queries and concerns promptly.
• Identify functional gaps and provide corrective actions.
• Ensure that project deliverables meet customer specifications.
• Support project team in developing reports, tables, fields, data interfaces and application extensions.
• Work with documentation team to develop user guides and training materials.
• Experience in the Retail domain is Plus

Perks and benefits

• Perks and benefits 30-50 Lacs per annum