Data Migration Lead
Job title: Data Migration Lead
Role Type: Hybrid – 3 Days/Week
Location: Surrey, UK
Duration of assignment: 6 months contract InsideIR35
The Role:
Legacy Analysis & Design
• Analyze Oracle schemas, procedures, packages, triggers, and dependencies.
• Perform source-to-target mapping and impact analysis.
• Define migration strategy (full load, delta, logical, physical).
• Document transformation logic and exceptions.
Migration Build & Execution
• Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL,
Python/Bash, or cloud DMS tools.
• Execute full and incremental loads.
• Validate data accuracy, referential integrity, and reconciliation results.
• Maintain playbooks, runbooks, rollback plans, and technical documentation.
AI-Enhanced Engineering
• Use AI tools to analyse PL/SQL logic, auto-generate mappings, and accelerate
documentation.
• Apply AI/ML for data profiling, anomaly detection, and automated quality
checks.
• Use LLM-based assistants for SQL optimisation, code conversion, and metadata
extraction.
• Build AI-powered dashboards and automated reporting.
Key responsibilities:
Legacy Analysis & Design
• Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
• Perform source-to-target mapping and impact analysis.
• Define migration strategy (full load, delta, logical, physical).
• Document transformation logic and exceptions.
Migration Build & Execution
• Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL,
Python/Bash, or cloud DMS tools.
• Execute full and incremental loads.
• Validate data accuracy, referential integrity, and reconciliation results.
• Maintain playbooks, runbooks, rollback plans, and technical documentation.
AI-Enhanced Engineering
• Use AI tools to analyse PL/SQL logic, auto-generate mappings, and accelerate
documentation.
• Apply AI/ML for data profiling, anomaly detection, and automated quality
checks.
• Use LLM-based assistants for SQL optimisation, code conversion, and metadata
extraction.
• Build AI-powered dashboards and automated reporting.
Key skills/knowledge/experience:
• Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
• Perform source-to-target mapping and impact analysis.
• Define migration strategy (full load, delta, logical, physical).
• Document transformation logic and exceptions.
Migration Build & Execution
• Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL,
Python/Bash, or cloud DMS tools.
• Execute full and incremental loads.
• Validate data accuracy, referential integrity, and reconciliation results.
• Maintain playbooks, runbooks, rollback plans, and technical documentation.
Desirable skills/knowledge/experience:
Legacy Analysis & Design
• Analyse Oracle schemas, procedures, packages, triggers, and dependencies.
• Perform source-to-target mapping and impact analysis.
• Define migration strategy (full load, delta, logical, physical).
• Document transformation logic and exceptions.
Migration Build & Execution
• Build and maintain ETL/ELT pipelines using Data Pump, pgloader, SQL,
Python/Bash, or cloud DMS tools.