Upload Button Icon Add office photos

Macquarie Group

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Macquarie Group Data Analyst Interview Questions and Answers

Updated 14 Jul 2024

Macquarie Group Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image shivam jindal

posted on 14 Jul 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Sql questions based on aggregate and window

Round 2 - Technical 

(2 Questions)

  • Q1. Sql on windows function
  • Q2. Python data and spark questions

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: There were 15 questions from quant’s, 10 questions from data interpretation with 1 mark each and -.5 for wrong answer also there were 2 case studies with 10 marks each with no –ve marks. Total 45 marks question, I did only 9 from quant and 7 from DI total 16 out of 25 questions and didn’t touch case studies. Quanta and DI were very basics level.

In those 16, 1 question was wrong so basically I did 14.5 out of 45, but with a accuracy of 90%. Didn’t expect to get shortlisted but was very tensed and angry upon myself coz it was my level paper. But around 12 mid night shortlist came and I was at 11th position out of 31 students in the list.

There were total around 90 students who appeared for written test. They allowed Mtech and Mca guys not Btech.
Total Questions: 25

Round: TECHNICAL INTERVIEW
Experience: I went there and greeted him. Firstly he told me to introduce myself, later he asked what I like the most. I told analytical thinking and logical reasoning and yeah I relate it with data base.(since I knew they came for Data analyst profile).

He asked me about join, gave me a table and told me to perform all joins. I did that and he asked me about Order by clause and, having clause then asked me normal forms up to bcnf.

Later asked about pl/sql difference b/w sql and pl/sql, what is trigger explain in detail. Some basics questions of DBMS theory asked me about my 2 projects and at the end he gave me a situation where I have a grocery shop outside nit Surathkal, and from last few days/months I realized a downfall in sales, what possible reasons could I find? I gave him 8 reasons within 2/3 mins. He was impressed…

After 1st round out of 31 only 13 were selected and I was there in d list.

Round: TECHNICAL INTERVIEW
Experience: As soon as I entered the room, mam told me “Ooo tum aao aao ”. I smiled because I was the 1st guy during presentation who asked the first question (she made every1 clap for me there) and she remembered my face. And eventually she did study from IIT Kanpur so yes she was able to speak fluent Hindi (plus point for guys like me :p). with her there was a guy he asked me to write code for taking a no and converting it into binary and 1 question from array- very simple later she gave me a table with employee id, order date and order amount. A customer can place max 1 order in 1 day. I had to find the latest transaction of every customer with amount as well. i did it using max function over date and group by with sub query, she asked me about my resume at the end she gave me 7,9,21,63,100 and told me to find the no of numbers between 1 to 50000 which are exactly divisible by all, i did it in 1 min.

but she was smiling, I thought I made some mistake in hurry, then I asked mam m I doing right or wrong (in curiosity as I find very comfortable there) she smiled and said “Chalo bhago ynha se ye interview h ”.I said sorry but yeah she was impressed with my interview so told ki “you will learn all these things very quickly”.

Round: TECHNICAL INTERVIEW
Experience: After 2nd round 9 were selected and I was one of them. It was basically a Managerial round and it scheduled over Skype. I had to introduce myself as well as my family background. Here comes the harder part when he asked me why you have such a poor academic back ground? I was speechless for a moment but I started telling the truth.

I told despite getting 68% marks in my 10th I was the third topper of my class. I got 60.66 % in 12th but yeah there also out of 700 students only 14 got first division. So basically I concluded that in my state board marking is not that much good. He said ok but what happened in graduation(64%) when you studied in Delhi?(what to say now :p) I said sir I did it from IGNOU and you can Google the fact that even less than 5% of student are able to clear the degree in 3 years. Later I explicitly mentioned that I m not blaming my boards but this is the fact which can’t be change.

Now He asked what happened in PG here also you scored only 7.50 CGPA which is less than even standard score of 8(Meri to jaan hi nikal gayi :p). Then I told him that sir u can see my pointer in first semester is very less close to 6.5 but after that I constantly improved myself. He was smiling …..

He asked me about my family background and then I told him how I struggled, I was giving tuition in my grads to continue my education and after grads took a gap of 1 year and cleared all MCA entrance examination and now sitting in front of him.

Later asked about my best qualities….i told him that I can lead group of people very well. I gave example of me being captain of my department cricket team and I was class monitor through 3rd to 12th std and also some stuff regarding my college events. He noted down something .I don’t know what.

