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

Job Title : Technical Consultant Oracle Integration Cloud (OIC) with PLSQL

Job Location : Hyd / Bglr / Mum/pune/Del/chennai /Kolkata

Experience: 4+ Yrs

Job Summary :

We are seeking a highly skilled Oracle Integration Cloud (OIC) Technical Consultant with strong expertise in PL/SQL to join our team. The ideal candidate will be responsible for designing, developing, and implementing integrations using Oracle Integration Cloud (OIC) while ensuring seamless data exchange across enterprise applications. The candidate must have hands-on experience in Oracle PLSQL development, working with REST/SOAP web services, and troubleshooting integration issues.

Key Responsibilities :

Oracle Integration Cloud (OIC) Development :

- Design, develop, and deploy end-to-end integrations using Oracle Integration Cloud (OIC).

- Create and configure OIC Adapters for applications like Oracle ERP, HCM, EBS, and third-party systems.

- Develop and maintain custom integrations, orchestrations, and data mappings.

- Monitor, troubleshoot, and optimize OIC integrations for performance and reliability.

PL/SQL Development :

- Develop, optimize, and maintain PL/SQL stored procedures, triggers, functions, and packages.

- Perform data transformation, validations, and migrations using PL/SQL and SQL queries.

- Design efficient database objects to support integration solutions.

Web Services & API Management :

- Develop and consume RESTful and SOAP web services for integrations.

- Work with JSON, XML, and other data interchange formats for API integrations.

- Secure API communications using OAuth, JWT, or basic authentication mechanisms.

Enterprise Application Integration (EAI) :

- Implement real-time and batch integration between Oracle Cloud and on-premise applications.

- Work with Middleware tools like Oracle SOA Suite, MuleSoft, or Dell Boomi (preferred but not mandatory).

- Configure and manage integration flows, connectivity agents, and lookup tables in OIC.

Collaboration & Support :

- Work closely with functional consultants, business analysts, and stakeholders to understand integration requirements.

- Provide support for integration issues, troubleshooting, and performance tuning.

- Conduct code reviews and follow best practices in CI/CD pipelines for OIC deployments.

Required Skills & Experience :

- 5+ years of experience in IT with a strong focus on Oracle Integration Cloud (OIC) and PL/SQL.

- Hands-on expertise in developing OIC integrations, including configuring adapters, designing orchestrations, and troubleshooting issues.

- Strong proficiency in PL/SQL programming, including writing complex stored procedures, functions, and queries.

- Experience in working with REST and SOAP APIs for application integrations.

- Good understanding of Oracle Cloud ERP, HCM, or EBS modules.

- Knowledge of data migration strategies, integration security, and authentication mechanisms.

- Experience with version control tools like Git, Bitbucket, or similar.

- Strong problem-solving, debugging, and analytical skills.

Preferred Skills (Good to Have) :

- Experience with Oracle SOA Suite, MuleSoft, or Dell Boomi.

- Exposure to OAuth authentication, JWT tokens, and API security best practices.

- Experience with CI/CD pipelines for Oracle Cloud deployments.

- Knowledge of cloud infrastructure (Oracle Cloud, AWS, Azure) and containerization tools like Docker/Kubernetes .

Educational Qualifications :

- Bachelors or Masters degree in Computer Science, Information Technology, or a related field.

- Oracle Cloud Integration or PL/SQL certifications (preferred but not mandatory).