Meta Data Engineer I interview questions

I was contacted by a recruiter and he scheduled a 30 minute phone discussion which explained the interview process and towards the end he asked 4 questions from SQL and 4 from python . And then he sent a bunch of study materials which mostly had links to some online courses. Also he gave me time to study and practice and then suggest a date for the next coding interview. All those links are very helpful , so dont neglect anything. Also I practiced SQL and python coding in hackerrank, leetcode and interview cake. After 1 month I had my coding interview(Coderpad and talk over the phone) . It was 25 minutes SQL and 25 minutes python. I am a SQL person but I struggled a bit at the end. I answered 4 out of 5 SQL questions. looks like, based on our ability they move on to harder levels which is a good sign. And then on python I was able to complete only 2 out of 3. We need to pass all corner test cases as well for which my interviewer helped me with hints. It was overall a bit tough interview with the stringent timeline. However I got the email from my recruiter after 4 hours saying that I have been selected for Onsite interview. Again I had a 45 minute call with the recruiter and he gave a bunch of study materials. I went through all those and scheduled my onsite interview after a month. As others mentioned it was end to end test cases and it was interesting and challenging. It was mostly SQL and then a little data modeling, visualization and python coding (just 1 pgm). They give a scenario or issue and ask us to brain storm the issue and figure out the root cause which should match their expectation. once it matches they will write a transaction table data (like a log file data) and then ask us to write a bunch of SQL queries. Behavioral interview was around 12 questions. all related to how you handle situations at work. lunch interview was just a chat. be prepared to ask a few questions during that. Overall, I did well. However after 3 days my recruiter called me and told that I was not selected because they expected more perfection in SQL whereas my product knowledge and data modeling was good. Just one thing. Don't panic about 5 hour interview. Time just flies once you are inside your interview room. Also food was good and people were nice. It was a very good experience. I have been given an option to try in 6 months. Maybe I will take that opportunity. Advise to others - Practice SQL for onsite interview. Avoid sub queries and try to do it in single query wherever possible.