Meta Data Engineer interview questions

First round was just a phone call and the recruiter was very nice and almost seemed like a foregone conclusion that you would make it to the next round. Second round was a live paired program coding exam with 6 problems, 3 python, 3 SQL.

Writing this review for initial technical screen. so it helps others. You should be good at reading questions fast and grasping what to write. SQL somebody posted in blind, mostly revolves around books, copies and authors etc. they are 4 to 5 schemas for me. Python too continues similar to SQL questions, for me it was Library related questions for both SQL and Python. SQL, get comfortable writing SQL by looking at schemas and without expected output not looking at data, because you won’t have time to look each table data. Questions mostly aggregations with joins. Specially Counts & percentages. Python leetcode won’t help much. Understand common data structures like they said list, tuple, sets, hashmaps and all functions with them. And may be practice stratrascratch python questions not leetcode. Because python questions too are like business usecase, lengthytakes time to read and get comfortable to write code