Hello,


Hope you’re doing great.

Please find the below requirement. Thanks.!!!




*Job title: 386695: SQL DBA Location: Des Moines, IA*

*Duration: 1 year*
*In Person Interview required.*



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.



*Required / Desired Skills*

Skill

Required / Desired

Amount

of Experience

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

Required

5

Years



Acha Ayyappa

Integrated Technology Services Inc.,



Direct: 703-246-1342 || Email: a...@its-incorp.com || Gmail:
spkayya...@gmail.com

-------------------------------------------------------------------------------------------------

2201 Cooperative Way, Suite 600,  Herndon VA 20171 || www.its-incorp.com



-------------------------------------------------------------------------------------------------

-- 
You received this message because you are subscribed to the Google Groups 
"Business_Intelligence" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to business_intelligence+unsubscr...@googlegroups.com.
To post to this group, send email to business_intelligence@googlegroups.com.
Visit this group at http://groups.google.com/group/business_intelligence.
For more options, visit https://groups.google.com/d/optout.

Reply via email to