Oracle Financials Lead Developer (Onsite)

Columbus Technologies and Services; Pasadena (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Columbus Technologies and Services seeks a qualified Oracle EBS Analyst/Developer for a 1-year contract at NASA JPL in Pasadena, CA. The role requires US citizenship and will be onsite with a 9/80 schedule and benefits via W2.

You will collaborate with Enterprise System Analyst, analyze requirements, implement Oracle configurations, and develop SQL/PLSQL code. Strong knowledge of Oracle EBS R12.2 and related tools is essential.

Qualifications

• 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.
• 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.

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.

Skills

Oracle EBS

SQL/PLSQL

Unix/Linux scripting

REST APIs

GIT

Informatica

OBIEE

Oracle APEX

Oracle Forms

Tools

SQL Developer

TOAD

Oracle APEX

OBIEE

GitHub

JIRA

Informatica

Data Warehouse

Job description

OVERVIEW

Must be a US Citizen

Duration - 1 year contract position with potential to be extended or converted

W2 with full benefits, 9/80 Work Schedule

Customer and contract specific training will be required and provided.

Location - NASA Jet Propulsion Laboratory, Pasadena, CA (onsite)

Offer contingent on ability to successfully pass a background check and drug screen

Salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

JOB DESCRIPTION

• 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.

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), 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.
• 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.

Equal Opportunity/Affirmative Action

Columbus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, marital status, age, national origin, veteran status, disability status, or any other characteristic protected by applicable federal, state, or local law. As a federal contractor, Columbus participates in the E-Verify Program to confirm eligibility to work in the United States.