SAS DI Studio Consultants - Johannesburg Verfied

Salary Negotiable Johannesburg, Gauteng Johannesburg, Gauteng more than 14 days ago 08-02-2017 8:46:47 AM
08-03-2017 8:46:47 AM
We have a few vacancies available for SAS DI Studio Consultants.

ETL experience:
• Must be familiar with ETL concepts such as
o Type1 and Type2 updates,
o error handling,
o scheduling,
o transformation rules, and
o maintenance of ETL processes.

SAS DI Studio 9.4:
• Must have experience with SAS DI Studio, preferably 9.4, although earlier versions should be sufficient.
• Job involves importing data from multiple sources including, but not limited to, flat files and Oracle databases.
• Must be able to build DI jobs to transform landing files into staging SAS datasets as per technical specs, and load them into Oracle tables using the standard Di studio transformations.
• Must be able to write and maintain custom transformations where required

Environments:
• Must also be familiar with the Unix environment (using Putty and WinSCP) and the SAS 9.4 platform i.e. creating SAS and Oracle libraries, scheduling jobs etc.

SKILLS REQUIRED:
- Strong ETL experience
- SAS 9.4 or later
- SAS DI Studio
- UNIX