Oracle Cloud Integration

ISA is a premier technology solution provider for the Aviation industry. We are backed by Air Arabia and headquartered in Sharjah, UAE, while the Research and Development center is located in Colombo, Sri Lanka and Pune, India. We are a 100% owned subsidiary of Air Arabia

Location : Pune

: Smartworks Building, Nexa Soft, Core Ops,5th Floor, 43EQ, Survey No 44, PLOT A, H. No. 8 / 1 (P, opp. Opp. Ravindranath Tagore School of Excellence, Balewadi, Pune, Maharashtra

Job Title : Oracle Cloud Integration

Job Type : Full-time

Job Overview :

Support and manage all OIC integrations, VBCS, PCS & App Composer deployed across all core fusion.

Manage end-to-end data integration implementations using Oracle technology.

ODI Administration and Load Balancing & Data warehousing concepts.

Database design, relational and dimensional data modelling skills.

Manage high data volume environments / performance tuning in ODI.

Build necessary queries, functions, packages, triggers and stored procedures in PL / SQL and T / SQL.

Build and manage data quality and governance policies and procedures.

Take handover on all the technical components from the implementation partner migrated in the production environment.

Support and enhance development of custom solution built on Oracle Jet with WebLogic framework.

Support and enhance integrations built using Apex forms.

Develop skillset of the members of the team to enhance their skill on the OIC, Apex, OJET, SQL, BIP etc.

Introduce new technical ideas, inputs, expertise to enhance existing technical integrations and solutions to improve data performance and user experience.

Keep update on all the new technical capabilities introduced by Oracle in the ERP product space and demonstrate useful cases for acceptance on the project where applicable.

Liaise with development teams on finalizing data models, data loading methodologies and data reconciliations tasks.

Manage building database scripts and integrate with release pipelines in Dev, UAT & Prod segments.

Support and manage all existing Custom solutions / processes built on PaaS

Build BI Reports, OTBI reports and write basic data exactions queries using SQL

Identifies and applies creative and innovative approaches to resolving product implementation and integration obstacles and problems.

Design and develop OTBI reports, FRC reports and write basic data exactions queries using SQL

Support and manage all Finance and third-party integrations

Establish / define reconciliation process and reports and support the business users during month-end and year-end reconciliation process

Design and define process wise custom fusion roles and provide the data access as appropriate

Should work with Oracle support team for application bugs / enhancements

Should encourage the business to use Oracle standard functionalities and reports

Mapping business requirements and translating these requirements into Oracle Applications functional specifications.

Develop unit test scripts and coordinate User Acceptance Testing of the system enhancements or custom solutions.

Required Qualifications & Skills :

Minimum of 5 years' experience as an Integration consultant

Minimum 2 full life cycle implementations of OIC and After go live support project experience.

Expert level using Oracle tools (Design Studio, Application Composer, Page Composer, Workflow – Approval Rules / Notifications, PL / SQL and Fusion Middleware Object Design, Development & Testing

Expertise in OIC, REST / SOAP Integration components

Experience with business requirements, technical analysis and design, coding, testing, and implementation of Extension within a software environment

Broad knowledge and deep domain experience within the Oracle PaaS / IaaS product

High attention to details.

Employs technical expertise, and interpersonal relations to interact with senior level, stakeholders and external providers, and to execute initiatives / changes that achieves company’s objectives.

Demonstrates the ability to contribute and successfully deliver against business strategy and set KPIs.

Experience with business requirements, technical analysis and design, coding, testing, and implementation of customization within software environment

Proven ability to be self-directed and operate effectively in a fast-paced, high-energy environment

Please send resumes to