PubMatic Data Analyst Interview Questions and Answers

Q1. All basic concepts of pthon sql and ml
Add your answer

Apptitude, tecncal, cognitiive

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

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

It was easy to approach!

Discussions about common topics like boon or bane to society

Asked about the scenarios

Q1. Technical round related to skills and resume
Add your answer

Q1. Discussions regarding work culture and compensations
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

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

Q1. Tell about yourself
Ans. 
I am a data analyst with a background in statistics and programming, passionate about turning data into actionable insights.
• Background in statistics and programming

• Experience in data analysis and visualization tools like Python, R, and Tableau

• Strong problem-solving skills and attention to detail

• Ability to communicate complex data findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Rate yourself in sql
Ans. 
I rate myself as proficient in SQL with experience in writing complex queries and optimizing database performance.
• Proficient in writing complex SQL queries

• Experience in optimizing database performance

• Familiar with database management systems like MySQL, PostgreSQL, etc.
Answered by AI
Add your answer