Oracle Techno functional Consultant SME

Virtusa; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading technology consulting firm in Dubai is seeking a highly skilled Oracle Apps TechnoFunctional Consultant. The role involves designing and implementing complex integrations within Oracle EBS, notably in Finance and SCM modules. Ideal candidates should have at least 5 years of experience in integration development and possess deep technical expertise, particularly with Oracle APIs and open interface tables. This position offers contract engagement with competitive compensation.

Qualifications

• 5 years as an Oracle Apps TechnoFunctional Consultant focusing on integrations within Oracle EBS.
• Proficient in designing and implementing integrations with Oracle APIs and open interface tables.
• Demonstrated experience in writing high-performance SQL and PL/SQL code for data handling.

Responsibilities

• Design, develop, and implement complex integrations within Oracle EBS 12.2.5.
• Ensure data integrity and accuracy in integration processes through quality checks.
• Act as the primary technical support for integration issues, providing root cause analysis.

Skills

SQL and PL/SQL

Integration with Oracle APIs

XML Data Structures

BLOB objects handling

Custom Debug and Logging

Education

Certifications in Oracle EBS

Tools

Oracle SOA Suite

Oracle Forms

BI Publisher

Job description

Overview

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.
• 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 PL/SQL.
• Write advanced SQL and PL/SQL queries, stored procedures, functions, and packages to support integration requirements with a focus on high performance.
• Quality Assurance: Ensure data integrity and accuracy in integration processes through quality checks and rigorous documentation.
• Documentation: Create comprehensive technical specifications, integration designs, and user guides facilitating clear communication and efficient work.
• Troubleshooting: Act as the primary technical support for integration issues, providing root cause analysis and implementing robust, sustainable solutions.

Qualifications

• 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 programs; experience with Finance and SCM open interface tables.
• Skills: SQL and PL/SQL with demonstrated experience in writing high-performance code for data handling, XML, BLOB objects, and custom data types for integration.
• Technologies: Oracle Forms, Reports, Workflow, BI Publisher, Oracle SOA Suite and related integration tools.
• Understanding: Familiar with Oracle EBS business processes specifically within Finance and SCM to translate functional requirements into technical solutions.
• Certifications: Certifications in Oracle EBS or related Oracle technologies (preferred).
• Preferred Qualifications: Prior experience in EBS 12.2.x upgrades or similar large-scale integration with cloud-based integration tools and web services (REST/SOAP).

Engagement

Required Experience: Contract