Oracle Technical Consultant

Infidocs Technologies

Roles & Responsibilities

• Develop, enhance, and support RICEFW components (Reports, Interfaces, Conversions, Extensions, Forms, Workflows).
• Design and build integrations between EBS and external systems using:
• PL/SQL
• REST/SOAP Web Services
• Oracle SOA/OIC (preferred)
• Develop and maintain BI Publisher Reports, XML Publisher templates, and custom reports.
• Build and customize Oracle Forms, Oracle Reports, OAF pages (as required).
• Work extensively on SQL, PL/SQL, packages, procedures, and performance tuning.
• Understand business requirements and convert them into technical design documents.
• Work with functional consultants on requirement analysis, data mapping, testing, and solution validation.
• Support month-end activities, production issues, debugging, and RCA.
• Handle code migrations, version control, and documentation as per SDLC.
• Develop interface programs for data migration using Open Interface Tables, APIs, WebADI, FBDI.
• Participate in SIT/UAT and coordinate with business users.

Required Technical Skills

• 7+ years of hands-on Oracle EBS Technical experience
• Expertise in:
• SQL & PL/SQL
• BI Publisher
• Oracle Reports / XML Publisher
• Oracle Forms / OAF
• Oracle Workflow (AMW, approvals)
• Strong understanding of EBS modules such as:
• Financials (AP, AR, GL)
• SCM (PO, OM, INV)
• HRMS (optional but good to have)
• Strong experience with:
• Inbound & Outbound Interfaces
• Conversions & Data Migration techniques
• REST/SOAP APIs, XML, JSON
• Good knowledge of EBS data models, setups & process flows.