Teradata Developer

1connecttech; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider in the United States is seeking a candidate with strong Teradata SQL skills, including performance tuning of complex queries and handling of various data types like Geospatial, XML, and JSON. Familiarity with Teradata utilities and Vantage analytical features is crucial. This role demands expertise in both Unix and Mainframe environments for executing utilities. Applicants should demonstrate a comprehensive understanding of Advanced Teradata SQL and its various utilities.

Skills

Basic and Advanced Teradata SQL

Teradata BTEQ

Teradata MLOAD

Teradata FASTLOAD

Teradata FASTEXPORT

Teradata TPUMP

Complex Query Performance Tuning

Geospatial Data Types

XML Handling

JSON Handling

Array Handling

Teradata Parallel Transporter

Teradata Vantage Features

Job description

• Strong knowledge of Basic and Advance Teradata SQL including all Indexes (Primary, Secondary, Partition and Join Index).
• Strong knowledge of Teradata utilities BTEQ, MLOAD, FASTLOAD, FASTEXPORT and TPUMP.
• Strong knowledge of Teradata Parallel Transporter.
• Performance tuning of complex queries.
• Secondary skills for Teradata
• Teradata Vantage analytical features such as npath and SentimentExtracter.
• Handling complex data types like Geospatial Data Types, XML, JSON and Array.
• Executing Teradata utilities script with both Unix and Mainframe based environments.