Data Warehousing Specialist

A financial services company based in South Africa is looking for a Data Warehousing Specialist to join their team Education & Qualifications: Relevant IT and data analytics qualifications e.g.

B.Tech or B.Sc.

(Informatics) (Essential) Dimensional modelling and/or relevant Microsoft certification (Advantageous) Principles Familiar with design patterns in data development industry.

The candidate must have solid understanding of Metadata constructs.

Clear understanding of EDW Knowledge of Domain driven design would be an advantage Familiar with the concept of Data Marts Familiar with abstraction techniques Modelling Proven data modelling techniques (5 years) Knowledge and experience in Ralph Kimball data warehouse modelling (5 years) Knowledge of Immon data warehouse modelling techniques would add an advantage Data normalization skills most especially the 2nd Normal form Data Transportation Solid experience of ETL systems Solid experience of sourcing, staging and loading Familiar with parallel loading principles F amiliar with source to target mapping Development Software A dvanced knowledge of T-SQL (5 years) and the following concepts Dynamic T-SQL Multi-threading Performance optimisation and tuning Practical experience of SQL Server Database Engine (5 years) Practical experience of MS SSIS ETL software (5 years) Practical experience of MS SSAS OLAP software (5 years) Practical experience of MS Visual Studio Data Tools (5 years) Knowledge of Database Administration would add an advantage Expert knowledge in configuration of database hardware resources Repository type Able to source data from different repositories Fully acquainted with Microsoft SQL Server repository Knowledge of Data Lake would be an advantage Knowledge of Oracle would be an advantage Knowledge of Hadoop is not essential but will also be an advantage Should you meet the requirements for this position, please email your CV to it.vacancystand-outstaffing.co.za . You can also contact the team on XXX-XXXX or alternatively you can visit our website Should you not hear from us within 3 days, please consider your application unsuccessful.