jobapplier

Oracle Fusion Technical Data Conversion Lead

Sonata Software

Job Title: Oracle Fusion Technical Data Conversion Lead

Location: Irvine, CA (Onsite)

Duration: Contract

Position Summary

Lead end-to-end data conversion from JD Edwards (JDE), AS/400, and multiple boundary/legacy systems to Oracle Fusion Cloud ERP. Own conversion strategy and technical execution, including extraction, profiling, mapping, transformation, cleansing, loading, validation, reconciliation, mock conversions, and production cutover. Partner with Oracle functional teams, business SMEs, source-system owners, integration teams, and program leadership to ensure accurate, complete, and timely migration of business-critical data.

Key Responsibilities

  • Lead the data conversion strategy, architecture, planning, and execution across JDE, AS/400, and boundary systems.
  • Define and manage the conversion object inventory, scope, dependencies, sequencing, schedule, and readiness criteria.
  • Lead data extraction from JDE, AS/400/DB2, databases, files, APIs, SaaS platforms, and other boundary systems.
  • Develop and review source-to-target mappings, transformation rules, cleansing logic, defaults, lookups, and cross-references.
  • Lead Oracle Fusion data loads using FBDI, REST/SOAP services, OIC, ADFdi, ESS/import processes, and approved ETL tools.
  • Coordinate conversion across Finance, Procurement, Supply Chain, Order Management, Inventory, and Manufacturing domains.
  • Establish automated validation and reconciliation using record counts, financial/control totals, inventory quantities, referential-integrity checks, and exception reporting.
  • Lead Mock Conversions, Dress Rehearsal, and Production Cutover; resolve load failures and improve success rates and runtime each cycle.
  • Develop the conversion runbook covering final extraction, freeze timing, load sequencing, reconciliation, business validation, and sign-off.
  • Lead onsite/offshore developers and report conversion status, risks, issues, dependencies, and readiness to program leadership.

Required skills and experience

  • 10+ years of ERP/data-conversion experience and 5+ years of Oracle applications experience, preferably Oracle Fusion Cloud ERP.
  • Led at least one full-cycle Oracle Fusion implementation or enterprise data migration, including multiple mock cycles and go-live cutover.
  • Strong hands-on expertise with Oracle FBDI, Fusion import/load processes, SQL, ETL, staging, transformation, error handling, and reconciliation.
  • Experience converting data from JD Edwards EnterpriseOne, AS/400/IBM i, and third-party or custom boundary systems.
  • Working knowledge of JDE data structures across Finance, Address Book, Item Master, Inventory, Procurement, Sales, and Manufacturing.
  • Strong understanding of Oracle Fusion business-object dependencies, conversion sequencing, data governance, and systems of record.
  • Experience with OIC, Informatica, Azure Data Factory, PL/SQL, Mulesoft, or comparable integration technologies is preferred.
  • Strong leadership, analytical, troubleshooting, stakeholder-management, and executive communication skills.

Key Deliverables

Conversion Strategy & Architecture • Conversion Object Inventory • Source-to-Target Mapping • Extraction & Transformation Specifications • Data Cleansing Rules • Cross-Reference Mappings • Oracle Load Programs/Templates • Validation & Reconciliation Framework • Mock Conversion Results • Conversion Runbook • Production Cutover Plan • Final Reconciliation & Business Sign-Off

ABOUT SONATA SOFTWARE

Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services.

Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

For more information, please visit

www.sonata-software.com

  • "
  • Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law
  • "

Every job at Sonata Software