All Jobs Vacancy

Data Engineer

Posted Today by eTeam Workforce Limited

Description

We are a Global Recruitment specialist that provides support to the clients across EMEA, APAC, US and Canada. We have an excellent job opportunity for you.

Job Title: Data Engineer

Duration: 6 months

Location: Telford or Hove - typically required once or twice a month

Pay Rate: £486 per day all inc. (PAYE through FCSA umbrella)

Role Overview

  • An experienced Data Engineer is required to support the CDW SA team in delivering DWIT Informatica Advanced Scans across Legacy data warehouses. This role is a key enabler for the strategic migration from Legacy data warehouses to the new Data Lakehouse architecture.
  • The successful candidate will work closely with DWIT and CDW stakeholders to establish a comprehensive and accurate as-is view of each Legacy warehouse, leveraging Informatica Advanced Scanning capabilities wherever possible.

Security Clearance:: This role requires SC Clearance (active or eligible).

Key Responsibilities:

  • Perform detailed analysis of Legacy data warehouses using Informatica Advanced Scanning techniques.
  • Produce a complete and accurate as-is representation of each data warehouse.
  • Identify and document all inbound data feeds consumed by CDW, including:
  • Source/origin systems
  • Data formats
  • Full feed-by-feed data content
  • Capture and document the actual metadata held within the data warehouse, including:
  • Table structures
  • Field names and definitions
  • Identify and document all outbound data feeds from the data warehouse, including:
  • Consuming systems or platforms
  • Full feed-by-feed data content
  • Outbound metadata (tables, fields, and structures)
  • Where possible, generate bespoke outputs from Informatica Advanced Scanning for each Legacy warehouse to support analysis and migration planning.
  • Collaborate with architecture, data, and migration teams to ensure outputs are aligned to Data Lakehouse migration objectives.
  • Ensure documentation is clear, accurate, and suitable for use in downstream migration and governance activities.

Required Skills and Experience:

  • Strong experience with Unix Shell scripting
  • PL/SQL and Oracle SQL
  • Maestro/TWS scheduling tools
  • ETL concepts and implementations
  • Command line tools (PuTTY/CLI)
  • File transfer tools (eg WinSCP)
  • Use of text and documentation tools (eg Notepad++, Word or equivalent)

Desirable Knowledge and Experience:

  • SA Profiles extracts
  • SA MARTs
  • SA Warehouse structures and concepts
  • Caseflow and KBS
  • Authorete
  • Eureka
  • Business Objects tooling:
  • BO Infoview
  • BO Developer
  • BO CMC
  • BO Import Wizard

Additional Information:

  • This role is hands-on and delivery-focused, supporting a critical phase of legacy-to-Lakehouse migration.
  • Strong attention to detail, documentation quality, and stakeholder collaboration are essential.
  • This is a hybrid role, with office attendance at either Telford or Hove typically required once or twice a month, depending on team collaboration and client requirements.
Rate:
£486/day
Location:
Telford
IR35 Status:
Inside
Remote Status:
Hybrid
Industry:
Data & Analytics
Seniority Level:
Not Specified

Take-Home Pay

£7,000 per month

Visit calculators for additional details

Share job