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.
--
Job details are sourced from the employer's original posting.
Open job postingAbout the company
qualifications and fitness for work irrespective of sex, age, marital status, civil partnership, sexual orientation, color, race, creed, religion, national or ethnic origin. TelligenTech gives full and fair consideration to all applicants for employment from disabled persons having regard to particular aptitudes and abilities, continuing where possible the employment of staff who become disabled. Our definition of diversity includes all human characteristics that make people unique as individuals from any Race, gender, geographic origin or culture. Our People management philosophy is to treat everyone as equal for employment in TelligenTech. We shall not discriminate on the basis of Lifestyle, age, disability, sexual orientation, economic status, marital status and religion. Our Culture : The interpersonal corporate culture begins with the executives. Our executives believe that leadership drives a culture, culture drives innovation, innovation and execution drives results. Our culture