Whitehall Resources
Data Migration Lead
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Migration Lead, contracted for an unspecified length, with an inside IR35 pay rate. Key skills include Oracle analysis, ETL/ELT pipeline construction, AI-driven automation, and data quality assurance, requiring strong data engineering experience.
🌎 - Country
United Kingdom
💱 - Currency
£ GBP
-
💰 - Day rate
Unknown
-
🗓️ - Date
April 9, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Inside IR35
-
🔒 - Security
Unknown
-
📍 - Location detailed
Surrey, England, United Kingdom
-
🧠 - Skills detailed
#Metadata #Data Migration #Data Profiling #Migration #Data Accuracy #ML (Machine Learning) #SQL (Structured Query Language) #Automation #Triggers #Cloud #AI (Artificial Intelligence) #"ETL (Extract #Transform #Load)" #Anomaly Detection #Quality Assurance #Python #Documentation #DMS (Data Migration Service) #Data Engineering #Oracle #Bash #Strategy #Data Extraction
Role description
Data Migration Lead
Whitehall Resources are currently looking for a Data Migration Lead.
This role will be Inside of IR35, so you will be required to use an FCSA Accredited Umbrella Company.
Key Requirements:
- Responsible for analysing legacy Oracle assets and delivering secure, accurate, and automated data migration pipelines as part of a broader modernisation programme.
- The role combines strong data engineering with AI driven automation and quality assurance.
Key Responsibilities/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.
- 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.
- Use AI tools to analyse PL/SQL logic, autogenerate 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.
Data Migration Lead
Whitehall Resources are currently looking for a Data Migration Lead.
This role will be Inside of IR35, so you will be required to use an FCSA Accredited Umbrella Company.
Key Requirements:
- Responsible for analysing legacy Oracle assets and delivering secure, accurate, and automated data migration pipelines as part of a broader modernisation programme.
- The role combines strong data engineering with AI driven automation and quality assurance.
Key Responsibilities/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.
- 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.
- Use AI tools to analyse PL/SQL logic, autogenerate 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.
