*Hi, *
**
* Please send your resume on [email protected] if you are comfortable with
the position*
**
**
***Industry:* Healthcare*
Location:* MA*
Duration:* 3 – 4 months*
Start Date:* within two weeks*
**
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: [email protected]
--
You received this message because you are subscribed to the Google Groups
"US_IT.Groups" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/us_itgroups?hl=en.
