*Hello, * *I have an opening with the Department of Human Services for the State of Iowa. They are looking to migrate their enterprise data warehouse from the current SQL Server 2005 to SQL Server 2012. They require a consultant to be extremely well-versed in SQL Server Integration Services (SSIS). Please take a look at the requirement provided below and if you find that you have any consultants interested in this position, please forward their resume and contact details *
*Tite: SQL Developer * *Location: Des Moines, Iowa* *Duration : 6 months* *Client: State of Iowa, Department of Human Services* *Project Description: The Department has an enterprise data warehouse currently begin migrated from SQL Server 2005 to SQL Server 2012. Tools used by DHS within the data warehouse environment are SQL Server Reporting Services (SSRS), Query Analyzer for direct query, DBXtra (visual query building tool), and Oracle Business Intelligence Enterprise Edition.* *Role Description: * *1. Migrate the existing environment to SQL Server 2012* *2. Design and development of dimensionally structured databases (Kimball Model) along with the development and implementation of Enterprise Conformed Dimensions,* *3. Development of highly-automated ETL packages in support of source data import and data mart database refresh.* *4. Development of complex T-SQL Queries including;* *a. Optimization of recurring Queries, and* *b. Converting queries into parameterized stored procedures in support of reporting and analytic needs.* *Please note that this is open for a round one In-Person ONLY opening. * *Thanks & Regards* *Anurag Upreti* *IT Recruiter* *Website:www.sysmind.com <http://www.sysmind.com>* *Email: anu...@sysmind.com <anu...@sysmind.com>* *Phone:609-897-9670 Extn 4002* *Fax: 609-228-5522* *Address: 38 Washington Road, Princeton Junction, NJ 08850* *[image: Description: Description: Description: cid:image001.gif@01CC0A79.D4FFDB80]* -- You received this message because you are subscribed to the Google Groups "Oracle-HRMS-India" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-hrms-india+unsubscr...@googlegroups.com. To post to this group, send email to oracle-hrms-india@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-hrms-india. For more options, visit https://groups.google.com/d/optout.