*NEED: Data Modeler ( MN, 6+months) * *Location: MINNEAPOLIS/MN Duration: 12+Months*
*Interview Mode: Telephonic Then Skype* *Job Description:* It is for a Risk and Compliance project, process impovements. No coding. and Teredata. Modeling tool used is ERWIN. This position will move the data to the data warehouse. *Quesitons to consider asking candidates*: Whats an active server? - should mean the same thing, data stewardship. *Data Quality* - tracking different data of capture, process improvements. *Must Haves* - Communication, articulate the concepts. Application - tech asset system. consolidate, create a consistent asset (hardware/software). servers, switches, end user computing (386,000 end users). 1- 2 years as programmer/analyst (not platform specific, UNIX preferred), and 6 + years of Data Analyst with 2-4 years as Physical Data Modeler - Coordinate with the Business Analysts, business Intelligence team, and end users to understand reporting requirements, translating them into Data Warehouse design; - Create necessary Functional Specification Documentation (i.e. source target mapping, data models, business rules, etc.) to support the business requirements; - Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating and analyzing data in current systems; - Develops data warehouse solutions by designing proposed system; Utilizing data warehouse design techniques; Defining database physical models and functional capabilities, follow EDA and Enterprise level standards, security procedures, back-up, and recovery specifications; - Work closely with the DBA team while defining and implementing physical database structures; - Facilitate design and architecture concept discussions with Development team to define ETL processes; - Implement database structure by developing process flow diagrams; applying optimum access techniques; coordinating installation actions; documents actions; ensure application and business partners data access adheres to Enterprise Security policy standards; - Maintains database performance by identifying and resolving production and application problems; evaluating, integrating, and installing new releases; updating models; completing maintenance; answering user questions; - Consult data warehouse and cube design and metadata layers; reviewing design against common methodologies and standard; - 7 - 10+ years experience with medium to expert Data Analysis and minimum 4 years Data Modeling; - Hands-on working experience with Power Designer or Erwin data modeling tools; - Preferred experience with high-end Data Bases like Teradata or Oracle; - Mid-to-high end SQL skills; - Excellent oral and written communications skills; - Excellent experience presenting Enterprise Data Warehouse design and modeling solutions to technical teams and business partners; - Solid understanding of Metadata concepts; including data mapping, business level metadata and technical metadata Regards, *Bittu Chauhan* *IDC Technologies, Inc.* | 1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035 Direct:408-459-0313 *Gtalk : bittu.ramy , Yahoo ID : bittu_ramy* -- You received this message because you are subscribed to the Google Groups "Oracle Developers" 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/oradev. For more options, visit https://groups.google.com/d/optout.
