Sr. Data Warehouse analyst

Job Description

Location: Tumwater, WA or Olympia, WA

Start Date: 12/01/2013

Duration: 12+ months

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.

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 & Regards,

Rahul | Telligen Tech,INC|

Phone: 614 321 8003/614-364-4111 |Fax: 646 827 7559 |

Email: rahul@telligentech.com | http://telligentech.com |

Additional Information

Thanks & Regards,

Rahul | Telligen Tech,INC|

Phone: 614 321 8003/614-364-4111 |Fax: 646 827 7559 |

Email: rahul@telligentech.com | http://telligentech.com |