*Please send me only the matching resumes!!*
*Location - MN*
*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 following:*
*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
Thanks & Regards
Mohd Fahad |
* ReasonSourceTech. ______________________________*
*| E: [email protected] <[email protected]> **| Url :**
www.reasonsourcetech.com <http://www.satincorp.com/>*
--
You received this message because you are subscribed to the Google Groups
"Oracle Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/oracle-users.
For more options, visit https://groups.google.com/d/optout.