Round 0: Technical Assessment
Questions: This was a 60 min long online assessment round where the questions asked were of simple data structure and CS Fundamentals. Prepare database concepts and operating systems pretty well.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 1: First Interview: Data Structures + SQL
Questions:
- Easy Leetcode question (something like balanced parentheses).
- Medium Leetcode problem regarding graphs (standard problem).
- SQL query similar to this problem.
- Question on the difference between RANK() and DENSE_RANK().
- Discussion about projects and deployment process.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2: Data Warehousing Concepts + DBMS + SQL
Questions:
- Two to three SQL questions (not standard but similar to those present here.).
- Discussion on data warehousing concepts about OLTP, OLAP databases, and differences.
- Standard questions about snowflake vs star schema.
- Discussion on MapReduce based on previous internship experience.
- Imagined an online delivery system and discussed its analytics, including table structures, ETL pipeline setup, data size, and storage.
- Writing queries on newly created database tables.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Preparation Tips:
- Prepare SQL very well, try out all kinds of queries especially those involving window functions.
- Learn about Data Warehousing concepts, including ETL pipelines, OLAP vs OLTP.
- Practice database schema design and DBMS concepts.
- Data Structure questions are easier than SDE roles but still asked, so prepare them all.