*ETL-SSIS Developers* Duration: 6-8 months contract
Location - Louisiana Using ETL process diagrams and supporting technical specifications developed during Design construct ETL jobs using SSIS. Jobs will address both historical and delta (ongoing) load processes to populate the RDBMS databases. - Excellent communication and client interfacting skills - Ability, experience and desire to work in a collaborative team environment - Hands on development, and implementation of data warehousing and business intelligence solutions - Must have experience with Microsoft SQL Server 2005 and 2008. This experience must include - Management Studio, and creating Integration Services packages (SSIS). Desired - Experience using with Allfusion Erwin Data Modeler - Government agency experience - Financial, accounting and/or tax industry experience Our client maintains information system applications to support tax administration (and ancillary) applications. Application data for these systems currently reside in relational databases (DB2/MVS, SQLServer, and Access) and non-relational data sources (sequential files, VSAM files, Excel). LDR uses Gentax, a custom off the shelf (COTS) application developed by Fast Enterprises, LLC as its Integrated Tax System. Currently information access for these systems is supported by static data inquiry screens within each application, extensive development of custom reports, and limited ad hoc access to the operational database of each application. * * *Phase 2 - Development/implementation of the Department’s first data mart. The services are to include: * - Physical database design - Design and development of the data mart population process (SSIS ETL and CDC as required) - Configuration of the business intelligence tool to access the data mart (Cognos metadata model and initial reports) - The design, development, and implementation of data warehousing and business intelligence solutions. The Data Modeling tool that will be used on this project will be Allfusion ERwin Data Modeler The Business Intelligence tool that will be used on this project is Cognos 8 (currently version 8.3). The ETL tool that will be used on this project is Microsoft SQL Server Integration Services (currently 2005). The majority of the data to be extracted and loaded into the data mart resides in SQL 2005 databases within the Department’s tax processing application. The tax processing application contains a reporting database, which is a copy of the production database. The reporting database is comprised of 1,157 tables and is currently 850GB in size. The reporting database is refreshed on a daily basis, but is not necessarily a daily refresh as processes may still be occurring during the backup/restore. The operational data for the initial data mart is estimated at 100 GB. It is anticipated to grow at a rate of approximately .5 GB per year. The data mart will be refreshed daily, but will not necessarily be a full refresh and as changed data will be required in most cases * * *Thanks/Regards,* *Nagesh Gona* *400 W Cummings Park || Suite#2850 || Woburn, MA-01801 * *Email:** nag...@xperttech.com** || Phone: 781-898-2018 * *Fax: 781-207-0709 || **www.xperttech.com* <http://www.xperttech.com/>* *** -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To post to this group, send email to sap-workflow@googlegroups.com. To unsubscribe from this group, send email to sap-workflow+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-workflow?hl=en.