Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in May 2024. There were 3 interview rounds.
Basic assignment on SQL and Python, followed by a case study
DENSE_RANK assigns consecutive ranks to rows with the same value, while RANK leaves gaps in the ranking sequence.
DENSE_RANK will not skip any ranks, even if there are ties in the data.
RANK will leave gaps in the ranking sequence when there are ties.
For example, if three rows have the same value and are ranked 1, 1, and 2, DENSE_RANK will assign ranks 1, 1, and 2, while RANK will assign ranks 1, 1, and 3.
An index is a statistical measure used to represent the performance of a group of assets or securities.
An index is used to track the performance of a specific market, sector, or asset class.
It is often used as a benchmark for comparing the performance of investment portfolios.
Examples of popular indexes include the S&P 500, Dow Jones Industrial Average, and Nasdaq Composite.
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
Basic SQL query and data analysis thing
Factors affecting Netflix subscriber rate include competition, content quality, pricing, and user experience.
Competition from other streaming services like Amazon Prime, Hulu, and Disney+
Quality of content available on Netflix compared to competitors
Pricing strategy and affordability for potential subscribers
User experience including interface, recommendations, and customer service
Top trending discussions
I applied via Approached by Company and was interviewed in Dec 2021. There were 4 interview rounds.
Two datasets were shared. Complete freedom was given to derive different insights.
I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.
SQL based leetcode medium and hackerrank
Python take home EDA case study assessment
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
Estimate the number of users on the application based on market research, user demographics, and industry trends.
Consider the total addressable market (TAM) for the application
Analyze user demographics and behavior to estimate adoption rate
Look at industry benchmarks and competitor data for reference
Use surveys, focus groups, and user feedback to gather insights
Consider factors like market saturation, growth potential,
I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.
Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.
Row number is a function that assigns a unique number to each row in a result set.
Rank is a function that assigns a rank to each row based on the values in a specified column.
Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.
Partit...
Real-time examples of data analytics
Predictive maintenance in manufacturing
Real-time fraud detection in banking
Personalized recommendations in e-commerce
Real-time traffic analysis for smart cities
Real-time health monitoring in medical devices
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
Union removes duplicate rows from the result set, while Union all includes all rows.
Union sorts the result set, while Union all does not.
Union is slower than Union all because it performs a distinct operation.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FRO
Joins are generally faster than unions.
Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.
Joins can utilize indexes on the columns being joined, which can improve performance.
Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...
I applied via Recruitment Consulltant and was interviewed in Dec 2022. There were 2 interview rounds.
MYSQL window functions allow for calculations across rows in a result set.
Window functions are used to perform calculations across rows in a result set
They are used with the OVER() clause
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
They can be used to calculate running totals, moving averages, and more
I applied via Naukri.com and was interviewed in Sep 2023. There was 1 interview round.
I applied via Company Website and was interviewed before Dec 2020. There was 1 interview round.
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Production Analyst
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Product Manager
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Product Manager
4
salaries
| ₹0 L/yr - ₹0 L/yr |
UI/UX Designer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Dream11
MyTeam11
Fantasy Akhada
My11Circle