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

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
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quant, LR, puzzles, cat based level 2 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between tuple nd list
  • Ans. 

    Tuple is immutable and ordered, while list is mutable and ordered in Python.

    • Tuple is created using parentheses () while list is created using square brackets []

    • Tuple elements cannot be changed once assigned, while list elements can be modified

    • Tuple is faster than list for iteration and accessing elements

    • Example: tuple = (1, 2, 3) and list = [1, 2, 3]

  • Answered by AI
  • Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Round 3 - HR 

(2 Questions)

  • Q1. Walk me through ur cv
  • Ans. 

    I have a strong background in data analysis with experience in various industries.

    • Bachelor's degree in Statistics with a focus on data analysis

    • Proficient in SQL, Python, and data visualization tools like Tableau

    • Experience working with large datasets and conducting statistical analysis

    • Completed internships at XYZ Company and ABC Organization

    • Presented findings at industry conferences

  • Answered by AI
  • Q2. What have learnt from this experience?
  • Ans. 

    I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.

    • Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

    • Improved ability to identify trends, patterns, and outliers in data sets

    • Enhanced communication skills by presenting findings and recommendations to stakeholders

    • Learned to collaborate with team memb

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - just be honest , calm

Skills evaluated in this interview

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

I applied via Referral and was interviewed before Aug 2022. 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 - One-on-one 

(4 Questions)

  • Q1. How do you setup a Dark Store?
  • Ans. 

    Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.

    • Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.

    • Optimize the layout of the store for efficient picking, packing, and shipping of orders.

    • Implement inventory management systems to track stock levels accurately and prevent stockouts.

    • Train staff on order f...

  • Answered by AI
  • Q2. How do joins work in the simplest manner?
  • Ans. 

    Joins combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

  • Answered by AI
  • Q3. Write a basic query explaining the order of execution?
  • Ans. 

    The order of execution in a query determines the sequence in which operations are performed.

    • 1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 2. The FROM clause specifies the tables involved in the query.

    • 3. The WHERE clause filters the rows based on specified conditions.

    • 4. The GROUP BY clause groups the rows that have the same values into summary rows.

    • 5...

  • Answered by AI
  • Q4. Difference between Group By and Distinct?
  • Ans. 

    Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.

    • Group By is used with aggregate functions like COUNT, SUM, AVG, etc.

    • Distinct is used to retrieve unique values from a column or set of columns.

    • Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Blinkit Data Analyst interview:
  • SQL
  • joins
  • window functions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL base Question
  • Q2. About your projects
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. About previous experience situation based questions excel problem solving
  • Q2. Tell me about yourself difference between data quality and data validity

Interview Preparation Tips

Interview preparation tips for other job seekers - excel skills and data analysis basics
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

Round 2 - Case Study 

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

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

I applied via Company Website and was interviewed in Jul 2023. There were 4 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 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(5 Questions)

  • Q1. What is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

    • It emphasizes code readability and uses indentation to define code blocks.

    • Python has a large standard library and a vibrant community of developers.

    • Example: print('Hello, World!')

    • Example: import pandas as pd

  • Answered by AI
  • Q2. What is python used for?
  • Ans. 

    Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.

    • Data analysis and visualization

    • Web development (Django, Flask)

    • Artificial intelligence and machine learning (TensorFlow, PyTorch)

    • Automation and scripting

    • Scientific computing (NumPy, SciPy)

  • Answered by AI
  • Q3. What type of language is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is an interpreted language, meaning it does not need to be compiled before running.

    • It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

    • Python has a large standard library and a thriving community, making it versatile and widely used.

    • Example: Python is used for web develop...

  • Answered by AI
  • Q4. What is oops in python?
  • Ans. 

    Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.

    • OOP allows for the organization of code into reusable components called classes.

    • Classes can have attributes (variables) and methods (functions) associated with them.

    • In Python, everything is an object, and classes can be defined using the 'class' keyword.

    • Encapsulation, inheritance, and polymorph

  • Answered by AI
  • Q5. What is array in python?
  • Ans. 

    An array in Python is a data structure that stores a collection of elements of the same type.

    • Arrays can store elements such as integers, floats, or strings.

    • Arrays are indexed starting from 0, with elements accessed using their index.

    • Example: arr = ['apple', 'banana', 'cherry']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL query optimisation

Round 2 - HR 

(1 Question)

  • Q1. Regular discussion, about job role, why swiggy

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare excel, and sql

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
18% less than the average Data Analyst Salary in India
View more details

MagicPin Data Analyst Reviews and Ratings

based on 3 reviews

2.2/5

Rating in categories

4.5

Skill development

1.1

Work-life balance

1.6

Salary

2.4

Job security

1.6

Company culture

2.9

Promotions

1.6

Work satisfaction

Explore 3 Reviews and Ratings
Team Lead
56 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Key Account Manager
52 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Executive
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare MagicPin with

Nearbuy

4.6
Compare

Little India

3.8
Compare

Paytm

3.3
Compare

BookMyShow

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