i
Filter interviews by
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
Practice sql as much as you can
Be good with nath and reasoning
Reasoning was asked
Top trending discussions
I appeared for an interview in Dec 2021.
Round duration - 90 Minutes
Round difficulty - Easy
Problem solving using SQL questions
Round duration - 90 Minutes
Round difficulty - Easy
A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round
Metrics selection based on campaign objectives, target audience, and key performance indicators.
Identify campaign objectives and goals
Consider target audience and their behavior
Select key performance indicators (KPIs) relevant to the campaign
Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost
Analyze data to measure success and make data-driven decisions
Round duration - 30 Minutes
Round difficulty - Easy
Social empathatic fit round
Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding
Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
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.
I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.
Technical SQL Coding Round of 1 hour
Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,
Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.
Bar Raiser Round of 1 hour involving -
1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?
2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.
3. Resume based work exp discussion
I appeared for an interview before Feb 2024.
Mostly medium leetcode
Mostly medium level DSA
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
SQL - technical round
Case Study round - 2
I appeared for an interview in Feb 2025.
Sql and excel then tableu
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Quantitative aptitude, verbal ability, critical reasoning
Use SQL query to find store with highest Average Order Value (AOV).
Use GROUP BY clause to group by store
Calculate AOV by dividing total revenue by total orders
Use ORDER BY and LIMIT to find store with highest AOV
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.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Engineer
88
salaries
| ₹4.5 L/yr - ₹16.7 L/yr |
Senior Software Engineer
58
salaries
| ₹11.5 L/yr - ₹31.5 L/yr |
Business Development Specialist
24
salaries
| ₹4 L/yr - ₹10.5 L/yr |
Product Support Engineer
23
salaries
| ₹1.5 L/yr - ₹10 L/yr |
Product Manager
22
salaries
| ₹15 L/yr - ₹32 L/yr |
Rupeek
Razorpay
ACKO
Kissht Finance