Oracle Software Engineer II (802)

M&S Consulting; Pasadena (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

M&S Consulting, Pasadena, CA, is seeking an experienced Oracle EBS professional to join our on-site team. The role focuses on designing, developing, and supporting Oracle EBS customizations, reports, interfaces, and workflows to optimize financial processes.

You will work with Oracle EBS R12.2.x, OAF, and related tools, ensuring performance, testing, and user training activities are executed with quality. This is an onsite opportunity requiring proximity to Pasadena.

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), personalization’s, DFF/KFF, FNDLOAD, alerts, and AOL components.

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

Oracle Forms

Oracle Reports

OAF

REST APIs

GIT

OBIEE

Data warehousing

Tools

GitHub

Informatica

Oracle APEX

SQL Developer

TOAD

Job description

M&S (which stands for Management and Solutions) was conceived in 2002 with the vision of creating highly effective teams of elite consultants to deliver strategic process and technology solutions to enterprise organizations across the US. Our commitment to delivery in complex environments and long-term customer success has merged process and technology into innovative solutions, established deep pockets of expertise, and enabled innovative transformation for evolving businesses.

We have intentionally cultivated steady growth focused on being approachable and helpful to our dearly valued clients and closely cared-for employees. M&S people simply “care hard”, and this reflects in our work products, our interactions, and our culture.

Job 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

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

Must be a US Citizen or Permanent Resident

This is an onsite role. It is not remote. Must be in or near Pasadena, CA

M&S Consulting proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a protected veteran, or any other characteristic protected by law.