Interview was mostly based on SQL knowledge and few were on handling the big data. How would you join the tables given few scenarios. Basically two Technical rounds. Need minimum knowledge on big data technology

The first round was done through Karat, which is a third party platform offers interview service. The first couple minutes asked simple python commands and what are the output, then followed by a easy-medium leetcode style question. Once the first question was finished, the interviewer posted another question which involves more complex algorithm of shortest path.