Meta Data Engineer interview questions

Started off with brief introduction and questions. 3 Python and 3 SQL questions were asked, timed for 30 minutes each. Difficulty level was Medium. You are expected to interact and as questions as you solve. Solved 5 out of 6 problems, but did not get selected

Phone interview: 30min SQL and 30min Coding. Basic question on the aggregation and the algorithm. Find max min avg of the order by date, customer, product, state. Coding was easy pretty much what people already posted here.