Add office photos
Filter interviews by
IPG Mediabrands Interview Questions, Process, and Tips for Freshers
Top IPG Mediabrands Interview Questions and Answers for Freshers
- Q1. What are joins and how do you use it?asked in Analyst interview
- Q2. What are SQL Joins?asked in Data Analyst interview
- Q3. What is data validation What is delete and truncate Delete and dropasked in Senior Analyst interview
IPG Mediabrands Interview Experiences for Freshers
3 interviews found
(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
Analyst Interview Questions asked at other Companies
Shrikanth Patil
(2 Questions)
- Q1. What are SQL Joins?
- Ans.
SQL Joins are used to combine rows from two or more tables based on a related column between them.
SQL Joins are used to retrieve data from multiple tables based on a related column between them.
Common types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
- Q2. Different functions in Python numpy
- Ans.
Python numpy provides various functions for numerical operations on arrays.
numpy.sum() - calculates the sum of array elements
numpy.mean() - calculates the mean of array elements
numpy.max() - returns the maximum value in an array
numpy.min() - returns the minimum value in an array
numpy.std() - calculates the standard deviation of array elements
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Sep 2022. There were 2 interview rounds.
(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...
Interview Preparation Tips
Senior Analyst Interview Questions asked at other Companies
Interview questions from similar companies
Selected
I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL Window Functions and RANK, DENSE RANK Difference
- Ans.
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
RANK function assigns a unique rank to each distinct row within a partition.
DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.
Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
- Q2. Hadoop Default Replication Factor
Interview Preparation Tips
- SQL
- Spark
- Hadoop
- YARN
Salary offered is below industry standard.
Overall not a good experience.
Skills evaluated in this interview
Business Development Executive Interview Questions & Answers
Tsl Consulting
Anonymous
posted on 16 Oct 2024
(2 Questions)
- Q1. Why do you want to join sales
- Ans.
I am passionate about building relationships, meeting new people, and achieving targets in a dynamic and competitive environment.
Enjoy interacting with people and building relationships
Excited about meeting new challenges and targets
Thrilled by the dynamic and competitive nature of sales
Seeking opportunities for personal and professional growth
Passionate about helping customers find solutions to their needs
- Q2. What are your technical skills
- Ans.
I have strong technical skills in data analysis, CRM systems, and market research.
Proficient in Microsoft Excel for data analysis and reporting
Experience with CRM systems such as Salesforce for managing customer relationships
Skilled in conducting market research using tools like SurveyMonkey and Google Analytics
Interview Preparation Tips
Selected
I applied via campus placement at Christ University, Bangalore and was interviewed before Dec 2023. There were 3 interview rounds.
Asked us to write 3-4 copies and script on a particular situations
2-3 topics were asked
(1 Question)
- Q1. Tell us something that's not on the resume
- Ans.
I am fluent in three languages - English, Spanish, and French.
I have lived in three different countries growing up, which is how I became fluent in multiple languages.
Being multilingual has helped me in my previous copywriting roles to create content for diverse audiences.
I have also translated marketing materials and campaigns into different languages to reach a wider audience.
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Asked about the company, hobbies, about myself
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Oct 2022. There were 4 interview rounds.
Few general apptitute questions
3 Data Structures Coding Questions
1 SQL Questions
(4 Questions)
- Q1. Asked to explain the logic of the question which i got in exam(i didn't remember the question, i was happened almost 3 months back).
- Q2. Asked me to write code for sum of Fibonacci series.
- Q3. Asked me to write the login to print employees first name and salary.
- Q4. Few basic questions on Java(I preferred java as my primary program lang)
Interview Preparation Tips
- Data Structures
- DBMS
- SQL
- any programme lang
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
Asked most question from javascript, and react also, interviewer was behaving rude
(1 Question)
- Q1. There was no hr round
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Jan 2023. There were 2 interview rounds.
(2 Questions)
- Q1. 1. What's your design story?
- Ans.
My design story began with a passion for creativity and problem-solving, leading me to pursue a career in UI/UX design.
I have always been interested in art and design, and started learning graphic design in high school.
During my college years, I discovered my love for user-centered design and began taking courses in UI/UX design.
I have worked on various design projects, including creating wireframes and prototypes for ...
- Q2. Can you walk me through your process?
Interview Preparation Tips
IPG Mediabrands Interview FAQs
The duration of IPG Mediabrands interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
IPG Mediabrands Interviews By Designations
- IPG Mediabrands Campaign Manager Interview Questions
- IPG Mediabrands Data Analyst Interview Questions
- IPG Mediabrands Senior Analyst Interview Questions
- IPG Mediabrands Senior Associate 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
- Show more
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
IPG Mediabrands Reviews and Ratings
based on 70 reviews
Rating in categories
|
Senior Executive
48
salaries
|  ₹4.8 L/yr - ₹11 L/yr |
|
Assistant Manager
35
salaries
| ₹8.4 L/yr - ₹14 L/yr |
|
Senior Analyst
28
salaries
| ₹6.7 L/yr - ₹14.9 L/yr |
|
Senior Associate
22
salaries
| ₹5.7 L/yr - ₹11 L/yr |
|
Data Analyst
16
salaries
| ₹4.1 L/yr - ₹8.5 L/yr |
Groupm Media
Dentsu Aegis Network
Madison World
Havas Media
Calculate your in-hand salary
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Interview Questions for Fresher
