US - IT - Data Modeler III

Posted 2 Days Ago
Be an Early Applicant
Mount Laurel, NJ, USA
In-Office
Senior level
Agency • Information Technology • Professional Services • Consulting
The Role
Design and document dimensional data models and physical database designs for data warehouses and marts. Use ANSI SQL and Oracle to perform impact analysis, create data dictionaries and mappings, and support data administration. Produce detailed design documentation using ERWIN and related modeling tools.
Summary Generated by Built In
Company 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.

Skills Required

  • ERWIN (6 years)
  • ANSI SQL / SQL (6 years)
  • OLTP (6 years)
  • Oracle (6 years)
  • RUP (6 years)
  • MS Office (6 years)
  • Dimensional Modeling experience (6 years)
  • Data Warehousing (6 years)
  • Data Marts (6 years)
  • Data Administration (6 years)
  • Experience designing physical models for data warehouses and data marts
  • Impact analysis of data structure changes (Oracle database design)
  • Power Designer
  • Teradata FSLDM / Teradata
  • Logical Data Models
  • Financial/Banking industry experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
350 Employees

What We Do

Procom is a leading North American provider of IT staffing and contract workforce services. They specialize in connecting businesses with high-quality technical talent through contract staffing, direct hire, and IT consulting. Additionally, Procom provides comprehensive workforce solutions, such as Employer of Record (EOR) and Agent of Record (AOR) services, designed to help organizations manage their contingent workforces and support long-term digital transformation and growth.

Similar Jobs

Samsara Logo Samsara

Consultant

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
101K-136K Annually

Samsara Logo Samsara

Consultant

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
101K-136K Annually

Samsara Logo Samsara

Engagement Services Manager

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
101K-136K Annually

Toast Logo Toast

Central Jersey Shore District Manager, SMB

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Trenton, NJ, USA
5000 Employees
211K-338K Annually

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account