This role is a senior techno-functional position responsible for advanced support,
technical analysis, and solution delivery in Oracle Fusion Cloud Financials. The
individual will act as a bridge between Finance business and technical/integration
teams, with strong emphasis on data, integrations, reporting, and troubleshooting,
while retaining functional ownership of finance processes.
Compared to Analyst II, this role requires deep technical expertise (SQL, integrations,
data model, SLA) and ability to drive complex issue resolution and enhancements
independently.
Key Responsibilities
1. Production Support & Issue Resolution
• Provide L2/L3 support for Oracle Fusion Finance modules (GL, AP, AR, FA, CM)
• Perform deep-dive troubleshooting using SQL, logs, and interface tables
• Conduct root cause analysis across subledger → SLA → GL flow
• Resolve data, accounting, and integration failures
2. Techno-Functional Analysis
• Analyze business requirements and translate them into technical solutions
• Evaluate impact across:
o Subledgers
o SLA rules
o GL postings
o Integrations
• Act as Finance + Data SME
3. Technical Expertise (Major Focus Area)
• Work hands-on with:
o SQL (Intermediate to Advanced) – joins, aggregations, reconciliation
queries
o Oracle Finance tables (AP, AR, GL, XLA tables)
o SLA architecture (events, accounting rules)
• Support:
o FBDI templates & bulk data loads
o Interface tables troubleshooting
• Develop and troubleshoot:
o OTBI reports
o BI Publisher reports
4. Integration Support
• Work with integration tools:
o OIC / Mulesoft / APIs / file-based integrations
• Troubleshoot:
o Failed integrations
o Data mismatches
• Understand:
o Upstream/downstream systems
o Data mapping and transformations
5. Month-End Close & Finance Support
• Support R2R close cycle
• Ensure:
o Data integrity
o Accurate accounting
• Work with Finance teams on:
o Reconciliation issues
o Adjustments
o SLA corrections
6. Enhancements & Automation
• Identify opportunities for:
o Automation
o Process optimization
• Drive:
o Small enhancements
o Reporting improvements
• Participate in:
o Release cycles, UAT, regression testing
7. Documentation & Governance
• Prepare:
o Technical design documents
o Data flow diagrams
o SOPs
• Ensure:
o Audit readiness
o Compliance support
Required Skills (Updated Focus)
Must Have (Strong Emphasis)
• Oracle Fusion Finance modules (GL, AP, AR, FA, CM)
• Strong SQL (mandatory – not basic anymore)
• Finance data model understanding (tables + joins)
• SLA concepts (events, accounting derivations)
• Production support (L2/L3)
Tech-Heavy Additions
• FBDI + data load troubleshooting
• Interface tables + integration debugging
• Basic knowledge of:
o REST APIs
o Web services
Good to Have
• OIC / Mulesoft exposure
• BI Publisher (layout + data templates)
• OTBI customization
• Finance domain depth (P2P, O2C, R2R)
Experience
• 5–9 years
• At least 3–4 years in Fusion techno-functional role
Behavioral Expectations
• Strong ownership
• Problem-solving mindset
• Ability to work independently on complex issues
• Stakeholder communication (Finance + IT)
Oracle Fusion Cloud Financials, Oracle Fusion Finance, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), SQL, Oracle Finance Data Model, Oracle Finance Tables, SLA Architecture, Subledger Accounting (SLA), Financial Accounting, Production Support, L2 Support, L3 Support, Root Cause Analysis, Troubleshooting, OTBI, Oracle Transactional Business Intelligence, BI Publisher, FBDI, Bulk Data Loading, Interface Tables, Oracle Integration Cloud (OIC), MuleSoft, REST APIs, Web Services, File-Based Integrations, Data Mapping, Data Transformation, Reporting, Finance Integrations, Data Integrity, Reconciliation, Record-to-Report (R2R), Accounting Corrections, Process Automation, Process Optimization, Application Enhancements, Release Management, User Acceptance Testing (UAT), Regression Testing, Technical Documentation, Data Flow Diagrams, SOP Documentation, Audit Compliance, Governance, Stakeholder Management, Business Analysis, Problem Solving, Communication, Oracle ERP, Finance Domain (P2P, O2C, R2R).