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 ICS System (backup and configuration).
Import legacy data is correctly into the newly- created ICS 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 IJS Business Model for future use in the schema creations.
Manage the Integration schema.
Maintaining the IJS Transversal Timesheet System.

Minimum Qualifications
Appropriate Degree or Equivalent 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 BI stack environment, including SQL server and SSIS
3+ years in Microsoft SQL server, SQL, SSRS and SSIS
3+ years in ETL methodologies