Hi,
Position title : SQL DBA - Data Warehouse Duration : 12 months Location: Des Moines, IA Interview F2F Need minimum 5+ years of experience. Description: The Department is in need of a SQL developer to support; 1. The migration of the existing environment to SQL 2012, 2. Work with data warehouse analysts, policy and field staff to design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs. 3. Work with DHS staff in the development of Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. 4. Design and development of data cubes 5. Design and development of highly-automated ETL packages. The Department predominately uses SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool. Data Sources include mainframe, IDMS (via extracts), other SQL Server databases, and Oracle. Required Skills: * Experience using SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool * Design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs * Assist power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases * Design and development of data cubes * Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. * Experience using SSRS to create reports * Query Analyzer for direct query * Migration experience from current (SQL 2005 or 2008) environment to SQL 2012 With Best Regards, Pranahitha Lenkala Senior Recruiter, JP Computer Systems Inc. 3169, West Springs DR, Suite B, Ellicott City, MD 21043. Direct: 410.220.0891 | Fax: 410 558-6145 | e-Mail: pranahi...@jpcomputersinc.com | www.jpcomputersinc.com LinkedIn: Lenkala Pranahitha | GTalk: pranahithareddy785 To unsubscribe from this mailing, please reply to this email with the word UNSUBSCRIBE in the subject line, or click here. -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
