Upload Button Icon Add office photos

Filter interviews by

Clear (1)

MagicPin Analyst Interview Questions and Answers

Updated 6 Dec 2024

MagicPin Analyst Interview Experiences

2 interviews found

Analyst Interview Questions & Answers

user image Anonymous

posted on 6 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Campus Placement

Round 1 - Coding Test 

Hackerrank, sql and python questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Pivot tables in excel?
  • Q2. Sql questions on joins and window functions

Analyst Interview Questions & Answers

user image Ritik Gupta

posted on 22 Feb 2024

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

I applied via LinkedIn and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Questions on python and SQL

Round 2 - One-on-one 

(1 Question)

  • Q1. With the hiring department
Round 3 - Case Study 

With the AVP of company

Analyst Interview Questions Asked at Other Companies

asked in Capgemini
Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, you ... read more
asked in Deloitte
Q2. Reverse a Number Problem Statement Given an integer 'N', write a ... read more
Q3. A 10x10x10 cube is made up of 1x1x1 cubes. Its outer surface is p ... read more
Q4. Ninja and the Game of Words In this game, Ninja is provided with ... read more
Q5. Good old standard problem: Playing number game with your friend t ... read more

Analyst Jobs at MagicPin

View all

Interview questions from similar companies

Analyst Interview Questions & Answers

Ola Cabs user image Satyam Mudaliar

posted on 18 Sep 2015

Interview Preparation Tips

Round: Test
Experience: English was unpredictable.. Maths was easy but it will be good if you have practice, logical reasoning requires practice but are interesting
Tips: Leave english comprehensions for the end.. Do not waste too much time on one question even if it appears easy.. attempt the paper in the order of your comfort and mark every questions in case of NO negative marking
Duration: 60 minutes

Round: HR Interview
Tips: Smile!! And think before speaking anything, else you may contradict your own point.. Prepare "Tell me about yourself" well and guide your interview by focusing on your strongest point, you may face more questions on that point.. refer to 64 HR questions book

Round: Stress Interview
Tips: If they are giving you stress, that means they like you.. Relax!! Do not get nervous, thats what they want to check.. Think for the solution to the problem normally, you know you can crack it (Stress interview may be a part of HR, technical, case or any other interview.. you may have to make it out yourself)

Skill Tips: ""
Skills: Puzzles, Speaking skills, Aptitude, guesstimates, Case solving, presentation skills
College Name: IIT Bombay

I applied via Referral and was interviewed before Dec 2021. 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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic sql and joins ..
  • Q2. Advance excel is a must have
Round 3 - Case Study 

Price precision of riders, city wise calculation of cost per orders and earnings

Round 4 - HR 

(1 Question)

  • Q1. Salary expectations and all

Interview Preparation Tips

Interview preparation tips for other job seekers - plz prepare for business understanding like how businesses works and at the end how you values to the company

Analyst Interview Questions & Answers

Ola Cabs user image Sanjyot Thete

posted on 13 Mar 2015

Interview Questionnaire 

5 Questions

  • Q1. Why do you want to work with us?
  • Ans. 

    I am impressed with the company's reputation and growth potential, and I believe my skills and experience align well with the job requirements.

    • I have researched the company and am impressed with its reputation and growth potential

    • I believe my skills and experience align well with the job requirements

    • I am excited about the opportunity to work with a talented team and contribute to the company's success

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

    I have the necessary skills, experience, and passion to excel in this role.

    • I have a proven track record of success in similar roles.

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

    • I am passionate about this industry and eager to contribute to its growth.

    • I have excellent communication and teamwork skills.

    • I am committed to delivering high-quality work and exceeding expectations.

  • Answered by AI
  • Q3. If we need you to transfer to another place ASAP and you haven't completed your current assignment, how would you handle it?
  • Ans. 

    I would prioritize completing my current assignment and then discuss the transfer with my supervisor to ensure a smooth transition.

    • I would communicate with my supervisor to understand the urgency of the transfer

    • I would prioritize completing my current assignment to the best of my ability

    • I would discuss the transfer with my supervisor to ensure a smooth transition

    • I would try to complete as much work as possible before l...

  • Answered by AI
  • Q4. What's the maximum number of runs a batsman can score in an ODI?
  • Ans. 

    A batsman can score a maximum of 264 runs in an ODI.

    • The maximum number of runs a batsman can score in an ODI is limited by the number of balls bowled and the number of boundaries hit.

    • The maximum number of balls bowled in an ODI is 300, assuming no extras are bowled.

    • If a batsman hits a boundary off every ball they face, they can score a maximum of 240 runs.

    • If a batsman hits sixes off every ball they face, they can score...

  • Answered by AI
  • Q5. Two jug problems, where you need to obtain a specified amount of water by using two differently sized jugs
  • Ans. 

    Solving two jug problems to obtain a specified amount of water using differently sized jugs.

    • Understand the capacity of each jug

    • Determine the amount of water needed

    • Fill one jug with water and pour it into the other jug

    • Repeat until the desired amount is reached

    • Use the remaining water in the larger jug to measure the remaining amount needed

    • Consider the possibility of multiple solutions

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Was resume shortlisted, nothing great about that.
Tips: Keep up the CPI, but I guess it's too late for that now.

