Client - MoneyGram
Location - MN 55416
12 month Project
DW data modeler
Job Description: Data Analyst/Data Modeler on application development
projects in a data warehousing environment.
Client wants to see resumes with the followin:
1. Data modeling tools candidate has worked with at each project
(*PowerDesigner/ERWIN
is required)* 2. Detailed description of candidates role in the project 3.
Detailed description of the data model candidate was working on, including
the relationships among the major entities that were in that model
Required Skills
Minimum of 6+ years total IT experience
4+ years experience as a *Data Analyst / Modeler
implementing Data Warehousing/Business Intelligence solutions*
Excellent understanding of relational database concepts,
normalization and de-normalization, and dimensional modeling concepts
Experience with modeling tools like *PowerDesigner/ERWIN*
In-depth knowledge of at least one *RDBMS (preferably
Oracle) including strong SQL knowledge*
Experience with *SQL, PL/SQL, Toad, PLSQL Developer* or
other common data analysis, exploration, migration, and reporting tools
Experience in analyzing and documenting data mapping and
transformation rules
Strong analysis and problem solving skills
Strong written and oral communication skills
Experience writing complex views / materialized views, SQL
queries and triggers
Responsibilities and Duties:
Understand and translate business requirements into data
models
Work with the Application Development team to implement
data strategies and build data flows
Create or update conceptual, logical and physical data
models using best practices and according to company standards
Recommend opportunities for reuse of data models where
appropriate
Generate DDL scripts and implement them in the database
Perform reverse engineering of physical data models from
databases and SQL scripts
Champions and protects data from definition through
interpretation
Evaluate data models and physical databases for variances
and discrepancies
Understanding of ETL process and moving of data from source
to target
Understanding of different change data capture approaches
and implementation
Perform data model reviews with Data Modeling counterparts
and BI team members
Kind Regards
*Fazal Mahmood*
*Aspire Systems Inc.*
*Certified Minority Owned Business Enterprise (MBE) *
*E-Verified Approved Employer*
*Four Time Award Winner ( 2009 & 2010 & 2011 & 2012) Best of Danbury Award*
*Approved Inc. 500 Company*
*Corp Office: *
*36 Mill Plain Road, **Suite # 16, Danbury, CT 06811*
*Ph : 732 414 2854*
*Fax : 203 798 0060*
*Email: **[email protected] <[email protected]>*
*Yahoo IM*:* fazalmrecruiter*
*URL: **www.aspiresystem.com
<http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://www.aspiresystem.com>*
------------------------------
No virus found in this message.
--
You received this message because you are subscribed to the Google Groups
"java-core" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send an email to [email protected].
Visit this group at http://groups.google.com/group/java-core.
For more options, visit https://groups.google.com/d/optout.
