Oracle Techno functional Consultant SME

We are looking for a highly skilled Oracle Apps TechnoFunctional Consultant with a strong focus on integration development and deployment within Oracle EBS 12.2.5. The consultant will be responsible for understanding complex integration requirements from the Solution Architect designing and implementing solutions within Oracle EBS particularly in Finance and SCM modules. The ideal candidate will possess deep technical expertise especially in handling APIs open interface tables wrapper programs and custom debugging/logging Responsibilities:Integration Development: Design develop and implement complex integrations within Oracle EBS 12.2.5 focusing on Finance and SCM and Open Interface Tables: Utilize Oracle APIs and open interface tables for integration ensuring data accuracy consistency and optimal performance. Indepth knowledge of Finance and SCM open interface tables is Programs: Develop custom wrapper programs with validations custom debug and logging mechanisms to support seamless integration and BLOB and Custom Data Types: Work efficiently with XML data structures handle BLOB objects and manage custom data types to ensure effective data handling in and PL/SQL Expertise: Write advanced SQL and PL/SQL queries stored procedures functions and packages to support integration requirements with a focus on highperformance and Management and Quality Assurance: Ensure data integrity and accuracy in integration processes through quality checks and rigorous Documentation: Create comprehensive technical specifications integration designs and user guides facilitating clear communication and efficient and Troubleshooting: Act as the primary technical support for integration issues providing root cause analysis and implementing robust sustainable :Experience: 5 years as an Oracle Apps TechnoFunctional Consultant with a strong focus on integrations within Oracle EBS Expertise: Proficient in designing and implementing integrations using Oracle APIs open interface tables and custom wrapper experience with Finance and SCM open interface tables and skills in SQL and PL/SQL with demonstrated experience in writing highperformance code for data in handling XML BLOB objects and custom data types for integration and Technologies: Experience with Oracle Forms Reports Workflow BI Publisher Oracle SOA Suite and related integration Understanding: Familiar with Oracle EBS business processes specifically within Finance and SCM to translate functional requirements into technical solutions. Preferred Qualifications: Prior experience in EBS 12.2.x upgrades or similar largescale integration with cloudbased integration tools and web services (REST/SOAP).Certifications in Oracle EBS or related Oracle technologies.