MathCo Trainee Junior Data Analyst Interview Questions and Answers

General aptitude questions

Was given a topic and asked to talk about for 2 mins

Q1. Why LatentView?
Ans. 
LatentView offers a dynamic work environment with opportunities for growth and learning in the field of analytics.
• LatentView has a strong reputation in the analytics industry for delivering innovative solutions to clients.

• The company values continuous learning and development, providing employees with opportunities to enhance their skills.

• LatentView offers a collaborative work culture where employees can work on divers...read more
Answered by AI
Add your answer
Q2. What do you expect from us?
Ans. 
I expect a supportive work environment, opportunities for growth, and clear communication.
• Supportive work environment where I can collaborate with team members

• Opportunities for growth and advancement within the company

• Clear communication regarding expectations, feedback, and goals
Answered by AI
Add your answer

Basic coding questins

Q1. All based on my project
Add your answer

Aptitude test was easy, you can prepare it with online available resources

We were asked to complete few games which were related to logical thinking

It was a common topic and was 1 hour long

Q1. They asked basic sql question like joins, windows function, subqueries. Also they asked one guestimate and a case study. Guestimate- No. of IPhone stores in delhi Case study - How to increase the profit of...read more
Add your answer

Blood Relations, Pipes and Cisterns, Time and work etc.

Question based on hashmap

Is Artificial Intelligence boon or ban.

Q1. Python and SQL questions
Add your answer
Q2. Python and Numpy, Pandas
Add your answer

Q1. Basic SQL questions
Add your answer
Q2. Statistical questions
Add your answer

Difficult aptitude, had to solve a lot of problems in 2 hrs

GD topic was "online vs offline education "

Q1. SQL question on self join
Add your answer
Q2. Guesstimate on number of cars sold in delhi
Ans. 
Approximately 1.5-2 million cars are sold in Delhi annually.
• Consider population of Delhi (approx. 20 million)

• Assume car ownership rate (approx. 10%)

• Factor in replacement rate and new buyers
Answered by AI
Add your answer

8 python coding
With 2 aptitude

Game based assessment.
More than 8 games need to play

Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
Add your answer
Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
Ans. 
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
• There are four types of joins in SQL: inner join, left join, right join, and full outer join.

• Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.

• Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...read more
Answered by AI
Add your answer

Get questions from all topics and medium level questions

They give one topic and provide one minute for thinking its overall 30 min discussion

Q1. Total technical rounds 1)basic resume questions, python and sql questions. 2)same round 1 but a little bit extra dose 3) managerial round
Add your answer
Q2. List, tuple, oops concept. joins from sql
Add your answer

Q1. Why latent view why analytics best achivemnts
Ans. 
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
• Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.

• Analytics provides a systematic approach to analyzing data and extracting meaningful insights.

• My best achievement is developing a predictive model for customer churn that helped
Answered by AI
Add your answer