Round: Test
Experience: Test wasn't too difficult. Can be cracked if you're in your game and have a chill mind.
Tips: General aptitude preparation should be started atleast before a month from placements. Solve GATE papers, institute placement tests, read CAT modules and their tips for faster problem solving. English needs time for those who haven't used it much in their childhood. But still the difficulty level of questions in these placement tests is easy.

Round: HR Interview
Experience: Was  generally good. Interviewer was young and we could connect.
Tips: It is extremely important that you remain calm. You need to tame that nervousness down. Think of the interview as a general talk with a stranger. Be your natural self. That's when the ideas hit you for the questions you haven't prepared. Practice interviewing with friends and read about the most common questions on the Interwebz.

Round: Puzzle Interview
Experience: Problems were easy. Asked for a pen and paper and slowly solved them.
Tips: Practice puzzles. There are some good sites for this.

Skills: Managing people, Analytical thinking
College Name: IIT BOMBAY

Skills evaluated in this interview

Analyst Interview Questions & Answers

Ola Cabs user image Tarun Meena

posted on 15 Jan 2015

Interview Preparation Tips

Round: Test
Experience: It was a very general aptitude test, including probability reasoning etc.
Tips: practice some CAT papers

Round: HR Interview
Experience: Very basic and general HR questions starting with tell me something about yourself and why this job?
Tips: You should have tailor made answers for tell me about yourself for different sectors/firms, this will help a lot, start preparing on this a month in advance.

College Name: IIT BOMBAY

Analyst Interview Questions & Answers

Ola Cabs user image Rahul Kandalam

posted on 14 Jan 2015

Interview Questionnaire 

7 Questions

  • Q1. Standard HR: Tell me about yourself, why this company and how do you think we help you reach your goals?
  • Q2. Tell me one cool thing you got to do at IIT
  • Ans. 

    I got to participate in a robotics competition at IIT

    • Designed and built a robot from scratch

    • Programmed the robot to complete tasks autonomously

    • Competed against other teams from different colleges

    • Learned valuable skills in engineering and teamwork

  • Answered by AI
  • Q3. Why did you choose IIT and do you regret it? What's different here?
  • Ans. 

    I chose IIT for its reputation and opportunities. No regrets. The environment is competitive and challenging.

    • IIT has a strong reputation for producing successful graduates

    • I was attracted to the opportunities for research and innovation

    • The academic environment is highly competitive and challenging

    • I have no regrets about my decision to attend IIT

  • Answered by AI
  • Q4. What is a portfolio? How do you measure risk?
  • Ans. 

    A portfolio is a collection of investments. Risk can be measured through standard deviation, beta, or value at risk.

    • A portfolio is a combination of different investments such as stocks, bonds, and mutual funds.

    • The purpose of a portfolio is to diversify investments and reduce risk.

    • Risk can be measured through standard deviation, which measures the volatility of returns.

    • Beta measures the sensitivity of a portfolio to mar...

  • Answered by AI
  • Q5. What is beta? What is Value at risk? What is formula for beta?
  • Ans. 

    Beta is a measure of a stock's volatility. Value at risk is a statistical measure of potential losses. Formula for beta is Covariance(Stock, Market) / Variance(Market).

    • Beta measures a stock's sensitivity to market movements.

    • Value at risk is the maximum potential loss that an investment portfolio may suffer within a given time frame.

    • Beta formula is calculated by dividing the covariance of the stock and market returns by...

  • Answered by AI
  • Q6. What is covariance? How does it measure sensitivity? What is volatility?
  • Ans. 

    Covariance measures the relationship between two variables. It measures sensitivity by indicating the direction of the relationship.

    • Covariance is a statistical measure that shows how two variables are related to each other.

    • It measures the direction of the relationship between two variables.

    • A positive covariance indicates that the two variables move in the same direction.

    • A negative covariance indicates that the two vari...

  • Answered by AI
  • Q7. What is WACC? How do value a company? Suggest a method that can help you decide on project undertaking?
  • Ans. 

    WACC is the weighted average cost of capital. To value a company, one can use various methods such as DCF, comparables, or precedent transactions. A method to decide on project undertaking is NPV analysis.

    • WACC is the average cost of all the capital a company has raised

    • To value a company, one can use DCF, comparables, or precedent transactions

    • DCF involves projecting future cash flows and discounting them back to present...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: It was not tough. Practiced lots of quant questions.Couldn't manage time for verbal. Overall, it was okay! I lost five minutes over one question.
