Sr. Data Warehouse analyst
Tumwater, WAAll locationsTumwater, WAOlympia, WA, United States On-site
Salary not listedJobFig found this opening at its original source and checks that it remains available.
About the role
Company Description 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 | Qualifications 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 |
What you'll bring
- Ø 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 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.