Datametica SQL Engineer interview questions

In first technical round questions like joins, indexing, difference between view and Materialized view, 2nd highest salary, delete duplicate, concatenate first name and last name etc. were asked. In second technical round roles and responsibilities of current project, other scenario based questions, what did you do for self learning, in aws do we use s3 or s3a etc; and basic of linux and python.