Oracle Technical Consultant - EBS

Amtec Staffing; Pasadena (CA); On-site; USD 102,000 - 168,000; Full time

Job summary

Amtec Staffing in Pasadena, CA seeks an Oracle EBS Technical Analyst/Oracle EBS Consultant for a 1-year contract with extension potential. The role centers on configuring Oracle EBS R12, conducting fit-gap analyses, and building scalable SQL/PLSQL code to support complex inventory and manufacturing workflows.

You will collaborate with the Lead ESA, map as‑is to to‑be processes, optimize performance, and prepare design documents.

Qualifications

• Two+ Oracle EBS R12 implementations with ODM/MRP experience.
• Deep technical knowledge of ODM/MRP and Inventory workflows.
• Ability to map As‑Is processes to Oracle EBS standard functionality.
• Strong SQL/PLSQL coding and reporting skills.

Responsibilities

• Collaborate with the Lead ESA to review and refine requirements.
• Conduct fit-gap analyses and present practical options.
• Map current to future business workflows in Oracle EBS.
• Recommend configuration updates to optimize processes.
• Support feature changes aligned with approved designs.
• Troubleshoot issues and manage Oracle Service Requests.
• Create functional/technical design documents and flows.
• Develop SQL/PLSQL code and optimize performance.

Skills

Oracle EBS R12

SQL/PLSQL

ODM/MRP

Inventory management

Problem solving

Tools

Form Personalization

BI Publisher

Custom.pll

Interfaces/APIs

Job description

Job Title: Oracle EBS Technical Analyst/ Oracle EBS Consultant

1-year contract with possibility of extension/conversion

Pay: $74.00- $122.00 hourly

Complex Challenges. Real Impact. We’re looking for an Oracle Technical Consultant ready to tackle challenging systems and support innovative, mission-driven technology.

No C2c or Corp-to-Corp partnership

Key Responsibilities

• Collaborate with the Lead ESA (Enterprise Systems Analyst) to review existing business requirements and gather new requirements from stakeholders
• Conduct fit-gap analyses and present options
• Map current-state and future-state business workflows
• Recommend Oracle configuration updates to optimize business processes
• Support ESA in implementing new features and/or system changes aligned with approved functional designs
• Troubleshoot application issues through resolution
• Log and manage Oracle Service Requests
• Create and update functional design documents, technical design documents, and process flows associated with configurations or approved customizations
• Develop scalable Oracle SQL/PLSQL code including procedures, functions, packages, and triggers
• Update existing code to meet evolving requirements
• Tune and optimize queries for performance
• Build or retrofit interfaces, APIs, and data loaders
• Support custom extensions including Form Personalization and custom.pll
• Diagnose system bottlenecks, debug functional and technical issues, and apply fixes
• Support testing and user training activities
• Perform additional duties as directed by project team
• Provide bi-weekly status reports

Required Skills

• Demonstrated experience delivering two or more Common Inventory implementations as part of broader ODM/MRP deployments in Oracle eBS R12.13.x.
• Deep functional and technical expertise in ODM, including Inventory and Oracle Master Scheduling/MRP
• Ability to map, fit, and enhance complex "As-Is" business processes into Oracle EBS standard functionality
• Expert-level knowledge of ODM/MRP including Inventory setup steps, profile options, and system parameters to optimize performance
• Comprehensive understanding of the ODM lifecycle: BOM, Inventory, WIP, MRP, Purchasing, and Costing
• Strong understanding of upstream and downstream integration points
• Strong technical skills: Oracle SQL, PL/SQL, Form personalization, custom.pll, and BI Publisher reports
• Strong analytical and problem-solving skills