Oracle EBS Developer

Caterpillar Inc.•Nashville, TN

4d•$94,728 - $151,572•Onsite

About The Position

Supports the IT function by assisting with the development, testing, and implementation of application systems. The role develops and maintains Oracle E-Business Suite (EBS) custom code and integrations, supports testing and application releases, troubleshoots production issues, and collaborates with functional teams to translate business requirements into technical designs and documentation. The position is based onsite at Caterpillar’s Nashville main office five days per week.

Requirements

Degree or equivalent experience desired.
Knowledge of Oracle EBS architecture and core-module relationships.
Experience or working knowledge of SQL, PL/SQL, Oracle Forms, Oracle Workflows, and Oracle EBS RICEFW components.
Knowledge of Oracle EBS 12.2 ADOP and EBR standards.
Working knowledge of Oracle Workflow, Concurrent Processing, XML/BI Publisher, REST APIs, SOAP services, XML, JSON, and file-based integrations.
Ability to create and execute unit test plans and support SIT, UAT, regression testing, and release cycles.
Ability to troubleshoot technical issues involving code, logs, integrations, APIs, and data discrepancies.
Ability to analyze and optimize SQL and PL/SQL performance.
Ability to document technical designs and maintain technical documentation.
Ability to support source-code management, migration, and deployment activities.

Responsibilities

Develop and maintain custom SQL and PL/SQL code, Oracle Forms, and Workflows in compliance with Oracle EBS 12.2 Online Patching (ADOP) and Edition-Based Redefinition (EBR) standards.
Apply knowledge of Oracle EBS architecture and relationships across core modules.
Design, develop, troubleshoot, and support Oracle EBS RICEFW components, including reports, interfaces, conversions, extensions, forms, and workflows.
Work with Oracle Workflow, Concurrent Processing, XML/BI Publisher, REST APIs, SOAP services, XML, JSON, and file-based integrations.
Create and execute unit test plans, troubleshoot integration and API failures, and provide technical support for SIT, UAT, regression testing, and Oracle EBS release cycles.
Develop and support integrations between Oracle EBS and external applications.
Investigate and resolve production issues involving custom code, interfaces, application and log errors, and data discrepancies.
Analyze and optimize SQL and PL/SQL to identify and address performance bottlenecks.
Collaborate with functional teams to translate business requirements (MD50/FDD) into technical designs, including MD70/TDD documentation.
Create and maintain technical documentation and support source-code management, migration, and deployment activities.