Hi,
I have an urgent requirement which I need to fill immediately.
Requirement:
Title: UAT Tester
Location: Boston, MA
Duration: 3 1/2 months, or 560 hours
Start Date: As soon as we can find a candidate
Primary Skillset:
Strong, working knowledge of Netezza: o Ability to write SQL pass-through code so query is completely performed in Netezza.
o 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,
o Some knowledge of Netezza architecture to write more optimized queries which would take advantage of Netezza’s architectural hardware enhancements for performance.
· Advanced PROC SQL
o Ability to generate efficient PROC SQL to be completely run in Netezza,
o All summarizations, joins, drops, creates need to be done in Netezza,
o Efficient use of CASE statements in Netezza,
o Efficient user of sub-queries,
o 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
o MACRO language
o Complex DATA step programming
o TABULATE and REPORT procedures
o Output Delivery System
o Summary Statistics
· Experience deconstructing SAS code and SAS MACROS written by others, as part of a UAT testing process.
o 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
General Business Problem:
The project is now moving into UAT. The resource(s) need to help perform UAT of work previously performed. The work performed was replicating existing SAS reports the client had developed using an inefficient process – they wanted to start with a fresh approach, not using any of the existing code. All data will was extracted from a Data Warehouse / Data Mart that the client developed, called QEDM. This DW / DM is in Netezza. The project involved taking data extracts from Netezza and then populating Excel spreadsheets (no Pivot tables or hidden cells). The headers and footers needed to be precise and included the customer logo
Thanks & Regards
Madhu Babu
Vortalsoft Inc
Direct: 732 377 3493
Fax: 732 909 2476
E-Mail: madhu@vortalsoftusa.com
