- Role Summary
- We are seeking an experienced Oracle Fusion Finance Functional Resource to bridge our core Oracle ERP financial modules and our SQL-based analytics ecosystem. You will ensure accurate financial data extraction, validate General Ledger (GL) and Accounts Receivable (AR) datasets, and support reliable reporting across Power BI.
- - Key Responsibilities
- Data Validation &
- Reconciliation: Perform end-to-end data validation and reconciliation between Oracle Fusion Financials (GL, AR) and downstream SQL databases/Power BI dashboards to guarantee 100% financial accuracy.
- Analytics &
- Reporting Support: Design, validate, and troubleshoot financial reports in Power BI, translating complex accounting logic into explicit analytical views.
- Data Extraction &
- SQL Querying: Write and optimize SQL queries to extract, transform, and audit data across Oracle Fusion tables (via OTBI, BI Publisher, or external data pipelines).
- Troubleshooting &
- Root Cause Analysis: Investigate data discrepancies, broken data connections, and reporting anomalies across Oracle data connectors and reporting layers.
- Stakeholder Collaboration:
Partner with offshore/onshore finance teams and data engineers to refine reporting requirements and maintain data governance standards.
- Required Qualifications
- Oracle Fusion Expertise: 3+ years of hands-on functional experience with Oracle Fusion Cloud Financials, specifically General Ledger (GL) and Accounts Receivable (AR).
- SQL &
- Data Architecture: Strong proficiency in writing complex SQL queries and understanding Oracle Fusion underlying database schemas/tables.
- BI &
- Reporting Tools: Proven experience building, validating, and troubleshooting reports in Power BI (including managing Oracle data connections and gateways).
- Analytical Mindset: Demonstrated ability to reconcile sub-ledger to GL balances and trace data lineage from source transaction to visual report.
- Offshore Readiness: Strong written and verbal communication skills with the ability to work independently and overlap with global team hours as needed.
- Preferred Qualifications
- Experience with Oracle Fusion Analytics Warehouse (FAW), OTBI, or BI Publisher (BIP).
- Familiarity with ETL/ELT pipelines connecting Oracle Cloud ERP to external SQL data warehouses (e.g., Azure SQL, Snowflake, SQL Server).