SQL DBA (2012 Experience) in IA for 1 Year Contract !! Locals only !!
Kindly Reply on: Lisa.dutt@itbtalent.com
***********Candidates Must be local for Face to face Interview*********
Location: Des Moines, IA
Interview Process: In Person
The Department has an enterprise data warehouse currently begin migrated from SQL Server 2005 to SQL Server 2012.
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.
6.Assist Data Warehouse Analysts and other power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases.
Tools used by DHS within the data warehouse environment include; SQL Server Reporting Services, Query Analyzer for direct query, DBXtra (visual query building tool), and Oracle Business Intelligence Enterprise Edition. Key day to day activities are;
1.Design and development of dimensionally structured databases (Kimball Model) along with the development and implementation of Enterprise Conformed Dimensions,
2.Development of highly-automated ETL packages in support of source data import and data mart database refresh.
3.Development of complex T-SQL Queries including;
a.Optimization of recurring Queries, and
b.Converting queries into parameterized stored proceedures in support of reporting and analytic needs.
Extensive experience with SQL Server Integration Services along with Dimensional modeling skills is paramount for this position.
Experience using SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool Required 5 Years
Design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs Required 5 Years
Migration experience from current (SQL 2005 or 2008) environment to SQL 2012 Required 1 Years
Query Analyzer for direct query Required 3 Years
Assist power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases Required 5 Years
Design and development of data cubes Required 5 Years
Query Analyzer for direct query Required 3 Years
Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. Required 5 Years
Experience using SSRS to create reports
Regards,
Lisa Dutt
Technical Recruiter
Desk No : 609-935-3773 Ext 102
Princeton Forrestal Village
116 Village Blvd, Suite 200
Princeton - New Jersey 08540
Lisa.dutt@itbtalent.com | lisa.dutt13@gmail.com
www.itbrainiac.com
If you prefer not to receive emails from us, simply reply to this e-mail with the word "REMOVE" in the subject line.
Location: Des Moines, IA
Interview Process: In Person
The Department has an enterprise data warehouse currently begin migrated from SQL Server 2005 to SQL Server 2012.
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.
6.Assist Data Warehouse Analysts and other power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases.
Tools used by DHS within the data warehouse environment include; SQL Server Reporting Services, Query Analyzer for direct query, DBXtra (visual query building tool), and Oracle Business Intelligence Enterprise Edition. Key day to day activities are;
1.Design and development of dimensionally structured databases (Kimball Model) along with the development and implementation of Enterprise Conformed Dimensions,
2.Development of highly-automated ETL packages in support of source data import and data mart database refresh.
3.Development of complex T-SQL Queries including;
a.Optimization of recurring Queries, and
b.Converting queries into parameterized stored proceedures in support of reporting and analytic needs.
Extensive experience with SQL Server Integration Services along with Dimensional modeling skills is paramount for this position.
Experience using SQL Server Integration Services (SSIS) with complex T-SQL as its ETL tool Required 5 Years
Design, develop and implement data mart databases that are dimensionally modeled around line of business reporting/analytic needs Required 5 Years
Migration experience from current (SQL 2005 or 2008) environment to SQL 2012 Required 1 Years
Query Analyzer for direct query Required 3 Years
Assist power users of the data warehouse in the design and development of complex queries spanning multiple tables and databases Required 5 Years
Design and development of data cubes Required 5 Years
Query Analyzer for direct query Required 3 Years
Analytics (SPSS and other statistical tools), structured reporting (e.g. trends, metrics) and ad-hoc reporting solutions. Required 5 Years
Experience using SSRS to create reports
Regards,
Lisa Dutt
Technical Recruiter
Desk No : 609-935-3773 Ext 102
Princeton Forrestal Village
116 Village Blvd, Suite 200
Princeton - New Jersey 08540
Lisa.dutt@itbtalent.com | lisa.dutt13@gmail.com
www.itbrainiac.com
If you prefer not to receive emails from us, simply reply to this e-mail with the word "REMOVE" in the subject line.
You received this message because you are subscribed to the Google Groups "Jobs for USA consultants (Citizen G.C and H1B)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobs-for-usa-consultants-citizen-gc-and-h1b+unsubscribe@googlegroups.com.
To post to this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b@googlegroups.com.
Visit this group at http://groups.google.com/group/jobs-for-usa-consultants-citizen-gc-and-h1b.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment