Senior Oracle EBS R12 & OIC Technical Consultant - SCM Integration

Techagi Solutions Llc
Santa Clara, CA, United States
3 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Application Frameworks Unit Testing Cloud Computing Computer Programming Databases Concurrent Computing Software Debugging Software Design Documents JSON Oracle (Applications) Oracle Forms
+17 more
Performance Tuning Service-Oriented Architecture Shell Script Simple Object Access Protocol (SOAP) Software Deployment PL-SQL SQL Databases Oracle Fusion Middleware Extensible Markup Language (XML) Data Logging File Transfer Protocol (FTP) Sql Optimization SOAPAPI Integration Tests Oracle Ebusiness Restful APIs Sql Tuning

Job description

  • Design, develop, and maintain Oracle EBS R12 technical components using SQL, PL/SQL packages, procedures, functions, views, triggers, and staging tables.
  • Develop Oracle EBS public APIs, open interfaces, custom concurrent programs, and request sets.
  • Implement FND_REQUEST processing and interface error-handling mechanisms.
  • Design, develop, and support OIC integrations using REST, SOAP, JSON, XML, SFTP, database, and file-based integration methods.
  • Develop bidirectional integrations between Oracle EBS R12 and Oracle Fusion Cloud.
  • Build data extracts and interfaces for Inventory, BOM, WIP, Purchasing, Order Management, MRP/ASCP, and SCM Planning.
  • Support integration of items, suppliers, inventory balances, forecasts, demand, supply, purchase orders, work orders, and planning recommendations.
  • Implement integration controls, including logging, reconciliation, retry mechanisms, duplicate prevention, and monitoring.
  • Troubleshoot SQL performance, concurrent program failures, API errors, OIC mappings, and data-quality issues.
  • Support technical design documentation, unit testing, CRP, SIT, UAT, cutover, go-live, and hypercare.
  • Develop or support custom Oracle Forms when required.

Requirements

  • 8-10+ years of Oracle technical development experience.
  • Strong hands-on Oracle EBS R12 development.
  • Advanced SQL/PLSQL programming, debugging, and performance tuning.
  • Oracle EBS public APIs, open interfaces, concurrent programs, and staging tables.
  • Hands-on Oracle Integration Cloud (OIC) development.
  • REST/SOAP web services, JSON, XML, and SFTP integration experience.
  • Knowledge of Oracle EBS manufacturing and SCM modules.
  • Experience with Inventory, BOM, WIP, Purchasing, Order Management, and MRP/ASCP.
  • Unix/Linux and shell scripting.
  • Experience supporting integration testing, troubleshooting, and production deployments.

Preferred Skills

  • Oracle Fusion SCM Planning Cloud.
  • Oracle Demand Management.
  • Oracle Supply Planning.
  • Oracle Application Framework (OAF).
  • Oracle Forms development.
  • Oracle EBS Integrated SOA Gateway.
  • Manufacturing or global supply chain implementation experience.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…