Resume Score
CV/Résumé Score
  • Expertini Resume Scoring: See how well your CV/Résumé matches this job: Oracle Technical Consultant – OIC & PL/SQL Developer.
Patna | Expertini

Urgent! Oracle Technical Consultant – OIC & PL/SQL Developer Job | Proso.ai

Oracle Technical Consultant – OIC & PL/SQL Developer



Job description

Job Title: Oracle Technical Consultant – OIC & PL/SQL Developer

Location: Work from Home

Experience: 5+ Years

Shift: US Rotational Shift

Employment Type: Full-Time


About the Role:

We are looking for a highly skilled Oracle Technical Consultant with strong hands-on experience in Oracle Integration Cloud (OIC) and PL/SQL development.

The ideal candidate will have deep technical expertise in designing, developing, and optimizing Oracle Cloud integrations, along with strong programming skills in procedures, functions, packages , and REST API development.

This is a remote position , requiring flexibility to work in US rotational shifts and collaborate effectively with global teams and clients.


Key Responsibilities:

  • Design, develop, and implement integrations using Oracle Integration Cloud (OIC) for Oracle Fusion ERP and HCM applications.

  • Develop and optimize complex PL/SQL procedures, functions, packages , and triggers.

  • Work with REST and SOAP APIs for data exchange between Oracle Fusion Cloud and third-party systems.

  • Perform data extraction, transformation, and loading (ETL) activities using FBDI, HDL , and other Oracle integration tools.

  • Build integration error handling and fault management frameworks.

  • Collaborate with functional and technical teams to translate business requirements into technical solutions.

  • Participate in unit testing, SIT, and UAT phases to ensure successful integration delivery.

  • Troubleshoot and resolve performance or data-related issues in integrations and database procedures.

  • Maintain documentation, including technical design, mapping sheets, and test scripts.


Required Skills & Qualifications:

  • 5+ years of technical experience in Oracle Fusion Cloud integrations and development.

  • Strong expertise in Oracle Integration Cloud (OIC) – integrations using REST, SOAP, File-based, and scheduled flows.

  • In-depth proficiency in Oracle PL/SQL , including complex procedures, functions, packages , and query optimization.

  • Hands-on experience with REST API design, development, and integration.

  • Exposure to Oracle ERP or HCM Cloud modules and data models.

  • Good knowledge of FBDI, BIP, HDL , and data conversion/migration processes.

  • Familiarity with error handling, logging frameworks, and OIC monitoring tools.

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

  • Excellent communication and collaboration skills for working with distributed teams.


Required Skill Profession

Other General



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Oracle Technical Potential: Insight & Career Growth Guide


Advance your career or build your team with Expertini's smart job platform. Connecting professionals and employers in Patna, India.