Oracle Integration Cloud (OIC) Developer

Job Description

Job Description As a core member of our Group IT team, you will work with dedicated professionals to bring our recently launched Oracle Fusion Finance and HCM to full optimization. The ideally candidate, will have worked directly on a Cloud Fusion Project and can bring this experience with them. Responsibilities You will be a Specialist on the team to specify technical requirements for the integration requirements on the programme, this involves developing, validating and reviewing conceptual, logical and physical integration design Contribute to the end-to-end development of Oracle Integration Cloud (OIC) solutions, including active involvement in solution design activities, configuration, and implementation – ensuring that the solutions are fit for purpose Work as part of a global team of Oracle Integration Cloud (OIC) developers and functional experts Develop and provide technical support of Oracle ERP/PPM integrations, extensions and reports, including making REST and SOAP calls, FBDI File Uploads, BI-Publisher reports, analysis and OTBI Reports, Visual Basic Studio/Redwood. Perform integrations between Oracle Cloud and 3rd party applications both inbound and outbound Write technical specifications, based on functional design discussions or documentation Work with Oracle Support (via Service Request) for Fusion and OIC server/seeded functionality related issues Perform any other duties which the team may require as part of the projects and business objectives Qualifications Minimum 4 years of experience with the following: Oracle Fusion ERP/PPM API capabilities Oracle Fusion ERP key Master/Transactional Tables (i.e. AP_INVOICES_ALL, RA_CUSTOMER_TRX , PO_HEADERS_ALL, PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_M ) Development & unit testing of integration components & web services (SOAP/REST) using OIC and other 3rd party tools such as POSTMAN and SoapUI. OIC adapters, usage of File adapter, usage of orchestration integration patterns (Scheduled and App-driven) Supporting integrations, including monitoring, and altering Development of BIP reports in Oracle Fusion including creation of RTF, ETEXT and Excel templates via BI Publisher Desktop Oracle SQL and PL/SQL (Stored Procedures, Functions, Packages) Oracle DB objects (Table, Views, Index, Sequence) design, creation, maintenance, and analysis Minimum 2 years of experience with the following: BIP Reports advanced concepts (sub-templates, embedded variables, bursting) Integration security and Oracle offerings Ability to leverage pre-built integrations, cloud adapters, connections, SaaS applications, etc. in the solution It Is Preferred, If You Also Have Oracle Fusion HCM API capabilities Certified Oracle Integration Cloud Specialist