Reference # 18-01771 Title Senior SQL Developer
Location Phoenix, ARIZONA
Position Type Contract
Experience Level Contract
Start Date / End Date 11-11-2018 --- 30-06-2019
Job description:
Development and implementation of new and existing database solutions
Create SSIS projects and packages to perform ETL related tasks and prepare SSIS projects for deployment
Design database import / export processes used to generate client data warehouse deliverables
Create and maintain conceptual, logical, and physical database models
Managing and versioning the database projects using Visual Studio Team Foundation Server 2015
Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration
Datawarehouse design principles
Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming.
Participates in integrating activities with other IT departments for successful implementation and support of project efforts

Required 3 years of experience in Visual Studio/C#/VB, SSIS, FS 2015, .Net Framework, WCF, C# and TFS 2015
Required 3-5 years of TSQL/SQL Server
Required 5 years of MS SQL Server 2008-2017
Preferred 3 years of ETL Processing, Repository Pattern, Factory Pattern, Unit Testing, Windows and Visual Studio
Preferred 1 year of Powershell, Non-Relational DBs, Event Sourcing Pattern, Event Store and MQ Series