A new Job, ID: 39351 <http://www.ejobsville.com/display-job/39351> was added at eJobsVille.com - For the Best Tech Jobs in Town<http://www.ejobsville.com>
Title: Data Modeler posted on 2013-09-23 12:59:16 Job Description:• Experience in database programming, data modeling and design and development of large database • Experience in Conceptual/Logical/Physical Data Modeling and Data Analysis skills • Experience in data mart and warehouse modeling. Knowledge of the pros and cons of Innmon and Kimball methodologies • Hands on experience developing fully normalized relational data models • Worked with an Entity/Relationship tool, such as ER Studio or ERwin • Solid understanding of database architecture, design, and performance tuning and strong SQL skills • Excellent verbal and written communication skills, client relation skills, and the ability to work effectively in a technical team environment • Understanding the Business Requirements of the project. • Work with Business SME to understand the project requirements • Define the Subject Areas involved in the business requirements • Build Conceptual Data Model • Work with Business SME to understand high level entities and relationship between entities for each subject areas. • Walkthrough of the Conceptual Data Model to Architect Team. • Capture Business Description, Meta data for conceptual entities • Get sign off of Conceptual Data Model • Build Logical Data Model • Transform Subject areas into Logical Data Structures • Work closely with business to identify and define the grain for each logical entity • Ensure all the attributes are identified, and nothing is missed, by close interaction with IT & Business leads • Capture all the attributes for each logical entity in Logical Data Model diagram • Walkthrough of the Logical Data Model to Architects. • Capture Business Description, Meta data for Logical entities & Attributes • Analyze Capacity Planning aspect. • Get sign off of Logical Data Model • Build Physical Data Model • Understand USAA best practices for standard naming conventions and coding practices to ensure consistency of data models. • Convert Logical Model to Physical Model • Delivery Capacity Planning, perform Sizing, predict data growth for next 2-3 years. • Define Data Purge, Storage Strategy, Collaborate with OPS team • Define best practices (Storage, indexes, partitioning etc ) for application optimization. • Walkthrough of the Physical Data Model to Architect Team. • Get sign off of physical Data Model • Delivery Meta Data to the Business Team and Enterprise repository • Maintain conceptual, logical and physical data models along with corresponding metadata • Suggest Data Modeling changes for the changes in requirements, new enhancements and system performance Job Requirements: SkillDB2 , SQL Server , Neteeza , Erwin, ERStudioLocationSan Antonio, TXTotal Experience8 yrs.Max Salary$ DOE Per Hour Employment TypeDirect Jobs (Full Time)DomainAny Click here to view full job description and apply<http://www.ejobsville.com/display-job/39351> (Guest users can also apply) ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "SAP ABAP" 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/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.
