SQL Server Developer - ETL / SSIS

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • 10-15 lakh
  • 8-10 years
  • Views
  • 14 Dec 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Required skills:

- Minimum five years of experience using SQL Server Integrated Services (SSIS) (2014, 2012, 2008, 2005) including:

- Full and Incremental Fact Dimension ETL SSIS package development

- Slowly changing dimensions of Type 1, 2 and 3

- Creating and processing Surrogate Keys

- Creating and processing junk dimensions, bridge tables, and degenerate dimensions

- Minimum five years of experience with aggregating tables, data profiling, full and incremental loads, de-duplication of records, and transforming data

- Minimum five years of experience with performance tuning of SSIS packages

- Minimum five years of experience with robust SSIS packages with row counts, verifications, notifications, security, runs on development, test and productions servers, ftp file compression, indexing constraints

- Minimum five years of experience with dropping, truncating, creating, and modifying tables within SSIS packages

- Minimum five years of experience with SSIS packages executing Script Tasks using .net and stored procedures

- Minimum five years of experience with scheduling and deploying SSIS packages by using package configuration and project deployment model as part of an overall ETL framework

- Minimum five years of experience documenting unique features of SSIS packages, DB maintenance, programs and systems

- Minimum five years of experience designing and developing with SQL Server Analysis Services (SSAS) projects (if needed)

- Minimum five years of experience using Visual Studio Team Foundation Server

- Ability to be located on-site and work team compatible hours

Desired skills:

- Experience working with SQL Server 2014

- Experience working with customers to extract detailed requirements

- Demonstrated ability to communicate effectively in written, visual and oral formats with project teams, internal and external business and technical representatives, and executive management

- Experience with SQL Server database migrations

- Experience with Master Data Management (MDM) methodologies

- Experience converting SSIS packages to newer versions

- Experience working with DEL provider data and processes: licensed child care, Early Childhood Education and Assistance Program (ECEAP), Head Start, Early Supports for Infants and Toddlers (ESIT), Family Friend and Neighbor (FFN)

- Experience working with FamLink, Social Services Payment System (SSPS), ACES and BarCode data and processes


Job Posted By

O.P. Chawla
Director