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 


·         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


·         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


·         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


3 Immediate positions : Automation Testing at timothy_nell in Virginia


Senior Java Microservices at timothy_nell in Virginia


BSA with Healthcare at timothy_nell in California


BSA with Healthcare at timothy_nell in California


Senior Java Microservices at timothy_nell in Virginia