Job summary:


Title:
SSIS, SSRS, ETL - W2 Only

Location:
Phoenix, AZ, United States

Length and terms:
Long term - W2 or 1099 only


Position created on 07/10/2020 05:32 pm

Job description:


*** Initial PO for 6 months; usually projects with this customer goes for 3+ years ***

W2 or 1099 only - no c2c ;  hourly contract.

  • Develop high performance code using T-SQL and C#  in SQL Server 2017 environment, including writing stored procedure, functions, triggers, and SSIS packages.
  • Advanced knowledge of T-SQL, SSIS, SSRS, and ETL processing, including the ability to remediate issues with complex SQL queries.
  • 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 database projects using Azure DevOps
  • 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

Skills

  • 3 Years of experience in Windows
  • 1 year of experience in Powershell
  • 3 years of experience in Visual Studio/C#/VB
  • 3 years of experience in SSIS
  • 3-5 years of experience in TSQL / SQL Server
  • 5 years of experience in MS SQL Server 2012-2017
  • 3 years of experience in SQL Server Management Studio (SSMS)
  • 3 years of experience in Visual Studio 2012-2019 (WIth SSDT) - AZURE DEV OPS (Source Control Management)
  • 2 years of experience in .NET Framework
  • 2 years of experience in Waterfal Model
  • 2 years of experience in Agile/SCRUM
  • 3 years of experience in AZURE DEV OPS - Running Unit Tests, Task Management (TFS)
  • 1 year of experience in MQ Series

Contact the recruiter working on this position:



The recruiter working on this position is Abaka Kartik(Shaji Team)
His/her contact number is +(1) (571) 2812089
His/her contact email is karthik.abaka@msysinc.com

Our recruiters will be more than happy to help you to get this contract.