Senior Oracle EBS R12 & OIC Technical Consultant - SCM Integration
Techagi Solutions Llc
Santa Clara, CA, United States
3 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