JD:
- Knowledge of complete Teradata Architecture.
- 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.