Data Warehouse Developer (Informatica) with ETL, PowerCenter for SQL, PowerExchange for Mainframe ADABAS, transact SQL, SQL Server, SSIS, data modeling, COBOL/Natural, .Net and OLAP cubes experience
Location: Tumwater WA
Duration: 14 months
Required knowledge, skills and abilities
a) Creating and maintaining Extract, Transform, and Load (ETL) processes using Informatica, including use of PowerCenter for SQL.
b) Experience using PowerExchange for Mainframe ADABAS.
c) Writing complex queries using Transact SQL for reporting and data validation purposes.
d) Administering and/or managing Microsoft SQL Server 2000, 2005, 2008 r2, 2012 databases.
e) Working with large organizations (over 1000 employees). f) Employing data warehouse principles and theories, including knowledge of the various
tactical approaches to data warehouse development.
It would be desirable for the contractor to have demonstrated skills and knowledge in the following areas:
g) Creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS).
h) Tuning and optimizing SQL Server databases. i) Understanding database modeling and design principles and ability to use a data model
diagram. j) Performing mainframe-to-server automation, bulk copy and FTP download. k) Programming in .Net. or COBOL and/or Natural running on an MVS/zOS platform. l) Creating and maintaining OLAP cubes