************** Urgent Requirement ********************* Need 3 Data Architects/ Data Modelers *heavy Retail Applications* background
Location: Columbus Duration: 3+ months *Skill Requirements: -Has extensive knowledge of retail business domain,* -Experienced and strong relational and dimensional data modeling skills -Business requirements analysis skills *-Erwin Data Modeling Tool expertise.* -Understanding of current and emerging technologies and conceptual and analytic skills. Title: Data Architect/ Data Modeler *Responsibilities * -Business requirements analysis and derive good understanding of data needs to satisfy the business reporting and analytical needs -Performance Gap analysis for the new data needs against existing data warehouse data model and Identify data model enhancement / impact Analysis for captured requirements; -Perform source data analysis and profiling to understand source data and determine the system of record based on business requirements and EDW data analysis -Working with technology teams who are supporting source systems to understand source data constraints and delta logic as well as extract logic to meet the business requirements -Design logical data model for desired functionality based on business reporting and analytical requirements, integrate the new data with existing EDW data model. And Documenting Data Owner and Data Definition in Erwin ; -Understand reporting and ad hoc analytical usage of the new data model and propose physical database design recommendations -Produce physical data model and proper indexing that promote fast data retrieval based on BI usage. -Produce DDL and DML for implementing physical data structures -Perform source to target data mapping with accurate transformation rules and business logic to transform source data element into EDW target data element. -Responsible for review and manage modeling deliverables based on data specification; -Responsible for managing and reporting status on modeling deliverables -Follow, Maintain and enhance enterprise data model development standards -Understand overall EDW subject areas overview and review of all modeling objects; Data Modeling Deliverables: -Requirements to Data Model Mapping (Metrics to data elements level) -ER Diagrams in Erwin modeling tool -Data Entity and Attribute Definitions documented in Erwin. -Data owner, data CRUD (Create, Read, Update, Delete) process, Cross Subject Area integration in Data Modeling Functional Specifications -Summary Data Requirements Analysis and Modeling in Erwin -Views (One-to-One and Special Views) modeling in Erwin and Physical instantiation in Data Bases -Physical DDL generation from ERWin model to EDW databases (including base tables, views and aggregation tables. Pl. send your consultant resume to [EMAIL PROTECTED] Thanks, Victor Headstream, Inc. 302 356 0156 [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AJAX-Tools" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/ajax-tools?hl=en -~----------~----~----~----~------~----~------~--~---
