Job Details

Pay Rate Range: $ 53.57 - 55.14/hr.
GBaMS ReqID: 10605112

Job Description:
Must be hands-on on integration
Good knowledge of CEMLI architecture; PL/SQL optimization; BI Publisher, Oracle Reports; OAF/Java customizations; Forms personalization; Workflows.

Pre-Screening Questionnaire:
1.Which RICEW components have you built most (interfaces/reports/conversions/workflows)?
2.Explain how you design an inbound interface in EBS (staging, validation, load, import, error handling).
3.How do you troubleshoot a failed concurrent request (logs, trace, FND diagnostics)?
4.Which tools have you used for BI Publisher/XMLP and how do you handle bursting/layout issues?
5.How do you debug SLA/XLA accounting issues from a technical perspective?
6.What is your approach to performance tuning a slow PL/SQL report/interface?
7.Describe an integration with a boundary application (bank, tax, OCR, CRM).
8.Have you supported R12.2 patching/ADOP impacts on custom objects?

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.

Generic Managerial Skills, If any: N/A

Key Words to search in Resume: Oracle Technical Architect

Education: Bachelor's Degree or higher

Experience Range: 10+ Years

REQ Intake:
Preferred Rates Range for developer: *** - ***
Duration of assignment: 9-12 months
Bill rate flexible: NO
If yes, what's the max bill rate suppliers can submit profiles at? 75$
Location and zip code (city, state, and zip code): Cleveland OH 44122
Remote/hybrid/On-site: Remote
Do you have a pre-identified candidate in mind? no
# of round of interviews: 2
Will there be an interview with the end client? Yes

Rate
Please note: While the rate range is provided for guidance, we encourage suppliers to avoid submitting candidates near the maximum unless they fully meet all listed qualifications and experience requirements.
Rate Guidance: Submit at a rate that reflects their actual experience and fit for this role.

Background Check Requirements:
Does this position require a 2nd background check? No
Is this position limited to U.S. citizens and does not offer sponsorship for candidates requiring a visa or green card? No
Is this an ITAR requirement? No

Pre-screening Questionnaire Instructions (FOR SUPPLIER USE ONLY)
Purpose:
This Pre-Screening Questionnaire is intended for supplier use only during the candidate evaluation process. It should not be shared directly with candidates under any circumstances.

Instructions for Suppliers:
1. Obtain the Questionnaire:
Retrieve the Pre-Screening Questionnaire from the Beeline job request.

2. Use During Pre-Screening:
Utilize the questions to guide your internal interview or pre-screen discussions with candidates.
Do not email, attach, or send the questionnaire document to candidates.
Record or summarize candidate responses in accordance with your internal process or Beeline requirements.

3. Submission:
Once the pre-screen is complete, include relevant information from the questionnaire in the candidate's coversheet.
Ensure all data entered is accurate, concise, and reflects the candidate's actual responses.

Reminder:
This material is confidential and intended exclusively for supplier recruiting teams to evaluate candidate suitability before official submission.

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

Skills: Oracle eBS R12 Financials

Experience Required: 6-8 years

Skills: Category Name Required Importance Experience SkillCategoryTest1_MN Oracle eBS R12 Financials Yes 1 7+ years