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.