I was not sure that I could clear that interview. When the result came they called all 9 students and said that they find is difficult to eliminate 4 names .i was sure that I m out of picture now but fortunately my name was at 2nd position. Wowwwww

Round: HR Interview
Experience: It was telephonic round and just my hobbies and all, he asked me about my poetry writing hobby as well as Hindi Shayaris. I was told to recite 1 …when he listened, he was very impressed…

College Name: IIT KANPUR

I was interviewed in Oct 2016.

Interview Questionnaire 

4 Questions

  • Q1. Select any five companies you would invest in and why given the required metrics.
  • Ans. 

    I cannot provide investment advice, but here are five companies that have shown strong financial performance in recent years.

    • Apple - consistently high revenue and profit margins

    • Amazon - dominant player in e-commerce and cloud computing

    • Microsoft - strong growth in cloud computing and enterprise software

    • Alphabet (Google) - diversified revenue streams and strong advertising business

    • Visa - dominant player in the payments i

  • Answered by AI
  • Q2. Questions based on case study.
  • Q3. Detailed discussions on the indian economy?
  • Q4. Brexit vote and how it would effect the indian economy?
  • Ans. 

    The Brexit vote could have both positive and negative effects on the Indian economy.

    • Positive effects: Increased trade opportunities with the UK, potential for attracting foreign investments from companies relocating from the UK.

    • Negative effects: Uncertainty in global markets leading to volatility in exchange rates, potential decline in exports to the UK.

    • Example: Indian IT companies may face challenges due to stricter i...

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: We were first taught the basics of operations involved in working with an investment bank. Based on the workshop we were given a case study with a list of companies to select the one's which are potencial candidates for investments. We were all divided into groups of 5 students.

Round: Test
Experience: The test was basic. Economical aptitude requires prior knowledge of economics concepts. The review topicwas GST bill.
Duration: 1 hour
Total Questions: 41

Round: Stress Interview
Tips: It is important to be aware about the current events and economies.

Skills: Economic Affairs, Financial Economics, Knowledge On Current Affairs
College Name: Thapar University, Patiala

I was interviewed before Jun 2016.

Interview Questionnaire 

6 Questions

  • Q1. Tell me about yourself from the day u were born till today (Stopped mid way when I mentioned the finance course)
  • Q2. What is a Brownian motion? Properties of Brownian motion?
  • Ans. 

    Brownian motion is the random motion of particles in a fluid due to collisions with other particles.

    • Brownian motion was first observed by Robert Brown in 1827.

    • It is named after the botanist Robert Brown.

    • The motion is caused by the random movement of fluid molecules.

    • Brownian motion is a continuous-time stochastic process.

    • It is often used to model various phenomena in physics, finance, and biology.

    • Properties of Brownian ...

  • Answered by AI
  • Q3. What is a Martingale? What are Markov Processes? Is Martingale a Markov Process? Are Markov Processes Martingales?
  • Ans. 

    A Martingale is a mathematical concept used in probability theory and statistics. Markov Processes are stochastic processes that satisfy the Markov property.

    • A Martingale is a sequence of random variables where the expected value of the next variable, given the current and past variables, is equal to the current variable.

    • Markov Processes are stochastic processes where the future state depends only on the current state a...

  • Answered by AI
  • Q4. Then the HR guy asked me One trait of mine that I’m not proud of?
  • Q5. Then there was a puzzle m2 = n2 + 32294 ( It was also asked in last year’s interview)
  • Q6. Then there was another HR question, In a group would it be better for me to assume a leadership position or simply be a part of it? Why?

Interview Preparation Tips

Round: Test
Experience: The Maths section had questions on basic probability and statistics. Also the Maths section had a higher weight age than the other sections (Questions carrying 3 marks each while other sections had 1 or 2 marks for each question. They were here, offering a quant profile so that justifies the distribution.) The DI/Quant (2 marks each) and English (1 Mark Each) section were similar to CAT. The finance section had questions on Basic Accounting. Anyone who did well in the Maths section could find his name in the shortlist.

Round: Technical + HR Interview
Experience: Possible Lapses: I

Data Analyst Interview Questions & Answers

Barclays user image Harshu Tiwari n

posted on 2 Dec 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

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 - Aptitude Test 

1 hours for aptitude and few coding

Round 3 - Technical 

