2 back-to-back rounds focusing on Data Engineering fundamentals about Star Schema, Snowflake schema, Data warehouses, Datalakes, Dimensional modelling, OTLP vs OLAP, behavioral aspects, and very light coding (SQL was simple join and take count based on product, Python - Sort an array without using Sort function)

First round was OA with SQL questions, mcqs and 1 DSA then 2 Technical interviews SQL questions like joins, group by, NULL values, SQL theory, easy to medium leetcode, questions on resume