Summary
I recently went through a technical interview round for a Data Engineer 1 role at G2, which involved Python and SQL challenges after clearing an aptitude test. I was given a Python problem to design a movie booking system and a SQL query to find the most popular show date for a specific movie.
Full Experience
I recently had an interview after successfully clearing an aptitude test which had 40 questions in 15 minutes. Following that, I received a call from HR for the first technical round, which focused on Python and SQL and lasted 30 minutes. During this round, I was presented with two distinct problems: one involved designing a movie booking system in Python, and the other required a SQL query to identify the busiest show date for a specific movie ID.
Interview Questions (2)
A theater has 200 seats.
- Single booking → assign a random seat from available ones.
- Group booking → pick a random starting seat, then allocate following seats in serial order.
- Example: If user books 3 seats, and seat 67 is randomly picked, then next seats could be 69, 71 (skipping already booked ones like 68 and 70).
I had to come up with an algorithm in Python for this.
Find the date when most people watched Movie ID = 123
Table Schema:
Booking(
Booking_id INT,
Booking_date DATETIME,
Show_date DATETIME,
Movie_id INT,
Seat_number INT
);