Duties:
- Update, test and maintain the current back-end data import functionality for the [STAGING] ETL process using test and actual data.
- Load initial departmental data from flat files into staging data environment and supply exception reports to the relevant departments.
- Development and deploy of new System (backup and configuration).
- Ensure that all legacy data is imported correctly into the newly- created system.
- Review Data Requirements for FTP Submissions, [STAGING] Database Model.
- Manage SSIS ETL Packages: Load ICS Data, Audit FTP Location, Load Source Data.
- Management of the Business Model for future use in the schema creations.
- Integration schema management.
- Maintaining the Timesheet System.
Minimum Qualifications
- Degree in Computer Science, or Information Technology, or Informatics, or Engineering, or Information Systems, or Commerce or other relevant qualification at NQF7
Minimum Experience
- 5+ years in the ICT industry
- 3+ years in Systems Analysis
- 4+ years in the development of ICT systems (SDLC)
- 3+ years’ in ETL / Business Intelligence Development in Microsoft Bl stack environment, including SQL server and SS’S
- 3+ years in Microsoft SQL server, SQL, SSRS and SSIS
- 3+ years in ETL methodologies
Desired Skills:
- Microsoft
- BI
- SQL
- SSRS
- SSIS
- ETL
- deployment
Desired Work Experience:
- 5 to 10 years
Desired Qualification Level:
- Degree