Description
Requisition#
Location: Phoenix, AZ
Duration: 8 Months
Interview process: In-person/F2F.
Requirements:
Minimum 5 years of experience in TSQL/SQL Server
Minimum 3 years of experience in Windows
Minimum 3 years of experience in Visual Studio/C#/VB
Minimum 3 years of experience in SSIS
Minimum 3 years of experience in MS SQL Server 2
Minimum 3 years of experience in Non-Relational (No-SQL) DBs
Minimum 3 years of experience in ETL Processing, Repository Pattern, Factory Pattern, Unit testing
Minimum 3 years of experience in.NET Framework, WCF, C#
Minimum 3 years of experience in TFS 2015.
Minimum 1 year of experience in Event Sourcing Pattern, Event Store
Minimum 1 year of experience in Powershell
Minimum 1 year of experience in MQ Series
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
Write ad-hoc SQL queries and scripts to support various job functions
Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming.