AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
IPG Mediabrands Analyst Interview Questions and Answers
IPG Mediabrands Analyst Interview Experiences
1 interview found
Shrikanth Patil
(2 Questions)
- Q1. What are joins and how do you use it?
- Ans.
Joins are used in databases to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Processing speed of different scriting languages?
- Ans.
Processing speed of scripting languages varies based on factors like code complexity and optimization.
Processing speed can vary based on the specific task being performed.
Compiled languages like C++ tend to be faster than interpreted languages like Python.
Optimizing code can improve processing speed.
JavaScript can be faster than Python for certain tasks.
Consider using libraries or frameworks optimized for performance.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 2 interview rounds.
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.
(1 Question)
- Q1. Combined tech and coding round
Interview Preparation Tips
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.
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions about your previous experience
(1 Question)
- Q1. Excel and Data visualization questions. Depends on the role you are being hired for.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Accountings based question
- Q2. P2p cycle and invoicing process
Interview Preparation Tips
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
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed in Jan 2023. There were 3 interview rounds.
Easy and simple quest during round one. Easy to crack
(3 Questions)
- Q1. Tell me abt yourself
- Q2. Platforms knowledge and process related questions
- Q3. Explain metrics used in Digital marketing's and main KPI
- Ans.
Metrics used in digital marketing include CTR, CPC, CPA, and main KPI is ROI.
CTR (Click-Through Rate) measures the percentage of clicks on an ad compared to the number of impressions.
CPC (Cost Per Click) is the amount paid for each click on an ad.
CPA (Cost Per Acquisition) measures the cost of acquiring a customer through a specific campaign.
ROI (Return on Investment) is the main KPI, calculating the revenue generated
Interview Preparation Tips
Skills evaluated in this interview
Selected
I was interviewed before Mar 2024.
(2 Questions)
- Q1. About datorama explain how it works
- Q2. More about digital marketing
I applied via Campus Placement and was interviewed in Jul 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions from SQL, Python, Excel, Tableau and from my Projects
Interview Preparation Tips
Reasoning and logic base qus
(1 Question)
- Q1. About metrics like Cpc, cvr
(1 Question)
- Q1. Discuss about previous work
(2 Questions)
- Q1. Profile Related
- Q2. Product management
IPG Mediabrands Interview FAQs
Recently Viewed
SALARIES
Uno Minda Kyoraku
SALARIES
Automatic Data Processing (ADP)
SALARIES
Wood Group
SALARIES
Adaan Digital Solution
SALARIES
NES Fircroft
SALARIES
Ramkrishna Forgings
INTERVIEWS
IPG Mediabrands
No Interviews
SALARIES
IPG Mediabrands
SALARIES
IPG Mediabrands
SALARIES
Uno Minda Kyoraku
Tell us how to improve this page.
IPG Mediabrands Interviews By Designations
- IPG Mediabrands Senior Associate Interview Questions
- IPG Mediabrands Senior Analyst Interview Questions
- IPG Mediabrands Data Analyst Interview Questions
- IPG Mediabrands Campaign Manager Interview Questions
- IPG Mediabrands Analyst Interview Questions
- IPG Mediabrands Assistant Manager Interview Questions
- IPG Mediabrands Data Engineer Interview Questions
- IPG Mediabrands Public Relations & Media Relations Manager Interview Questions
Interview Questions for Popular Designations
IPG Mediabrands Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
IPG Mediabrands Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Executive
50
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
47
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Analyst
37
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
36
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Groupm Media
Dentsu Aegis Network
Madison World
Havas Media
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Analyst Interview Questions
