Pasadena Oracle EBS Lead Developer – FinOps & Integrations

Columbus Technologies; Pasadena (CA); On-site; USD 124,000 - 185,000; Full time

Job summary

Columbus Technologies in Pasadena, CA, seeks an experienced Oracle EBS Analyst for a 1-year contractor role, onsite at NASA JPL. You will design, develop, and support Oracle EBS customizations, reports, and interfaces while building scalable SQL/PLSQL solutions to optimize financial processes.

Responsibilities include requirements gathering, fit-gap analyses, code optimization, and coordinating with stakeholders; US citizenship required and background check/drug screen will apply.

Qualifications

• Design, develop, review, test, deploy, and support Oracle EBS customizations, extensions, reports, interfaces, conversions, and workflows.
• Develop and maintain SQL/PLSQL, performance tuning, Oracle Workflow, XML Publisher, Reports, Forms, and Unix/Linux scripting.
• Support Oracle Financials modules, including AP, PO, PA, FA, GL, and SLA.
• Develop and support OAF, personalizations, DFF/KFF, FNDLOAD, alerts, and AOL components.
• Demonstrate expertise in Oracle EBS R12.2.x implementation, upgrades, patches, and integration projects.
• Utilize tools such as GIT, Informatica, OBIEE, Oracle APEX, SQL Developer, TOAD, and data extraction/data warehouse solutions.
• Support month-end and year-end close processes, reconciliations, audits, and financial reporting.
• Participate in user testing and acceptance throughout the development lifecycle to validate requirements.

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 design documents and process flows for configurations or 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 issues, and apply fixes.
• Support testing and user training activities.
• Perform additional duties as directed by project team.
• Provide bi-weekly status reports.

Skills

Oracle EBS

SQL/PLSQL

Performance tuning

Oracle Workflow

XML Publisher

GIT

Unix/Linux scripting

OBIEE

Tools

SQL Developer

TOAD

Informatica

OBIEE

Oracle APEX

Data warehouse solutions

Job description

Columbus Technologies in Pasadena, CA, seeks an experienced Oracle EBS Analyst for a 1-year contractor role, onsite at NASA JPL. You will design, develop, and support Oracle EBS customizations, reports, and interfaces while building scalable SQL/PLSQL solutions to optimize financial processes.

Responsibilities include requirements gathering, fit-gap analyses, code optimization, and coordinating with stakeholders; US citizenship required and background check/drug screen will apply.