All Jobs Vacancy

Data Engineer – SC Cleared

Posted Today by Whitehall Resources

Job Spec

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.

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.

Skills Required

  • 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 (e.g. WinSCP)
  • Use of text and documentation tools (e.g. Notepad++, Word or equivalent)

Desirable Skills

  • 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
Rate:
Not specified
Location:
United Kingdom
IR35 Status:
Inside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Not Specified

Take-Home Pay

Not Available

Visit calculators for additional details

Share job