Both interviewers were super kind, had great presence and introduced me to everything I needed to know about the position. I am very glad with the interview. (Some extra words I apparently need to add in order to make this information "valuable")
Interview questions [1]
Question 1
Normalization and denormalization, nulls and repeated values check, union and union all, rownumber and other similar functions
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.