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 appeared for an interview 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

I appeared for an interview in Dec 2021.

Round 1 - Video Call 

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round 2 - Video Call 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

  • Q1. In a marketing campaign, how would you decide which metrics to track?
  • Ans. 

    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

  • Answered by AI
Round 3 - HR 

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in BangaloreEligibility criteriaNoJupiter Money interview preparation:Topics to prepare for the interview - SQL, Tablea, Data Visualisation, Key Metrics for a Product, Data Visualisation using PythonTime required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding

Application resume tips for other job seekers

Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job

Final outcome of the interviewSelected
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL questions are asked in this round Some theory questions are asked as well

Interview Preparation Tips

Interview preparation tips for other job seekers - focus on SQL
practice plenty of SQL and case study problems
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
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:
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 - 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
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is the order of execution in sql
  • Ans. 

    The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 1. FROM: Specifies the tables involved in the query.

    • 2. WHERE: Filters the rows based on specified conditions.

    • 3. GROUP BY: Groups the rows that have the same values into summary rows.

    • 4. HAVING: Filters groups based on specified conditions.

    • 5. SELECT: Selects the columns to be included in the result set.

    • 6. ORDER BY: Sorts the result set base

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. How to do conditional formatting in excel
  • Ans. 

    Conditional formatting in Excel allows users to format cells based on specified conditions.

    • Select the range of cells you want to apply conditional formatting to

    • Go to the 'Home' tab and click on 'Conditional Formatting'

    • Choose the desired formatting option, such as color scales, data bars, or icon sets

    • Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.

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 

(1 Question)

  • Q1. Detailed discussion on past experience and projects.
Round 3 - Technical 

(2 Questions)

  • Q1. 2 Hackerrank SQL Questions
  • Q2. 1 Hackerrank Python Question

Interview Preparation Tips

Topics to prepare for Razorpay Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Deep knowledge of SQL and Python is required along with Data Analysis fundamentals.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

I applied via Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on sql

Interview Preparation Tips

Interview preparation tips for other job seekers - it is good experience and moderate prepare for sql, data visualisation etc,it lasted for 2 hrs 30 mins. the interviwers want to test by both technical and soft skills

I appeared for an interview in Mar 2017.

Interview Questionnaire 

4 Questions

  • Q1. Tell us something about yourself.
  • Ans. 

    I am a detail-oriented business analyst with experience in data analysis and project management.

    • Experienced in data analysis and project management

    • Detail-oriented and analytical mindset

    • Strong communication and interpersonal skills

    • Proficient in various analytical tools such as Excel, SQL, and Tableau

  • Answered by AI
  • Q2. What do you about our company?
  • Ans. 

    I am not familiar with your company.

    • I have not had the opportunity to research your company yet.

    • I would appreciate it if you could provide me with more information about your company.

    • I am open to learning more about your company and its goals.

  • Answered by AI
  • Q3. Why should we hire you?
  • Ans. 

    I have the skills, experience, and passion to excel in this role and contribute to the success of the company.

    • I have a strong background in data analysis and problem-solving, which are essential skills for a business analyst.

    • I have experience working with various stakeholders, including clients, developers, and project managers, to ensure successful project delivery.

    • I am a quick learner and adaptable to new technologie...

  • Answered by AI
  • Q4. What are the marketing strategies according to you?
  • Ans. 

    Marketing strategies are plans and tactics implemented by businesses to promote their products or services and reach their target audience.

    • Identifying target audience and market segmentation

    • Creating a unique value proposition

    • Developing a marketing mix (product, price, place, promotion)

    • Utilizing digital marketing channels (social media, email marketing, SEO)

    • Implementing content marketing and storytelling

    • Building brand a...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The questions were very tough to complete.Highly based on technical questions.
Tips: Hard work is necessary to crack it.
Duration: 3 hours
Total Questions: 45

Round: HR Interview
Experience: It went on very smoothly and i was quite comfortable with the interviewer.
Tips: One just needs to answer all the questions asked by the interviewer in a proper manner or confident manner presenting valid points.

College Name: Kiit university

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 22 salaries
₹2.2 L/yr - ₹10.9 L/yr
At par with the average Data Analyst Salary in India
View more details

Mobikwik Data Analyst Reviews and Ratings

based on 4 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 4 Reviews and Ratings
Team Lead
69 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
55 salaries
unlock blur

₹2.7 L/yr - ₹6.7 L/yr

Software Developer
49 salaries
unlock blur

₹7.9 L/yr - ₹30.6 L/yr

Software Development Engineer II
48 salaries
unlock blur

₹11 L/yr - ₹30 L/yr

Explore more salaries
Compare Mobikwik with

Paytm

3.3
Compare

Freecharge

3.8
Compare

HighRadius

2.9
Compare

Razorpay

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