Senior Oracle Data Conversion & Technical SME

Accountabilities

• Own data conversion strategy and execution across multiple concurrent Oracle customer engagements, defining object inventories, dependencies, load sequences, mock conversions, and cutover plans.

• Determine and implement the most appropriate data loading approach for each object, including Oracle EBS open interfaces, public APIs, Web ADI, Fusion FBDI, HDL, and REST APIs.

• Collaborate with Oracle functional architects to develop source-to-target mappings for legacy systems such as SAP ECC, JD Edwards, and older Oracle EBS environments.

• Define customer-specific technical access and security requirements before conversion activities begin, including staging schemas, API users, and application-level access models.

• Build, execute, and troubleshoot data loads across Oracle E-Business Suite modules, including Order Management, Receivables, Payables, Purchasing, Inventory, General Ledger, and Fixed Assets.

• Develop API-based conversion solutions using Oracle public PL/SQL APIs, ensuring appropriate application context, MOAC initialization, and robust error handling.

• Configure Web ADI integrators and use tools such as FNDLOAD and iSetup to migrate configurations between environments.

• Execute Oracle Fusion data conversions using FBDI, UCM, ESS jobs, ADFDI, HDL where applicable, and REST APIs.

• Ensure appropriate sequencing of master data, open transactions, and balances, resolving interface errors and import failures until successful completion.

• Profile and validate source data, identifying duplicates, missing mandatory attributes, invalid codes, and inconsistent relationships before loading.

• Perform comprehensive reconciliation of record counts, control totals, balances, and critical attributes, producing evidence for customer approval.

• Lead mock conversions and production cutovers, managing execution timing, restart procedures, rollback plans, and delivery risks.

• Handle sensitive business information, including personal data, banking details, and pricing, in accordance with customer security and data protection requirements.

• Contribute technical knowledge and conversion expertise to AI-powered platform capabilities, improving automated mapping, validation, and loading processes.

• Develop reusable conversion templates, validation scripts, mapping libraries, and playbooks to improve delivery efficiency across engagements.

• Support pre-sales activities by defining conversion scope, technical approaches, effort estimates, and risks alongside client partners and principal architects.

• Provide knowledge transfer, documentation, and runbooks that enable customer teams to manage delta loads and post-go-live conversion activities independently.

Requirements:

• At least 10 years of Oracle E-Business Suite technical experience, particularly R12.1 and R12.2, with data conversion as a core specialization.

• Technical lead ownership of data conversion activities across at least 3 full-lifecycle Oracle projects.

• Deep hands-on knowledge of Oracle EBS open interface tables and import programs across Order Management, Receivables, Payables, Purchasing, Inventory, General Ledger, and Fixed Assets.

• Strong business-object expertise aligned with the relevant specialization:

  • Order-to-Cash (OTC): Customer master data, Trading Community Architecture (TCA), pricing, sales orders, returns, receivables, invoices, and receipts.

  • Procure-to-Pay (P2P) and Product Master: Supplier master, product and item master, purchasing, payables, inventory, and receiving.

  • Extensive production experience with Oracle public PL/SQL APIs, including TCA, Order Management, item, supplier, and pricing APIs.

  • Strong understanding of Oracle application context, MOAC initialization, and API error handling.

  • Expert-level SQL, PL/SQL, and SQL*Loader skills, with experience analyzing concurrent manager processes, APPS schema structures, interface errors, and application logs.

  • Practical experience with Web ADI, FNDLOAD, and Oracle EBS R12.2 Online Patching, including Edition-Based Redefinition implications for custom staging objects.

  • Strong understanding of Oracle data models, including TCA parties, accounts and sites, items, inventory organizations, and downstream transaction processing.

  • Hands-on experience with Oracle Fusion data loading using FBDI, UCM, ESS jobs, ADFDI, HDL where applicable, and Fusion REST APIs.

  • Proven track record of successful data reconciliations, business-approved conversion results, and well-executed production cutovers.

  • Ability to independently manage several concurrent engagements while maintaining delivery quality, accountability, and organization.

  • Demonstrated ability to learn new AI platforms quickly and become proficient in their application to enterprise data conversion.

  • Excellent written and verbal business English, including the ability to communicate technical concepts and present effectively to business and technical stakeholders.

  • Experience working with distributed onshore, nearshore, and offshore teams, supported by strong asynchronous communication and collaboration skills.

  • Bachelor’s degree in a related field or equivalent practical experience.

  Preferred qualifications:

  • Experience migrating data from SAP ECC or JD Edwards into Oracle EBS or Fusion, beyond EBS-to-EBS upgrades.

  • Strong Order-to-Cash expertise, including Order Management, Advanced Pricing, AutoInvoice, and Receivables.

  • Experience with ETL and data integration tools such as Oracle Data Integrator, OCI Data Integration, Informatica, or Python.

  • Familiarity with Integrated SOA Gateway and Oracle Integration Cloud (OIC).

  • Experience delivering conversions in environments where direct database access is restricted and application-level tools are required.

  • Knowledge of Oracle Fusion extraction and reconciliation using BICC and BI Publisher.

  • Experience working with AI, automation, or RPA tools in enterprise delivery environments.

  • Oracle E-Business Suite or Oracle Fusion Cloud certifications.

  • Experience delivering offshore technical services directly to US or European customers with strong ownership across time zones.

  Benefits:

  • Competitive compensation: The position advertises compensation of $200,000–$225,000; the applicable compensation structure and currency should be confirmed for the India-based engagement.

  • Remote flexibility: Work remotely from anywhere within India.

  • International collaboration: Work directly with US-based customers, architects, and distributed delivery teams.

  • AI-driven innovation: Collaborate with advanced AI agents and contribute to next-generation enterprise transformation technology.

  • Technical leadership: Own complex conversion strategies and influence technical delivery across multiple engagements.

  • Professional development: Expand expertise across Oracle EBS, Oracle Fusion, and AI-powered enterprise platforms.

  • Career opportunity: Contractor engagement through a staffing partner, with potential conversion to a permanent position in the future.

  • Global exposure: Support enterprise transformation initiatives across multiple customers and industries.

  • Flexible engagement environment: Daily overlap with US business hours of at least 3–4 hours, with occasional travel as required.