Reputed US IT Staffing Company based in USA, RICEFW Technologies. 

Position Details:

Job Title: Data Modeler

Location: Washington, DC - USA

Duration: 1 Year Initial

Mode of Interview: F2F Preferred, Skype Considered

Client: International Financial Organization Industry

Responsibilities:

• Conduct/attend requirements definition meetings with end users and document system/business requirements
• Develop an in-depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
• Enhance (or create – if new system) system logical data model to meet requirements, applying the Data Modeling Standards and the logical Data Naming Conventions. Apply the same enhancements in the physical data model, using the Data Modeling Standards and the physical Data Naming Conventions appropriate for the specific back-end database
• Select the appropriate data types and sizes for the new fields added to the system data model
• Document definitions for all new data model constructs
• Document the data model enhancements in a standard document.
• If the project involves the creation an interface between two systems, the data modeler would create a mapping matrix describing the correlation between the data elements in the two system data models
• Develop data mappings for reports, to correlate data elements on reports to tables/fields in the underlying physical data model
• Perform analysis of system data to identify patterns, exceptions and erroneous data
• Create high-level process models (activity hierarchy diagrams, data flow diagrams, workflow diagrams, system interface diagrams) to represent business processes for the area under analysis
• Contribute to the development of a body of generally applicable methods, procedures and deliverables for the data modeling/business analysis function

Requirements:

• 6 years of business analysis experience.
• 4 years of hands-on data modeling expertise for relational databases – both for logical and physical data models – including detailed knowledge of normalization techniques, forward-engineering and reverse-engineering techniques.
• Experience in modeling large-scale (100+ entities) relational data models
• Experience with ERWIN (3.5 and 4.1) – min. 3 years
• Thorough understanding of normalization techniques.
• Familiarity with Oracle 8.x/9.x. database constructs and PL/SQL..
• Familiarity with various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams).
• Excellent communication and facilitation skills.
• Excellent writing/documentation skills.
• Ability to juggle multiple tasks in a fast-paced environment.

All your information will be kept confidential according to EEO guidelines.