Senior ETL Data Engineer

London  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Senior ETL Data Engineer with SAS Data Integration, XML and SQL experience is required by large Public Sector authority in Croydon

*IR35 status confirmed out of scope.
*SC Clearance- Will consider candidates who are SC cleared and Eligible for SC

ETL Data Engineer Essential experience:
Use of SAS Data Integration (DI) Studio to populate data warehouse/lakes
Extracting data from data sources (including databases, XML, flat files, Excel etc.)
Writing and optimising SQL queries, functions, procedures (Greenplum, Postgres)
Documenting ETL designs and implementations, and operations guide
Data Analysis and Modelling (including Entity Relationship Diagrams, Star Schemas, Relational Data Analysis)

ETL Data Engineer Desirable experience:
Experience with POLE models and data matching
ETL Scheduling (concepts/practice and any use of ActiveEon)
Experience with Business As Usual ETL operations
Database partitioning design and strategy
Experience interfacing with data sources/systems via APIs eg REST
Data Quality monitoring and reporting
SAS Macro programming
SAS Enterprise Guide
Scripting (DOS, Linux, PowerShell, VBScript)
Windows and/or Linux networking fundamentals
XML (XML validation, XSDs)
Programmatic text file manipulation (Grep, Sed, Awk, Tr, Findstr)
Agile/Scrum working practices

Start date
ASAP
Duration
6 month
From
Square One Resources
Published at
26.07.2017
Project ID:
1387167
Contract type
Freelance
To apply to this project you must log in.
Register