Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mobikwik Team. If you also belong to the team, you can get access from here

Mobikwik Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mobikwik Data Analyst Interview Questions and Answers

Updated 3 Oct 2024

Mobikwik Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Oct 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I was interviewed in Sep 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me brief about your self
  • Ans. 

    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

  • Answered by AI
  • Q2. What are youre strenth and weekness
  • Ans. 

    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)

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do best stay carm

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Types of Window Function
  • Ans. 

    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.

  • Answered by AI
  • Q2. Difference between Joins with examples
  • Ans. 

    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:

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Basics of Logistic regression
  • Q2. What is Logistic Regression? What is Recall
  • Ans. 

    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...

  • Answered by AI
  • Q3. What is Recall?
  • Ans. 

    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...

  • Answered by AI
  • Q4. What is the difference between linear and logistic reg.?
  • Ans. 

    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...

  • Answered by AI
  • Q5. What are the performance metrics of Regression
  • Ans. 

    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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - do not go in-depth just cover basics of ML, python, Excel

Skills evaluated in this interview

I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQl window functions, how to use joins group by in queries, how data analytics works.. What is ETL

Interview Preparation Tips

Interview preparation tips for other job seekers - Have knowledge about finance domain. Be yourself. Prepare really good for SQL. Know your way in data analytics and engineering.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(5 Questions)

  • Q1. Fibonacci sequence
  • Q2. Databricks cluster questions
  • Q3. Intermediate SQL questions from datalemur
  • Q4. Python questions from geeksforgeeks
  • Q5. ETL information

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up python and SQL and spark. Ready to do coding questions.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Jul 2022. There were 2 interview rounds.

Round 1 - Assignment 

Basic technology function of MODEM and it's working via SM to master .

Round 2 - Case Study 

Doubt in honesty while e and eco of functional programming.

Interview Preparation Tips

Interview preparation tips for other job seekers - Jobs in our hands basic of human topology uses and grabed service.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

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.

Round 3 - Case Study 

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

Round 4 - HR 

(1 Question)

  • Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.

Interview Preparation Tips

Topics to prepare for Jupiter Money Data Analyst interview:
  • SQL
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I applied via Campus Placement and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Assignment 

Statistics assignment on given dataset

Round 3 - One-on-one 

(1 Question)

  • Q1. Credit Risk, loan disbursement process, PD model , machine learning

Interview Preparation Tips

Interview preparation tips for other job seekers - There might one more one on one round
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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.

Round 1 - Aptitude Test 

45 min , 45 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Technical question( PowerBI, data science)
  • Q2. Behaviourial question

Interview Preparation Tips

Interview preparation tips for other job seekers - Combination of: Data Mining , Data Science, Basic Statistics, Database Management
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Coding Test 

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.

Round 3 - Not selected in the first round 

(1 Question)

  • Q1. As I didn't qualified in the first round of interview, I did not face the second orund.

Interview Preparation Tips

Interview preparation tips for other job seekers - Think once before you apply.
Record the interview from the candidates' side as well.

Mobikwik Interview FAQs

How many rounds are there in Mobikwik Data Analyst interview?
Mobikwik interview process usually has 1 rounds. The most common rounds in the Mobikwik interview process are HR.
How to prepare for Mobikwik Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mobikwik. The most common topics and skills that interviewers at Mobikwik expect are Data Analysis, SQL, Data Analytics, Python and Data Visualization.

Tell us how to improve this page.

Mobikwik Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Mobikwik Data Analyst Salary
based on 23 salaries
₹2.7 L/yr - ₹7 L/yr
At par with the average Data Analyst Salary in India
View more details

Mobikwik Data Analyst Reviews and Ratings

based on 5 reviews

4.9/5

Rating in categories

4.9

Skill development

4.9

Work-life balance

4.9

Salary

4.9

Job security

4.9

Company culture

4.9

Promotions

4.9

Work satisfaction

Explore 5 Reviews and Ratings
Team Lead
78 salaries
unlock blur

₹2.2 L/yr - ₹7 L/yr

Assistant Manager
56 salaries
unlock blur

₹4.5 L/yr - ₹12.6 L/yr

Senior Executive
53 salaries
unlock blur

₹2.7 L/yr - ₹6.7 L/yr

Software Developer
47 salaries
unlock blur

₹7.7 L/yr - ₹30.7 L/yr

Software Development Engineer II
44 salaries
unlock blur

₹11 L/yr - ₹30 L/yr

Explore more salaries
Compare Mobikwik with

Paytm

3.3
Compare

Freecharge

3.9
Compare

PhonePe

4.0
Compare

Payed

2.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview