Description

Must Have Technical/Functional Skills

Oracle EBS R12 (12.1/12.2) SCM internals; strong in OM, INV, WSH, PO, BOM, WIP, CST, QA.

CEMLI architecture; PL/SQL optimization; BI Publisher, Oracle Reports; OAF/Java customizations; Forms personalization; Workflows.

12.2 online patching (adop), editioning/EBR concepts, driver/file management.

Integrations: ISG (REST/SOAP), ORDS for REST, EDI (X12/EDIFACT), 3PL/TMS, file-based and middleware patterns (SOA/OIC/Mule/Kafka).

Performance: AWR/ASH, SQL Profiles, partitioning; concurrent manager tuning.

DB & App: Oracle DB 12c/19c, WebLogic, EBS tech stack administration concepts (working knowledge).

DevOps & Governance: Git, code review, build pipelines, migration tools (Kintana/ServiceNow), change control, audit readiness.

Good to have skills:

Exposure to ASCP/Demantra, EAM, Costing close performance improvements.

Experience with spin‑offs/divestitures: data carve‑out, object rationalization, cutover orchestration.

Cloud/OCI fundamentals (object storage, OAC, GoldenGate/ODI), security (IDCS/SSO).

Knowledge of tax engines (Vertex), shipping systems (FedEx/UPS/Loftware), and finance touchpoints (AR/AP/GL impacts).

Roles & Responsibilities

1) Architecture & Solution Design

Define and govern target technical architecture for Oracle EBS R12 SCM (OM, INV, WSH, PO, BOM, WIP, CST, QA, ASCP).

Lead fit–gap, solution blueprints, and HLD/LLD for RICEW (Reports, Interfaces, Conversions, Extensions, Workflows).

Establish coding standards (PL/SQL, OAF/Java, Oracle Forms, BI Publisher, Oracle Reports) and reusable patterns.

Guide 12.2.x online patching (adop) compliance: file system standards, editioning views, EBR-safe objects.

2) Integrations & Data

Architect integrations with 3PLs/Carriers, EDI (850/855/856/810), TMS/WMS, MES, CRM, Tax, Banking.

Use appropriate options: DB links, AQ/Advanced Queues, ISG (Integrated SOA Gateway), REST via ORDS, Web services, flat files, or middleware (SOA/OIC/Mulesoft).

Own data migration strategy (items, BOM, routings, on-hand, suppliers/customers, open orders/POs, pricing, banks).

Ensure data quality, idempotency, and reconciliation frameworks; design error handling & reprocessing

Key Skills

Education

Bachelor's degree