Oracle OIC Consultant

About Company :

Our client is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital & IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients' long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.

• Job Title : Oracle OIC Consultant
• Location : Chennai
• Experience : 10+ yrs
• Job Type : Contract to hire.
• Notice Period : - Immediate joiners.

Mandatory Skills :

Oracle SaaS & Integration Developer

10+ years� Experience on multiple implementations, version upgrades, maintenance, and support projects, including designing, developing processes that fuel swift corrective actions, significant cost savings, and fault-free deliverables.

Excellent experience of the following Oracle technologies : Oracle cloud Integration, BI Publisher, OTBI, ATP, Redwood changes

Must be expert in Oracle PL / SQL � should have written complex packages, procedures and functions in Oracle ATP and invoke them through Oracle Cloud Integration

Must be expert in designing and development of complex customer facing transactional reports using BI-Publisher and OTBI.

Experience in screen development using VBCS.

Strong Knowledge of Oracle Fusion Database Tables, Integrations.

Experience in the following Oracle tools : Oracle FBL, FBDI, HDL, HCM Extracts

Perform multiple performance fine-tunings on frequently utilized long running reports queries.

Good knowledge of the EBS / Oracle Fusion Functional and Database knowledge.

Extensive expertise in interface development utilizing PL / SQL within Oracle.

Migrating legacy Integration solutions to Oracle Cloud Integration, resulting in improved scalability and reduced maintenance efforts

Ability to create various Inbound and Outbound Integrations in Oracle Cloud Integration.

Proficient in Oracle Rest Data Services (ORDS), Oracle SQL, PL / SQL, and Shell Scripting, with a demonstrated ability to develop new workflows and effectively implement AME in workflow approval processes.

Excellence in analysing business requirements and designing solutions using AIM / OUM methodology, including meticulous documentation such as MD050, MD070, MD120, CV060, AN050, and DS140, among others.

Skills Required

Oracle Sql, Otbi, Shell Scripting, Bi Publisher, Redwood, Hdl, Oracle Pl Sql, VBCS, Hcm Extracts, atp