ICT Jobs in Africa
|ETL Developer,   Cape Town,   South Africa|
(External factors which influence the work environment, taking future conditions and strategic requirements into account)
Dynamic start up culture and expanding company
Pioneer in Ecommerce in South Africa
Embedded in leading emerging market internet and media company
Fast paced /multi time zone
Translate business requirements for technical team
Responsible for the data aspects of the data warehouse (conceptual and logical models of the data warehouse and subsequent data marts / cubes). Modelling data by applying dimensional and star schema models with an understanding of the techniques used by Ralph Kimball
Ensure the quality of BI solutions by identifying data quality issues
Plans the overall architecture of the data warehouse / BI solutions, including performance considerations, storage considerations, data schemas and subject definitions
Perform source system data analysis and data mapping as needed to perform data integration
Analyse & translate functional specifications into technical specifications
Participate in design workshops, providing technical insight and knowledge. Serves as a technical reviewer and contributor in requirements, design and code reviews. Identify and introduce process efficiencies in the data integration process
Interpret written business requirements and technical specification documents to develop program logic using ETL technology. Optimize ETL data load jobs to improve performance and automate them
Create, document, and implement test plans and scripts to test program logic. Investigate, analyse, document and correct reported defects
Lead Unit and Integration Testing activities and assist in User Acceptance Testing as needed
Big Data Mining & Enrichment.
Desired Skills and Experience
Ideal Candidate profile:
3 to 5 years Data Warehousing and ETL experience
Relevant 3 year tertiary qualification (e.g. BSc Comp Sci, Mathematics etc.)
Experience in the following technologies: Microsoft BI stack, SAS, QlikView
Familiar with project methodologies (waterfall and agile) and SDLC
In depth knowledge of Data Warehousing and Data Management practices. Has strong understanding of data warehousing concepts and how best to organize underlying data structures to support BI
In depth knowledge of BI environments, solutions and implementations
In depth understanding of physical database design and optimisation for high availability and performance
Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimisation.
Understand ETL basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation
Understand database concepts of referential integrity, indexes and keys and table metadata.
Ability to query source and target databases for unit testing
Ability to interact with individuals and groups across all levels of an organization
Ability to work effectively in a team environment. Ability to work effectively in a dynamic team
Flexible attitude (A 'can do' attitude)
Ability to be flexible and adaptable when dealing with change
Strong problem solving skills and analytical ability
Ability to thrive under production pressure and deadlines
Ability to allocate time efficiently, handling multiple demands and competing priorities.
About this company:
Kalahari.com builds and operates an ecommerce platform that powers a range of products that are sold for our own account. Our aim is to continue pioneering ecommerce in South Africa and Africa by providing the most relevant online solutions and buying experience available.
Our team offers great opportunities for results-oriented individuals who know how to identify market needs and opportunities, define product objectives and plans, are focused on excellent customer experiences, and are experienced in creating and driving functional specifications through the development process. This is your opportunity to make a big impact on the satisfaction of our buyers and the performance of our business.
The ETL Developer will report to the Head of Business Intelligence, and be responsible for the development and implementation of Kalahari’s technical Business Intelligence strategy. We are looking for an ETL Developer with experience in Business Intelligence, Data Warehousing and dimensional modelling, with a particular focus in the e-commerce field preferred.
TOP ICT AFRICA HEADLINES
MTC Namibia Erects 14 New Transmission Towers
By Ngaevarue Katjangua Windhoek — The Mobile Telecommunications company (MTC) has erected 14 new network towers countrywide over a period of f..
FiberGuide Signs an Agreement with Optical Technology Training (OTT) to Deliver Certified Optical Networking Courses in Africa.
The in-depth 5 day training course in optical networking is a key enabler for well-designed and implemented national backbones, metro networks, ..
Uber Fare Boost Raises Income for Drivers, But will it Last?
Uber driver partners are paid 75% of the fare paid by the riders. It follows that when Uber continuously reduce rider fares, partner driver revenue..
How to Run Successful Load Tests
Load testing is instrumental to any web or mobile presence, whether it is e-commerce, bookings, media, governmental or something else – a mode..