Oracle Developer

Title: Oracle Software Engineer VI

Location: Pasadena, CA 91109

Duration: 1 year (possible extension/conversion!)

Shift: 1st

9/80 Work Schedule

Pay Rate: $90-134/HR (depending on experience and outcome of the interview)

Job Details:

• Collaborate with the Lead ESA 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 Personalization
• 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

Required Skills:

• 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), personalization’s, 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.
• The methodology ensures users can validate the accuracy of business requirements and assess the usability and performance of new developments.
• Strong analytical and problem-solving skills
• Familiarity with REST APIs
• Proficient with MS Office

Desired Skills:

• · Experience with JIRA and GitHub