Job Description

We are looking for a highly skilled Oracle Apps Techno-Functional 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 mechanisms.


Key Responsibilities:


Integration Development: Design, develop, and implement complex integrations within Oracle EBS 12.2.5, focusing on Finance and SCM modules.


APIs and Open Interface Tables: Utilize Oracle APIs and open interface tables for integration, ensuring data accuracy, consistency, and optimal performance. In-depth knowledge of Finance and SCM open interface tables is essential.


Wrapper Programs: Develop custom wrapper programs with validations, custom debug, and logging mechanisms to support seamless integration and troubleshooting.


XML, 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 integrations.


SQL and PL/SQL Expertise: Write advanced SQL and PL/SQL queries, stored procedures, functions, and packages to support integration requirements, with a focus on high-performance and scalability.


Data Management and Quality Assurance: Ensure data integrity and accuracy in integration processes through quality checks and rigorous testing.


Technical Documentation: Create comprehensive technical specifications, integration designs, and user guides, facilitating clear communication and efficient troubleshooting.


Support and 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 Techno-Functional Consultant, with a strong focus on integrations within Oracle EBS 12.2.5.


Technical Expertise:


Proficient in designing and implementing integrations using Oracle APIs, open interface tables, and custom wrapper programs.


Extensive experience with Finance and SCM open interface tables and APIs.


Advanced skills in SQL and PL/SQL, with demonstrated experience in writing high-performance code for data integrations.


Proficient in handling XML, BLOB objects, and custom data types for integration requirements.


Tools and Technologies: Experience with Oracle Forms, Reports, Workflow, BI Publisher, Oracle SOA Suite, and related integration tools.


Functional 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 large-scale integration projects.


Experience with cloud-based integration tools and web services (REST/SOAP).


Certifications in Oracle EBS or related Oracle technologies.

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth -- one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.



Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.



Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.