CICigna
Oracle Integration Consultant
Bangalore ₹6-9 LPA Posted 3 Jun 2025
FULL TIME
Uat
Sql
PCS
OIC
VBCS
+1 more
Job Description
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:
- Bachelors 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.