AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
MathCo
Compare
Filter interviews by
MathCo Junior Data Analyst Interview Questions and Answers
MathCo Junior Data Analyst Interview Experiences
2 interviews found
Anonymous
Basic python programs, pandas, SQL
(1 Question)
- Q1. Knowledge about case studies
(1 Question)
- Q1. Why should we hire you?
Interview Preparation Tips
Basic python programs, pandas, SQL
(1 Question)
- Q1. Knowledge about case studies
(1 Question)
- Q1. Why should we hire you?
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Oct 2022. There were 4 interview rounds.
SQL and quant, logical questions were asked.
(1 Question)
- Q1. 1. Tell me about your self 2. Resume based questions 3. Need to write basic SQL queries and also print same output using pandas
(1 Question)
- Q1. 1. Tell me about your self 2. Statistics questions 3. Guestimates 4. Why do you want to join company
Interview Preparation Tips
I applied via Company Website and was interviewed before Jan 2024. There were 2 interview rounds.
SQL Test
3 questions for Solution using SQL queries.
(4 Questions)
- Q1. SQL queries using window function
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a specific subset of rows within a table.
They are commonly used with aggregate functions like SUM, AVG, and COUNT.
Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().
- Q2. Resume questions
- Q3. Past experience
- Q4. KPI that you have created
- Ans.
I created a KPI to measure customer retention rate.
Developed formula to calculate percentage of customers retained over a specific period
Monitored customer churn rate to track effectiveness of retention strategies
Analyzed customer feedback and behavior to identify factors influencing retention
Implemented initiatives to improve customer retention based on data insights
Interview Preparation Tips
Then he had bad internet connectivity he didnt hear my responses properly
(1 Question)
- Q1. What are the SQL commands can you explain it
- Ans.
SQL commands are used to interact with databases to perform various operations like querying, updating, and deleting data.
SELECT: Retrieves data from a database
INSERT INTO: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
CREATE TABLE: Creates a new table in the database
ALTER TABLE: Modifies an existing table structure
DROP TABLE: Deletes a table from the databas
Skills evaluated in this interview
Selected
I appeared for an interview before Feb 2024.
The platform used was Deselect, which featured questions on Python, SQL, and aptitude.
(3 Questions)
- Q1. Asked some python and sql questions.
- Q2. Questions regarding sql joins, having where clause.
- Q3. Some machine learning questions on regression, classification, confusion matrix, assumptions of linear regression, how bagging boosting works.
(2 Questions)
- Q1. Asked questions related to projects mentioned in resume
- Q2. Asked me to explaind the credit card fraud detection project end to end.
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
Basic quants test had to attend.
Interview Preparation Tips
- Python
- SQL
- powerbi
(2 Questions)
- Q1. They asked about projects
- Q2. They asked about projects and data analytics
I applied via Referral
Interview Questionnaire
4 Questions
- Q1. I was asked to write the algorithm of checking
- Q2. How many mobile phones are sold each year in India
- Ans.
Approximately 150-200 million mobile phones are sold each year in India.
India is the second-largest smartphone market in the world after China.
The number of mobile phone users in India is expected to reach 1.25 billion by 2020.
The Indian smartphone market grew by 7% YoY in 2019.
Major players in the Indian smartphone market include Xiaomi, Samsung, and Vivo.
- Q3. How many tube lights are there in the city of Mumbai
- Ans.
It is not possible to accurately determine the number of tube lights in the city of Mumbai.
The number of tube lights in a city is not publicly available information.
The city of Mumbai has a large population and a vast number of buildings, making it impossible to count all the tube lights.
The number of tube lights can vary greatly depending on factors such as residential, commercial, and industrial areas.
Even if we cons...
- Q4. Three different puzzles
Interview Preparation Tips
Experience: The Test is in lines of what we prepare for all the major competitive exams, similar to CAT. The difficulty level is moderate to easy. No negative marking. Cut off were sectional as well as overall.
It was overall a smooth ride. The results were given an hour later after the test.
Tips: Attempt your strong section first. Maintain accuracy and try and be fast in solving.
Duration: 60 minutes
Total Questions: 60
Round: Guesstimate Interview
Experience: It was pretty smooth. They generally look for your thought process rather than the exact figure. Expect cross questions on your solution.
Round: Puzzle Interview
Experience: This round was combined with the Guesstimate question. The puzzles were of a good level. But if you like solving them in your free time, you would fare well here.
Skills: Analyzing And Problem Solving Skills, Logical Thinking
College Name: KJ Somaiya Institute Of Management Studies And Research
Motivation: Its into Analytics industry. I like the the culture and the people. Wish to build a career in Analytics.
I applied via Campus Placement and was interviewed before Oct 2020. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Tell me. Something about yourself
- Q2. Probability question on dice, guesstimate on Delhi Metro, Resume Based, Projects in Detail
- Q3. Behavioral as well as Mathematical questions
Interview Preparation Tips
MathCo Interview FAQs
Tell us how to improve this page.
MathCo Interviews By Designations
- MathCo Analyst Interview Questions
- MathCo Data Analyst Interview Questions
- MathCo Trainee Analyst Interview Questions
- MathCo Senior Associate Interview Questions
- MathCo Delivery Manager Interview Questions
- MathCo Associate Data Scientist Interview Questions
- MathCo Data Scientist Interview Questions
- MathCo Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Junior Engineer Interview Questions
- Junior Medical Coder Interview Questions
- Junior Resident Doctor Interview Questions
- Junior Software Developer Interview Questions
- Junior Executive Interview Questions
- Junior Research Analyst Interview Questions
- Junior Software Engineer Interview Questions
- Junior Research Associate Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Associate
225
salaries
|  ₹10 L/yr - ₹28 L/yr |
|
Analyst
214
salaries
| ₹4 L/yr - ₹8.2 L/yr |
|
Data Analyst
200
salaries
| ₹3 L/yr - ₹8.2 L/yr |
|
Data Scientist
139
salaries
| ₹4.9 L/yr - ₹19 L/yr |
|
Associate
130
salaries
| ₹7 L/yr - ₹17 L/yr |
Fractal Analytics
Kiya.ai
Subex
Zeta
- Home >
- Interviews >
- MathCo Interview Questions >
- MathCo Junior Data Analyst Interview Questions
