ORACLE DATA MIGRATION & ODI ETL SPECIALIST

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

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.

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.

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.

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

• Database/schema object inventory and dependency mapping.
• Migration scripts and execution documentation.
• Migrated database schemas, objects, data, and data marts.
• Migrated or rebuilt ODI ETL workflows.
• Source-to-target reconciliation reports.
• Exception logs and resolution evidence.
• 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 on-site role, and the selected candidate will be required to work from the project location

Work Location

In person