Please send resumes to [EMAIL PROTECTED]
Position: Erwin Data Modeler Location: Columbus, OH Duration: 6+ Months One of our clients needs 3 Data Modelers with Erwin and retail background Responsibilities: a.. Business requirements analysis and derive good understanding of data needs to satisfy the business reporting and analytical needs b.. Performance Gap analysis for the new data needs against existing data warehouse data model and Identify data model enhancement/impact Analysis for captured requirements; c.. Perform source data analysis and profiling to understand source data and determine the system of record based on business requirements and EDW data analysis d.. 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 e.. 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 f.. Understand reporting and ad hoc analytical usage of the new data model and propose physical database design recommendations g.. Produce physical data model and proper indexing that promote fast data retrieval based on BI usage. h.. Produce DDL and DML for implementing physical data structures i.. Perform source to target data mapping with accurate transformation rules and business logic to transform source data element into EDW target data element. j.. Responsible for review and manage modeling deliverables based on data specification; k.. Responsible for managing and reporting status on modeling deliverables l.. Follow, Maintain and enhance enterprise data model development standards m.. Understand overall EDW subject areas overview and review of all modeling objects Data Modeling Deliverables: a.. Requirements to Data Model Mapping (Metrics to data elements level) b.. ER Diagrams in Erwin modeling tool c.. Data Entity and Attribute Definitions documented in Erwin. d.. Data owner, data CRUD (Create, Read, Update, Delete) process, Cross Subject Area integration in Data Modeling Functional Specifications e.. Summary Data Requirements Analysis and Modeling in Erwin f.. Views (One-to-One and Special Views) modeling in Erwin and Physical instantiation in Data Bases g.. Physical DDL generation from ERWin model to EDW databases (including base tables, views and aggregation tables Thanks and Regards, Nick Carter - Data Group Inc. Direct: 732-734-5350 Main: 1-732-791-2348 Extn: 255 Fax: 732-907-1174 / 732-960-2339 Email: [EMAIL PROTECTED] Certified Minority Women Owned Business Enterprise (MWBE) & Small Business Enterprise (SBE) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "IT provider" 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.co.in/group/IT-provider?hl=en -~----------~----~----~----~------~----~------~--~---
