Sr. Data Warehouse analyst

Mandatory Knowledge, Skills and Abilities:Minimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services.Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes.Minimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 R2 software tools to administer and/or manage SQL Server databases.Minimum 5 years of experience working with large organizations (over 1000 employees).Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of various tactical approaches to data warehouse development.Desirable Knowledge, Skills and Abilities:Creating and maintaining Extract, Transform, and Load (ETL) processes using Informatica, including use of PowerCenter for SQL Server.Experience creating and maintaining OLAP cubes.Experience tuning and optimizing SQL Server databases.Understanding of database modeling and design principles and ability to use a data model diagram.Experience performing mainframe-to-server automation, bulk copy, and FTP download.Experience programming in .Net, COBOL, and/or Natural running on an MVS/zOS platform.

#J-18808-Ljbffr