Lead Oracle Engineer

Houlihan Lokey

Lead Oracle Engineer design and support for Oracle Cloud ecosystem solutions. Houlihan Lokey provides strategic financial advice and supports enterprise-grade solutions.

Posted 7/2/2026full-timeNew York City • California, Illinois, Massachusetts, New York, Texas • 🇺🇸 United StatesSenior💰 $130,000 - $200,000 per yearWebsite

Tech Stack

Tools & technologies

CloudERPETLOracleSOAPSQL

About the role

Key responsibilities & impact

Design, develop, and maintain advanced Oracle APEX applications supporting Finance, Accounting, Procurement, and operational business processes, with a focus on user experience, role-based security, workflow automation, auditability, and long-term maintainability.
Maintain and enhance ETL and data pipelines processes that support APEX application, reporting, data synchronization, and downstream business processes.
Review existing custom applications and data flows to identify opportunities for simplification, performance improvement, automation, and automation.
Lead the design and development of integrations between Oracle Fusion Cloud ERP and internal or external systems using Oracle Integration Cloud—including application and scheduled integrations, file-based integrations, REST/SOAP, ERP adapter, SFTP, and event-driven integration patterns.
Design reusable integration patterns, error-handling frameworks, logging mechanisms, reconciliation processes, and exception monitoring to ensure reliability and operational visibility across the OIC environment.
Develop technical solutions across Oracle Fusion Financials modules—including General Ledger, Payables, Receivables, Procurement, Expenses, Cash Management, and Fixed Assets—leveraging FBDI, ADFDI, ESS jobs, BI Publisher, OTBI, REST APIs, and SOAP services.
Create, maintain, and optimize SQL and PL/SQL packages, procedures, functions, views, triggers, and data validation logic, applying performance tuning practices to support applications, integrations, reporting, and automation.
Partner with business users and cross-functional teams to gather requirements, perform fit-gap analysis, and translate business needs into scalable, well-documented Oracle Cloud solutions.
Work with security, audit, and compliance teams to ensure all solutions align with SOX, ITGC, data security, segregation of duties, and change management requirements.
Troubleshoot complex production issues across APEX, OIC, Oracle Fusion, BI Publisher, OTBI, ESS jobs, APIs, and data interfaces—providing clear root cause analysis and sustainable long-term remediation.
Support end-to-end testing—including unit testing, system integration testing, UAT, and regression testing.
Support Oracle quarterly updates by reviewing release notes, assessing potential impact, testing integrations, validating custom applications, validating critical business processes, and resolving post-upgrade issues.
Provide technical guidance to developers and consultants on Oracle APEX, OIC, Oracle Fusion integration, and development best practices, contributing to team capability and knowledge sharing.
Actively explore AI-enabled tools, Oracle Process Automation, and emerging Oracle Cloud capabilities to identify and implement automation opportunities that reduce manual effort, streamline integrations, and improve operational efficiency.
Bring an innovation and continue improvement mindset to the Oracle ecosystem by evaluating new technologies, simplifying complex solutions, improving supportability, and strengthening the overall Oracle platform.

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance Technology, or a related field, or equivalent professional experience.
8+ years of hands-on experience with Oracle technologies, including Oracle Cloud ERP, Oracle APEX, ODI, OIC, SQL, and PL/SQL.
8+ years of experience designing and developing Oracle APEX applications in an enterprise environment.
5+ years of experience with Oracle Integration Cloud, including ERP adapters, REST/SOAP APIs, scheduled integrations, file-based integrations, and error handling.
Strong experience supporting Oracle Fusion Cloud ERP, preferably within Financials, Procurement, Expenses, or related finance applications.
Advanced SQL and PL/SQL development experience, including performance tuning, complex queries, stored procedures, packages, functions, and data validation logic.
Strong understanding of Oracle Fusion integration methods including FBDI, ADFDI, ESS jobs, BI Publisher, OTBI, REST APIs, SOAP services, and business events.
Demonstrated experience with JSON, XML, XSLT, web services, API authentication, SFTP, and secure data transmission practices.
Strong communication skills with the ability to work directly with business stakeholders, IT teams, vendors, and senior leadership.

Benefits

Comp & perks

Competitive total compensation package
Discretionary incentive compensation

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle APEXOracle Cloud ERPSQLPL/SQLOracle Integration CloudREST APIsSOAP ServicesFBDIADFDIBI Publisher

Soft Skills

Strong Communication Skills