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