System Analyst/ Design Ii (Sas)

System Analyst/ Design Ii (Sas)
Company:

Esmart Recruitment Cc


Place:

Gauteng


Area:

Art Director

System Analyst/ Design Ii (Sas)

Details of the offer

Our client in the banking institutions is seeking a Systems Analyst/ Designer II (SAS Data Warehouse Developer) . The position is based in Sandton. Responsibilities: Registration of files in the Data Warehouse Dev, QA and production environments Develop, test and implement programs from supplied specifications to extract, transform and load data into various data warehouse marts using predominantly SAS, SQL and Netezza tools Develop extract, transformation and load processes through the DataStage ETL tool Perform root cause analysis and impact assessments and implement solutions Peer review and Quality assure the output of colleagues Optimisation of programs and applications Perform a technical lead role and mentor and coach junior staff Support all production-related incidents to ensure that tight daily SLAs are met Professional application and demonstration of acquired knowledge across technologies, and/or in-depth speciality in a specific technology – e.g. SAS, and SQL Actively participate in project teams as a core project member (incl cross functional forums and external parties) Take responsibility for incident fixes and manage to closure (focus on live environment) Maintain expertise in the use of the SAS Macros and determine macro development priorities Provide input and/or write the programming specifications Develop SAS programs using the SAS Enterprise Guide as well as macros Creating and managing users and user access to Netezza databases Create large SAS Datasets and manipulating the data for the preparation of reports, tables, listings and graphs Write SAS programs to performed ad-hoc analysis and data manipulation Use SAS Base programming/SAS Enterprise Guide to produce various business reports Develop database with large, diverse data source files Minimum requirements: Advanced Diplomas/National 1st Degrees SAS Certificate and/or SAS trainings 4 years in SAS experience, including advanced SAS macros and SQL Experience with ETL Experience with Netezza Knowledge of appliance technology such as Netezza will be a big plus Good understanding of data warehouse concepts Exposure to scheduling tools Advanced debugging ability Advance understanding of testing practices Exposure to IBM Banking Data Warehouse Model - preferably Problem solving skills Interpret the business requirements in order to create technical specifications across projects Deliver and coordinate coding work tasks according to technical specifications Market Related Salary Minimum requirements: Advanced Diplomas/National 1st Degrees SAS Certificate and/or SAS trainings 4 years in SAS experience, including advanced SAS macros and SQL Experience with ETL Experience with Netezza Knowledge of appliance technology such as Netezza will be a big plus Good understanding of data warehouse concepts Exposure to scheduling tools Advanced debugging ability Advance understanding of testing practices Exposure to IBM Banking Data Warehouse Model - preferably Problem solving skills Interpret the business requirements in order to create technical specifications across projects Deliver and coordinate coding work tasks according to technical specifications


Source: Adzuna_Ppc


Area:

  • Media - Art - Design / Art Director

Requirements