AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Wunderman Thompson MSC Data Analyst Interview Questions and Answers
Wunderman Thompson MSC Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.
(2 Questions)
- Q1. Campaign Management life cycle
- Q2. SQL joins and how to prioritise the work
- Ans.
SQL joins are used to combine data from multiple tables. Prioritising work involves understanding the business requirements.
Understand the business requirements and which tables need to be joined
Choose the appropriate join type (inner, outer, left, right)
Optimise the query by selecting only necessary columns and filtering data before joining
Consider the size of the tables being joined and the performance impact
Test and
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self Introduction
- Q2. Salary Expectation
(1 Question)
- Q1. 14 questions in excel formulas
Interview Preparation Tips
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Complex sql scenarios and their results
- Ans.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
Interview Preparation Tips
Skills evaluated in this interview
Selected
Object Detection on a subset of COCO dataset having Cars and Person classes
(1 Question)
- Q1. Technical discussion on Machine Learning, Deep Learning Concepts and coding round.
(1 Question)
- Q1. Technical discussion on Deep Learning and Computer Vision.
Srinivasa moorthy
(1 Question)
- Q1. Explain process in adf
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.
You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.
ADF supports a wide range of d...
Skills evaluated in this interview
Ido Edel
Selected
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
(1 Question)
- Q1. Tell me about yourself
What different between having and where
Interview Preparation Tips
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self Introduction
- Q2. Salary Expectation
(1 Question)
- Q1. 14 questions in excel formulas
Interview Preparation Tips
Data Engineer Interview Questions & Answers
Saama Technologies
Gautamee Jakinkar
posted on 29 May 2024
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries
(1 Question)
- Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...
Interview Preparation Tips
- SQL
- Python
- Pyspark
Selected
I applied via Walk-in and was interviewed before Jul 2023. There were 2 interview rounds.
Given with 60 questions to complete in 1 hour.
(1 Question)
- Q1. Manager round basic introduction, college project and your role and contribution in it.
(1 Question)
- Q1. Related to data warehouse
(1 Question)
- Q1. Python, data warehouse, data modelling
Wunderman Thompson MSC Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
Wunderman Thompson MSC Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Analyst
10
salaries
|  ₹6 L/yr - ₹9.5 L/yr |
|
Analyst
7
salaries
| ₹2.5 L/yr - ₹8.1 L/yr |
|
Lead Analyst
6
salaries
| ₹8 L/yr - ₹10.5 L/yr |
|
Senior Developer
6
salaries
| ₹8 L/yr - ₹11 L/yr |
|
Campaign Execution Analyst
6
salaries
| ₹4.5 L/yr - ₹6.5 L/yr |
Ogilvy
Dentsu Communications
Havas Worldwide
Publicis
- Home >
- Interviews >
- Wunderman Thompson MSC Interview Questions >
- Wunderman Thompson MSC Data Analyst Interview Questions
