Upload Button Icon Add office photos

Filter interviews by

Clear (1)

IPG Mediabrands Senior Analyst Interview Questions and Answers

Updated 8 Oct 2024

IPG Mediabrands Senior Analyst Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Projects you did in previous organization?
  • Ans. 

    Led various projects in previous organization including data analysis, process improvement, and system implementation.

    • Implemented new data analysis tools to improve efficiency

    • Led a team in developing a process improvement strategy resulting in cost savings

    • Managed the implementation of a new system to streamline operations

  • Answered by AI
  • Q2. Reverse the String in python
  • Ans. 

    Reverse a string in Python using slicing

    • Use string slicing with a step of -1 to reverse the string

    • Example: 'hello'[::-1] will return 'olleh'

  • Answered by AI
  • Q3. Project in last organization
  • Ans. 

    Led a cross-functional team to implement a new CRM system

    • Managed project timeline and budget effectively

    • Collaborated with IT, sales, and marketing teams to gather requirements

    • Provided training and support to end users post-implementation

  • Answered by AI

Skills evaluated in this interview

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 Sep 2022. There were 2 interview rounds.

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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Tableau questions Sql questions And excel questions
  • Q2. What is data validation What is delete and truncate Delete and drop
  • Ans. 

    Data validation ensures data is accurate and useful. Delete removes specific records, truncate removes all records, drop removes entire table.

    • Data validation ensures data is accurate, complete, and useful for analysis

    • Delete removes specific records from a table based on a condition

    • Truncate removes all records from a table, but keeps the table structure

    • Drop removes an entire table from the database

    • Example: DELETE FROM t...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well

Senior Analyst Interview Questions Asked at Other Companies

Q1. Explain 3 statement financial model Calculating discount rate Cou ... read more
Q2. Tell me about your profile? What do you know about Transaction Mo ... read more
asked in Accenture
Q3. What do you understand by Budgeting and Forecasting?
Q4. Q4. What is the probability of getting 5 Sundays in 31 day month.
Q5. Q4. You are standing in a field. Chances of seeing atleast 1 plan ... read more

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basics of Campaign building
  • Q2. What is Ad network and Ad exchange
  • Ans. 

    Ad network is a platform that connects advertisers with publishers to display ads. Ad exchange is a marketplace for buying and selling ad inventory.

    • Ad network connects advertisers with publishers to display ads

    • Ad exchange is a marketplace for buying and selling ad inventory

    • Ad network typically charges a commission on ad spend

    • Ad exchange uses real-time bidding to determine the price of ad inventory

    • Examples of ad network...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Always know about each and every term that you write in your resume. Do not brag about something that you don't know. Be transparent and calculative about your knowledge and offer.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Resume, achievements, market dynamics
  • Q2. Case studies on Market operations , targets achievements

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, Answer politely and clearly...Dont beat on the bush
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com 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 Resume tips
Round 2 - HR 

(1 Question)

  • Q1. General question about your background companies you worked with relevant experience
Round 3 - Technical 

(2 Questions)

  • Q1. What is budgeting What is forecasting Foreign exchange diff AS 11 Prepare product budget
  • Ans. 

    Budgeting is the process of creating a financial plan for a specific period. Forecasting is predicting future financial outcomes.

    • Budgeting involves estimating income and expenses for a specific period

    • Forecasting involves predicting future financial outcomes based on past data and trends

    • Foreign exchange diff AS 11 refers to the accounting treatment of foreign exchange gains or losses

    • Preparing a product budget involves e...

  • Answered by AI
  • Q2. How you resolve team issues How you will forward report with some missing report
Round 4 - Technical 

(1 Question)

  • Q1. Diff between budget and forecasts Prepare a budget for buying software Salary expenses increase but head count is same Variance analysis
  • Ans. 

    Difference between budget and forecasts, preparing a software buying budget, salary expenses increase but head count is same, variance analysis.

    • Budget is a financial plan for a specific period, while forecast is an estimate of future financial outcomes.

    • Preparing a software buying budget involves identifying the software needs, researching prices, and allocating funds.

    • Salary expenses increasing while head count remains ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared about what written in your cv
And presentable

I applied via Recruitment Consulltant and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. End to end implementation cycle of isms
  • Ans. 

    The end to end implementation cycle of ISMS involves planning, implementation, monitoring, review, and improvement.

    • Planning involves identifying the scope, objectives, and risks of the ISMS.

    • Implementation involves designing and implementing controls to mitigate identified risks.

    • Monitoring involves regular checks to ensure the controls are effective.

    • Review involves assessing the effectiveness of the ISMS and identifying...

  • Answered by AI
  • Q2. Risk assessment steps
  • Ans. 

    Risk assessment involves identifying, analyzing, and evaluating potential risks to determine the likelihood and impact of those risks.

    • Identify potential risks

    • Analyze the likelihood and impact of each risk

    • Evaluate the risks to determine their priority

    • Develop a plan to mitigate or manage the risks

    • Monitor and review the risks regularly

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Enterprise risk assessment
  • Q2. Annex A control of iso 27001
  • Ans. 

    Annex A controls are the information security controls listed in ISO 27001 standard.

    • Annex A contains 114 controls categorized into 14 sections.

    • These controls are designed to ensure the confidentiality, integrity, and availability of information.

    • Examples of controls include access control, asset management, cryptography, incident management, and more.

    • Organizations must select and implement controls based on their risk a...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand standard thoroughly, and 1 cycle of implementation from scratch

I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 2 interview rounds.

Round 1 - Coding Test 

