Oracle EBS Technical Consultant

Oracle EBS Integration Development

• Design develop and maintain integrations between Oracle EBS R12 and external applications.
• Develop and consume REST and SOAP web services.
• Build and support Oracle SOA Suite integrations BPEL processes Mediator services and adapters.
• Integrate AI/Automation platforms with Oracle EBS Finance and Supply Chain modules.
• Develop inbound and outbound interfaces using Oracle APIs Open Interfaces Interface Tables and Concurrent Programs.
• Troubleshoot integration issues and perform root cause analysis.

Technical Development

• Develop and customize Oracle Forms Reports PL/SQL packages procedures and database objects.
• Create reusable integration frameworks and APIs.
• Utilize XML Publisher (BI Publisher) for reporting requirements.
• Develop data extraction and transformation processes for AI automation use cases.
• Support performance tuning of SQL PL/SQL and integration components.

Solution Design

• Analyze business requirements and translate them into technical solutions.
• Prepare technical design documents interface specifications and deployment documents.
• Collaborate with functional consultants business users AI teams and external vendors.
• Ensure integrations comply with enterprise security and governance standards.

Support & Governance

• Participate in end-to-end testing UAT support and production deployments.
• Provide L2/L3 support for integration and interface-related issues.
• Monitor integration performance and recommend improvements.
• Support release management and migration activities.

Integration Technologies

• REST API Development and Consumption
• SOAP Web Services
• Oracle SOA Suite
• BPEL
• Mediator
• Oracle Service Bus (OSB) preferred
• JSON XML XSD WSDL

Database & Development

• Advanced SQL
• PL/SQL
• Oracle Database Performance Tuning
• Shell Scripting

Integration Tools

• Postman
• Swagger/OpenAPI