Sr. Oracle Developer

Veridic Solutions LLC; Houston (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

Veridic Solutions LLC in Houston, TX seeks an experienced Oracle EBS Developer to design and customize modules using OAF, PL/SQL, APEX, and Reports. You will implement data migration tasks, develop integrations via APIs and Web Services, and optimize performance.

You will guide junior developers, validate features, and train users on custom applications while working with EBS R12.2 modules such as Inventory, Purchasing, and Order Management.

Qualifications

• Deep knowledge of OAF components including View Objects, Application Modules, Entity Objects and Controller Updates
• Proficient in PL/SQL, SQL, Java, Oracle Forms, Reports, Workflow Builder, JDeveloper
• Experience with Oracle Database and related tools for performance tuning
• Knowledge of different versions of Oracle EBS (R12 and beyond) and their specific features

Responsibilities

• Develop and customize Oracle EBS modules using OAF components, PL/SQL, APEX, Reports, and XML Publisher
• Create custom workflows and approval processes using Oracle Workflow Builder
• Familiar with AIM methodology
• 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, often involving data extraction and transformation
• Write SQL scripts to query and manipulate data within Oracle databases
• Provide ongoing support for existing EBS applications and resolve issues as they arise
• Conduct system testing and validation for new features and enhancements
• Identify and resolve performance issues in EBS applications and optimize PL/SQL code and SQL queries
• Train end-users on new features and custom applications
• Train junior developers and provide knowledge transfer sessions on best practices in Oracle development tools

Skills

OAF components

PL/SQL

APEX

Reports

XML Publisher

Java

Oracle Forms

Workflow Builder

JDeveloper

Oracle Database

SQL

Performance tuning

Data extraction

Data transformation

Tools

JDeveloper

Oracle Forms

APEX

XML Publisher

Reports

Job description

• Develop and customize Oracle EBS modules using OAF components, PL/SQL, APEX application platform, Reports, and XML Publisher.
• Create custom workflows and approval processes using Oracle Workflow Builder.
• Familiar with AIM methodology

Integration:

• Implement integrations with third-party applications using APIs, FTP, and Web Services
• Develop Custom Web ADI solutions to retrieve and load data using excel.

Data Management:

• Manage data migration and conversion tasks, often involving data extraction and transformation.
• Write SQL scripts to query and manipulate data within Oracle databases.

Support and Maintenance:

• Provide ongoing support for existing EBS applications and resolve issues as they arise.
• Conduct system testing and validation for new features and enhancements.

Performance Tuning:

• Identify and resolve performance issues in EBS applications.
• Optimize PL/SQL code and SQL queries for better performance.

Documentation and Training:

• Train end-users on new features and custom applications.

Oracle Modules

• Enterprise Asset Management, Order Management, Purchasing, Install Base, Inventory, in Oracle E-Business Suite R12.2

Requirements

• Deep knowledge of OAF components including View Objects, Application Modules, Entity Objects and Controller Updates
• Proficient in PL/SQL, SQL, Java, Oracle Forms, Reports, Workflow Builder, JDeveloper
• Experience with Oracle Database and related tools for performance tuning.
• Knowledge of different versions of Oracle EBS (R12 and beyond) and their specific features.

Soft Skills

• Strong analytical skills to diagnose and solve issues.
• Ability to collaborate with functional teams and stakeholders to gather requirements and communicate technical concepts.
• Guide junior developers and provide knowledge transfer sessions on best practices in Oracle development tools.
• Excellent written and oral communication, Interpersonal and Analytical skills