Job Page:   Data Warehouse Developer (SSIS)


Listed By:   Resource 1   (via Jobg8)
Contact Name:   John Mussatto,   Agency
Job location:   Chicago Illinois, USA
Job Type:   Contract
Info:   Ref: JSSSIS_AZURE_312 I.T. & Communications
Duration: 12 months Not Specified Market (DOE)
 
Job Description:

    Resource 1 is in need of a Data Warehouse Developer to join a team responsible for the development, maintenance and execution of extraction, transformation and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse using MS SQL Server Integration Services (SSIS). This is a very large complex, HA (High Available) environment that includes SQL Server 2016 databases and clustered columnstore indexing. Individual should have at least 7 years of experience working in a large EDW environment. Must have experience designing, developing, enhancing, and troubleshooting SSIS packages. Should also be knowledgeable in designing and implementing database schemas using Kimball/Inmon methodologies. The current repository is over 40 terabytes of data, 100+ packages, billions of records on stable SQL Server 2014/2016 databases. Will also assist in designing/developing OLAP solutions using MS SQL Server Analysis Services (SSAS), so experience with SSAS and T-SQL development/tuning are plusses. Individuals will work with business SMEs and Data Architects to design and implement 3NF and dimensional data models. Individual will likely be involved in future Azure projects as well. May also be asked to help define and implement standards and practices for data warehousing initiatives throughout the company. Selected individual should have an understanding of data normalization rules, denormalization and other techniques to support reporting and analytics. Local candidates are preferred for on-site interviews.

    Technical Environment: SQL Server (2014/2016), SQL Server Integration Services (SSIS), T-SQL, SQL Server Analysis Services (SSAS), Enterprise Data Warehouse (EDW), Database Objects, Kimball/Inmon, database schemas & OLAP.


 Job number: 108693, Company id: 63111
Posted: 07/10/2017
Expires: 09/08/2017
Hit Statistics:
      Job Page

The Legal Disclaimer.


Copyright(c) 1995 - 2017 Software Contractors' Guild , 9725 Richland Hills Ln, Bakersfield CA 93306