This is kind of mixed round with both technical questions followed by coding test.This position if for SR RPA developer(uipath) so I was asked about UiPath and then was asked to extract data from some pdf invoices using document understanding.
I was asked if I know Power BI,( if they have had a look at my resume before shortlisting my profile,they would have known that I dont have any exposure to power BI),Still they shortlisted it.

Round 2 - Technical 

(1 Question)

  • Q1. Combined tech and coding round

Interview Preparation Tips

Interview preparation tips for other job seekers - The whole story:
I was approached by a consultancy regarding this job opportunity with Dentsu,Bangalore COE.
Pathetic experience right from the beginning.
I told my CTC expectation and the HR(consultancy) was like 'Dentsu offers only 30-40% hike at max.'. and I was like ' what! When did RPA skillset become a non-digital skill, that too when digital profiles recruitment is on a peak stage. (Trust me the hike % have gone all time high during the last 3-4 months for digital skillset.), But after 1 day, HR replied back saying that the company is ok to match my expectation.(this was a bit fishy).
Then,
The interview was rescheduled 4 times because they want to conduct interview after 3PM and during weekdays only and also the interview is for 1 hr and 30 mins (which is pretty much busy time as I work during UK hours and also 1.30 hrs seriously?)
Finally I compromised and i took half day leave to attend the interview.
I've answered pretty much everything they asked and have completed the data extraction task within the given time but I dont know what made them drop my profile.
This is what I came to conclusion :
They needed someone who is having POWER BI,VBA experience with RPA tools knowledge.
Then why the hell have they raised a CO to hire an sr. RPA developer for UIPATH?
Are they expecting everything to be done by a single resource, if that's the expectation then here's my Tip "READ THE RESUMES PROPERLY" before shortlisting.
Here's my tip to those who attend interviews for similar positions in this company:
Don't waste your precious time and dont compromise.Just because they are offering a job doesn't mean you have to compromise. When interviews are being scheduled on weekdays and for experienced professionals, its a common sense that the schedule has to be based on common available times for both the parties and if the interview is going to be more than an hour,it has to be scheduled on a weekend.
The whole interview seemed to be a timepass activity as the people (2 persons) interviewing me dropped one after the other saying that they had some work. Lol.
I had to attend interview at the time they wanted and by applying a leave but they couldn't wait.

Analyst Interview Questions & Answers

WPP user image Anonymous

posted on 12 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Accountings based question
  • Q2. P2p cycle and invoicing process

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Reasoning and logic base qus

Round 2 - Technical 

(1 Question)

  • Q1. About metrics like Cpc, cvr
Round 3 - One-on-one 

(1 Question)

  • Q1. Discuss about previous work

I applied via LinkedIn and was interviewed before Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is sem in digital marketing?
  • Ans. 

    SEM stands for Search Engine Marketing, which involves promoting websites by increasing their visibility in search engine results pages.

    • SEM involves paid advertising on search engines like Google and Bing

    • It includes strategies like keyword research, ad copywriting, and bid management

    • SEM can be used to drive traffic, increase brand awareness, and generate leads or sales

    • Examples of SEM platforms include Google Ads, Bing

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prep well. do well and they will go in detail for each thing on the cv

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

IPG Mediabrands Interview FAQs

How many rounds are there in IPG Mediabrands Senior Analyst interview?
IPG Mediabrands interview process usually has 1-2 rounds. The most common rounds in the IPG Mediabrands interview process are Technical and Resume Shortlist.
How to prepare for IPG Mediabrands Senior Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at IPG Mediabrands. The most common topics and skills that interviewers at IPG Mediabrands expect are Data Analysis, Data Visualization, Python, SQL and Tableau.
What are the top questions asked in IPG Mediabrands Senior Analyst interview?

Some of the top questions asked at the IPG Mediabrands Senior Analyst interview -

  1. What is data validation What is delete and truncate Delete and d...read more
  2. Reverse the String in pyt...read more
  3. Project in last organizat...read more

Recently Viewed

INTERVIEWS

Exide Industries

No Interviews

LIST OF COMPANIES

Exide Industries

Locations

INTERVIEWS

Exide Industries

No Interviews

INTERVIEWS

Exide Industries

90 top interview questions

INTERVIEWS

Exide Industries

No Interviews

INTERVIEWS

Wood Group

No Interviews

INTERVIEWS

CtrlS

No Interviews

INTERVIEWS

Flipkart

No Interviews

INTERVIEWS

Exide Industries

No Interviews

DESIGNATION

Tell us how to improve this page.

IPG Mediabrands Senior Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

3 Minds Digital Interview Questions
4.4
 • 65 Interviews
Publicis Interview Questions
3.7
 • 52 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
Moris Media Interview Questions
4.5
 • 24 Interviews
Cheil India Interview Questions
3.0
 • 17 Interviews
WPP Interview Questions
3.0
 • 11 Interviews
Z1 Tech Interview Questions
4.0
 • 11 Interviews
Liqvd Asia Interview Questions
4.2
 • 10 Interviews
View all
IPG Mediabrands Senior Analyst Salary
based on 31 salaries
₹6.7 L/yr - ₹14.5 L/yr
17% more than the average Senior Analyst Salary in India
View more details

IPG Mediabrands Senior Analyst Reviews and Ratings

based on 9 reviews

3.2/5

Rating in categories

3.0

Skill development

3.5

Work-life balance

2.8

Salary

3.5

Job security

3.6

Company culture

2.7

Promotions

3.1

Work satisfaction

Explore 9 Reviews and Ratings
Senior Executive
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare IPG Mediabrands with

Groupm Media

3.9
Compare

Dentsu Aegis Network

3.4
Compare

Madison World

3.8
Compare

Havas Media

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