Location: Los Angeles, CA — Hybrid (3 days onsite at client location: Tuesday, Wednesday, Thursday)
Duration: 6 months
Employment Type: Contract
Work Authorization: US work authorization required (no sponsorship)
Competencies:
- 10+ years of relevant experience
- Expert-level Oracle SQL and PL/SQL
- Proven experience with Oracle E-Business Suite (EBS) R12 Order Management and Advanced Pricing
Role Description — Key Responsibilities and Skills
- Design, develop, test, and support Oracle EBS R12 technical solutions focused on Order-to-Cash (O2C), including Order Management and Shipping modules
- Implement and maintain Oracle Advanced Pricing configurations: pricing qualifiers, formulas, modifiers, and pricing rules
- Develop and maintain custom code and integrations using PL/SQL, APIs, concurrent programs, workflows, and Oracle development tools
- Perform sales order lifecycle activities: order creation, updates, booking, scheduling, fulfillment, delivery creation, and shipping confirmation support
- Develop and maintain XML Publisher (BIP) reports, FDI/OTBI extracts, and other BI/reporting artifacts supporting Order Management and Shipping
- Design, build, and troubleshoot integrations using REST and SOAP APIs; validate payload structures, field mappings, and data flows
- Leverage Oracle PaaS services for integration logic, extensions, and custom services as required
- Support and validate mappings between EBS OM/Shipping transactions and Oracle Fusion SaaS Order Management and Inventory data models and APIs
- Diagnose and resolve application issues, analyze logs, and perform root-cause analysis for production and non-production environments
- Perform metadata and data model analysis, optimize SQL and PL/SQL performance, and enforce coding standards and change-control practices
- Collaborate with functional analysts, business stakeholders, integration teams, and third-party vendors to translate business requirements into technical solutions
- Provide technical documentation, runbooks, and knowledge-transfer materials to support ongoing operations and handoffs