Meta Data Engineer I interview questions

To master advanced SQL and Python for technical interviews beyond the standard Glassdoor level, focus on high-complexity problems that require multi-step logic, data cleaning, and algorithmic efficiency. Focus on logic building rather than number of questions while solving.

Initial Screening 3 SQL 3 Python SQL: Star schema, sales transaction fact, book author etc dims * Identify authors who have published at least 5 books * Calculate the percentage of total sales completed on the same day the customer registered * Find customers who purchased 3 or more books on both the first and last day of sales, excluding those with only one transaction * Find the IDs of the top 5 customers, ordered by average payment per book made by the people they invited * Find the total number of authors registered with the bookstore. What percentage of them have a website URL that contains ".com", and what percentage never made a sale? * What was the total value of sales and the number of unique paying customers, grouped and sorted in descending order by payment type? * Having a transaction table find the sum of total orders and the count of unique customers Python: * Calculate the average book price from a list of prices * The bookstore gathered a list of customer comments from each shop location and wants to find the most common comment across all locations (ignoring duplicates from the same location). If multiple comments appear the same number of times, return any one of them. * Search an element in an unsorted list * Given a list of workshops, return the largest number of classes that were hosted in total across any consecutive years that had at least one workshop each.