SAS DI Studio Consultants - Johannesburg Verfied

Salary Negotiable Johannesburg, Gauteng Johannesburg, Gauteng more than 14 days ago 10-01-2017 12:20:26 PM
07-02-2017 12:20:26 PM
We have a few vacancies available for SAS DI Studio Consultants.

With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.

We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development.

We have worked in more than 25 countries around the world and are currently implementing large-scale projects throughout Africa, the Middle East and Australia.

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