Full-timeSQL + SSIS Lead

0 applicants

at timothy_nell in Virginia

Role              : SQL + SSIS Lead with ETL



Location       : Richmond, VA



Mode           : 6+ months on C2C



Client           : Life Time Fitness



 



Job Description:



 



·         Requires 10+ years of experience in Microsoft SQL Server

Development, with minimum 3 years of experience in SQL Server 2014.



·         Proficient in ETL process and development of SSIS (Integration

Services) packages.



·         Expert in creating and analyzing complex stored procedures.



·         Ability to convert Business requirements to technical requirements.



·         Knowledge of database administration techniques and database

administration tools.



·         Experience in design and development of new and existing multi-tier

online transactional systems.



·         Experience in performance tuning and query optimization



·         Experience in Healthcare Business and Agile delivery model



 Mandatory Skill Set:



·         MS SQL Server 2014 and above



·         Integration Services (SSIS) 2014 and above



·         Database knowledge (T-SQL) on SQL server 2014 and above



·         JIRA and Confluence



·         Bit Bucket



·         Source Tree



 Additional skill set (plus):



·         Work closely with DBAs to support and deliver application releases



·         Experience with Agile and Scrum methodologies



·         Excellent analytical and problem solving skills



·         Experience in the health care insurance industries desired



·         Excellent written, verbal and interpersonal communication 



·         SharePoint



·         Data Modelling tools like Erwin



·         MS Visio



·         SQL Sentry



·         Pl/SQL



·         Red Gate tools 



 Responsibilities:



·         Familiar with Logical Data Model and Physical Database design.



·         Strong skills in Data Analysis, Data Profiling and Data Mapping for

ETL processes.



·         Performed analysis of Business and system requirements including

Impact analysis of existing systems and create design specifications with the

consultation of Business users and technical architects.



·         Proficient in Design and Development of process required to

Extract, Transform, Load data to the data warehouse using MS Integration

Services.



·         Implemented various Performance tuning techniques on Sources,

Targets, Mappings and Workflows in MS Integration Services.



·         Working knowledge on different data sources as Flat files, SQL

Server, XML and Excel files.



·         Created SSIS packages to perform Extract, Transform and Load data

from various heterogeneous sources and destinations like Excel, SQL server,

Access, CSV and flat files using tasks and transformations provided by SSIS. 



·         Hands on Experience with SSIS Transformations like Execute SQL

task, Script task, Data flow tasks, Conditional split, Script component, Union

all, Derived column transformations.



·         Experience in creating Excel, Access and SQL Connections used in

SSIS Packages.



·         Experience in providing Logging, Error handling by using Event

Handler, and Configuration using XML for SSIS Packages.



·         Well versed in developing the complex SQL queries, unions and

multiple table joins and experience with Views.



·         Experience in database programming in TSQL



·         Provides support during the system implementation.



·         Partner with the architects to plan and develop solutions.



·         May work with business operations to capture metadata to build out

data models.



·         Work with project teams to plan and execute the quality control

process.



·         Details all aspects of functional designs, including record

layouts, pseudo-code, detailed data mapping, etc



 




Reference : SQL + SSIS Lead jobs

Recent jobs at timothy_nell

Full-time

3 Immediate positions : Automation Testing at timothy_nell in Virginia

11-10-2017
Full-time

Senior Java Microservices at timothy_nell in Virginia

11-09-2017
Full-time

BSA with Healthcare at timothy_nell in California

11-09-2017
Full-time

BSA with Healthcare at timothy_nell in California

11-07-2017
Full-time

Senior Java Microservices at timothy_nell in Virginia

11-03-2017