SUMMARY:
My Focused client based in Centurion is currently recruiting for a dynamic incumbent to join their team.
POSITION INFO:
Qualifications:
- B.Tech IT or B.Sc. Informatics
- Additional dimensional modelling, Microsoft certification will be advantageous
Job description:
Methodologies:
• The candidate must have ability to elicit data requirements from stakeholders
• The candidate must have clear documentation skills
Principles
• The candidate must be familiar with design patterns in data development industry.
• The candidate must have solid understanding of Metadata constructs.
• The candidate must have clear understanding of EDW
• Knowledge of Domain driven design would be an advantage
• The candidate must be familiar with the concept of Data Marts
• The candidate must be familiar with abstraction techniques
Modelling
• The candidate must have proven data modelling techniques (3 years)
• The candidate must have knowledge and experience in Ralph Kimball data warehouse
Modelling (3 years)
• Knowledge of Immon data warehouse modelling techniques would add an advantage
• The candidate must have data normalization skills most especially the 2nd Normal form
Data Transportation
• The candidate must have solid experience of ETL systems
• The candidate must have solid experience of sourcing, staging and loading
• The candidate must be familiar with parallel loading principles
• The candidate must be familiar with source to target mapping
Development Software
• The candidate must have practical knowledge of T-SQL (4 years)
• The candidate must have practical experience of SQL Server Database Engine (4 years)
• The candidate must have practical experience of MS SSIS ETL software (4 years)
• Knowledge of MS SSAS OLAP software would add an advantage (4 years)
• The candidate must have practical experience of MS Visual Studio Data Tools (4 years)
• Knowledge of Database Administration would add an advantage
• Expert knowledge in configuration of database hardware resources
Repository type
• The candidate must be able to source data from different repositories
• The candidate must be fully acquainted with Microsoft SQL Server repository
• Knowledge of Hadoop would be an advantage but it is not a must
• Knowledge of Data Lake would be an advantage
• Knowledge of Oracle, Sybase, IBM DB2, IBM AS400 would be an advantage
Please visit our website --------Please upload your CV here--------> to submit your CV directly or to view other finance related jobs. If you have not had any response in two weeks, please consider your application unsuccessful. Your profile will be kept on our database for any other suitable position
NB! This job is now closed. You can apply for other jobs by uploading your CV.