Senior Data Warehouse Analyst

Position: Senior Data Warehouse Analyst
Location: Tumwater or Olympia WA
Duration : 1 Year +
Rate: Market


Mandatory

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.

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. or COBOL and/or Natural running on an MVS/zOS platform.
Experience using PowerExchange for Mainframe ADABAS.




Thanks and Warm Regards,

C Mathan Brabhu
V: 301.880.0219 | C: 301.327.8532 | F: 888.599.5824 | E: Mathan@optimalbg.com | C: Optimal Business Group, Inc