Senior Oracle Data Conversion & Technical SME
Tessera Labs · Full-time · Posted 1d ago
Center of Excellence | Working alongside Tessera AI Agents
Location: India-based (offshore).
Remote: Yes, within India, with a daily overlap of US business hours (at least 3–4 hours) and occasional travel as needed.
Experience: 10+ years
Employment type: Contractor through a staffing partner; conversion to a permanent role is possible later.
Positions: 2 — one Order-to-Cash data SME and one Procure-to-Pay and Product Master data SME (see Position Profiles).
Start date: Immediate.
Engagement model: Multi-engagement technical delivery role. Approximately 80% hands-on data conversion work across several concurrent Oracle customer engagements (E-Business Suite and Fusion), 20% platform enablement, pre-sales support and product input. Works from India with a daily overlap of US business hours alongside customers, Oracle functional architects and the Principal Architects.
Tessera is an AI-native platform for enterprise transformation. The multi-agent platform delivers governed execution across ERP, CRM, HCM, and finance systems, cutting timelines from years to weeks and costs by more than half. Built on deep expertise across Oracle, SAP, Salesforce, Workday, and other systems of record, Tessera address the scope a system integrator would have traditionally taken up with the speed of execution and efficiency of an AI-native platform.
For decades, enterprises have struggled with fragmented business systems, where migrations have consumed hundreds of millions of dollars, data stayed inconsistent and unreliable, and business processes slowed under manual review. Tessera was founded to change that, for Oracle and every other system enterprises depend on. The name itself — a tessera, a single tile in a mosaic — reflects our mission: unifying the disparate pieces of the enterprise into a coherent whole. Tessera is an AI-powered, multi-agent platform that harmonizes systems and lets teams work in plain English.
We are looking for two Senior Oracle Data Conversion & Technical SMEs to own how data gets into Oracle — across several customer engagements at the same time. Our Oracle functional architects decide what the target should look like; you decide how the legacy data actually arrives there: through which interface, in what order, under what access, and how everyone knows it arrived correctly.
Your centre of gravity is Oracle E-Business Suite: the open interface tables and import programs, the public PL/SQL APIs, Web ADI and the concurrent manager. Much of our pipeline is migration into EBS — from SAP ECC, JD Edwards and older EBS instances — and our customers rarely give a vendor direct database access. You need to know what can be loaded through which door, and why each door rejects what it rejects.
You will also need real Oracle Fusion loading depth — FBDI, HDL and the Fusion import processes — because many of our customers run EBS and Fusion side by side, or are part-way from one to the other, and the same master data has to land correctly in both.
You will do this work with Tessera’s AI agents, not instead of them. The platform profiles the source data, proposes mappings, generates transformation logic and load files, and runs the reconciliations. What it cannot do is decide whether a customer with forty bill-to sites is a data problem or a business reality, or why Order Import rejects lines that look perfectly valid. That judgment is the role, and every time you exercise it we expect it to go back into the platform.
Two outcomes define the job. The first is converted data the business trusts on day one: counts, balances and open items that reconcile to the source, with evidence the customer signs. The second is that the next conversion goes faster — load templates, validation rules and playbooks captured in the platform rather than in your head. The second is what makes the first repeatable, and it is the measure you will be held to.
We are hiring two SMEs with the same technical foundation but different business data depth. Each candidate should be clear which profile they are applying for.
Customer master in the Trading Community Architecture (TCA) model: parties, accounts, account sites and site uses (bill-to, ship-to), contacts, customer profiles and credit limits — through the Customer Interface and the TCA public APIs.
Pricing: price lists, modifiers and qualifiers in Advanced Pricing.
Open sales orders and returns through Order Import and OE_ORDER_PUB, including holds, partial shipments and order types.
Open receivables: invoices, credit and debit memos through AutoInvoice, and unapplied or on-account receipts through the receipt APIs or Lockbox.
Supporting objects: payment terms, salesreps, transaction types and customer bank accounts.
Oracle Fusion equivalents: customer import (FBDI/REST), Order Management order import, and Receivables AutoInvoice and receipt imports.
Supplier master: suppliers, supplier sites and site assignments, contacts and supplier bank accounts — through the Supplier Open Interface and the supplier APIs.
Product master: items and organization assignments, item templates, categories and catalogs, units of measure and conversions, item cross-references, and bills of material where in scope.
Sourcing and purchasing: approved supplier lists, sourcing rules, blanket and contract agreements, and open purchase orders through the Purchasing Documents Open Interface (PDOI).
Open payables and receiving: open AP invoices through the Payables Open Interface, and open receipts through the Receiving Open Interface.
Inventory: on-hand balances, lots and serials through the Inventory Transactions Interface.
Oracle Fusion equivalents: supplier import, item import (Product Hub), purchase order and agreement import, and Payables invoice import (FBDI).
Own the conversion approach on several concurrent engagements: the object inventory, load sequence and dependencies, the number of mock loads, and the cutover plan.
Choose and defend the load method for each object — open interface and import program, public API, Web ADI, FBDI or HDL — based on volume, validation, restart needs and the access the customer will actually grant.
Lead source-to-target mapping with the Oracle functional architects: SAP ECC customer master and partner functions to the TCA model, material master to items and inventory organizations, pricing conditions to price lists, and JD Edwards address book and item master to their Oracle equivalents.
Settle the environment and access model with the customer’s IT and security teams before the first load — staging schemas, API users, application-level access only — rather than discovering it in mock load one.
Build and run loads through the open interfaces and standard import programs: Customer Interface, Item Import, Order Import, AutoInvoice, Payables Open Interface, Journal Import, Mass Additions, and the Receiving and Inventory transaction interfaces.
Develop API-based loads where the interfaces fall short — TCA party, account, site and contact APIs, OE_ORDER_PUB, supplier, item, BOM, pricing and receipt APIs — with application context, MOAC initialisation and API error handling done properly.
Configure Web ADI integrators for user-maintained data and restricted-access engagements, and use FNDLOAD or iSetup to move configuration between instances.
Load Oracle Fusion through FBDI via UCM and ESS jobs, ADFDI, HDL where HCM is in scope, and REST where volumes allow — and know where Fusion import processes behave differently from their EBS counterparts.
Sequence masters before open transactions and balances, and work rejections to zero from interface error tables, concurrent request logs and API messages.
Profile and pre-validate source data before it reaches Oracle: duplicates, missing mandatory attributes, invalid codes, and broken relationships such as orphaned ship-to sites.
Reconcile every load — record counts, control totals, open balances and key attributes against the source — and produce sign-off evidence that the customer’s finance and data owners accept.
Run repeatable mock conversions and the production cutover, including timing, restart and rollback.
Handle sensitive data — personal data, bank details, pricing — within the customer’s security and data processing rules.
Contribute your Oracle data model, interface and load know-how back into the Tessera platform, so the agents get better at conversion with every engagement.
Turn field fixes into reusable assets — load templates, validation scripts, mapping libraries and conversion playbooks — so one fix serves many customers instead of one.
Support pre-sales on Oracle opportunities with a conversion component: object scope, approach, effort and risk, alongside the client partner and the Principal Architect.
Leave the customer’s team able to run delta and post-go-live loads themselves, with runbooks and named owners.
10+ years of Oracle E-Business Suite technical work (R12.1/R12.2) with data conversion as your centre of gravity, including technical-lead ownership of conversion on at least three full-lifecycle projects.
Deep, hands-on command of the EBS open interface tables and import programs across Order Management, Receivables, Payables, Purchasing, Inventory, General Ledger and Fixed Assets.
Conversion depth in the business objects of your position profile: for Position 1, customer, pricing, sales order and receivables data; for Position 2, supplier, item and product master, purchasing, payables and inventory data. You should be able to explain how each object is validated on import and what breaks downstream when it is loaded wrong.
Oracle public PL/SQL APIs in production use — TCA, Order Management, item, supplier and pricing — including the application context and MOAC initialisation without which an API call quietly does nothing.
Expert SQL, PL/SQL and SQL*Loader, and fluency with the concurrent manager, the APPS schema, and interface error and log analysis.
Web ADI and FNDLOAD, and an understanding of R12.2 Online Patching (Edition-Based Redefinition) and what it means for custom staging objects.
Oracle data model knowledge that goes beyond the tables: the TCA party, account and site model, items and inventory organizations, and how converted orders, invoices and receipts behave in downstream processes.
Working Oracle Fusion data loading experience: FBDI through UCM with ESS jobs, ADFDI, HDL where HCM is in scope, and the Fusion REST APIs.
A record of reconciliations the business signed off and cutovers that ran to plan.
Proven ability to work on several engagements at once without losing control of any of them.
Proven ability to learn a new AI platform quickly and become the person others ask. You will be expected to reach real fluency in the Tessera platform within your first months.
Excellent verbal and written business English, with strong presentation ability to both business and technical audiences.
Experience working with distributed (onshore, nearshore and offshore) delivery teams, with strong asynchronous communication discipline.
Bachelor’s degree in a related field, or equivalent practical experience.
If your conversion experience is running somebody else’s load scripts, this is not the role — the work here starts with deciding how the data should get in. If you are an Oracle functional consultant who has filled in FBDI templates but never written a PL/SQL load or worked an Order Import error table down to zero, you would be better placed in our Oracle Functional capability, and we hire for that separately. If you have only ever loaded data with direct database access, you will struggle with customers who allow application-level access only. And if you want one engagement at a time with a scope someone else agreed, you will find this uncomfortable.
Migrations from SAP ECC or JD Edwards into Oracle E-Business Suite or Fusion, not only EBS-to-EBS upgrades.
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 because direct database access was not allowed.
BICC and BI Publisher for Fusion extraction and reconciliation.
Prior experience partnering with AI, automation or RPA tooling inside an enterprise delivery context.
Oracle certification in E-Business Suite or Fusion Cloud.
Experience delivering from an offshore centre directly to US or European customers, with strong ownership despite the time-zone gap.
Month 1: Fluent in the Tessera platform. Owning conversion on at least one engagement, with the object inventory, load methods and sequence agreed with the customer.
Month 3: A full mock conversion run and reconciled on that engagement, conversion on a second engagement underway, and reusable load templates and validation checks live in the Tessera platform.
No third party may recruit, solicit candidates, publish job opportunities, use Tessera Labs’ name or branding, or represent that they are acting on behalf of Tessera Labs without prior written authorization. Any such activity conducted without explicit written consent is strictly prohibited.
New Zealand