Logo of Huzzle

Oracle OIC Developer

  • Job
    Full-time
    Senior Level
  • Software Engineering
    IT & Cybersecurity
  • Dubai

AI generated summary

  • You need a Bachelor's in Computer Science, 5+ years as an Integration consultant, 2 OIC implementations, Oracle tools expertise, Agile experience, strong communication skills, and a proactive attitude.
  • You will manage OIC integrations, data loading, ODI administration, database design, and BI reporting. Collaborate with teams on data models and ensure data quality and governance.

Requirements

  • Bachelor’s degree in Computer Sciences or equivalent or a related discipline
  • Minimum of 5 years' experience as an Integration consultant
  • Minimum 2 full life cycle implementations of OIC
  • 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
  • Oracle PaaS Certification is a plus.
  • Previous Project experiences in finance transformation
  • Experience working with Agile development methodologies
  • Strong stakeholders' management experience and good communication skills.
  • Flexible, open mind-set and comfortable working with existing systems.
  • Passionate about technology and applying it to business solutions.
  • Enthusiastic and possessing a “can do” attitude.
  • Have a track record of getting things done, within a fast-paced and changing environment.
  • Creative and be good at bringing others along with you.
  • Comfortable dealing with conflict.
  • You will be a team player with excellent written and oral communication skills.

Responsibilities

  • 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 modeling 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.
  • 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.

FAQs

What is the primary responsibility of the Oracle OIC Developer at Cigna?

The primary responsibility is to lead the technical effort for integrating different solutions using Oracle Integration Cloud Services within the insurance business, while supporting and managing all OIC integrations, VBCS, PCS, and App Composer.

What qualifications are required for the Oracle OIC Developer position?

A Bachelor’s degree in Computer Sciences or a related discipline is required, along with a minimum of 5 years of experience as an Integration consultant and at least 2 full life cycle implementations of OIC.

Is prior experience with Oracle tools necessary for this role?

Yes, expert-level experience with Oracle tools such as Design Studio, Application Composer, Page Composer, and Workflow is necessary.

Are there opportunities for employees to develop their skills?

Yes, the company encourages employees to keep up to date with the latest enhancements and releases in Oracle technology as part of their passion for continued learning.

What programming and database skills are needed for this role?

Strong proficiency in PL/SQL and T/SQL, as well as database design, relational and dimensional data modeling skills, are essential for this position.

What kind of project experience is preferable for applicants?

Previous project experience in finance transformation and experience working with Agile development methodologies are desirable.

Is there a focus on data governance and quality management in this role?

Yes, the role includes building and managing data quality and governance policies and procedures.

What is the work environment like at Cigna for this position?

The work environment is fast-paced and changing, and employees are expected to have a “can do” attitude and be creative in solving complex technical problems.

What type of reporting experience is required?

Candidates should have experience building BI reports, OTBI reports, and writing basic data extraction queries using SQL.

Does Cigna promote diversity and inclusion in its hiring process?

Yes, Cigna is an advocate for diversity and qualified applicants are considered without regard to race, color, age, disability, and other protected characteristics.

Science & Healthcare
Industry
10,001+
Employees

Mission & Purpose

The Cigna Group is a global health company committed to creating a better future built on the vitality of every individual and every community. We relentlessly challenge ourselves to partner and innovate solutions for better health. The Cigna Group includes products and services marketed under Cigna Healthcare, Evernorth Health Services or its subsidiaries. The Cigna Group maintains sales capabilities in more than 30 countries and jurisdictions, and has more than 190 million customer relationships around the world.