I was asked about simple joins and for loops. There were no algorithm based questions. I had one phone conversation followed by an onsite. The phone conversation was all behavioral based. I found out about the offer a week after the onsite. I would be surprised if the interviews aren't different now.

What is the difference between left and inner joins.