Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MathCo Team. If you also belong to the team, you can get access from here

MathCo Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

MathCo Junior Data Analyst Interview Questions and Answers

Updated 16 Feb 2022

MathCo Junior Data Analyst Interview Experiences

2 interviews found

Round 1 - Coding Test 

Basic python programs, pandas, SQL

Round 2 - Technical 

(1 Question)

  • Q1. Knowledge about case studies
Round 3 - HR 

(1 Question)

  • Q1. Why should we hire you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to have basic knowledge on python, SQL and case studies on ML
Round 1 - Coding Test 

Basic python programs, pandas, SQL

Round 2 - Technical 

(1 Question)

  • Q1. Knowledge about case studies
Round 3 - HR 

(1 Question)

  • Q1. Why should we hire you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to have basic knowledge on python, SQL and case studies on ML

Junior Data Analyst Interview Questions Asked at Other Companies

asked in Morningstar
Q1. What is the main difference between data mining and data analysis ... read more
asked in Mep Media
Q2. How do you use 'PARTITION BY` and `ORDER BY in window functions
asked in Mep Media
Q3. What is SQL, and why is it important in data analytics
asked in Cognizant
Q4. Difference between Adverse Event and Adverse reaction with exampl ... read more
asked in Mep Media
Q5. What is the difference between 'WHERE` and 'HAVING` clauses

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(3 Questions)

  • Q1. What is Overfitting in decision tree
  • Ans. 

    Overfitting in decision trees occurs when the model learns noise in the training data rather than the underlying pattern.

    • Overfitting happens when the decision tree is too complex and captures noise in the training data.

    • It leads to poor generalization on unseen data, as the model is too specific to the training set.

    • To prevent overfitting, techniques like pruning, setting a minimum number of samples per leaf, or using en

  • Answered by AI
  • Q2. What is bagging
  • Ans. 

    Bagging is a machine learning ensemble technique where multiple models are trained on different subsets of the training data and their predictions are combined.

    • Bagging stands for Bootstrap Aggregating.

    • It helps reduce overfitting by combining the predictions of multiple models.

    • Random Forest is a popular algorithm that uses bagging by training multiple decision trees on random subsets of the data.

  • Answered by AI
  • Q3. What is neuron How its used in DL
  • Ans. 

    A neuron is a basic unit of a neural network that receives input, processes it, and produces an output.

    • Neurons are inspired by biological neurons in the human brain.

    • They receive input signals, apply weights to them, sum them up, and pass the result through an activation function.

    • Neurons are organized in layers in a neural network, with each layer performing specific tasks.

    • In deep learning, multiple layers of neurons ar...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 

(2 Questions)

  • Q1. They asked about projects
  • Q2. They asked about projects and data analytics
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Python coding and sql coding

Round 2 - Technical 

(2 Questions)

  • Q1. List all the string which start with 'a'
  • Ans. 

    List of strings starting with 'a'

    • Use a loop to iterate through each string

    • Check if each string starts with 'a'

    • Add the string to the list if it starts with 'a'

  • Answered by AI
  • Q2. Find out max value from the given table
  • Ans. 

    Use SQL query to find max value from a table

    • Use SQL query SELECT MAX(column_name) FROM table_name;

    • For example, SELECT MAX(salary) FROM employees;

    • Ensure proper column name and table name are used in the query

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - great experience

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

SQL and quant, logical questions were asked.

Round 3 - Technical 

(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
Round 4 - Technical 

(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

Interview preparation tips for other job seekers - Have a knowledge on your resume completely and prepare SQL and python libraries very well. Practice guestimates questions as well.

I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Basic spark questions like optimization techniques
  • Q2. Reparation coalesce joins
  • Q3. Slowly change data handling in spark
  • Ans. 

    Slowly changing data handling in Spark involves updating data over time.

    • Slowly changing dimensions (SCD) are used to track changes in data over time.

    • SCD Type 1 updates the data in place, overwriting the old values.

    • SCD Type 2 creates a new record for each change, with a start and end date.

    • SCD Type 3 adds a new column to the existing record to track changes.

    • Spark provides functions like `from_unixtime` and `unix_timestam

  • Answered by AI
  • Q4. Cumulative sum and rank functions in spark
  • Ans. 

    Explanation of cumulative sum and rank functions in Spark

    • Cumulative sum function calculates the running total of a column

    • Rank function assigns a rank to each row based on the order of values in a column

    • Both functions can be used with window functions in Spark

    • Example: df.withColumn('cumulative_sum', F.sum('column').over(Window.orderBy('order_column').rowsBetween(Window.unboundedPreceding, Window.currentRow)))

    • Example: df...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't waste time. Think twice before attending. Keep as backup offer

Skills evaluated in this interview

I applied via AngelList and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Behaviour round questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of python and behavioral questions

I applied via Naukri.com and was interviewed in Sep 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. There is online test is totally on SQL please prepare for SQL. There are 3 rounds in which first online test based on sql then 2nd is technical round and 3rd Manager round. Technical round on sql and machi...

Interview Preparation Tips

Interview preparation tips for other job seekers - Mainly Please prepare for SQL, Machine Learning and case study.

Interview Questionnaire 

1 Question

  • Q1. Round 1: Coding round, Round 2: Basic and conceptual from Spark and Hive, Round 3: In Depth question from Spark and Hive, Write code in Spark and Hive.

Interview Preparation Tips

Interview preparation tips for other job seekers - They will grill you on whatever knowledge you have in Big data. Be very thorough and confident with your concepts. Also, Practice SQL and Spark codes. They will ask you to write an application in Spark.

MathCo Interview FAQs

How many rounds are there in MathCo Junior Data Analyst interview?
MathCo interview process usually has 3 rounds. The most common rounds in the MathCo interview process are Coding Test, Technical and HR.

Tell us how to improve this page.

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Zeta Interview Questions
3.3
 • 69 Interviews
Kiya.ai Interview Questions
3.4
 • 48 Interviews
Subex Interview Questions
3.5
 • 35 Interviews
View all
MathCo Junior Data Analyst Salary
based on 4 salaries
₹4.5 L/yr - ₹5 L/yr
11% more than the average Junior Data Analyst Salary in India
View more details
Analyst
229 salaries
unlock blur

₹4 L/yr - ₹11 L/yr

Senior Associate
227 salaries
unlock blur

₹10 L/yr - ₹28 L/yr

Data Analyst
188 salaries
unlock blur

₹3 L/yr - ₹9.7 L/yr

Associate
142 salaries
unlock blur

₹6 L/yr - ₹17 L/yr

Data Scientist
127 salaries
unlock blur

₹6 L/yr - ₹19 L/yr

Explore more salaries
Compare MathCo with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

LatentView Analytics

3.7
Compare

Tiger Analytics

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