Bloomberg - Pune (India) | SSE | Interview R1 | Techincal Screening | 24th Dec 2025
Salesforce | MTS | Selected
LinkedIn SWE Infra Interview experience
Google L4 Interview Experience & Timeline
TCS Digital Interview Experience (TCS NQT Priority Hiring)
DE Shaw | SDE1 Lateral entry Interview round | code pair
Summary
I had a code pair round for a SDE 1 lateral hire position at DE Shaw. Surprisingly, no DSA questions were asked. The interview focused on OOP concepts, DBMS fundamentals, and involved writing SQL queries for two specific problems based on a provided schema.
Full Experience
I recently interviewed for a SDE 1 lateral hire position at DE Shaw, participating in a code pair round. To my surprise, there were no DSA questions. The interview primarily focused on Object-Oriented Programming (OOP) and Database Management Systems (DBMS).
For OOP, I was asked questions related to abstract classes, inheritance, virtual methods, and the final keyword. The interviewer also provided a small class diagram and asked several questions based on it.
The DBMS part covered joins and indexing in databases. Following these conceptual questions, I was given a schema for restaurant, area, delivery_agent, and customer tables and was asked to write queries for two specific scenarios:
- Youngest customer who lives in the most densely populated area of Mumbai.
- Average rating of all the delivery agents who deliver to India Gate area of New Delhi.
I was also instructed to add any additional information or tables if required to solve these questions. This round was a good mix of theoretical knowledge and practical application in database querying.
Interview Questions (2)
Given the following database schema, write a SQL query to find the youngest customer who lives in the most densely populated area of Mumbai.
restaurant(restaurant_id*, name, city, is_veg_only, rest_rating, location_area_id)
area(area_id*, area_name, city, density)
delivery_agent(agent_id*, name, age, vehicle_no, agent_rating)
customer(customer_id*, name, age, residence_area_id, cust_rating)If any more information or table is required, add it.
Given the following database schema, write a SQL query to find the average rating of all the delivery agents who deliver to India Gate area of New Delhi.
restaurant(restaurant_id*, name, city, is_veg_only, rest_rating, location_area_id)
area(area_id*, area_name, city, density)
delivery_agent(agent_id*, name, age, vehicle_no, agent_rating)
customer(customer_id*, name, age, residence_area_id, cust_rating)If any more information or table is required, add it.