First round with 3 interviewers: they asked about behaviour question, simple SQL queries, and translate the sql to pyspark. Second round with 3 interviewers as well: behaviour questions and medium sql questions.
Interview questions [1]
Question 1
how to find the second highest salary given the table structure
I applied online. I interviewed at Scotiabank (Toronto, ON) in Feb 2022
Interview
Not professional. they should vet candidates before sending out interviews. if the candidate is not suitable, don't do the interview instead of demeaning the candidate. Not a good experience overall.
easy process, 45 min interview process sql queries, basic java questions, databases, data warehousing hat is data modeling? ... Explain the difference between structured data and unstructured data. ... What are the design schemas of data modeling? ... What are big data's four Vs? .