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.
- 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.
Similar Jobs
What We Do
ProArch was founded on the belief that a future where change is ‘business as usual’ is fundamentally more exciting than one where it is not. We accelerate value and increase resilience for our clients with consulting and technology - enabled by cloud, guided by data, fueled by apps, and secured by design
