Technology Lead | SQL SSIS | SQL Server

Technology Lead | SQL SSIS | SQL Server

Work Location & Reporting Address: Livingston NJ 07039

Rate: 58.00

Contract duration (in months): 6

Target Start Date: 19 Mar 2018

Does this position require Visa independent candidates only? No

Must Have Skills (Top 3 technical skills only)

• Must be able to write complete TSQL queries with multiple joins & subqueries
• Must be able to create schema, tables, views able to utilize indexes
• Must be able to develop complex but efficient Stored procedures, functions, cursors

Nice to have skills (Top 2 only)

• Good to have knowledge of Python &.NET but not mandatory
• Strong verbal and written communication skills.

Detailed Job Description

Must be able to write complete TSQL queries with multiple joins sub queries

Must be able to develop complex but efficient Stored procedures, functions, cursors

Must be able to create schema, tables, views able to utilize indexes

Must be able to adapt the existing framework of the company build interfaces code that fits into this framework we have our own ETL tool which is very efficient data driven written in SQL UNIX. The developer must be able to learn it utilize it for further development.

Minimum years of experience*: 5+

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute*

• Strong SQL development skills
• Demonstrated competence developing complex Stored Procedures, Functions, Triggers and other database objects, as well as developing SSIS packages.
• Experience with large databases data warehouses required

Interview Process (Is face to face required?):