Oracle Financials Lead Developer

Columbus Technologies and Services Inc•Pasadena, CA

6d•$90 - $134•Onsite

About The Position

The Oracle Financials Lead Developer will collaborate with the Lead Enterprise System Analyst to review and gather business requirements, conduct fit-gap analyses, and map business workflows. This role involves recommending Oracle configuration updates, supporting the implementation of new features and system changes, and troubleshooting application issues. The developer will be responsible for creating and updating design documents, developing and optimizing Oracle SQL/PLSQL code, building interfaces and APIs, and supporting custom extensions. Additionally, the role includes diagnosing system bottlenecks, debugging issues, supporting testing and user training, and providing bi-weekly status reports.

Requirements

Design, develop, review, test, deploy, and support Oracle EBS customizations, extensions, reports, interfaces, conversions, and workflows.
Develop and maintain solutions using SQL, PL/SQL, performance tuning techniques, Oracle Workflow, XML Publisher, Oracle Reports, Oracle Forms, Concurrent Programs, and Unix/Linux scripting.
Support and enhance Oracle Financials modules, including AP, PO, PA, FA, GL, and SLA.
Develop and support Oracle Application Framework (OAF), personalizations, DFF/KFF, FNDLOAD, alerts, and AOL components.
Demonstrate expertise in Oracle EBS R12.2.X implementation, upgrades, patching, enhancements, and integration projects.
Utilize tools and technologies such as GIT, Informatica, OBIEE, Oracle APEX, SQL Developer, TOAD, custom data extractors, and data warehouse solutions.
Support month-end and year-end close processes, accounting reconciliations, audit requirements, and financial reporting activities.
Participate in user testing and acceptance throughout the development lifecycle to identify usability issues, missing requirements, and necessary design changes early, ensuring timely business validation and deployment of solutions.
Strong analytical and problem-solving skills.
Familiarity with REST APIs.
Proficient with MS Office.

Nice To Haves

Experience with JIRA and GitHub.

Responsibilities

Collaborate with the Lead Enterprise System Analyst to review existing business requirements and gather new requirements from stakeholders.
Conduct fit-gap analyses and present options.
Map current-state and future-state business workflows.
Recommend Oracle configuration updates to optimize business processes.
Support ESA in implementing new features and/or system changes aligned with approved functional designs.
Troubleshoot application issues through resolution.
Log and manage Oracle Service Requests.
Create and update functional design documents, technical design documents, and process flows associated with configurations or approved customizations.
Develop scalable Oracle SQL/PLSQL code including procedures, functions, packages, and triggers.
Update existing code to meet evolving requirements.
Tune and optimize queries for performance.
Build or retrofit interfaces, APIs, and data loaders.
Support custom extensions including Form Personalizations.
Diagnose system bottlenecks, debug functional and technical issues, and apply fixes.
Support testing and user training activities.
Perform additional duties as directed by project team.
Provide bi-weekly status reports.