Req; Need Data Modeler/Develoeper @ MD

Hi,

Hope you are doing good,

Please find the requirement below and let me know the feedback with updated profile.

 

Title: Physical Data Modeler/Developer

Location:  Must be local or willing to work locally in Baltimore, MD

Duration: 1 year+

Citizenship Requirement: US Citizen, green card holder, or H1B with at least 5 years working in the United States

 

Description:

The Physical Data Modeler/Developer is responsible for the design and instantiation of the physical data model based on the logical data model. This includes creating the base tables, associative tables, views, the semantic layer, and choosing and creating all indexes.  He/she will work in a team of 3 – 4 data modelers.

 

Skills/Experience Required:

• Have a minimum of 5 years development experience on Teradata.
• Have minimum of  2 years experience in ERwin.
• Have created physical data model with a data modeling tool like ERwin, PowerDesigner, etc.  Require strong ERWin experience over other modeling tools.
• Have strong experience in defining logical and physical models in ERwin, using naming standards, defining relationships, subject areas, forward engineering and reverse engineering scripts, applying Teradata functionalities such as compression, statistics, PPI through ERwin data model.
• Experience in ERwin API, Visual Basic Code Editor, Erwin 9.x and future releases and Erwin Model Manager is a plus.
• Have modified physical data model for efficient data access paths.
• Have generated and executed DDL to create databases, tables, views, and the semantic layer.
• Have identified and created primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes.
• Have identified statistics columns, and created and executed collect statistics statements.
• Have identified, defined, and created necessary associative tables, data constraints, and compression mechanisms.
• Have established standards, guidelines, and procedures for design and maintenance.
• Must have good communication skills.
• Must work well in a team environment.
• Must have experience interacting with end users, other developers, and/or other teams as part of the development process.
• Prefer healthcare or insurance industry related experience.
• Willing and can pass government security background/credit check.

 

Duration: for a good physical data modeler, must know Erwin, would like them to be familiar with the TD Industry models if possible – this is for healthcare.

Thanks, 

Vicky,

United IT Solutions Inc,

1212 Corporate Dr, Suite # 567, Irving, TX – 75038,

Direct: 9722959121, Work: 972-999-1449 Ext 100

Fax: 503-334-3640, Email: vicky@uniteditinc.com,                 

GTalk: vickyprofession,

Website: http://www.uniteditinc.com,

 

We respect your online privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with: “REMOVE" in the subject line and Include complete address and/or domain/aliases to be removed from our mailing list. We are sorry for the inconvenience caused to you.