Senior Oracle Data Migration Lead

Experience: 10–15 Years
Engagement Type: Full-Time
Project: Oracle Database, Data Warehouse & ETL Migration
Location: On-Site

Role Summary

We are seeking an experienced, hands-on Senior Oracle Data Migration Lead to architect, lead and execute an enterprise-scale Oracle-to-Oracle database and data warehouse migration involving multiple Oracle databases, Oracle EBS/ERP source systems, ODI/ETL integrations and downstream reporting applications.

The candidate will own the end-to-end technical migration lifecycle, including solution design, database and schema assessment, migration execution, ETL modernization, data integrity, production cutover and post-migration stabilization.

Key Responsibilities

- Migration Architecture & Planning: Assess existing Oracle databases, data warehouse schemas, ETL workflows and application dependencies. Define migration architecture, strategy, technical design and execution plans.
- Hands-on Migration Execution: Lead and perform Oracle-to-Oracle data migration, including schema/object migration, data extraction, transformation, bulk loading and incremental/delta migration.
- SQL/PLSQL Development: Develop, review and optimize complex SQL queries, PL/SQL procedures, packages and migration scripts.
- ODI/ETL Migration: Oversee migration and redevelopment of ODI mappings, repositories, packages, scenarios, load plans and integration workflows.
- Data Warehouse Migration: Manage migration of staging, operational, fact/dimension and historical datasets while maintaining data relationships and integrity.
- Data Validation & Reconciliation: Define and execute source-to-target reconciliation,



completeness checks, transformation validation and exception resolution.
- Database & Reporting Integration: Coordinate with Oracle DBAs and BI teams to ensure database configuration, connectivity and compatibility with OBIEE/OAS reporting environments.
- Performance & Risk Management: Identify technical dependencies, optimize migration performance and resolve complex data migration issues.
- Cutover & Deployment: Own mock migrations, production cutover planning, rollback strategy, final delta loads and post-migration stabilization.
- Technical Leadership: Guide ODI developers, coordinate cross-functional technical teams and maintain migration documentation and delivery milestones.

Mandatory Technical Skills

- Oracle Database: Strong hands-on experience with Oracle 12c/19c or later, database architecture, schema objects and data warehouse environments.
- SQL/PLSQL: Advanced scripting, stored procedures, packages, query optimization and bulk data processing.
- Oracle Data Migration: Proven experience in Oracle-to-Oracle database migration, including full/incremental loads, schema migration and production cutover.
- Oracle ODI/ETL: Strong understanding of ODI 12c architecture, repositories, topology, mappings, agents, packages, scenarios and load plans.




- Data Warehousing: Experience migrating enterprise data warehouses, staging layers, fact/dimension tables and historical datasets.
- Migration Utilities: Experience with Oracle Data Pump (expdp/impdp), SQL*Loader and database migration utilities.
- Data Reconciliation: Source-to-target validation, data integrity controls, exception management and root-cause analysis.
- Migration Delivery: Experience with migration runbooks, dependency management, performance optimization, cutover and rollback planning.

Preferred Skills

- Oracle E-Business Suite (EBS) / ERP integration experience.
- Knowledge of OBIEE-to-OAS migration dependencies and reporting integration.
- Oracle GoldenGate, RMAN and Linux/Unix shell scripting.
- Experience with complex Oracle platform modernization or rebuild projects.

Qualifications & Experience

- Bachelor's degree in Computer Science, IT, Engineering or a related discipline.
- 10–15 years of relevant Oracle database, ETL and data migration experience.
- Proven delivery of at least two end-to-end enterprise Oracle migration projects.
- Experience leading technical migration teams while actively contributing to migration development and execution.
- Solid analytical, troubleshooting, stakeholder coordination and technical leadership skills.

Mandatory Selection Criteria: Candidates must demonstrate hands-on Oracle data migration execution and technical leadership. Pure project managers, solution architects without implementation experience, and migration testing-only profiles will not be considered.

Work Location: In person

📌 Senior Oracle Data Migration Lead (Gurugram)
🏢 LDU Business Services
📍 Gurugram