Strong knowledge of Basic and Advance Teradata SQL including all Indexes (Primary, Secondary, Partition and Join Index).
Desired Candidate Profile
- Data warehouse concept.
- Knowledge of complete Teradata Architecture.
- Strong knowledge of Teradata utilities BTEQ, MLOAD, FASTLOAD, FASTEXPORT and TPUMP.
- Strong knowledge of Teradata Parallel Transporter.
- Performance tuning of complex queries.
- 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.