Senior ETL Data Engineer | SAS | XML | SQL | Croydon

Surrey  ‐ 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

Immediate interview and flexible start dates available via Square One Resources

Start date
ASAP
Duration
6 weeks (possible extension)
(extension possible)
From
Square One Resources
Published at
02.08.2017
Project ID:
1391211
Contract type
Freelance
To apply to this project you must log in.
Register