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.