Innovations technological

Dear Partner,

Hope you are doing great!

Please find below the urgent requirement and let me know if you have any available consultant for the same.

Please share resume at atul.m@directionstaff.com

SQL Server Developer/ Data Load Engineer
Location:  Bluffton, SC

Duration:  12+ Months

Mandatory Skills

·         5 years of experience in the US with very hands on experience in ETL related work and transformation

·         VS 2010/2012 BI suite & Data Tools (Specifically SSIS)

·         T-SQL (SQL queries, functions, stored procedures)

·         Working knowledge of relational and dimensional modelling

·         Working knowledge of Source Control

Desired Skills:

·         Agile/Scrum experience

Job Responsibilities:     

·         Review the current ETL process (by detail code and process analysis) and transform and re-architect the process

·         Responsible for developing and testing ETL routines using Microsoft Visual Studio Data Tools/BI suite (package configuration and deployment, simple and complex transformation, variables, VB scripting, database and file-based data source handling, exception and error handling, etc.)

·         Responsible for performance tuning of SSIS routines

·         Strong debugging skills with the ability to identify the root cause of the issues

·         Handling XML files for loading

·         Able to articulate and define the data processes as part of the production releases

·         Good Inter personal skills and articulate to the senior management as required

·         Should have good experience in planning and following good change control process. Identify the gaps in the general process and improve them as required

·         Should work independently and willing to go extra length to nail down the data related issues

·         Should have previous experience in streamlining the data load processes and able see the improvements implemented   

Experience Level in Years (Range)          

·         Altleast 5 years of experience in the US with very hands on experience in ETL related work and transformation