Data Engineer
Data Engineer - Telford with 2 days/week in the office
An experienced Data Engineer is required to support the team in delivering 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 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 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 temporary contract is inside IR35 and will require working under the direction of the client delivery manager as part of a multi-disciplinary team. The successful candidate will follow established delivery processes and working practices
Due to the secure nature of the position and working environment, you must have, or be eligible to obtain Security Clearance
More details relating to UK Security Clearance can be found here:
United Kingdom Security Vetting: clearance levels - GOV.UK
Damia Group Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept our Data Protection Policy which can be found on our website.
Please note that no terminology in this advert is intended to discriminate on the grounds of a person's gender, marital status, race, religion, colour, age, disability or sexual orientation. Every candidate will be assessed only in accordance with their merits, qualifications and ability to perform the duties of the job.
Should the role require the successful candidate to undergo and be eligible for UK Security Vetting. Clearance sponsorship will be provided where required. Due to the nature of the work, candidates should meet the relevant residency requirements. If applicable, Reserved Post nationality restrictions will be confirmed by the client. Damia is committed to inclusive recruitment and welcomes applicants from all backgrounds.
Damia Group is acting as an Employment Business in relation to this vacancy and in accordance to Conduct Regulations 2003.