Hi, Here is HOT *Data Modeler **requirement * for your consultants at *Southlake, TX*
*Title:** Data Modeler * *Location: Southlake, TX* *Interview : Telephonic + F2F* *Duration: 12 Months * *Interview: Telephonic +Skype* *Job Description:* *Experience, Skills and Knowledge: * · *8+ years proven data or integration architecture experience* · 10+ years overall IT experience · Must have 5+ years of experience in database technologies, data design and performance optimization for large OLAP, Columnar DBs & Data Warehouse solutions. · Must have very sound understanding of data access technologies, frameworks and patterns. · Expert in relational and dimensional structures for large (multi-terabyte) operational, analytical, warehouse and BI systems · Skilled in data profiling, business domain modeling, logical data modeling, physical relational data modeling and design · Strong skills in Entity Relationship Modeling (Erwin modeling software preferred) · Proven expertise in data analysis and facilitation; i.e. able to produce data designs using a variety of inputs such as requirements analysis, SME interviews, business process, data flow analysis, data profiling, etc. · Excellent written and verbal communication skills with strong relationship building skills · Ability to work in a large, complex business and technical environment · Experience with enterprise integration patterns, master data management, schema development, ETL architecture and ETL tools is desirable · Experience with Insurance and/or Claims Data preferable · Experience with Erwin or similar data modeling tool · Strong SQL expertise is a must *Essential Duties and Responsibilities: * · Organize working sessions with business/dev teams to understand sources of data and expected output. · Determine database structural requirements by analyzing operations, applications, review objectives with stake holders and evaluate current systems · Develop database solutions by designing proposed system, defining database physical structure and functional capabilities and data security requirements. · Develop flowcharts and documentation · Apply optimum access techniques · Coordinate DDL and DML actions · Maintain database performance by identifying and resolving production and application development problems along with data integration · Install new releases, complete maintenance; answer any user questions. · Prepare users by conducting training. · Accomplish information systems and organization mission by completing related results as needed. · Lead the data migration team to capture the current state of source databases, define the architect for target state and design the target data model · Lead the integration efforts with other work streams to realize the common goal of designing the target state architecture · Develops and validates data modeling solution · Responsible for analyzing and designing the process to capture the data lineage from source to target · Advise the implementation teams on the interpretation of proposed and final rules and rule requirements · Understand and drive resolution of complex issues · Define standards for naming, describing, governing, managing, modeling, cleansing, and enriching · Collaborate directly the with Data Warehouse Enterprise Architect to build conformed models across multiple Data Warehouses *Regards* *Vivek Nagare* *IDC Technologies Inc.* *Direct: **408-909-9498 EXT-691 * *Skype: vivek.nagare1* *Email: vivek.na...@idctechnologies.com <jai...@idctechnologies.com>* *Web: www.idctechnologies.com <http://www.idctechnologies.com/>* *US Office: IDC Technologies, Inc.,1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
