Add office photos
Filter interviews by
Macquarie Group Product Data Manager Interview Questions and Answers
Macquarie Group Product Data Manager Interview Experiences
1 interview found
Ashutosh Bajpai
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. Data Product Manager
(1 Question)
- Q1. Data governance and strategy
Psychometric test + aptitude
Interview questions from similar companies
Anonymous
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. SQL and Python and Spark related questions
- Q2. Project-oriented questions
(2 Questions)
- Q1. Coding and AWS cloud-related questions like GLUE, LAMBDA, Redshift etc
- Q2. Project and managerial-related questions
Data Analyst Interview Questions & Answers
ANZ Operations & Technology
PRITISAGAR SAHU
posted on 8 Nov 2024
(1 Question)
- Q1. How you calculate the tdi and mdi of a customer in sql
- Ans.
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.
Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.
Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.
Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
They asked about the sas,sql,and power bi
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(3 Questions)
- Q1. SQL Window functions
- Q2. Excel computed fields in pivot tables
- Ans.
Excel pivot tables allow users to create computed fields using formulas.
In Excel pivot tables, computed fields are created by adding a new field with a formula.
Formulas can be simple arithmetic operations or more complex calculations.
Computed fields can be used to perform calculations on existing data in the pivot table.
Examples: calculating profit margin by dividing revenue by cost, calculating average sales per month
- Q3. Difference in precision and recall
- Ans.
Precision is the ratio of correctly predicted positive observations to the total predicted positives, while recall is the ratio of correctly predicted positive observations to the all observations in actual class.
Precision focuses on the accuracy of positive predictions, while recall focuses on the proportion of actual positives that were correctly identified.
Precision = TP / (TP + FP)
Recall = TP / (TP + FN)
Example: In...
(2 Questions)
- Q1. About past experience
- Q2. Past project details
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There were 4 interview rounds.
Basic aptitude questions
Data structure and algorithms
(1 Question)
- Q1. Java, SQL questions
(1 Question)
- Q1. Casual talk about roles
Saurabh Gupta
(1 Question)
- Q1. PartitionBy vs bucketBy in spark
Selected
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Basic aptitude test like distance problem , age etc
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.
(1 Question)
- Q1. Python data types, SQL medium to complex, Spark medium question
(1 Question)
- Q1. SQL complex, Spark theory
(1 Question)
- Q1. Basic HR questions
Interview Preparation Tips
- Python
- SQL
- Spark
I applied via Job Fair and was interviewed in Oct 2024. There were 2 interview rounds.
About General English Grammer
About your personal description
Interview Preparation Tips
- general
Make eye contact which person is interviewing
Be polite and neat
I applied via Recruitment Consultant and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Data manipulation using pandas and SQL
- Ans.
Data manipulation using pandas and SQL
Pandas is a Python library used for data manipulation and analysis
SQL is a language used for managing relational databases
Pandas can read data from SQL databases using the read_sql() function
Data can be filtered, sorted, grouped, and aggregated using pandas functions
SQL queries can be executed using pandas' read_sql_query() function
Interview Preparation Tips
Skills evaluated in this interview
Macquarie Group Interview FAQs
Tell us how to improve this page.
Macquarie Group Interviews By Designations
- Macquarie Group Senior Associate Interview Questions
- Macquarie Group Assistant Manager Interview Questions
- Macquarie Group Executive Interview Questions
- Macquarie Group Manager Interview Questions
- Macquarie Group Associate Interview Questions
- Macquarie Group Associate Vice President Interview Questions
- Macquarie Group Data Analyst Interview Questions
- Macquarie Group Data Analyst Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Macquarie Group Product Data Manager Reviews and Ratings
based on 1 review
Rating in categories
|
Assistant Manager
658
salaries
|  ₹11.8 L/yr - ₹30 L/yr |
|
Executive
545
salaries
| ₹9 L/yr - ₹25 L/yr |
|
Manager
404
salaries
| ₹16 L/yr - ₹38 L/yr |
|
Senior Associate
379
salaries
| ₹5.5 L/yr - ₹20 L/yr |
|
Assistant Vice President
252
salaries
| ₹24.5 L/yr - ₹47.7 L/yr |
Citigroup
Goldman Sachs
Morgan Stanley
JPMorgan Chase & Co.
Calculate your in-hand salary
- Home >
- Interviews >
- Macquarie Group Interview Questions >
- Macquarie Group Product Data Manager Interview Questions
