Upload Button Icon Add office photos

Filter interviews by

Mep Media Interview Questions, Process, and Tips

Updated 4 Jan 2025

Mep Media Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - HR 

(11 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a recent graduate with a degree in Data Science and a passion for analyzing and interpreting data to drive business decisions.

    • Recent graduate with a degree in Data Science

    • Passionate about analyzing and interpreting data

    • Strong skills in statistical analysis and data visualization

    • Experience with programming languages such as Python and R

    • Completed internships in data analysis roles

  • Answered by AI
  • Q2. What is power Bi
  • Ans. 

    Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.

    • Developed by Microsoft

    • Allows users to create interactive visualizations and reports

    • Integrates with various data sources such as Excel, SQL databases, and cloud services

    • Enables data exploration and sharing insights with stakeholders

    • Offers features like dashboards, data connections, and data

  • Answered by AI
  • Q3. What is SQL
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language

    • It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables

    • Common SQL commands include SELECT, INSERT, UPDATE, DELETE

    • Example: SELECT * FROM table_name WHERE condition;

  • Answered by AI
  • Q4. Hobbie and skills
  • Q5. What is ETL
  • Ans. 

    ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a data warehouse for analysis.

    • Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.

    • Transform: Data is cleaned, standardized, and transformed into a consistent format suitable for analysis.

    • Load: The transformed data is loaded into a da...

  • Answered by AI
  • Q6. Type of keys
  • Ans. 

    Types of keys in data analysis include primary keys, foreign keys, and composite keys.

    • Primary key uniquely identifies each record in a table (e.g. customer ID)

    • Foreign key links two tables together (e.g. customer ID in orders table)

    • Composite key consists of multiple columns to uniquely identify a record (e.g. combination of customer ID and order ID)

  • Answered by AI
  • Q7. What is join
  • Ans. 

    Join is a SQL operation used to combine rows from two or more tables based on a related column between them.

    • Join is used to retrieve data from multiple tables based on a related column.

    • 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;

  • Answered by AI
  • Q8. What is RLS
  • Q9. Cross join vs outer join
  • Ans. 

    Cross join produces Cartesian product of two tables, while outer join combines rows from two tables based on a related column.

    • Cross join returns all possible combinations of rows from two tables.

    • Outer join combines rows from two tables based on a related column, including unmatched rows with NULL values.

    • Example: Cross join - SELECT * FROM table1 CROSS JOIN table2

    • Example: Outer join - SELECT * FROM table1 LEFT JOIN tabl

  • Answered by AI
  • Q10. What is fact & dimensions
  • Ans. 

    Facts are measurable data points, while dimensions provide context to the facts by categorizing and organizing them.

    • Facts are quantitative data that can be measured or counted.

    • Dimensions provide context to the facts by categorizing and organizing them.

    • In a sales database, the fact could be the total revenue generated, while dimensions could include product category, region, and time period.

  • Answered by AI
  • Q11. Explain the difference between `TRUNCATE`, `DELETE`, and `DROP` commands.
  • Ans. 

    TRUNCATE removes all rows from a table, DELETE removes specific rows, and DROP deletes the entire table structure.

    • TRUNCATE is faster than DELETE as it does not log individual row deletions.

    • DELETE is slower than TRUNCATE as it logs each row deletion.

    • DROP removes the entire table structure along with all data.

    • TRUNCATE and DELETE can be rolled back, but DROP cannot be rolled back.

    • Example: TRUNCATE table_name;

    • Example: DELE...

  • Answered by AI
Round 2 - Technical 

(15 Questions)

  • Q1. What is SQL, and why is it important in data analytics
  • Ans. 

    SQL is a programming language used for managing and analyzing data in relational databases.

    • SQL stands for Structured Query Language

    • It is used to retrieve, manipulate, and analyze data stored in relational databases

    • SQL is important in data analytics as it allows analysts to query databases to extract relevant information for analysis

    • It helps in filtering, sorting, and aggregating data to generate insights

    • Examples of SQL...

  • Answered by AI
  • Q2. Explain the difference between 'INNER JOIN', 'LEFT JOIN`, `RIGHT JOIN`, and `FULL OUTER JOIN`.
  • Ans. 

    Different types of SQL joins used to combine rows from two or more tables based on a related column between them.

    • INNER JOIN: Returns rows when there is at least one match in both tables.

    • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

    • FULL OUTER JOIN: Returns all rows when there is a match

  • Answered by AI
  • Q3. What is the difference between 'WHERE` and 'HAVING` clauses
  • Ans. 

    WHERE clause is used to filter rows before grouping, while HAVING clause is used to filter groups after grouping.

    • WHERE clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

    • HAVING clause is used with SELECT statement to filter groups based on a condition

    • WHERE clause is applied before the data is grouped, while HAVING clause is applied after the data is grouped

    • Example: SELECT * FROM ta...

  • Answered by AI
  • Q4. Difference between Append and Merged
  • Ans. 

    Append adds rows to a dataset, while Merge combines datasets based on a common key.

    • Append adds rows to the bottom of a dataset, increasing the number of observations.

    • Merge combines datasets based on a common key, such as a unique identifier or variable.

    • Appending is useful for adding new data, while merging is useful for combining related datasets.

    • Example: Appending a new month of sales data to an existing dataset. Merg...

  • Answered by AI
  • Q5. Row-level Security and 4 role in power Bi
  • Ans. 

    Row-level security in Power BI allows restricting access to specific rows of data based on user roles.

    • Row-level security in Power BI is used to control access to data at the row level based on user roles.

    • Roles in Power BI define the level of access users have to data and reports.

    • Examples of roles in Power BI include Admin, Analyst, Viewer, and Contributor.

    • By setting up row-level security, users can only see the data th...

  • Answered by AI
  • Q6. Schedule Refresh & Gateways
  • Q7. What are BookMarks, use of it
  • Ans. 

    Bookmarks are digital markers used to quickly navigate to specific sections or pages within a document or website.

    • Bookmarks allow users to easily access important or frequently visited sections of a document or website.

    • They are commonly used in web browsers to save specific web pages for quick access.

    • Bookmarks can also be used in PDF documents to mark important pages or sections for easy reference.

  • Answered by AI
  • Q8. Difference between Duplicate & Reference
  • Ans. 

    Duplicate refers to an exact copy, while reference is a pointer to the original object.

    • Duplicate is a separate copy of the original data, while reference points to the original data.

    • Changing a duplicate does not affect the original, but changing a reference does.

    • Duplicates consume more memory than references.

    • Example: Duplicate - making a photocopy of a document. Reference - sharing a link to a document.

    • Example: Duplica...

  • Answered by AI
  • Q9. Results of Left Join, Right Join and Cross Join
  • Ans. 

    Left Join includes all records from the left table and matching records from the right table. Right Join includes all records from the right table and matching records from the left table. Cross Join combines all records from both tables.

    • Left Join: Includes all records from the left table and matching records from the right table.

    • Right Join: Includes all records from the right table and matching records from the left t...

  • Answered by AI
  • Q10. What are Indexing, it's types and use of it
  • Ans. 

    Indexing is a technique used to optimize data retrieval in databases by creating indexes on columns.

    • Types of indexing include clustered and non-clustered indexes

    • Clustered indexes physically reorder the data in the table based on the index key

    • Non-clustered indexes create a separate structure to store the index key and a pointer to the actual data

    • Indexes are used to speed up data retrieval operations such as SELECT queri

  • Answered by AI
  • Q11. Difference between Union & Union all
  • Ans. 

    Union combines and removes duplicates, Union all combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union all combines result sets without removing duplicates

    • Union is slower than Union all as it involves removing duplicates

    • Union all is faster than Union as it does not remove duplicates

  • Answered by AI
  • Q12. How to find 3rd Highest Salary, Marks
  • Ans. 

    To find the 3rd highest salary or marks, you can use SQL query with ORDER BY and LIMIT.

    • Use SQL query with ORDER BY to sort the salaries or marks in descending order

    • Use LIMIT 2,1 to skip the first two highest salaries or marks and get the third highest

  • Answered by AI
  • Q13. How do you use 'PARTITION BY` and `ORDER BY in window functions
  • Ans. 

    PARTITION BY is used to divide the result set into partitions, while ORDER BY is used to sort the rows within each partition in window functions.

    • PARTITION BY is used to group rows with the same values in specified columns

    • ORDER BY is used to sort the rows within each partition

    • Example: SELECT column1, column2, SUM(column3) OVER (PARTITION BY column1 ORDER BY column2) AS total FROM table_name

  • Answered by AI
  • Q14. Explain window functions like `ROW_NUMBER()`, `RANK()`, and `DENSE_RANK()`.
  • Ans. 

    Window functions like ROW_NUMBER(), RANK(), and DENSE_RANK() assign a unique number to each row based on specified criteria.

    • ROW_NUMBER() assigns a unique sequential integer starting from 1 to each row within a partition

    • RANK() assigns a unique rank to each row within a partition, with no gaps in ranking if there are ties

    • DENSE_RANK() assigns a unique rank to each row within a partition, with possible gaps in ranking if t

  • Answered by AI
  • Q15. Workspace & App
Round 3 - HR 

(4 Questions)

  • Q1. What work did you find most difficult
  • Ans. 

    I found data cleaning and manipulation to be the most difficult part of my work.

    • Understanding and cleaning messy data sets

    • Manipulating data to fit the required format

    • Dealing with missing or inconsistent data

    • Creating new variables or features from existing data

    • Ensuring data quality and accuracy

  • Answered by AI
  • Q2. Why should we hire you
  • Ans. 

    I have a strong analytical background, excellent problem-solving skills, and a passion for data-driven decision making.

    • I have a degree in Statistics and experience with data analysis tools such as Python and SQL.

    • I have successfully completed projects where I analyzed large datasets to provide actionable insights.

    • I am detail-oriented and have a proven track record of delivering accurate and timely results.

  • Answered by AI
  • Q3. Where do you see yourself in 5 years
  • Ans. 

    In five years, I see myself as a Senior Data Analyst leading a team and working on more complex projects.

    • Advancing to a Senior Data Analyst role

    • Leading a team of junior analysts

    • Working on more complex and challenging projects

    • Continuing to learn and grow in the field of data analysis

  • Answered by AI
  • Q4. Salery discussion

Interview Preparation Tips

Topics to prepare for Mep Media Junior Data Analyst interview:
  • Power Bi
  • SQL
Interview preparation tips for other job seekers - Answer with patience and listen to the questions carefully, maintain confidence, be honest and don't get scared

Skills evaluated in this interview

Top Mep Media Junior Data Analyst Interview Questions and Answers

Q1. What is SQL, and why is it important in data analytics
View answer (1)

Junior Data Analyst Interview Questions asked at other Companies

Q1. What is the main difference between data mining and data analysis?
View answer (4)

Interview questions from similar companies

I was interviewed before Sep 2016.

Interview Questionnaire 

1 Question

  • Q1. It was an online technical test. Questions were related to ME outlook, mobile device management , Networking and many more

Interview Preparation Tips

Round: Grammar Round
Experience: It was a written English grammar test to analyse how grammatically sound you are.
Tips: Just revise your basic English grammar like prepositions verbs nd essay/paragraph writing

Round: COMMUNICATION SKILLS Round
Experience: In this round they ask you to speak something on the given topic or sometimes group discussion . Basically they test your vocabulary, your thought process, pronunciation, accent and above all confidence.
Tips: Be confident in whatever you speak. Remember if you get nervous you will need with your words .

Round: Technical Interview
Experience: This was an online test and it had 50 questions all objective types.
Tips: Be technically sound. You cannot Google them as these search engines are blocked

College Name: Babu Banarasi Das National Institute Of Technology And Management (BBDNITM)

I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1.  overloading ,inheritance concepts,structures,pointers

Interview Preparation Tips

Interview preparation tips for other job seekers - have good understanding of basics and have expertise on any specific area.

Interview Questionnaire 

2 Questions

  • Q1. Basic Programming Questions, Data structures, SQL queries
  • Q2. This was the most simple one, they simply asked introduce yourself and fine with night shifts.

Interview Preparation Tips

General Tips: I joined HCL as a fresher and got Intervie

Interview Questionnaire 

1 Question

  • Q1. What I know and what I don't know

Interview Preparation Tips

Round: Test
Experience: Aptitude, reasoning, logical, etc. 2 hours

Interview Questionnaire 

2 Questions

  • Q1. C and C++ - technically related stuffs
  • Q2. Communicate and fluency

Analyst Interview Questions & Answers

HCLTech user image Raj Hrithik

posted on 2 Sep 2017

I was interviewed in Jul 2017.

Interview Questionnaire 

1 Question

  • Q1. Experience summary and the roles

Interview Preparation Tips

Round: Test
Experience: I was allowed to write a test for 2hrs in that each headings seems to be different and also there is a section heading marks
Duration: 2 hours
Total Questions: 70

Round: Technical Interview
Experience: After finishing i was advised to attend 2nd round in that they ask about the detailed experience of my previous company and finally technical terms question also flows

Skills: Logical And Structured Thinking, Communication And Confidence, Attitude, Psychometric Test, Project Management

Interview Questionnaire 

7 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a software engineer with experience in developing and maintaining software applications.

    • I have a strong background in programming languages such as Java, C++, and Python.

    • I have worked on various projects, including developing web applications and implementing software solutions.

    • I am skilled in problem-solving and debugging, ensuring efficient and effective software development.

    • I have experience in collaborating wi...

  • Answered by AI
  • Q2. What are your objectives
  • Q3. What are you going to do for companies betterment
  • Q4. What is your final year project all about
  • Q5. What you learned from your summer intenship
  • Ans. 

    I learned valuable teamwork and problem-solving skills during my summer internship.

    • Developed strong collaboration skills by working with a team of software engineers to complete projects

    • Gained experience in troubleshooting and debugging software issues

    • Learned to effectively communicate and present technical concepts to both technical and non-technical stakeholders

    • Improved problem-solving abilities by identifying and re...

  • Answered by AI
  • Q6. What you learned from your winter intenship
  • Q7. Do you have any question

Interview Preparation Tips

Round: Test
Experience: Verbal section was a easy section,It comprised of Comprehension,Spotting errors,Synonyms,Antonyms,Relationship between two given words,Rearranging the sentences.Logical reasoning the second section in which problems on data interpretation,blood relations,syllogism,where there with little bit difficulty.third section was of quant we usual  think it's easy but this was a tough one! with standard problems,percentage,profit loss,speed distance time.....etc.
Tips: While,attempting verbal part always give most appropriate answers.Options may be more confusing and closer one but you have to select the correct one!!!!! Always check for sectional cutoff and if its there then try to attempt each section properly if not then concentrate on section in which you are strong....refer to sites such as IndiaBIX, M4maths, freshersworld for aptitude questions
Duration: 60 minutes
Total Questions: 75

Round: Group Discussion
Experience: GD was not a round included for Capgemini placement test,Pearson versant english test was there once you clear your apti but due to technical faults GD was the round taken.There was a group of 10 people and we were given topic and 5 mins for preparation then GD was started.I was the second one to speak on the topic,I was in the favour of MNC because I really feel that for freshers Indian IT company is not very great start.Rather if one starts with MNC then it gets a brand name associated with them and also global exposure for one.And also Indian IT sectors are largely collaborating with the MNCs so for fresher MNC is a good start than Indian IT company.
Tips: I will suggest you to understand the topic well,jot down the points you want to say and then always initiate for the GD do not argue,just humbly disagree to the topic,do not get personal in it...as soon as you start the supervisor judges you so do not hesitate and just put your points confidently only your English is judged by this...
Duration: 20 minutes

Round: HR Interview
Experience: As I entered they  checked me from top to bottom means how formally you are dressed and shoes,then asked for my resume and started to see and verify each and everything written in it is true and genuine.And both TR and HR interview was taken simultaneously.My interview was the quicker one they just started with name then all above mentioned questions....
Tips: Go properly dressed with shoes polished,do not panic or try to recollect what you  have prepared just be genuine.Write resume neatly and study it well they scan it and ask most questions from it...

Round: Pearson versant English test
Experience: This test consist of two sections firstly the telephonic round in which we were provided with one toll free number and  unique test-id then it was for about 20 mins we talked on telephone.The questions asked were on basic english,like  repeat the sentences,correct the jumbled sentences,complete the sentences,answer in yes or no.Second test was a computer based test for 60 mins in which complete the sentences synonyms,copying the passage,email writing ,listen and write,were few of the questions directed.this test is taken mainly to check your english and writing skills.
Tips: Be clear and loud enough in telephonic test,and search placement papers of every company you sit for.

General Tips: "Try try you will succeed" always believe on this saying and keep giving tests if you failed in one!!
College Name: TERNA ENGINEERING COLLEGE
Motivation: Capgemini is one of good MNC its under top 10 best IT companies also its symbol spade which represented free enivronment to work and moto "People matter,results count".motivated me to join it!

Interview Questionnaire 

1 Question

  • Q1. Telephonic/Computer assessment for English proficiency

Interview Preparation Tips

Round: Test
Experience: Aptitude was not too easy or too tough like that of CAT. But if one has prepared for CAT exam even a bit, then he can perform pretty well.
Tips: Practice previous year CAT papers. Question sections and format asked in Capgemini test will be similar to that of CAT exam. Improve reading skills by reading anything that interests you.
Duration: 180 minutes
Total Questions: 120

Round: Other Interview
Experience: You will have to talk with a programmed voice using voice call. You need to follow the instructions of the programmed voice. They will record whatever you speak and judge your speaking skills.
Tips: Try to speak in English with at least few peers.

Round: HR Interview
Experience: You must be well thorough with your CV. Common questions like:*Tell me about yourself?*What are your strength and weakness?*Why consultancy and analyst profile?*What do you know about analyst profile?*What does Capgemini does? Tell us more about Capgemini?
etc can be expected for sure.The HR is not interested in your departmental knowledge, rather he is more interested in the way you are explaining something tin a layman manner. He/She cares how you analyse situations. Some random sitaution may be posed and HR may ask you to analyse the situation.
Tips: #Confidence in yourself.#Well verse with CV.#Able to explain even to layman.#Know basic information about data analytics.

General Tips: Aptitude+Communication fluency+Confidence = Job in  Capgemini
Skill Tips: Practice.
Skills: Aptitude, Communication, Confidence
College Name: I.I.T Guwahati
Motivation: Multi national and reputed.

Interview Questionnaire 

7 Questions

  • Q1. What is the diffrence between java & C
  • Ans. 

    Java is an object-oriented language while C is a procedural language.

    • Java is platform-independent while C is platform-dependent.

    • Java has automatic garbage collection while C requires manual memory management.

    • Java has built-in support for multithreading while C requires external libraries.

    • Java has a larger standard library compared to C.

    • Java is more secure than C due to its strong type checking and exception handling.

    • C ...

  • Answered by AI
  • Q2. What do u understand by pointers
  • Ans. 

    Pointers are variables that store memory addresses of other variables in programming languages.

    • Pointers allow direct access and manipulation of memory locations.

    • They are commonly used in programming languages like C and C++.

    • Pointers can be used to pass variables by reference, allowing modifications to the original value.

    • They can also be used to dynamically allocate memory.

    • Example: int* ptr; // declares a pointer to an

  • Answered by AI
  • Q3. Introduce urself
  • Q4. Ur weaknesses & strengths
  • Q5. Why should i hire u
  • Q6. Why us
  • Q7. Wer do u see urself in next 5 years
  • Ans. 

    In 5 years, I see myself as a senior software engineer leading a team of developers.

    • Leading a team of developers

    • Working on complex projects

    • Continuing to learn and grow in my role

    • Contributing to the success of the company

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Clear ur basic concepts also practice maths related questions
Tips: NA
Duration: 60 minutes
Total Questions: 45

Round: Group Discussion
Experience: initially I wasnt aware of the topic. i waited til everyone strted n waited for my turn... til the time i was listening to wat other students wer saying. den i got idea on wat the topic is really abt. i gathered some points in my mind and js spoke wat views i had .. it was ffun actually.
Tips: always first think about the topic before speaking.
Duration: 30 minutes

Round: Technical Interview
Experience: i dont exactly remember wat wer the questions asked.
Tips: NA

Round: HR Interview
Experience: Being honest wil help to crack this interview
Tips: NA

General Tips: WORK HARD TOWARDS YOUR GOAL !
Skill Tips: develop basi programming skills & logics
Skills: programing C/C++, basic java, OS, DB, NETWORKING, OOPS
College Name: SIES Institute Of Technology, Nerul
Motivation: Keep Chasin ur DREAMS.. !!
Funny Moments: yet to come !

Skills evaluated in this interview

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

Mep Media Interview FAQs

How many rounds are there in Mep Media interview?
Mep Media interview process usually has 3 rounds. The most common rounds in the Mep Media interview process are HR and Technical.
What are the top questions asked in Mep Media interview?

Some of the top questions asked at the Mep Media interview -

  1. What is SQL, and why is it important in data analyt...read more
  2. How do you use 'PARTITION BY` and `ORDER BY in window functi...read more
  3. What is the difference between 'WHERE` and 'HAVING` clau...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

SALARIES

vConstruct

LIST OF COMPANIES

BrenStone International

Overview

SALARIES

Via.com

SALARIES

ZS

REVIEWS

Infosys

No Reviews

Tell us how to improve this page.

Mep Media Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
View all

Mep Media Reviews and Ratings

based on 3 reviews

3.1/5

Rating in categories

3.5

Skill development

2.2

Work-life balance

2.2

Salary

1.5

Job security

3.1

Company culture

1.3

Promotions

3.1

Work satisfaction

Explore 3 Reviews and Ratings
Compare Mep Media with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent