Job Description :
Need a copy of Degree at the time of submission
1) SQL SSIS ETL Developer(04693)
Albany, NY
12 Months
Pay Rate: $42/hr on C2C
Required Skills:
The BSC has a need for a SQL programmer to write and modify complex queries, as well as create stored procedures.
The Senior Programmer will be asked to do the following:
n Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts.
n Create and optimize queries in multiple applications.
n Identify and recommend solutions for database performance issues and optimization.
n Design, develop, and modify views and stored procedures in support of system and business requirements, using Microsoft SQL Server Management Studio.
n Work with the Database Administrator to create and execute DDL scripts.
n Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
n Assist in the improvement and integration of automation and tools designed to support work.
n Advise program area with data modeling and best practices around data architecture for large enterprise datasets.
n Test all changes in multiple applications to ensure functionality.
n Document all ETL processes needed for the dashboard’s continued functionality and performance
2) C# SQL UI Developer(04695)
Albany, NY
24 Months
Pay Rate: $42/hr on C2C
Required Skills:
ITS Staff mentoring, code reviews for ITS staff, code rewrites, project work as necessary.