Filter interviews by
I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.
Top trending discussions
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.
They allow for calculations to be performed on a specific subset of rows within a query result set.
Window functions are commonly used for running totals, moving averages, and ranking data.
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a 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.
Full Outer Join: Returns rows when there is a match in one of the tables.
Cross Join:
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 before Feb 2024.
Mostly medium leetcode
Mostly medium level DSA
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 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 appeared for an interview in Sep 2024.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
SQL
Python
R
Tableau
Excel
SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard
I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.
based on 3 interviews
Interview experience
based on 3 reviews
Rating in categories
Collections Executive
33
salaries
| ₹2 L/yr - ₹4 L/yr |
Data Scientist
23
salaries
| ₹8.5 L/yr - ₹17 L/yr |
Sales Executive
21
salaries
| ₹2.4 L/yr - ₹3.8 L/yr |
Assistant Manager
19
salaries
| ₹3.8 L/yr - ₹14.9 L/yr |
Collection Officer
18
salaries
| ₹3 L/yr - ₹4 L/yr |
Rupeek
Razorpay
ACKO
Revolut