MS SQL Expert

The client is looking for a MS SQL expert

You will cover a spectrum of tasks from loading data from interfaces of different sources and techniques (file/DB access, push/pull) via Data Vault 2.0 data modeling (incl. methodology) with the help of a DWA tool to data provision in data marts and cubes in a Microsoft SQL Server based environment.

Required Skillset:
* Experience with Data Warehouse Automation (DWA) (Attunity Replicate, WhereScape RED and 3D)
* MS SQL Server 2017 technology
o SQL Server Core Service
o SSIS
o SSAS
o DQS Data Quality Services
o MDS Master Data Services
o Dynamic Data Masking
o T/SQL
* Reverse engineering of SAS (SASBase, SASMacro)
* Job Scheduling UC4/Shell Scripts
* Error handling
* Auditing
* Data profiling
* Ability to work in a team as an employee in a Scrum team