(1 Question)

  • Q1. Easy question of DS and maths

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy question about DS and maths and few python
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Case Study 

MCQ were asked which were case study focused on basic mathematics.

Round 2 - One-on-one 

(1 Question)

  • Q1. How is ChatGPT good and bad at the same time?
  • Ans. 

    ChatGPT is good at generating human-like responses quickly, but can also produce inaccurate or biased information.

    • Good: ChatGPT can provide quick responses to user queries, saving time and effort.

    • Bad: ChatGPT may generate inaccurate information or biased responses based on the data it was trained on.

    • Good: ChatGPT can assist in customer service by answering frequently asked questions efficiently.

    • Bad: ChatGPT may lack em...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and make sure you can answer anything asked from your resume.

Skills evaluated in this interview

Round 1 - One-on-one 

(2 Questions)

  • Q1. What databases have you worked on?
  • Ans. 

    I have worked on various databases including MySQL, Oracle, and MongoDB.

    • MySQL

    • Oracle

    • MongoDB

  • Answered by AI
  • Q2. Diferent types of join
  • Ans. 

    Different types of join are inner join, left join, right join, and full outer join.

    • Inner join returns only the matching rows from both tables.

    • Left join returns all the rows from the left table and matching rows from the right table.

    • Right join returns all the rows from the right table and matching rows from the left table.

    • Full outer join returns all the rows from both tables, with NULL values in the columns where there ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL questions from W3school. Read you JD in detail.

Skills evaluated in this interview

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

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

Round 1 - Aptitude Test 

Generic maths questions

Round 2 - Coding Test 

Online platform coding challenge

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and mostly questions revolve around prior work experience.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning ,quantitative aptitude

Round 2 - Coding Test 

2 coding questions,one was easy and other was medium to tough level

Round 3 - Technical 

(2 Questions)

  • Q1. Sql basics were asked and asked me to write few sql codes
  • Q2. Python codes ,and machine learning concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - ger a good knowledge in SQL, SAS , python , Machine Learning
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Get the maximum salary of the employee from the employee and department table
  • Q2. Explain the data analysis process that you would follow for employee salary table
  • Ans. 

    The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.

    • Start by cleaning the data to remove any duplicates, missing values, or outliers.

    • Explore the data by calculating basic statistics like mean, median, and standard deviation.

    • Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

    • Perform statistical modeling to an...

  • Answered by AI
  • Q3. Explain the challenges you faced in your project
  • Ans. 

    I faced challenges in managing large datasets and ensuring data accuracy in my project.

    • Managing large volumes of data from multiple sources

    • Ensuring data accuracy and consistency

    • Dealing with missing or incomplete data

    • Handling data cleaning and preprocessing tasks

    • Addressing technical issues with data storage or processing tools

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

Macquarie Group Interview FAQs

How many rounds are there in Macquarie Group Data Analyst interview?
Macquarie Group interview process usually has 2 rounds. The most common rounds in the Macquarie Group interview process are Coding Test and Technical.
How to prepare for Macquarie Group 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 Macquarie Group. The most common topics and skills that interviewers at Macquarie Group expect are Asset Management, Business Improvement, Business operations, Compliance and Data Management.
What are the top questions asked in Macquarie Group Data Analyst interview?

Some of the top questions asked at the Macquarie Group Data Analyst interview -

  1. Python data and spark questi...read more
  2. Sql on windows funct...read more

Recently Viewed

SALARIES

Netradyne Technology

SALARIES

SLB Logistics

INTERVIEWS

Patil Group

No Interviews

INTERVIEWS

NoBroker

No Interviews

INTERVIEWS

TCS

No Interviews

JOBS

Netradyne Technology

No Jobs

INTERVIEWS

Trimble

No Interviews

SALARIES

SLB Logistics

SALARIES

Eurofins It Solutions

INTERVIEWS

ZS

No Interviews

Tell us how to improve this page.

Macquarie Group Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Macquarie Group Data Analyst Salary
based on 6 salaries
₹5.5 L/yr - ₹13 L/yr
32% more than the average Data Analyst Salary in India
View more details

Macquarie Group Data Analyst Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Assistant Manager
657 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
534 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
407 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
359 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Vice President
251 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Macquarie Group with

Goldman Sachs

3.5
Compare

Morgan Stanley

3.7
Compare

JPMorgan Chase & Co.

4.0
Compare

UBS

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