Oracle EBS Developer

*Title: Oracle Software Engineer VI* *Location: Pasadena, CA* *Duration: 1 year* *Shift: 1st* *9/80 Work Schedule* *Pay Range: $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 Pay: $90.00 - $134.00 per hour Expected hours: 40.0 per week Work Location: In person