Tips: Face the verbal questions at the end if there is no specific cut off.Score in quant and then touch verbal part.Don't spend more than 2 mins on a question.
Duration: 60 minutes
Total Questions: 60

Round: Interview
Experience: It was very informal and I told them that I got to work as a student consultant for a space mission when she asked me about the cool stuff I did here. I tried to impress her by telling her how I made use of my time here at IIT and how important it is to use the opportunities when they are at arm length distance.
Tips: Be honest and impress HR. Try to smile and be active. They like active and positive people.And prepare for standard HR questions.

Round: Interview
Experience: It was a pure finance interview as my resume as completely finance type.I told all questions without any issues and these are standard questions if you expect finance type profile.
Tips: Be sure of what you put in your resume. If you cannot answer what's in your resume, you will be screwed.Try to steer your interview towards your stronghold and then make it impressive.If you don't know anything, let them know. It is totally fine.

Skill Tips: "Focus your skills when they say: Tell me about yourself.So they will get back to you saying: "You were saying you are strong in this. Can you elaborate". Just screw it."
Skills: Finance Knowledge, Analytical
College Name: IIT Madras
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

They ask about general mathematics and logical reasoning question

Interview Preparation Tips

Interview preparation tips for other job seekers - Amazing company. Best from the rest

Analyst Interview Questions & Answers

Tracxn user image Jay Shankar Prasad

posted on 16 Oct 2023

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

I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

15 questions 30 Minuities

Round 2 - Case Study 

2 or 3 case study the will ask

Round 3 - HR 

(1 Question)

  • Q1. Regarding CTC & Interests in the org.

Interview Questionnaire 

3 Questions

  • Q1. Logical / Reasoning
  • Q2. Maximim number of slices that can be cut in cake
  • Ans. 

    The maximum number of slices that can be cut in a cake depends on the number of cuts made and the shape of the cake.

    • The maximum number of slices is equal to the number of cuts plus one.

    • The shape of the cake also affects the maximum number of slices that can be cut.

    • For a round cake, the maximum number of slices is equal to the number of cuts made along the diameter plus one.

    • For a rectangular cake, the maximum number of ...

  • Answered by AI
  • Q3. Price of a meal at particular restaurant.
  • Ans. 

    The price of a meal at a particular restaurant varies depending on the menu item chosen.

    • The restaurant's menu offers a range of prices for different dishes.

    • The price of a meal can also vary depending on the time of day or day of the week.

    • Additional charges such as taxes and tips may also apply.

    • For example, a burger and fries may cost $10, while a steak dinner may cost $30.

    • The restaurant may also offer specials or promo...

  • Answered by AI
Contribute & help others!
anonymous
You can choose to be anonymous

MagicPin Interview FAQs

How many rounds are there in MagicPin Analyst interview?
MagicPin interview process usually has 2-3 rounds. The most common rounds in the MagicPin interview process are Coding Test, One-on-one Round and Case Study.
How to prepare for MagicPin 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, Data Analytics, Statistics and Analytics.
What are the top questions asked in MagicPin Analyst interview?

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

  1. sql questions on joins and window functi...read more
  2. pivot tables in exc...read more

Recently Viewed

SALARIES

Freight Tiger

SALARIES

Cogoport

SALARIES

InsanelyGood

JOBS

MagicPin

No Jobs

SALARIES

Ecom Express

SALARIES

MagicPin

INTERVIEWS

MagicPin

No Interviews

REVIEWS

Baker Hughes

No Reviews

REVIEWS

Baker Hughes

No Reviews

SALARIES

Cogoport

Tell us how to improve this page.

MagicPin Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Analyst Interview Questions from Similar Companies

Zomato Analyst Interview Questions
3.8
 • 2 Interviews
View all
MagicPin Analyst Salary
based on 18 salaries
₹3.4 L/yr - ₹11 L/yr
27% more than the average Analyst Salary in India
View more details

MagicPin Analyst Reviews and Ratings

based on 4 reviews

2.5/5

Rating in categories

3.6

Skill development

1.0

Work-life balance

2.3

Salary

2.0

Job security

2.0

Company culture

1.4

Promotions

2.3

Work satisfaction

Explore 4 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
54 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