Meta Data Engineer I interview questions

First round: Short technical screen with recruiter. The recruiter is not a technology expert, they have 20 questions with 20 answers in front of them. These are usually simple questions like "What do you call a function that calls itself?" (Recursive function). The 20 questions from this round are split: 10 programming and 10 SQL. Very easy if you know the basics! The next round is a technical interview with an experienced Data Engineer on Coderpad. Here, speed is of the essence. They'll ask you to choose which questions you want to start with first (Programming or SQL) and immediately start off! Try to be quick, take into account all test cases and get all test cases to pass! (Easier said than done, I know, but that's what they're looking for!) I got 3 programming questions and 3 SQL questions in the 1 hour. I was able to solve all 3 programming questions and also all the 3 SQL questions. However, I got stuck for like 10 mins on one of the slightly tricky SQL questions involving a sub-query join. This was probably why I got chucked out! :( Also, the prep. material they give is VERY basic and not really helpful for the kinds of questions they ask. I'd say look through the prep material once because it's really simple stuff, but practice programming and SQL on a service like LeetCode or HackerRank.

HR interview takes about 15 - 20 minutes. Mainly focus on SQL and some basic coding questions. The question are TF questions or short answer questions. It is pretty easy, but some questions are tricky.