Oracle Financial Consultant Lead

Key Responsibilities

• Lead technical design, development and support for Oracle Financials modules (AP, AR, GL, PO) on Oracle EBS and Oracle Fusion Cloud

• Translate finance and business requirements into technical solutions, including extensions, custom reports and workflows

• Build and maintain interfaces and integrations between Oracle ERP and third-party systems using APIs, open interfaces and REST/SOAP web services

• Develop and optimise SQL and PL/SQL objects, and resolve performance bottlenecks

• Design BI Publisher / OTBI reports and dashboards, including subledger, GL and statutory/compliance reporting

• Support period-end and month-end close by resolving interface failures and stuck transactions and by monitoring scheduled jobs

• Run SIT, UAT, defect fixing and production deployments, with controlled code migration across environments

• Perform root-cause analysis on production issues and deliver permanent fixes

• Prepare technical design documents, impact analyses and operational runbooks

• Coordinate with functional consultants, business analysts and finance stakeholders, and mentor technical team members Required Skills and Technical Expertise

• Oracle E-Business Suite R12.2.x, with exposure to Oracle Fusion Cloud ERP • Hands-on experience with Oracle Financials (AP essential; AR, GL, PO preferred)

• Strong SQL and PL/SQL (packages, procedures, views, query tuning)

• Integrations: Oracle APIs, open interfaces, REST/SOAP web services

• Reporting: BI Publisher / OTBI / XML Publisher

• SIT/UAT and release/deployment practices

• Agile delivery (Jira) in onsite-offshore models

• Strong communication and stakeholder management

Good to Have

• Oracle APEX, OAF, Forms and Reports

• Tableau or Power BI

• Unix/Shell scripting and job scheduling (Autosys)

• TOAD, SQL Developer, SVN/Git, Jenkins/Kintana

• Regulatory or tax-compliance reporting (e.g., VAT)

Qualifications and Experience

• Bachelors degree in IT, Computer Science or a related field (B.Tech/B.E./B.Sc./MCA)

• 10 to 15 years of Oracle ERP technical experience, including Oracle Financials, with team-lead or technical-lead exposure

• No mandatory certification.

Oracle certifications are a plus.

Ideal Candidate

An Oracle ERP technical lead who is comfortable in both the code and the finance process behind it. You pay close attention to detail around close cycles, trace issues to their root cause, and explain technical trade-offs clearly to finance and business stakeholders.