Skip to content
Jobgether

Senior Oracle Data Conversion & Technical SME

IndiaRemote · India
Senior · Full-time · Security & IT
POSTED 4 NOVVERIFIED 8M AGO
Apply Ask
Pay · Jobgether
₹6.5L–₹24.7L
p25–p75 · n=16
Open for
0d
since 4 Nov
Hiring · 30d
2,000
+534 net · open roles
SQL

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.

How Jobgether works

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.

We appreciate your interest and wish you the best!

Why Apply Through Jobgether?

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1

Source · JobgetherFirst seen 4 NovOriginal ↗