Oracle Cloud ERP Technical Consultant
Location: Palm Beach Gardens, FL Onsite
H1B transfer,|| W2
Type: W2 , 24 months long
Project: Migration from Legacy ERP to Oracle Cloud ERP
Position Summary: We are seeking a highly skilled Oracle Cloud ERP Technical Consultant to support a large-scale legacy-to-Oracle Cloud ERP migration project. The ideal candidate will have proven hands-on experience with Oracle Cloud technical frameworks, integrations, data conversions, and reporting tools. This role requires deep technical expertise across SQL, PL/SQL, Web Services, REST APIs, OTBI/BIP, FBDI, VBCS, Oracle Cloud ERP tables, and the ability to build custom APIs and technical components across Financials, P2P, and O2C modules.
Key Responsibilities
- Design, develop, and support technical components for Oracle Cloud ERP migration from legacy systems.
- Develop and maintain integrations using REST APIs, SOAP APIs, Web Services, OIC frameworks, and Oracle Cloud PaaS tools.
- Perform end-to-end data conversion activities using FBDI, ADFDI, SQL/PLSQL scripts, and custom loaders.
- Analyze legacy system data, validate mappings, and reconcile conversion results.
- Build custom APIs, extensions, and technical solutions using VBCS, APEX, OCS, and Oracle PaaS.
- Develop custom reports and dashboards using OTBI and BI Publisher (BIP).
- Troubleshoot technical issues across Oracle Cloud modules and create solutions that adhere to best practices.
- Work closely with functional consultants to understand business requirements and translate them into technical designs.
- Support technical testing cycles (SIT, UAT) and contribute to production cutover planning.
- Maintain strong understanding of Oracle ERP Cloud data model and tables across modules such as:
- GL, AP, AR, FA, P2P, O2C
Required Skills & Experience
- 5 10+ years of experience as an Oracle ERP Technical Consultant.
Proven hands-on experience with:
- SQL, PL/SQL, REST/SOAP Web Services
- OTBI, BI Publisher (BIP)
- FBDI & ADFDI
- VBCS / APEX / OCS / PaaS
- Oracle ERP Cloud table structures
- Strong knowledge of data conversion best practices for Oracle Cloud ERP.
- Ability to design and develop custom APIs and web services.
Solid understanding of functional data flows across:
- General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Procure-to-Pay (P2P), Order-to-Cash (O2C)
- Experience working with functional teams and end users on technical issue resolution.
- Excellent communication, documentation, and problem-solving skills.
#LI-SS1