JOB DESCRIPTION : ORACLE DATA MIGRATION & ODI ETL SPECIALIST

Required Resources: 2

Experience: 5–8 Years

Engagement: Project-Based

JOB OBJECTIVE

We are seeking an experienced Oracle Data Migration & ODI ETL Specialist to support the migration and rebuilding of an existing Oracle Data Warehouse environment. The resource will assess database schemas, data marts, objects and ODI ETL workflows; develop scripts; and execute Oracle-to-Oracle migration using SQL/PLSQL, Oracle Data Pump (import/export), and other appropriate utilities. This is a rebuild of the target environment, not a conventional in-place upgrade.

KEY RESPONSIBILITIES

1. Oracle Database & Data Warehouse Migration

- Assess existing schemas, tables, views, indexes, stored procedures, functions, and database objects.

- Identify dependencies across schemas, data marts, ETL workflows, and downstream reports.

- Develop and execute Oracle-to-Oracle migration scripts.

- Perform schema and data migration using Oracle Data Pump (EXPDP/IMPDP), SQL/PLSQL, and approved tools.

- Rebuild objects and verify compatibility with the target environment.

- Resolve migration failures, performance issues, and data integrity defects.

2. ODI ETL Migration & Reconfiguration

- Assess Oracle Data Integrator (ODI) mappings, packages, procedures, scenarios, and load plans.

- Migrate or rebuild ODI workflows and configure target connections.

- Reconnect Oracle EBS, ERP applications, and other enterprise data sources.

- Validate ETL transformations, business rules, dependencies, and scheduling.

- Troubleshoot ODI execution errors and optimize ETL performance.

3. Data Validation & Reconciliation

- Reconcile source and target schemas, tables, records, and control totals.

- Validate data completeness, accuracy, and consistency.

- Develop SQL-based reconciliation and exception reporting scripts.

- Analyze discrepancies and document root causes and resolutions.

4. Migration Execution & Deployment





- Prepare migration runbooks, execution scripts, and rollback procedures.

- Support migration rehearsals, cutover, and post-migration validation.

- Coordinate with DBAs, infrastructure teams, and OAS specialists.

- Support system integration testing (SIT), user acceptance testing (UAT), and stabilization.

REQUIRED TECHNICAL SKILLS

- Oracle Database and Oracle Data Warehouse architecture

- Advanced SQL and PL/SQL development and tuning

- Oracle Data Pump: EXPDP/IMPDP

- Oracle Data Integrator (ODI): mappings, packages, load plans, scheduling

- Data warehouse schemas, dimensional models, and data marts

- Oracle-to-Oracle data migration and database object dependency analysis

- Oracle EBS and ERP data integration concepts

- Source-to-target reconciliation and exception management

- Working knowledge of WebLogic and ODI connectivity

PREFERRED QUALIFICATIONS

- Bachelor's degree in Computer Science, IT, Engineering, or equivalent.

- 5–8 years of relevant Oracle database, data warehouse, and migration experience.

- At least one end-to-end Oracle Data Warehouse migration or rebuild project.

- Hands-on ODI development and migration experience.

- Experience in enterprise ERP integrations and large-scale data warehouse environments.

EXPECTED DELIVERABLES

1. Database/schema object inventory and dependency mapping.

2. Migration scripts and execution documentation.

3. Migrated database schemas, objects, data, and data marts.

4. Migrated or rebuilt ODI ETL workflows.

5. Source-to-target reconciliation reports.

6. Exception logs and resolution evidence.

7. Cutover and post-migration validation documentation.

MANDATORY SCREENING

Candidates must have hands-on Oracle-to-Oracle migration, SQL/PLSQL, Oracle Data Pump, and ODI ETL experience. Oracle DBA-only experience without scripting and ETL migration is insufficient.

Note : This is an in office role, and the selected candidate will be required to work from the project location

Work Location: In person

📌 ORACLE DATA MIGRATION & ODI ETL SPECIALIST (Gurugram)
🏢 LDU business services
📍 Gurugram