The Oracle Apps Technical Lead position is a technical role in UEI's IT department focused on developing solutions across various Oracle modules and Oracle Cloud while collaborating with global stakeholders to deliver key initiatives, support ongoing production issues, and manage the development, testing, and release of ERP application changes.
Design, develop, customize, and support Oracle EBS R12/R12.2 applications.
Develop and maintain RICEFW objects – Reports, Interfaces, Conversions, Extensions, Forms, Workflows
Develop complex SQL, PL/SQL packages, procedures, functions, triggers, and performance-optimized database objects.
Develop Oracle Forms, Oracle Reports, XML Publisher (BI Publisher), and custom concurrent programs.
Design and implement inbound and outbound integrations using Oracle APIs, Open Interfaces
Support integrations with third-party applications and enterprise systems.
Perform data migration and conversion activities using SQL*Loader, FNDLOAD, UTL_FILE, and data migration tools.
Develop, Maintain and Troubleshoot Unix shell scripts
Analyze, troubleshoot, and resolve production issues.
Conduct root cause analysis and recommend preventive solutions.
Support Oracle EBS patching, upgrades, and post-upgrade remediation activities.
Ensure compliance with development standards and coding best practices.
Work closely with functional consultants and business users to understand requirements.
Translate functional specifications into technical solutions.
Participate in requirement gathering, impact analysis, and solution design discussions.
Must Have
Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
Oracle Certifications – Good to have
10+ years of Oracle EBS Technical Development experience in Oracle E-Business Suite R12
Extensive hands-on experience in RICEFW development and support
Strong understanding of Oracle EBS architecture
Advanced SQL & PL/SQL
Oracle Forms & Reports
Oracle Workflow
Oracle Application Object Library (AOL)
BI Publisher / XML Publisher
Oracle APIs
Oracle Concurrent Processing
Unix/Linux Shell Scripting
UTL_FILE and SQL*Loader
Oracle Database 11g/12c/19c
Experience in one or more Oracle EBS modules like AP, AR, GL, FA, CM, PO, INV, OM, BOM, WIP
OAF
XML, XSD, XSLT handling
REST and SOAP Web Services
Desirable:
Oracle Integration Cloud (OIC)
Oracle Fusion ERP migration/integration experience
Exposure to enterprise reporting tools and analytics platforms