Experience, Skills & Job Requirements

1. 7 years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
2. 7 Years’ experience coding T-SQL including the use of dynamic SQL
3. 5-7 Years of SSIS development experience in developing ETL applications
4. Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
5. Working knowledge of best practices for loading a data into normalized and/or Star schemas
6. Experience with best practice SSIS design patterns
7. Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems
8. Familiarity with source code management systems (TFS)
9. Experience with development in other aspects of the Microsoft BI Stack – SSAS/SSRS a plus