Teradata Associate Technical Consultant interview questions

It was a 3 Round Interview 1) Technical round for 2 hours-over the phone 2) Managerial round for 1 hour- personal interview 3) HR- personal interview Technical round was a bit challenging. Managerial and HR round were relatively simple

First round is Phone Interview. Basic teradata and SQL questions were asked. Second round is face-to-face. Went upto 1 hour. Asked about joins, teradata architecture, star and snowflake schema, primary and secondary indexes, ETL process.