Filter interviews by
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FU...
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions are used in SQL to perform calculations on a set of rows related to the current row.
They allow you to perform calculations like ranking, moving averages, and cumulative sums.
Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits
Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.
Top trending discussions
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Quantitative aptitude, verbal ability, critical reasoning
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.
Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.
Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
I applied via LinkedIn and was interviewed in Jun 2023. There were 2 interview rounds.
SQL queries for JOINS
Use INNER JOIN to retrieve rows from both tables that have matching values
Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table
Use FULL JOIN to retrieve rows when there is a match in either table
The query is asking for metrics provided in a specific sheet.
Identify the specific sheet being referred to in the question
Review the metrics listed in the sheet
Analyze the relevance of each metric to the query
This is a case study round revolve around a business problem in which we have to analyse data driven solutions.
Data Representation, Logical Reasoning
I applied via Approached by Company and was interviewed in Jul 2024. There were 2 interview rounds.
Case studies about Navi UPI
Case studies about Navi UPI App
Current CTC and preferred location are confidential information.
Current CTC and preferred location are personal and confidential details.
It is common practice not to disclose current CTC during interviews.
Preferred location may vary based on individual circumstances and preferences.
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
Marketing campaign case study
based on 2 reviews
Rating in categories
KYC Associate
139
salaries
| ₹2.5 L/yr - ₹5 L/yr |
Team Lead
54
salaries
| ₹4 L/yr - ₹10.7 L/yr |
Collections Executive
47
salaries
| ₹2.5 L/yr - ₹4.5 L/yr |
Customer Support Executive
40
salaries
| ₹3.1 L/yr - ₹6 L/yr |
Customer Service Executive
27
salaries
| ₹3.2 L/yr - ₹6.1 L/yr |
ZestMoney
Paysense Services India
EarlySalary Services
Kissht Finance