Interview questions
Write a Java program using FileInputStream and BufferedReader to read data from a local file and print the output to the console
Zigzag Order Traversal of a Binary Tree
Design a Custom API that can query a backend server and return customer data such as the number of orders placed by a user based on their user ID
Design the data model for an ETL pipeline that ingests data from a database and loads it into Snowflake
Explain normalization in databases and its importance. Write an SQL query to handle SCD-1 or SCD-3
How soon could you join Meesho if you are selected?
How would you clean the data by filtering out records with null values in user_id?
Managed vs Unmanaged Tables
SQL Query to Find Average Sessions per User within 30-day period
What is the difference between Data Lakehouse, Delta Lake, and a Data Warehouse?
After cleaning, how would you store the transformed data into Delta Lake?
Compare Kafka Streams and Spark Structured Streaming for real-time processing
Databricks Cluster Management - standalone vs YARN mode
Design an ETL pipeline using Kafka and Spark Streaming
Explain how spark.read.format("delta").load() works
Explain the architecture and role of the Hive Metastore in a data pipeline
Explain the architecture of Kafka
Explain the architecture of Spark Streaming
Handling Skewness in Data - salting, broadcast join
Have you worked with data compaction in Delta Lake?
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.