Associate Lead Consultant - OIC-Oracle Integration Cloud Job

YASH Technologies; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

YASH Technologies in Pune, India, is seeking an experienced Oracle integration specialist to lead design and development of scalable integration solutions using OIC Gen3. The role focuses on building complex integrations, orchestrations, and automations with robust error handling and security considerations.

You will design REST and SOAP APIs, data mappings with XSLT, and manage batch/import flows using FBDI and SFTP, while collaborating with analysts and stakeholders.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
• 8–10 years of overall integration development experience.
• 5+ years with Oracle middleware and 3+ years on Oracle Integration Cloud (OIC).
• Deep knowledge of Oracle ERP, HCM, or SCM modules.
• Proficient in SQL, PL/SQL, JSON, XML, WSDL, and XSLT.
• Familiar with OCI concepts, OAuth, JWT, and SSL/TLS certificate management.
• Ability to translate requirements into technical integration specifications.
• Strong accountability, agility, collaboration, customer focus, communication, drives results, and conflict resolution.

Responsibilities

• Lead the design of scalable, secure, and high-performance integration solutions using OIC Gen3.
• Build and configure complex integrations, orchestrations, and process automations; define error handling, retry, and fault frameworks.
• Design, develop, and secure REST and SOAP APIs using JSON and XML.
• Create complex data mappings, transformations, and schema validations using XSLT and XSD.
• Implement batch integrations utilizing File-Based Data Import (FBDI), SFTP polling, and large file handling.
• Monitor integration flows, debug errors, and provide root‑cause analysis for production support issues.
• Partner with functional analysts and business stakeholders to translate requirements into technical integration specifications.
• Prepare and execute SIT scenarios, end‑to‑end validation of integrations; support UAT and fix defects.
• Post‑go‑live monitoring and stabilization, knowledge transfer and support.

Skills

OIC Gen3

Oracle middleware

Oracle Integration Cloud (OIC)

SQL

PL/SQL

JSON

XML

WSDL

XSLT

OCI concepts

OAuth

JWT

SSL/TLS management

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field

Tools

FBDI

SFTP

REST API Development

SOAP API Development

Job description

Key Responsibilities

• Lead the design of scalable, secure, and high-performance integration solutions using OIC Gen3.
• Build and configure complex integrations, orchestrations, and process automations. Define error handling, retry, and fault frameworks.
• Design, develop, and secure REST and SOAP APIs using JSON and XML.
• Create complex data mappings, transformations, and schema validations using XSLT and XSD.
• Implement batch integrations utilizing File-Based Data Import (FBDI), SFTP polling, and large file handling.
• Monitor integration flows, debug errors, and provide root‑cause analysis for production support issues.
• Partner with functional analysts and business stakeholders to translate requirements into technical integration specifications.
• Prepare and execute SIT scenarios, end‑to‑end validation of integrations. Support business users during UAT and fix defects.
• Post‑go‑live monitoring and stabilization, knowledge transfer and support.

Required Qualifications

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
• Experience: 8–10 years of overall experience in integration development.
• OIC Expertise: 5+ years of hands‑on experience with Oracle middleware, with 3+ years dedicated specifically to Oracle Integration Cloud (OIC).
• Oracle Cloud Modules: Deep functional and technical knowledge in Oracle ERP, HCM, or SCM modules.
• Technical Stack: Proficiency in SQL, PL/SQL, JSON, XML, WSDL, and XSLT.
• Cloud & Security: Familiarity with OCI concepts, OAuth, JWT, and SSL/TLS certificate management.
• Behavioral Competencies: Accountability, Agility, Collaboration, Customer Focus, Communication, Drives Results, and Resolves Conflict (see details below).

Required Behavioral Competencies

• Accountability: Role model initiative, remove obstacles, own results, identify risks, and maintain strong stakeholder communication.
• Agility: Adapt and motivate team in changing environments.
• Collaboration: Ensure connections within the team, find integration opportunities with other groups, and adjust work for successful outcomes.
• Customer Focus: Engage in executive discovery, predict customer needs, and build long‑term relationships for loyalty.
• Communication: Present complex ideas to various stakeholders, facilitate transparent conversations, and help others communicate effectively.
• Drives Results: Seek challenging opportunities and motivate team members to take on more responsibilities.
• Resolves Conflict: Balance stakeholder interests and manage conflicts, offering mutually beneficial solutions.

Certifications

• Mandatory (details to be provided by the hiring team).