Previous Job
Technical Specialist 5
Ref No.: 17-00807
Location: Rensselaer,, New York
Start Date: 06/30/2017
 Agency: NYS Dept. of Health
Is this a Project or Program specific request (e.g., Connections, SFS)?
If yes, please list the Project or Program Name:
NYS Health Benefit Exchange Project
Please provide a short description of the project:
New York State of Health (NYSOH) is New York's official health plan marketplace established by Executive Order No. 42. Development and design of the marketplace is funded with federal Exchange establishment grant funds. The hourly based IT resources requested are needed to support the on-going design and development of information technology systems consistent with federal regulations and state and rules.
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
The IBM Specialty -Technical Specialist 5 will work closely with the NYS of Health Marketplace program staff and other stakeholders to assist policy stakeholders with technical requirements review, testing and validation. Develops and maintains testing and defect documentation. 
Specific duties include:
Understanding data warehousing and DataMart's in order to facilitate and implement new business requirements
Able to understand existing datastage processes as well as develop new ETL processes based on business requirements.
Monitor ETL batches
Create manual and automated test scripts, operational alerts, and logging for the ETL batches.
Which Service Group is required?
Service Group 2
What is the number of staff being requested?
(maximum of 5)
Which Job Title Category is required?
Technical Specialist 5
Which Skill Level is required?
Which Skill Demand is required?
How many Candidate Response Forms are being requested per Contractor per position?     (1 or 2)
When is the Target Start Date?
(30 Business Days minimum from date of request)
How long is the engagement? (in months)
24 Months
When is the estimated completion date?
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)?
If  Part-Time, enter approximate number of hours per week:
What are the daily work hours? (note if negotiable or list preferred start and end time):
Where is the Home Base Region?
Region 1
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP
327 Columbia Turnpike, Rensselaer, NY 12144
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)
IBM Shop, AIX UNIX, Java Development, DB2 , SQL
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)
IBM WebSphere Application Server
Position Mandatory Qualifications
Technical Specialist 5:
 Assists with technical support of existing solutions and/or products. May install new products and assist in the migration to new releases or versions of products and provide related education. Area of expertise is usually related to a particular technology platform. In addition, a Technical Specialist may have programming skills and would be part of a project team. Minimum of 36 months experience.
  Requested Qualifications
Master's Degree in Information Technology or Computer Science.
72 months of hands on experience with writing SQL procedures, triggers & packages and UNIX Shell scripts to schedule jobs and other maintenance tasks.
48 months' experience with Infosphere Datastage versions 9.1 or higher with overall DW Architecture and Best practices.
48 months' experience working with the Affordable Care Act.
72 months of experience in working with Data warehousing mainly with writing Source to target mappings (STMs), creating ETL maps, PL/SQL to load Target Dimension and Fact tables, Job scheduling, troubleshooting performance issues for large implementations 2+ Terabytes (TB).
Professional IBM certifications including IBM Certified in XML Technologies and IBM Certified SOA Designer.
Completed or in progress certification- IBM Professional Certification Program- Datastage certification.
Additional Information Requests:
Are there additional security requirements for the Authorized User?
Will additional training possibly be required during the Engagement?
If Yes, provide description of anticipated training.
What type, or manner, of Knowledge Transfer is requested during the engagement?
Knowledge Transfer via written documentation.
Is travel anticipated during the Engagement?
If Yes, please list anticipated frequency and locations for travel: