Meta Data Engineer interview questions

Prescreening round involved a phone call with 10 simple SQL and 10 simple algorithm questions (one word answers) Screening round tested SQL and Python skills. The criteria was to solve medium to hard SQL questions (at least 3) and easy Python questions (at least 3). I got stuck on my third SQL question. The interviewer was polite and helpful.

Start with 1 round recruiter phone screen, then 1 round technical screen, the last one is a 4 round full loop on site interview including 3 technical interviews and 1 behavioral interview