SAS Programmer/Tester

0 views
Skip to first unread message

umesh pal

unread,
Mar 21, 2011, 12:07:40 PM3/21/11
to rudrao...@gmail.com
 
Hi,
 
  Please send your resume on um...@hevarsy.com if you are comfortable with the position
 
 
Industry:  Healthcare

Location:   MA

Duration:  3 – 4 months

Start Date:  within two weeks

Rate:  50/hr all inclusive

Responsibilities:

 

SAS Programmer/UAT Tester

 

Strong, working knowledge of Netezza:

    • Ability to write SQL pass-through code so query is completely performed in Netezza.
    • Knowledge of Netezza functions and the analogous SAS functions to avoid bringing data back into SAS to use a function that could have been done in Netezza,
    • Some knowledge of Netezza architecture to write more optimized queries which would take advantage of Netezza’s architectural hardware enhancements for performance.
  • Advanced SAS PROC SQL
    • Ability to generate efficient PROC SQL to be completely run in Netezza,
    • All summarizations, joins, drops, creates need to be done in Netezza,
    • Efficient use of CASE statements in Netezza,
    • Efficient user of sub-queries,
    • Knowledge of zone maps, primary keys, etc. in writing SQL to avoid performing full table scans and efficient reading of Netezza tables.
  • Base SAS with an emphasis on
    • MACRO language
    • Complex DATA step programming
    • TABULATE and REPORT procedures
    • Output Delivery System
    • Summary Statistics
  • Experience deconstructing SAS code and SAS MACROS written by others, as part of a UAT testing process.
    • Testing efficiency & validity of existing code
  • Experience with multi-tabbed Excel spreadsheets.
  • Ability to quickly grasp business logic/requirements and develop SAS code.
  • Proficiency in personal computer and desktop applications; in particular Microsoft Access and Excel
  • Experience working under a Methodology driven approach (coding standards, Unit/System/User Acceptance testing)
  • Effective verbal and written communications
  • Possess research skills and be a thorough and insightful tester of information.
  • Knowledge of healthcare industry a plus. 
  • Ability to work as part of a team

 

Hardware Architecture:

  • Hardware – IBM
  • Operating System  AIX

 

 Regards
 Umesh
 Reply on: um...@hevar.com


umesh pal

unread,
Mar 21, 2011, 12:37:37 PM3/21/11
to rudrao...@gmail.com
 

Hi,
 
  Please send your resume on um...@hevar.com if you are comfortable with the position
 
 
Industry:  Healthcare


Location:   MA

Duration:  3 – 4 months

Start Date:  within two weeks


Responsibilities:
Reply all
Reply to author
Forward
0 new messages