Sr. Oracle Developer

Indigo Beam•Houston, TX

1d•Hybrid

About The Position

The Sr. Oracle Developer develops and customizes Oracle E-Business Suite applications, including OAF components, PL/SQL, APEX, Reports, and XML Publisher. The role also creates Oracle workflows and approval processes, implements integrations, supports data migration and conversion, and maintains existing EBS applications. The developer performs system testing, resolves performance issues, documents solutions, and trains end users on new features and custom applications. The position works with Oracle E-Business Suite R12.2 modules including Enterprise Asset Management, Order Management, Purchasing, Install Base, and Inventory.

Requirements

Deep knowledge of OAF components, including View Objects, Application Modules, Entity Objects, and Controller Updates.
Familiarity with Java, XML, and JavaScript as they relate to OAF.
Proficiency in PL/SQL, SQL, Java, Oracle Forms, Reports, Workflow Builder, and JDeveloper.
Experience with Oracle Database and related tools for performance tuning.
Knowledge of Oracle EBS versions R12 and beyond and their features.
Familiarity with AIM methodology.
Strong analytical skills to diagnose and solve issues.
Ability to collaborate with functional teams and stakeholders to gather requirements and communicate technical concepts.
Excellent written and oral communication, interpersonal, and analytical skills.

Responsibilities

Develop and customize Oracle EBS modules using OAF components, PL/SQL, the APEX application platform, Reports, and XML Publisher.
Create custom workflows and approval processes using Oracle Workflow Builder.
Implement integrations with third-party applications using APIs, FTP, and Web Services.
Develop custom Web ADI solutions to retrieve and load data using Excel.
Manage data migration and conversion tasks, including data extraction and transformation.
Write SQL scripts to query and manipulate Oracle database data.
Provide ongoing support for existing EBS applications and resolve issues.
Conduct system testing and validation for new features and enhancements.
Identify and resolve performance issues in EBS applications.
Optimize PL/SQL code and SQL queries for performance.
Create technical documentation for developed solutions.
Train end users on new features and custom applications.
Guide junior developers and provide knowledge-transfer sessions on Oracle development best practices.
Collaborate with functional teams and stakeholders to gather requirements and communicate technical concepts.