Ho presentato la mia candidatura online. La procedura ha richiesto 2 giorni. Ho sostenuto un colloquio presso Geektrust (Bengaluru) nel mese di ott 2020
Colloquio
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
Ho presentato la mia candidatura online. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Geektrust (Bengaluru) nel mese di lug 2025
Colloquio
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
Domande di colloquio [4]
Domanda 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.
