Senior Oracle Data Conversion & Technical SME

The role

Two Senior Oracle Data Conversion & Technical SMEs will own how data enters Oracle across several concurrent customer engagements. You will design conversion approaches, perform hands-on loading into Oracle E-Business Suite and Fusion, and ensure data quality through reconciliation. The role involves working alongside Tessera AI agents to build reusable assets and platform knowledge.

What you will do

• Own the conversion approach including object inventory, load sequence, and cutover plans.
• Choose and defend load methods such as public APIs, Web ADI, FBDI, or HDL.
• Lead source-to-target mapping with Oracle functional architects.
• Build and run loads through open interfaces and standard import programs.
• Develop API-based loads with proper application context and error handling.
• Configure Web ADI integrators and use FNDLOAD or iSetup.
• Load Oracle Fusion through FBDI, ADFDI, HDL, and REST.
• Profile and pre-validate source data for duplicates and missing attributes.
• Reconcile every load against the source and produce sign-off evidence.
• Contribute Oracle data model and load know-how back into the Tessera platform.

Required qualifications

• 10+ years of Oracle E-Business Suite technical work (R12.1/R12.2) with data conversion focus.
• Technical-lead ownership of conversion on at least three full-lifecycle projects.
• Hands-on command of EBS open interface tables and import programs.
• Conversion depth in either Order-to-Cash or Procure-to-Pay and Product Master data.
• Oracle public PL/SQL APIs in production use.
• Expert SQL, PL/SQL and SQL*Loader.
• Fluency with concurrent manager, APPS schema, and interface error analysis.
• Web ADI and FNDLOAD knowledge.
• Understanding of R12.2 Online Patching (Edition-Based Redefinition).
• Oracle data model knowledge including TCA party, account and site model.
• Working Oracle Fusion data loading experience (FBDI, ADFDI, HDL, REST).
• Excellent verbal and written business English.

Nice to have

• Migrations from SAP ECC or JD Edwards into Oracle E-Business Suite or Fusion.
• Order-to-Cash depth: Order Management, Advanced Pricing, AutoInvoice and Receivables.
• ETL and data tooling at volume: Oracle Data Integrator, OCI Data Integration, Informatica or Python.
• Integrated SOA Gateway and Oracle Integration (OIC) for EBS and Fusion integration.
• Engagements where every load ran through application-level tools.
• BICC and BI Publisher for Fusion extraction and reconciliation.
• Prior experience partnering with AI, automation or RPA tooling.
• Oracle certification in E-Business Suite or Fusion Cloud.
• Experience delivering from an offshore centre directly to US or European customers.

About the company

Tessera is an AI-native platform for enterprise transformation. The multi-agent platform delivers governed execution across ERP, CRM, HCM, and finance systems.