Telligentech Inc
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr