Oracle Integration consultant
Role
As an Oracle Integration consultant, you will be joining the Cigna technology team responsible for building and maintaining Integration and supporting our rapidly growing Middle East region.
Working as a member of an agile team, you’ll lead the technical effort for integrating different solution using Oracle integration cloud services in our insurance businesses.
We are rapidly expanding the team to embark on a major change initiative to augment an existing application ecosystem to enable our business to expand into new markets in the MEA region and beyond. This is an exciting time to become part of the Cigna technology team, working on an initiative that is laying the foundations for our future state technology stack that will ultimately be used across our international business.
About You
You’re an experienced Oracle Integration consultant with a strong track record of delivery and experience of in oracle integration technology. Strong experience of the following OICS, Fusion reporting tools (BIP,OTBI)
Passionate about Oracle technology and keep up to date with the latest enhancements, releases and future roadmaps.
The type of person that loves the challenge of solving complex technical problems by thinking outside the box.
Core 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
- Lead the design and development of SAS-based products, ensuring alignment with business requirements.
- Actively contribute in an Agile environment, participating in sprints, stand-ups, and retrospectives.
Essential:
- 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
Competencies:
- 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.
About The Cigna Group
Cigna Healthcare, a division of The Cigna Group, is an advocate for better health through every stage of life. We guide our customers through the health care system, empowering them with the information and insight they need to make the best choices for improving their health and vitality. Join us in driving growth and improving lives.
Top Skills
What We Do
At Cigna, we're more than a health insurance company. We are your partner in total health and wellness. And we’re here for you 24/7 – caring for your body and mind.
As a global health service company, Cigna's mission is to improve the health, well-being, and peace of mind of those we serve by making health care simple, affordable, and predictable.
Our values are the core of our culture. Our values guide how all 74,000 of us around the world work together, serve our customers, patients, clients, communities, and deliver on our mission.