Proven 5+ years of experience writing T-SQL's, Stored Procedure, and Complex Queries using the Microsoft SQL Server.
8-10 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.
Possess a working knowledge of best practices for loading a data into normalized and/or Star schemas.
Candidate has experience with utilization of best practice SSIS design patterns.
Candidate has skill and ability in interfacing programmatically with a variety of enterprise systems.
Possess familiarity with source code management systems (TFS).
GENERAL QUALIFICATIONS
Candidate has very strong problem-solving and analytical skills.
Possess excellent communication skills, both written and verbal.
Candidate is a self-sufficient person that can complete high quality work, without significant guidance.
Knowledge and experience within the Insurance business space is considered a plus, but not mandatory.
EDUCATION REQUIREMENTS
Microsoft Certified Solution Associate (MCSA): SQL Server Development.
MCSA: Microsoft BI Development which covers the SSIS / SSRS.
B.A. / B.S. Degree in Computer Information Science or Information Technology
TECHNICAL QUALIFICATIONS
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.
