SQL Server Developer (Azure/SSIS) @ Princeton, NJ

Hello Team,

Please find the below requirement details

 

Position: SQL Server Developer (Azure/SSIS)

Location: Princeton, NJ

Duration: 6 Months

Client: Deloitte Touche Tohmatsu Services, Inc

 

Required Skills:

What it is going to take to get a placement
• Primary creating tables, no UI work, back-end database work. Views Triggers, Stored Procedures – Optimization, Troubleshooting, Maintenance, Azure piece, query performance.
• ETL work using Azure Data Factory, SSIS
• Experience SQL Server 2014, 2016 and some 2012
• Azure SQL – experience with pulling data from or to Azure

Job Description:

Vendors – Candidates will need to be screened and potentially complete a Coder byte code assessment prior to submittal to Deloitte. 

Note: This project is with Deloitte for internal projects. This is NOT implementation work. The end client is Deloitte and work is being done for Deloitte internally. 


What it is going to take to get a placement
•             Primary creating tables, no UI work, back-end database work. Views Triggers, Stored Procedures – Optimization, Troubleshooting, Maintenance, Azure piece, query performance.
•             ETL work using Azure Data Factory, SSIS 
•             Experience SQL Server 2014, 2016 and some 2012
•             Azure SQL – experience with pulling data from or to Azure

Requirements
•             Design and development of Microsoft SQL Server databases (MS SQL Server 2016/2014/2012). 
•             Minimum X  years of experience in software development using Microsoft SQL Server, Azure SQL, T-SQL and T-SQL language.
•             Creating stored procedures, views, Triggers, Functions and performance tuning of SQL queries.
•             Must have experience in troubleshooting and resolving database integrity issues, complex query performance optimizations, blocking and deadlocking issues, table partitioning, data replication/restore process 
•             Experience in Database Maintenance plans for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes. 
•             Experience in development of Azure Data factory/SSIS to Extract Data, Transform, Load (ETL) data into SQL Server from different source/environments;
•             Experience with Data Modeling tools to effectively design the data models
•             Understanding of API/UI components, json structure, web based application architecture
•             Ability to understand data and its business applicability
•             Must have experience working with DevOps and clarity in CI/CD process and experience with source control management like Git.
•             Working knowledge of BI Tools like Power BI.

Notes :

Note: This project is with Deloitte for internal projects. This is NOT implementation work. The end client is Deloitte and work is being done for Deloitte internally.

--

Thanks & Regards, Ranjith Dandabathini  Account Manager - Apex Account

Phone: (209) 392-5335 Email: Ranjith@imcsgroup.net 9901 East Valley Ranch Parkway Suite 3020 Irving, Texas – 75063