Oracle E-Business Suite Consultant

We are seeking a skilled Oracle E-Business Suite (EBS) API Consultant with hands-on experience in integrating and extending Oracle EBS modules using public and private APIs. The ideal candidate will have deep expertise in Oracle EBS R12, PL/SQL, and API integration across functional areas such as Financials, SCM, HRMS, and Projects.

Key Responsibilities:

• Design, develop, and maintain custom integrations using Oracle EBS APIs (standard and custom).
• Work with Oracle standard APIs (like FND, HR, PO, AP, AR, GL, etc.) for data conversion, interface development, and automation.
• Develop and optimize PL/SQL procedures, functions, packages, and triggers.
• Collaborate with functional consultants and business users to gather requirements and translate them into technical solutions.
• Perform end-to-end testing of APIs, interfaces, and data migration scripts.
• Troubleshoot and resolve API issues, ensuring data accuracy and system performance.
• Maintain technical documentation, including integration design, API usage, and deployment steps.
• Provide support for existing EBS customizations and extensions.
• Participate in system upgrades, patching, and regression testing involving API functionality.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 5+ years of experience working with Oracle EBS R12, with a strong focus on APIs and PL/SQL.
• Deep understanding of EBS architecture and schema.
• Proven experience with Oracle EBS public APIs and Open Interfaces across various modules.
• Strong hands-on skills in PL/SQL, Oracle Forms, and Oracle Reports (if applicable).
• Experience with data conversion and interface development using Oracle APIs.
• Familiarity with tools like TOAD, SQL Developer, and Oracle Workflow.
• Excellent problem-solving and debugging skills.

Preferred Skills

• Experience with Oracle Integration Cloud (OIC) or Oracle SOA Suite.

• Knowledge of EBS modules like OM, INV, WIP, PA, HRMS.
• Experience with REST/SOAP web services and middleware platforms.
• Understanding of EBS personalization and extension frameworks (OAF, Forms Personalization).
• Agile/Scrum project experience.

Soft Skills:

• Strong communication and interpersonal skills.
• Ability to work independently and in a team environment.
• Attention to detail and commitment to quality.
• Excellent time management and organizational skills.

Certifications (Nice To Have):

• Oracle Certified Professional (OCP) – PL/SQL Developer or similar.
• Oracle EBS Functional or Technical Certification.