Teradata Database Developer, NJ at Parsippany

Job Description

A minimum of 5 - 7 years of in-depth Teradata development experience.

2+ years of experience with TPT .

4 to 5 years of experience with writing Teradata Stored Procedures .

3 years of SQL Programming Experience in Teradata.

Expertise in Teradata SQL & Teradata Utilities like Multiload, Fastexport, BTEQ, Fastload, Teradata Parallel Transporter, TPump, VIEWPOINT, DATAMOVER.

Previous work experience in large database environments like Aster, Aprimo, IBM DB2 etc.

Good experiance with Teradata Performance tuning including collecting Stats, PI, PPI, Join Indexes, Secondary Indexes , analyzing explain plans.

In-depth knowledge in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.

Data modeling skills in Teradata is a plus.

Experiance with Teradata Administrator and Teradata Manager Tools for monitoring and control the system is a plus.

Loading data from various data sources and legacy systems into Teradata warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.

Strong DDL and DML writing skills are essential as well as being able to write complex SQLs for data analysis.

Expert level Teradata data warehouse implementation experience .

Certification in Teradata and Teradata SQL is a plus.

Experaince in working with DB2 , oracle, Sql Server is preferred.

Expert level Data Warehouse architecture experience utilizing commonly accepted ETL and BI tools such as Informatica, Microstrategy etc is a plus.

Competency with UNIX/Linux environments.

Competency with Enterprise tools commonly used in an EDW environment such as TIBCO, Goldengate, etc. is a plus.

Randstad Technologies is an EOE-M/F/V/D and is a wholly owned subsidiary of Randstad Holding nv, a $20.0 billion global provider of HR services and the second largest staffing organization in the world.

Job Requirements

 
Country: USA, State: New Jersey, City: Parsippany, Company: Randstad Technologies.