g2 logo
G2· data engineer 1

G2- Data Engineer 1

Result
Ongoing
Posted
10 Sept 2025
331 reads

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.

How it went

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.

Questions asked (2)

  1. 01

    Movie Booking System

    Data Structures & Algorithms

    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.

  2. 02

    Find Date with Most Viewers for Movie

    Data Structures & Algorithms

    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
    );
    

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at G2 recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!