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