Upload Button Icon Add office photos

Filter interviews by

MagicPin Data Analyst Interview Questions and Answers

Updated 11 Apr 2023

MagicPin Data Analyst Interview Experiences

2 interviews found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn 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. Excel and SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Python and project based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Took 2 interviews over the course of 2 weeks and then 1 hour before my scheduled final / HR round declined to hire me as they decided that they don't want to.
Utter disregard for a candidate's time and work. The humiliating level of such degraded professionalism that they cannot decide before posting an interview that they don't want to hire.
But they have the audacity to expect 7 days and open-ended work schedule from the candidates.
DO NOT APPLY.

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 Aug 2022

I applied via LinkedIn and was interviewed before Aug 2021. There were 2 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 

(4 Questions)

  • Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
  • Q2. Python Basics (data frame, data types, lamda, series etc)
  • Q3. SQL Functions (joins, limits, partitions, orders by and group by)
  • Q4. 3rd round was managerial round, where mostly non-technicial questions asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident, while answering the questions and you don't have to know all the questions rightly. It's okay if you don't know some.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. SQL and Excel were the key that helped me get this job.
  • Q2. Puzzles

I applied via Walk-in and was interviewed before Feb 2021. 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 - Aptitude Test 
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - easy to crack they will ask qestions
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. SQL: left join, right join and inner join questions find out the latest entry for an user when they log in to a app Python: few basic questions on python like count the characters in a word. Linux: what co...
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
  • Ans. 

    Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.

    • Data allows for informed decision-making and insights.

    • Tokopedia's extensive data provides a valuable opportunity for analysis.

    • My bachelor's thesis delved into data-driven insights and analysis.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Walkthrough bachelor's thesis

Interview Preparation Tips

Topics to prepare for Tokopedia Data Analyst interview:
  • SQL
  • Python
  • Data Analysis
Interview preparation tips for other job seekers - Good place to start your career, office politics is tricky tho.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Assignment 

SQL, excel, tableau , looker studio

Round 2 - HR 

(1 Question)

  • Q1. What is your notice period.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in May 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 - Assignment 

Send assignment doings MS Excel

Round 3 - Technical 

(2 Questions)

  • Q1. Asked about the previous project
  • Q2. What about your roles in previous company

Interview Preparation Tips

Topics to prepare for Zolo Data Analyst interview:
  • Excel

Data Analyst Interview Questions & Answers

Impact Guru user image Shubham Upadhyay

posted on 19 Apr 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Difference between rank and dense rank
  • Ans. 

    Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.

    • Rank assigns unique ranks to each distinct value in a dataset

    • Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

    • For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3

  • Answered by AI
  • Q2. How will merge multiple file in python
  • Ans. 

    Merge multiple files in Python using pandas.concat() or pd.merge() functions.

    • Use pandas.concat() function to merge multiple files vertically (row-wise).

    • Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

    • Ensure that the files have compatible column names and data types before merging.

    • Handle any missing or duplicate values appropriately during the merging process.

    • Consider ...

  • Answered by AI
  • Q3. Data frame explain in detail
  • Ans. 

    A data frame is a two-dimensional data structure in which data is stored in rows and columns.

    • Data frames are commonly used in programming languages like R and Python for data analysis.

    • Each column in a data frame represents a variable, while each row represents an observation.

    • Data frames can contain different types of data, such as numeric, character, and factor.

    • Data frames can be created from various sources like CSV f

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
  • Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
  • Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through some questions for interview on data analyst role and read those, this thing will help you to understand many concepts. Not very hard interview also the interviewer is helpful.

MagicPin Interview FAQs

How many rounds are there in MagicPin Data Analyst interview?
MagicPin interview process usually has 2-3 rounds. The most common rounds in the MagicPin interview process are Technical and Resume Shortlist.
How to prepare for MagicPin 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 MagicPin. The most common topics and skills that interviewers at MagicPin expect are Python, SQL, Analytics, Data Analytics and Excel.
What are the top questions asked in MagicPin Data Analyst interview?

Some of the top questions asked at the MagicPin Data Analyst interview -

  1. 3rd round was managerial round, where mostly non-technicial questions ask...read more
  2. Python Basics (data frame, data types, lamda, series e...read more
  3. Advance Excel (Vlookup, Index, Countifs, sumifs and othe...read more

Tell us how to improve this page.

MagicPin Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
MagicPin Data Analyst Salary
based on 30 salaries
₹2.1 L/yr - ₹9.2 L/yr
21% less than the average Data Analyst Salary in India
View more details

MagicPin Data Analyst Reviews and Ratings

based on 3 reviews

2.1/5

Rating in categories

4.0

Skill development

1.1

Work-life balance

1.5

Salary

2.9

Job security

1.1

Company culture

3.4

Promotions

1.6

Work satisfaction

Explore 3 Reviews and Ratings
Team Lead
56 salaries
unlock blur

₹2.2 L/yr - ₹7.5 L/yr

Senior Associate
54 salaries
unlock blur

₹2.9 L/yr - ₹9.3 L/yr

Key Account Manager
54 salaries
unlock blur

₹3 L/yr - ₹9.5 L/yr

Business Development Executive
50 salaries
unlock blur

₹2.8 L/yr - ₹8 L/yr

Associate
46 salaries
unlock blur

₹2.2 L/yr - ₹4 L/yr

Explore more salaries
Compare MagicPin with

Netmeds.com

3.6
Compare

Tracxn

3.2
Compare

Zolo

3.4
Compare

Milkbasket

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