Job Title: Consultant / Senior Consultant – Oracle Integration Cloud (OIC) & PL/SQL / SQL

Experience Required:

- Consultant: 2 to 5 years

- Senior Consultant: 5 to 8 years

Job Summary:

We are seeking experienced Consultants and Senior Consultants with a strong background in Oracle Integration Cloud (OIC) and PL/SQL / SQL development. The ideal candidate will be responsible for designing, developing, and maintaining integration solutions and backend logic across enterprise applications.

Key Responsibilities:

·      Develop and manage integrations using Oracle Integration Cloud (OIC), including App Driven Orchestration, Scheduled Orchestration, and File-Based Integrations.

·      Write efficient PL/SQL and SQL scripts to support backend processes and ensure data consistency.

·      Work with cross-functional teams to understand business requirements and deliver integration solutions.

·      Ensure security, error handling, and logging for integration flows.

·      Maintain and enhance existing integration solutions and support incident resolution.

·      Document technical specifications, integration designs, and deployment steps.

·      Collaborate with Oracle Cloud applications and external systems to establish robust connectivity.

·      Write efficient and optimized SQL and PL/SQL queries to manage large-scale datasets.

·      Perform data quality checks, troubleshooting, and performance tuning of data jobs.

Key Skills:

·      Strong hands-on experience in Oracle Integration Cloud (OIC).

·      Advanced PL/SQL and SQL development skills.

·      Familiarity with REST/SOAP APIs, JSON, XML, and web services.

·      Good understanding of Oracle Cloud applications (ERP, HCM, etc.).

·      Experience in designing and implementing scalable integration solutions.

·      Strong problem-solving and communication skills.