Filter interviews by
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
SDE 1 is an entry-level position where candidates gain foundational skills before advancing to SDE 2.
SDE 1 focuses on learning and building foundational skills in software development.
SDE 2 requires more experience and expertise in software development.
Advancing from SDE 1 to SDE 2 is a common career progression in tech companies.
SDE 1 roles often involve working on smaller projects or components of larger project...
No, I believe in standing up against bullying and supporting those who are being bullied.
I do not support bullying in any form and believe in treating others with respect and kindness.
I would try to intervene and help the person being bullied, either by talking to the bully or seeking help from a teacher or supervisor.
I believe in creating a positive and inclusive environment where everyone feels safe and respecte...
Count the number of islands in a 2D grid of '1's (land) and '0's (water).
An island is surrounded by water and is formed by connecting adjacent lands horizontally or vertically.
Use Depth-First Search (DFS) or Breadth-First Search (BFS) to explore and mark visited lands.
Iterate through each cell in the grid; when a '1' is found, increment the island count and explore its neighbors.
Example: In a grid like [[1,1,0],[0...
Find kth smallest element in unordered array with O(1) space
Use the QuickSelect algorithm to partition the array and find the kth smallest element
Choose a pivot element and partition the array into two subarrays
Recursively partition the subarray that contains the kth smallest element
Repeat until the pivot element is the kth smallest element
Time complexity: O(n) average case, O(n^2) worst case
Given a 2D matrix with doors and walls, fill distance matrix with minimum distance to the nearest door.
Iterate through the matrix and find the doors
Use Breadth-First Search (BFS) to calculate the minimum distance from each cell to the nearest door
Update the distance matrix with the minimum distances
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows re...
I would like to add a feature that allows users to schedule rides in advance.
Users can schedule rides for important events or appointments
Option to choose specific driver or vehicle for scheduled rides
Notifications for upcoming scheduled rides
Ability to edit or cancel scheduled rides
Given an array of distinct positive integers and a number 'K', your task is to find the K'th largest element in the array.
Array: [2,1,5,6,3,8], K =...
Find the Kth largest element in an array of distinct positive integers.
Sort the array in non-increasing order
Return the Kth element from the sorted array
Handle multiple test cases
Consider a grid containing oranges. Each cell in this grid can hold one of three integer values:
The task is to determine the minimum time required for all fresh oranges to become rotten in a grid.
Create a queue to store the rotten oranges and their time of rotting.
Iterate through the grid to find the initial rotten oranges and add them to the queue.
Perform BFS by popping each rotten orange from the queue, rot adjacent fresh oranges, and add them to the queue with updated time.
Continue until the queue is empt...
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
Platform: Code Signal, Duration: 90 mins, Topics: DSA
I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.
Graphs ,arrays , Hashmaps and Heaps
Changes on graph structure involve adding, removing, or modifying nodes and edges.
Adding a new node to the graph
Removing an existing node from the graph
Modifying the weight of an edge in the graph
Analyze case and data and present the result and some tech questions
I applied via Campus Placement and was interviewed in Aug 2023. There were 3 interview rounds.
Aptitude Test had questions on sql, analytic ques, case study ques on uber
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows related...
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.
I appeared for an interview in Oct 2023.
Python, SQL, Quant, Statistics, Numpy
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
I applied via LinkedIn and was interviewed in Sep 2023. There were 3 interview rounds.
To reduce contact rate, implement self-service options, improve website FAQs, and provide proactive communication.
Implement self-service options such as chatbots or automated phone systems
Improve website FAQs to address common customer inquiries
Provide proactive communication through email or text alerts
Reduce contact rates related to lost item
Multiple questions from cross-functional teams
I applied via Company Website and was interviewed in May 2023. There were 3 interview rounds.
Very Easy questions just do it
SDE 1 is an entry-level position where candidates gain foundational skills before advancing to SDE 2.
SDE 1 focuses on learning and building foundational skills in software development.
SDE 2 requires more experience and expertise in software development.
Advancing from SDE 1 to SDE 2 is a common career progression in tech companies.
SDE 1 roles often involve working on smaller projects or components of larger projects.
SDE...
No, I believe in standing up against bullying and supporting those who are being bullied.
I do not support bullying in any form and believe in treating others with respect and kindness.
I would try to intervene and help the person being bullied, either by talking to the bully or seeking help from a teacher or supervisor.
I believe in creating a positive and inclusive environment where everyone feels safe and respected.
Python , sql coding test
I applied via LinkedIn and was interviewed in Dec 2022. There were 3 interview rounds.
3 coding questions one on array
Count the number of islands in a 2D grid of '1's (land) and '0's (water).
Use Depth-First Search (DFS) or Breadth-First Search (BFS) to explore the grid.
Mark visited land cells to avoid counting them multiple times.
Iterate through each cell; if it's '1', increment the island count and explore its neighbors.
Example: For grid [['1','1','0'], ['0','1','0'], ['0','0','0']], the output is 1.
Count the number of islands in a 2D grid of '1's (land) and '0's (water).
An island is surrounded by water and is formed by connecting adjacent lands horizontally or vertically.
Use Depth-First Search (DFS) or Breadth-First Search (BFS) to explore and mark visited lands.
Iterate through each cell in the grid; when a '1' is found, increment the island count and explore its neighbors.
Example: In a grid like [[1,1,0],[0,1,0]...
Top trending discussions
Some of the top questions asked at the Uber interview for freshers -
The duration of Uber interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 11 interview experiences
Difficulty level
Duration
Driver
599
salaries
| ₹0.6 L/yr - ₹7.1 L/yr |
CAR Driver
349
salaries
| ₹0.9 L/yr - ₹8 L/yr |
Software Engineer
235
salaries
| ₹20 L/yr - ₹85 L/yr |
Senior Software Engineer
173
salaries
| ₹30 L/yr - ₹130.2 L/yr |
Data Analyst
154
salaries
| ₹6 L/yr - ₹25 L/yr |
Amazon
Ola Cabs
Airbnb