*Hi Partners,*
* *
*Please go through the whole requirement:*
* *
*Position: Data Warehouse Analyst with
Teradata<javascript:viewConComp('company',197)>
*
*Duration: 6 Months *
*Location: Des Moines, IA *
*Rate: Open *
*
*
*Position Summary:*
Responsible for *designing and developing data warehouse* solutions. Design,
develop and support Teradata physical databases; Support the appropriate SQL
engines; Develop and support the Logical Data Model extensions. Requires
knowledge of data warehouse implementation process from business
requirements through logical modeling, physical database design, data
sourcing and data transformation, data loading, SQL, end-user tools and SQL
performance tuning. Requires knowledge of relational database technology
(DB2, Teradata, Oracle, Informix) in an application development environment
and a working knowledge of third-party GUI tools (Business Objects, Visual
Basic, Powerbuilder, GQL, MicroStrategy, Cognos, Information Advantage).
Familiarity with state-of-the-art data warehousing technologies including
OLAP end-user tools and data mining. Basic knowledge of operating
environments (Windows NT, UNIX). Requires technical degree in computer
science with a database concentration or related discipline, and 5 to 7
years related experience. Specialty assignments include Data
Modeling/Mining, Data Transformation, Information Discovery, etc.
*Additional Job Description*:
*Cognos* *Report Developer* that will be local in the *Des Moines**, Iowa*.
The Iowa Department of Education requires a capable and experienced person
to develop reports using the *Cognos tool set* for its *data warehouse* of
education data.
The position requires performing functional and *data analysis on report
requirements*, recommending solutions for development, and developing
reporting objects *using Cognos 8*.
The developer will be involved in the entire *project life cycle *from
*evaluation,
development and installation* of *end user reports and cubes*.
This includes working with *IT staff and end users* on requirements and
reporting issues and assisting end users in *troubleshooting problems.*
*Creating documentation*, including *data dictionary* and *metadata*, will
be required along with providing end user training and support.
The project involves use of *prompts, drill-through, master-detail query
relationships*, conditional formatting, grouping and sorting features
of *Report
Studio* to generate efficient and user-friendly reports.
*Creation of complex reports* using *Report Studio* and performing *ad-hoc
queries using* *Query Studio* will be necessary.
Experience in *optimizing report* and *cube performance* is required.
Experience in *Cognos 8 development* (*Query Studio, Report Studio, Analysis
Studio, etc*.) and *Microsoft SQL Server 2005* is essential.
Training and knowledge in the *Cognos Software Development Kit (SDK)* is
highly desirable.
Experience in report *security administration* and *data security* would be
helpful.
Skill in *writing moderate to complex Structured Query Language (SQL)
queries* and stored procedures is necessary, as is the ability to understand
and interpret business requirements and to translate into concise rules for
developing reports.
The ability to work with end users of various levels of technical
sophistication, to communicate in a polite, courteous, and cooperative
manner, and to create effective end user documentation is necessary.
Knowledge of and experience working with *education data is necessary*.
Experience in *development of Cognos* *reports* for the following areas must
be identified explicitly:
o *Iowa** student* assessment *data including individual, group, and trend *
o School district equity
o Annual progress report including *school report card for the public*
o Curriculum and *course data*
o *Special education*
o Student indicators including graduation, drop out, discipline, and
attendance
o Program indicators including at risk and talented/gifted data.
B. Requisite Knowledge The individual selected will be expected to interact
with customers in a professional manner, to understand the business
requirements of the customer and to prepare clear concise statements of
reporting requirements for the data warehouse.
The individual will be *expected to develop and support reports* that
satisfy customer requirements.
*The individual selected must meet these requirements: *
a) Meet qualifications of *Information Technology Specialist 4 per State
guidelines*.
b) Possess experience in *developing Cognos reports for Iowa student
assessment data*.
c) Possess experience in using the *eScholar Complete Data Warehouse and
Framework to develop Cognos* reports.
d) Experienced in interacting with customers regarding application
requirements.
e) Strong business writing and interpersonal skills necessary for customer
contact.
f) Proficient in development of *reporting objects using Cognos 8, including
* *Query Studio, Report Studio, Access Manager, Scheduler*, and *Cognos* *
Software* *Development Kit (SDK).*
g) Proficient in using *MS SQL 2005* and in writing *relational database
queries using SQL*.
h) Knowledge of *Active Server Pages (ASP), ASP.NET, VB.NET, and VBScript
helpful*.
i) Experienced in development of structured *test plans/test scripts* for
use in executing unit and system testing.
j) Capable to complete programming assignments in a timely manner.
k) Available for work at the Iowa Department of Education, Grimes State
Office Building, Des Moines upon acceptance of the Service
--
Neo
Technical Recruiter
3 L’Amour CT, Dayton,New Jersey – 08810 | P: 201-204-3883 | F: 201-603-1326
| Web: www.augustuss.com
Yahoo IM: neo.recruit...@yahoo.com | n...@augustuss.net
--
You received this message because you are subscribed to the Google Groups "Open
Source Erp & Crm" group.
To post to this group, send email to open-source-erp-...@googlegroups.com.
To unsubscribe from this group, send email to
open-source-erp-crm+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/open-source-erp-crm?hl=en.
