The Cigna Group
Oracle OIC Developer
- Permanent
- Dubai, United Arab Emirates
- Experience 5 - 10 yrs
Report job as expired
Job expiry date: 27/08/2025
Job overview
Date posted
13/07/2025
Location
Dubai, United Arab Emirates
Salary
AED Undisclosed per month
Experience
5 - 10 yrs
Seniority
Senior & Lead
Qualification
Bachelors degree
Expiration date
27/08/2025
Job description
As an Oracle OIC Developer on Cignaâs agile technology team, you will lead technical integration efforts across the MEA insurance business using Oracle Integration Cloud and supporting PaaS solutions. Youâll manage end-to-end data integrations, maintain custom PaaS processes, build database scripts, design data models, develop PL/SQL and T/SQL code, and produce BI and OTBI reports. This role underpins a major transformation initiative to extend our application ecosystem into new markets, laying the foundation for a future state technology stack.
Required skills
Oracle Integration Cloud Service
OIC
Visual Builder Cloud Service
Process Cloud Service
App Composer
Fusion Middleware
PL/SQL
T/SQL
ODI Administration
Data warehousing
ETL concepts
Relational data modeling
Dimensional data modeling
Performance tuning
REST integration
SOAP integration
Oracle BIP
OTBI reporting
SQL
Release pipeline integration
Key responsibilities
- Support and manage all OIC integrations, VBCS, PCS & App Composer deployed across core Fusion applications
- Manage end-to-end data integration implementations using Oracle technologies
- Administer ODI environments, including load balancing and performance tuning
- Design relational and dimensional database models to support reporting and analytics
- Develop PL/SQL and T/SQL queries, functions, packages, triggers, and stored procedures
- Build and enforce data quality and governance policies and procedures
- Coordinate with development teams on data models, loading methodologies, and data reconciliation
- Develop database scripts and integrate them into release pipelines across Dev, UAT, and Prod
- Support and maintain existing custom PaaS solutions and processes
- Create BI and OTBI reports and write SQL queries for data extraction
Experience & skills
- Bachelorâs degree in Computer Science or related discipline
- Minimum of 5 yearsâ experience as an Integration consultant
- At least 2 full life cycle implementations of Oracle Integration Cloud
- After go-live support project experience
- Expertise with Oracle Design Studio, Application Composer, Page Composer, Workflow â Approval Rules/Notifications
- Strong proficiency in Fusion Middleware object design, development, and testing
- Hands-on experience with OIC REST/SOAP integration components
- Experience in technical analysis, design, coding, testing, and implementation of PaaS extensions
- Broad domain knowledge of Oracle PaaS/IaaS products
- Oracle PaaS Certification (desirable)
- Experience in finance transformation projects (desirable)
- Familiarity with Agile development methodologies
