Candidatei-me online. O processo levou 1 semana. Fui entrevistado pela Geektrust (Bengaluru) em jul. de 2025
Entrevista
I have given the first round of an interview. i was interviewing for the client target, the interview was consist of 3 parts:
1) HLD(high Level Design)
2)LLD(Low Level Design)
3)SQL query and optimizations
Perguntas de entrevista [4]
Pergunta 1
Q1: Design a video streaming service like Youtube/Netflix where users can upload/view/search videos. The service should be scalable where a large number of users can watch and share the videos simultaneously. It will be storing and transmitting petabytes and petabytes of data.
Q2:How will you design the social media application similar to Twitter using the given requirements?
part A - build such an application for a large enterprise with 100,000 active users
part B - the enterprise wants to scale the application to its entire stakeholder network of 10 million active users - what are the challenges in scaling the app and how would you solve them?
Q3: Consider a table called "Employees" with columns: employee_id, name, salary, and department_id. Write an SQL query to calculate the average salary for each department. The result should include the department name and the average salary.
Consider two tables: "Products" with columns: product_id, name, and price, and "Orders" with columns: order_id, product_id, and quantity. Write an SQL query to find the top 5 products by sales, based on the total quantity of each product sold. The result should include the product name and the total quantity sold.
Candidatei-me online. O processo levou 2 dias. Fui entrevistado pela Geektrust (Bengaluru) em out. de 2020
Entrevista
Interview round was split into 3: 1. Tech round to walkthrough your code and design on a coding challenge. 2. Tech round for system design. 3. HR Round and cultural fit
