Filter interviews by
I applied via Referral and was interviewed before Nov 2018. There were 5 interview rounds.
Top trending discussions
I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.
This is literally a live coding test. For analytics expect SQL, python, R.
There were some aptitude question, Pandas question, SQL queries.
Use SQL query with DISTINCT keyword to filter duplicate entries.
Use SELECT DISTINCT column_name FROM table_name;
DISTINCT keyword removes duplicate values from the result set.
For example, SELECT DISTINCT name FROM employees;
You can also use GROUP BY clause to eliminate duplicates.
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
Simple Case Study was discussed
SQL, General Aptitude Questions
10 minutes GD on general topics.
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
Basic aptitude question and 2 Sql question
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
I applied via Campus Placement and was interviewed before Aug 2023. There were 3 interview rounds.
Root cause analysis involves identifying the underlying reason for a problem or issue.
Identify the problem or issue that needs to be analyzed
Gather relevant data and information related to the problem
Use tools like fishbone diagram or 5 Whys to dig deeper into the root cause
Consider all possible factors that could have contributed to the problem
Develop a plan to address the root cause and prevent future occurrences
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
Self-join is used to join a table with itself to compare rows within the same table.
Used to compare rows within the same table
Helps in retrieving hierarchical data
Can be used to find employees who report to the same manager
Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.
Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.
Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.
Bounce Rate: Measure the percentage of visitors who leave the website after vi...
The probability of getting at least one six after throwing 2 unbiased dice is 11/36.
The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)
The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)
Travel Consultant
151
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Travel Consultant
68
salaries
| ₹0 L/yr - ₹0 L/yr |
Accounts Manager
52
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
44
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Executive
43
salaries
| ₹0 L/yr - ₹0 L/yr |
MakeMyTrip
Yatra
Cleartrip
Goibibo