Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
This job has expired.
 
Job Information
Job title

Teradata Data Modeler / Performance Specialist

Company TES - Information Technology
Wage Not specified
Location United States, North Carolina, Raleigh
Employment type Contract to Perm
Education Not Specified
Year Experience 4 - 5 Years of Practical Experience
Travel None
Published on 9/16/2004
Description
Job Description
Support for both logical and physical design work associated with a large corporate data warehouse.
Fine-tune existing ETL code and tables/views for performance improvements and decrease resource utilization.

Analyze source system data structures and map them to target data warehouse schemas. Must have excellent skills in requirements analysis, data assessment, business process reengineering, and familiarity with data warehousing design concepts such as 3rd Normal Form and Dimensional modeling.

Expertise and experience in:
NCR Teradata, Strong ETL efforts,
SQL (Teradata required), UNIX,
Teradata Application Utilities
Building efficient views
Working with aggregates
Job Control scripting (Unix shell scripting required)

Support the design and development of software that enables data to be moved from legacy (heritage) systems and external data sources into a staging area for the transformation effort to final data load into the data warehouse.

Move data from the source systems into a new format without compromising data integrity and to maintain all the business rules.

Bachelor's degree and 7 years of IT experience to include 2-3+ years of data warehousing specific experience. The Bachelor's degree must be a four-year degree in computer science, information systems, electrical engineering, business, operations research, math or related field.
Minimum of 3+ years strong NCR Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views.
Must be proficient at:
1) developing programs and procedures to receive data from the source
2) filter, integrate, transform, standardize and process the extracted data
3) cleanse and scrub the data to ensure data quality and integrity and populate the data warehouse
4)Unix shell scripting and/or MVS JCL

Must have excellent skills in requirements analysis, business process reengineering, data modeling, data warehousing design/development, and Teradata performance/tuning.

Certification in Teradata and Teradata SQL preferred

US Citizenship required and ability to obtain a Security Clearance


df-tc


Experience/Skills
Bachelor's degree; 7 years of IT experience to include 2-3+ years of data warehousing specific experience. Minimum of 3+ years strong NCR Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views.
Teradata certification preferred.

Other desired skills:
Bachelor's degree; 7 years of IT experience to include 2-3+ years of data warehousing specific experience. Minimum of 3+ years strong NCR Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities, Aggregates and building efficient views.
Ter

This job has expired.