US - IT - Data Modeler III

Reposted 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

CSC Logo CSC

Tax Research & QA Intern

Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Remote or Hybrid
4 Locations
8500 Employees

SailPoint Logo SailPoint

Customer Success Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
60K-101K Annually

SailPoint Logo SailPoint

Customer Success Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
60K-101K Annually

Wells Fargo Logo Wells Fargo

Reliability Engineer

Fintech • Financial Services
Hybrid
Iselin, NJ, USA
205000 Employees
119K-224K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 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