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