OIC & PL/SQL Technical Consultant

Job Description

Job Summary: We are looking for a skilled and experienced Oracle Integration Cloud (OIC) and PL/SQL Technical Consultant to join our team in Kolkata. The ideal candidate will have strong technical expertise in Oracle Cloud integrations, PL/SQL development, and hands-on experience with Oracle Fusion or EBS environments. Key Responsibilities: Design, develop, and implement integrations using Oracle Integration Cloud (OIC). Build and maintain PL/SQL programs, packages, procedures, and triggers. Analyze and troubleshoot integration issues and provide timely resolutions. Work closely with functional teams to gather requirements and translate them into technical specifications. Ensure high performance and responsiveness of the integrations and database components. Create technical documentation for integrations, enhancements, and data mapping. Participate in code reviews, unit testing, and system testing. Support migration and deployment activities across different environments. Required Skills and Experience: 5 to 8 years of hands-on experience in PL/SQL development and Oracle Integration Cloud (OIC). Strong understanding of Oracle Fusion Cloud / EBS architecture. Proficient in creating SOAP and REST web services. Experience with file-based data import/export, adapters (FTP, SOAP, REST, DB, ERP), and process automation using OIC. Solid experience in debugging, performance tuning, and optimization of PL/SQL code. Experience in working with large datasets and writing complex SQL queries. Good knowledge of data migration and integration techniques. Strong problem-solving skills and ability to work independently. Preferred Qualifications: Experience with Oracle Fusion ERP modules (Finance, SCM, HCM) integration. Familiarity with Agile/Scrum development methodologies. Oracle Cloud certifications in OIC or PL/SQL will be an added advantage. Education: Bachelors or Master’s degree in Computer Science, Information Technology, or a related field