i
Mobikwik
Filter interviews by
I was interviewed 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)
Top trending discussions
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 Campus Placement and was interviewed before May 2023. There was 1 interview round.
Logistic Regression is a statistical method used to model the probability of a certain event occurring based on one or more predictor variables. Recall is a metric used to evaluate the performance of a classification model.
Logistic Regression is used for binary classification tasks, where the outcome variable is categorical and has two classes.
It estimates the probability that a given input belongs to a certain categor...
Recall is a metric used in classification models to measure the ability of the model to find all relevant cases within a dataset.
Recall is calculated as the number of true positive predictions divided by the sum of true positive and false negative predictions.
It is also known as sensitivity or true positive rate.
A high recall indicates that the model is good at identifying all relevant cases, even if it means more fals...
Linear regression is used for predicting continuous values, while logistic regression is used for predicting binary outcomes.
Linear regression is used when the target variable is continuous and has a linear relationship with the independent variables.
Logistic regression is used when the target variable is binary or categorical and the relationship between independent variables and the target is non-linear.
Linear regres...
Performance metrics of Regression include Mean Squared Error, R-squared, Mean Absolute Error, etc.
Mean Squared Error (MSE)
R-squared (R^2)
Mean Absolute Error (MAE)
Root Mean Squared Error (RMSE)
Adjusted R-squared
I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.
I applied via Walk-in and was interviewed before Jul 2022. There were 2 interview rounds.
Basic technology function of MODEM and it's working via SM to master .
Doubt in honesty while e and eco of functional programming.
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 applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.
Statistics assignment on given dataset
posted on 19 Oct 2024
I applied via campus placement at Indian Institute of Information Technology and Management (ABV-IIITM), Gwalior and was interviewed in Apr 2024. There were 2 interview rounds.
45 min , 45 questions
I applied via Recruitment Consulltant and was interviewed in Jul 2023. There were 3 interview rounds.
Scheduled for 15 min but it took 30 min[this is completely alright].
- Self-introduction
- Python codes
- ETL questions
- SQL query[test link didn't work, they said that's fine]
Answered 90% of the questions correctly, but the feedback that I received was completely negative. Interviewers were in a hurry and they were not able to concentrate on the interview. They asked questions so fast and I answered most of them correctly and did coding well.
Two interviewers were supposed to join the interview, one joined 10 min late and another joined 15 min late then I had to introduce myself twice :)
I don't know why the feedback was completely negative.
based on 1 interview
Interview experience
based on 5 reviews
Rating in categories
Team Lead
78
salaries
| ₹2.2 L/yr - ₹7 L/yr |
Assistant Manager
56
salaries
| ₹4.5 L/yr - ₹12.6 L/yr |
Senior Executive
53
salaries
| ₹2.7 L/yr - ₹6.7 L/yr |
Software Developer
47
salaries
| ₹7.7 L/yr - ₹30.7 L/yr |
Software Development Engineer II
44
salaries
| ₹11 L/yr - ₹30 L/yr |
Paytm
Freecharge
PhonePe
Payed