Responsibilities: Design and develop integrations in OIC to Oracle ERP Cloud including making REST and SOAP calls and FBDI File Uploads. Design and develop integrations in OIC to Oracle ERP Cloud including extracting Oracle ERP Cloud data using BIPublsiher reports, analysis, and OTBI Reports. Design and develop customizations using VBCS in OIC to Oracle ERP Cloud. Provide hands-on technical and development support for implemented Oracle ERP Cloud modules. Provide hands-on technical and development support for implemented integrations in OIC to Oracle ERP Cloud. Provide hands-on technical and development support for implemented customizations using VBCS in OIC to Oracle ERP Cloud. Gather and document business requirements on IT incidents / Jira and change work. Document and manage technical specifications and software packages. Manage on-time changes delivery and business expectations and ensure internal customer satisfaction. Provide hands-on analysis, design, testing, implementation, and post-implementation support utilizing prescribed SDLC techniques and system documentation techniques (AIMS/OUM). Complete development tasks based on requirements submitted by business partners and best practices.
Required Skills: Oracle Integration Cloud, Oracle ERP Cloud support experience and Groovy Scripts. Experience with system interfaces (predominantly on a PaaS Cloud). Experience building integration in OIC using REST/SOAP Services. Experience building integrations in OIC, building and Uploading FBDI Files to Oracle ERP Cloud. Knowledge of Oracle Cloud Interface tables in financial and SCM modules. Hands-On Experience of XSLT and Groovy Scripts Hands-On Experience in data migration/integration methods i. e. SOAP and Rest Web Services, FBDI, and ADF DI. Hands-On Experience with reporting tools such as OTBI, and BI Publisher. Hands-On development of packages and functions using SQL/PLSQL and exposing them as REST using ORDS. Good Knowledge of building custom ESS jobs. Hands-on with development and unit testing of integration components and web services (SOAP/REST) using OIC. Hands-on with development and unit testing of VBCS components using OIC. Knowledge of Oracle R11i/12 ideal with functional knowledge of core Oracle EBS Modules including Financials and procurement. Strong knowledge of Oracle development tools, some e-Business application functionality, system administration, database structure, online patching, and knowledge of multi-Org architecture.
Technical requirements: Mandatory: FBDI files, OTBI Reports, BIP Analysis, SQL, PL/SQL, Unix Script, XML Publisher, Groovy Scripts. Advantage: Oracle BI Publisher, Web Adi, APEX. Must have good experience translating business requirements and design into technical solutions. Ability to research, learn, troubleshoot and support complex system customizations. The ability to multi-task and prioritize across concurrent workloads may be required. Excellent written and verbal communication.