- Johannesburg
- Salary: R66 667.00 - R100 000.00 Per Month
- Job Type: Permanent
- Sectors: IT General Technology
- Reference: 2117751
Vacancy Details
Employer: Goldman Tech Resourcing
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
• Familiar with source to target mapping
Development Software
• Advanced 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.vacancy@stand-outstaffing.co.za. You can also contact the team on XXX-XXXX or alternatively you can visit our website www.stand-outstaffing.co.za
Should you not hear from us within 3 days, please consider your application unsuccessful.
10 people have applied for this job. 457 people have viewed this job.
About Goldman Tech Resourcing
Goldman Tech Resourcing, TA Stand-Out Staffing, is one of South Africa’s most agile recruitment companies that focus on placing professionals and skilled people in contract and permanent employment.
Our mission is to be the most respected Recruitment Company within the IT, Finance and Mining Sectors by:
- Providing our clients with any number of quality candidates with the right technical skills and experience for a particular position.
- Providing the candidates we choose to work with a number of attractive career opportunities in a short space of time.
- Focusing on niche segments of market and knowing these segments intimately.
Similar Jobs
Data Warehousing Specialist
- Johannesburg
- Job Type: Permanent
- Posted 06 Mar 2024 | 9 Days left
More Jobs at Goldman Tech Resourcing
General Manager – Software Applications
- Gauteng
- Job Type: Permanent
- Posted 26 Apr 2024 | 60 Days left
BI Analyst
- Johannesburg
- Job Type: Permanent
- Posted 26 Apr 2024 | 60 Days left
Senior Estimator
- Johannesburg
- Job Type: Permanent
- Posted 26 Apr 2024 | 60 Days left
Candidate Construction Project Manager
- Pretoria
- Job Type: Permanent
- Posted 26 Apr 2024 | 60 Days left