Oracle Solution Architect / Technical Lead (OIC

Job Title: Oracle Solution Architect / Technical Lead (OIC)

Location: Open for USA Remote

Duration: 06 months +

Key Responsibilities :

· Lead Oracle Cloud (SaaS/PaaS) implementations, integrations, and support.

· Design and develop integrations using Oracle Integration Cloud (OIC), REST/SOAP APIs, FBDI, and middleware tools.

· Create technical design documents, data mappings, and perform code technical reviews.

· Develop and customize BI Publisher (BIP), OTBI reports, dashboards.

· Manage Oracle Cloud environments including ATP database administration, user roles, and security.

· Collaborate with functional teams for end-to-end testing, UAT, and quarterly patch impact analysis.

· Implement integrations for Manufacturing (WIP, BOM), Order Management, Inventory, Fixed Assets, and Projects, Financials (AR, AP, GL).

· Support ERP integration with third-party systems like EDI (OpenText), Macpac (Legacy ERP), PLM Aras, Pay Trace, Bill Trust, and banking systems (like BMO).

· Should have knowledge of BICC (Business Intelligence Cloud Extract).

· Perform migration activities across OIC instances and maintain GitHub repositories and Oracle SFTP servers.

· Ensure compliance with audit requirements and maintain version history documentation.

· Project Required Responsibilities and Knowledge required – Manufacturing & Supply Chain

· Have Knowledge of Oracle Manufacturing processes including Work in Process (WIP), BOM, and job creation.

· Develop and maintain integrations for Order Management (OM), Inventory (INV), and Procurement (PO) modules.

· Have Knowledge of Advanced Pricing, item attributes, and product lifecycle updates for manufacturing operations.

· Implement technical solutions for Contract Manufacturing, Drop Ship, and RMA processes.

· Have Knowledge of Supply Chain orchestration for B2B and B2C order flows, fulfillment, shipment, and delivery.

Required Skills: 

· Excellent problem-solving, documentation, and client interaction skills.

· Excellent communications skills to handle the audience during Onshore presence.

· Technical Expertise: SQL, PL/SQL, Oracle Integration Cloud (OIC), VBCS, OTBI/BIP, AIP Database.

· Process Knowledge: Oracle Manufacturing, Supply Chain, Order Management, Financials.

· Strong experience in Oracle Cloud ERP customizations and integrations.

· Proficiency in BI Publisher and Oracle Cloud methodology.

Experience: 

· 16+ years in Oracle Applications (Techno-Functional).

· Hands-on experience with Oracle Cloud implementations, ERP integrations, and automation projects.

· Worked with global clients across industries (Tech, Manufacturing, Hi-Tech).

· Should be able to travel to Client Location in the USA during required Project Phases.