SSIS Developer

TITLE - SSIS Developer

ROLE LOCATION(S) - Purchase, NY; Florham Park, NJ; NYC; Charlotte, NC

ROLE SUMMARY AND RESPONSIBILITIES
The ETL Developer will be primarily responsible for developing and supporting ETL code in SSIS for an enterprise data warehouse.


ROLE RESPONSIBILITIES
• Develop queries and stored procedures using T-SQL
• Understand and analyze requirements to develop, test, configure and deploy SSIS packages. Use of SQL Server 2014, 2016 or 2017 experience to implement robust, maintainable solutions that meet requirements
• Evaluate large and complex data sets
• Troubleshoot SSIS packages to address critical production issues
• Create tables, assign permissions, import data, perform app configurations, etc.
• Write and maintain technical documentation
• Manage source code versioning and deployment

REQUIRED TECHNICAL QUALIFICATIONS (in order of level of need)
• 5+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
• 5+ Years' experience coding T-SQL including the use of dynamic SQL
• 3-7 Years of SSIS development experience in developing ETL applications
• Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
• Working knowledge of best practices for loading a data into normalized and/or Star schemas
• Experience with best practice SSIS design patterns
• Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems
• Familiarity with source code management systems (TFS)

EDUCATION REQUIREMENTS
• Bachelor's degree in Computer Science, MIS, related field, or equivalent experience