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 the various tactical approaches to data warehouse development.

• Creating and maintaining Extract, Transform, and Load (ETL) processes using Informatica, including use of Power Center 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. or COBOL and/or Natural running on an MVS/zOS platform.