Hello Business Partner, Hope you are doing well today, Please review the requirement and let me know if you have any suitable resume for this position... * Job Title : Data Analyst Location : Olympia, WA Duration : 6+Month Contract * *////// Must be Local to WA or CO /////*
Job Description: One of our client is currently seeking a Senior Data Analyst to support the development and operations of our client’s data marts. These data marts are designed as conformed components of a departmental data warehouse. This resource will perform the technical tasks required to set up, maintain, and troubleshoot extraction transformation and loads (ETL) routines that move data from transactional database to the data warehouse. The resource will also provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. The data warehouse operation environment is SQL Server 2008 r2 and 2012 on Windows 2003 and 2008r2 servers, and ADABAS and VSAM on a MVS z/OS. Candidates interested in this position must meet ALL Mandatory skills: * Mandatory Skills and Experience:* Minimum 5 years of experience in creating and maintaining ETL processes using Informatica, including use of PowerCenter for SQL Server. Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes. Minimum 5 years of experience using MS SQL Server 200, 2005 and 2008 r2 software tools to administer and/or manage SQL Server database. Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development. Experience using PowerExchange for Mainframe ADABAS. Minimum 5 years of experience working with large organizations (over 1000) employees. *Highly Desired Skills and Experience:* Creating and maintaining ETL processes using SSIS 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 z/OS platform ----------------------- Thanks and Best Regards, Steven Smith steven.sm...@panzersolutions.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.