Sr. ERP Developer

Oracle ERP Cloud Technical Consultant (SCM, HCM)

Job Summary

Providence is seeking an experienced Oracle ERP Cloud Technical Consultant with strong expertise in Oracle Integration Cloud (OIC), HCM Extracts, Fast Formula, ERP Cloud reporting, integrations. This role requires hands-on technical skills, solid Oracle PaaS knowledge, and the ability to work independently on complex integration and ERP Cloud initiatives in support of Supply Chain business processes.

Essential Functions

• Design, develop, test, and support integrations using Oracle Integration Cloud (OIC – PaaS).
• Build interfaces using SOAP/REST web services, file-based integrations, and database technologies (SQL/PLSQL).
• Build HCM Technical Components using HCM Extracts and Fast Formulas
• Develop and maintain file processing solutions in OIC using XML, CSV, and JSON.
• Implement integration patterns with robust error handling, monitoring, and supportability.
• Partner with functional and technical stakeholders to deliver end-to-end integration scenarios across ERP Cloud Supply Chain and Human Capital modules including Account Payables.
• Develop and support ERP Cloud reporting using BI Publisher, OTBI, FRS, Smart View, and dashboards/infolets.
• Support ERP Cloud configurations and extensions using Sandboxes, Application Composer, Page Composer, and page integrations, as applicable.
• Perform ERP Cloud data conversions and loads using FBDI, ADFDi, and SOAP/REST services.
• Troubleshoot production issues, perform root cause analysis, and document resolutions and corrective actions.

Minimum Qualifications

• 3+ years of relevant experience, including strong hands-on experience with Oracle ERP Cloud (SCM).
• Hands-on expertise in Oracle Integration Cloud (OIC), including design and support of enterprise integrations.
• Working knowledge of Oracle PaaS architecture, integration security, and related best practices.
• Proficiency in SQL, PL/SQL, and integration/data formats including XML and XSLT.
• Experience with ERP Cloud reporting and data migration/conversion activities.
• Demonstrated ability to communicate effectively and collaborate with technical and business partners.
• Ability to work independently, manage priorities, and deliver to defined timelines and outcomes.

Preferred Qualifications

• Experience with ERP Cloud extensions and tools such as Sandboxes, Application Composer, and Page Composer.
• Strong experience developing reports using BI Publisher 
• Experience with data loads using FBDI and ADFDi