SSIS BI Developer - Buffalo, NY # 14-00886 - Georgia IT Inc.

Position: SSIS BI Developer with strong SSRS and DW Experience.
Salary. Preferably GC/Citizens
Location :- Buffalo, NY
For a good consultant we are okay to work from home or our NJ office

Here is requirement for the prod support role.

Must have's:
Technical - SSIS
SQL Server 2012 hands on
Very Good Troubleshooting skills
Very Good communication skills as this role will require interaction with Business people and other stakeholders
Capable of resolving issues independently with less guidance


Resource is expected to do:

Convert packages to have variables use expressions instead of a configuration file as well as ensure all expressions are capable of being used on all of their servers, including their new stage server
Remove configs and use expressions for SSIS packages and promote them to QA/Stage and Production
Compile weekly metrics from their SQL job history by querying the tables
Perform troubleshooting during their morning loads and Review the agent history for their DG jobs
Test DG package changes

Nice to Have:
SSRS