US - IT - Data Modeler III

Procom Services; Mount Laurel Township (NJ); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading company in financial services is seeking a Data Modeler III to design and implement data structures for data warehousing and marts. The ideal candidate will bring over six years of experience in ANSI SQL, OLTP, and data modeling, specifically utilizing ERWIN and Oracle. This is a contract position with the potential for an extension, requiring both technical skills and effective communication abilities.

Qualifications

• 6+ years of experience in ANSI SQL, Data Warehousing, and Dimensional Modeling is essential.
• Experience with ERWIN and Oracle database design is critical.
• Understanding of data administration and OLTP concepts needed.

Responsibilities

• Design and model data structures for warehouses and marts.
• Create dictionaries and data mappings based on project needs.
• Collaborate with stakeholders to support data modeling efforts.

Skills

ANSI SQL

Data Warehousing

Dimensional Modeling

Oracle

ERWIN

MS Office

OLTP

Data Administration

Data Marts

Tools

ERWIN

Power Designer

Oracle

Job description

TD Bank is a member of TD Bank Group and a subsidiary of The Toronto-Dominion Bank of Toronto, Canada, a top 10 financial services company in North America. The Toronto-Dominion Bank trades on the New York and Toronto stock exchanges under the ticker symbol "TD". For more information visit www.td.com

Job Description

1 Position - Data Modeler III ANSI SQL/W2 basis + Benefit coverage| ASAP

6 Month Contract (possible extension up to 2 yrs.)
Location: On site - Mount Laurel NJ
Interview: 1 Phone and 1 in person with hiring manager

This data modeler position requires strong ANSI SQL skills (preferably experience with Oracle), working dimensional data modeling experience and strong language and written skills to support creation of dictionaries, data mappings, and detailed design documentation. Dimensional data modeling experience is a must for this position; candidates without this experience should not apply.

Qualifications

MUST HAVE:
ERWIN * 6 yrs
ANSI SQL * 6 yrs
OLTP * 6 yrs
Oracle * 6 yrs
RUP * 6 yrs
MS Office * 6 yrs
SQL * 6 yrs
Dimensional Modeling experience * 6 yrs
Data Warehousing * 6 yrs
Data Marts * 6 yrs
Data Administration * 6 yrs


NICE TO HAVE:
Power Designer
Financial/Banking industry experience
Teradata FSLDM
Logical Data Models

SKILLS:
Experience in designing physical models for data warehouses and data marts.
Expertise in dimensional modeling; working knowledge of the Teradata or IBM Financial Services
Logical Data Models is a plus.
Experience in Oracle database design including the ability to perform impact analysis of data structure changes. Expertise in ERWIN, OLTP, SQL, RUP, Oracle and MS Office Tools is required;
Power Designer experience is also helpful but not required.
Strong ANSI SQL skills are required for this position.

Additional Information

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