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

Interview Preparation Tips

Round: Test
Experience: Data interpretation questions,english vocabulary(GRE BARRONS) is most important , apptitude questions and reasoning are from R S agarwal.
Total Questions: 65

Round: Technical Interview
Experience: Interviewer asked about your core subject littlebit and dont have any deep questions from c and c++.

Round: HR Interview
Experience: Given a topic and asked me to speak about that topic for one minute and given a situation asked me how would you react on that situation.

General Tips: It is easy to get a job in infosys comparatively other companies because you dont need to prepare for software side.
Prepare aptitude and reasoning from R S Agarwal and GRE BARRONS for vocabulary
College Name: NIT WARANGAL

Interview Preparation Tips

Round: Test
Experience: It went quite well.
Tips: Brush up everyday your aptitude skills
Duration: 30 minutes
Total Questions: 30

General Tips: Choosing your company and preparing for it early is better than trying everything on the day of selection process
Skills: Aptitude, Technical skills
College Name: IIT roorkee
Motivation: i am a self motivator

Interview Questions & Answers

Cognizant user image Anonymous

posted on 20 Jan 2015

Interview Questionnaire 

1 Question

  • Q1. Why should we select you?
  • Ans. 

    I have the necessary skills, experience, and passion to excel in this role.

    • I have relevant experience in the field

    • I possess the required skills and qualifications

    • I am a quick learner and adaptable to new situations

    • I am passionate about the industry and eager to contribute

    • I am a team player and work well with others

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Very basic(class 7 level) english, quant and DI from CAT preparation will do. I was asked to estimate the number of newspapers I would buy if I am a supplier for the campus. Then slightly complicated the problem four or five times.
Tips: Try to answer as many questions as possible--the test is the one major criterion for selection.
Total Questions: 65

Round: Guesstimate Interview
Experience: One-on-one interview.Basic guess estimation and details about your projects. Try to show you have some knowledge in mathematics.

Round: HR Interview
Experience: HR interview--A panel of 4 or 5 people(who have taken the individual interviews in round I).
Tips: Be confident and try not to tell something which you can’t defend.

General Tips: As is the case for most companies, CAT preparation will definitely help. I don’t think much focus was was given on the essay but the other sections of the test are really important.
Skill Tips: A decent CGPA(mine was exactly 8) will help. HR interview--A panel of 4 or 5 people(who have taken the individual interviews in round I). Should be able to speak about your own projects and internships.
College Name: IIT KHARAGPUR

Interview Preparation Tips

Round: Case Study Interview
Experience: No one would be eliminated in this round. They will provide you ample time - around 40-50 minutes to write a response on a case study. The topic would be new and unheard of, but you can think and write peacefully in that amount of time.
Tips: Make sure you highlight the points made and do remember them for the Group Discussion phase.

Round: Group Discussion
Experience: One-third of the guys will get selected for the interviews from each group of 8-10 guys. The topic of the GD would be same as the case study. Now, its time for you to recall the points you made during the writing section. The GD will last for around 15-20 minutes.
Tips: Good communication skills, relaxed but expressive tone. Don’t be silent and try to speak up whenever you get a chance. Try to bring new air into the discussion and think from all the different perspectives. You should speak at least 2-3 times, even if you just say 1-2 sentences each time. That will do. They also individually ask each person to speak, specifically those who could not speak, but you had better not be that guy or girl. There is no need to fight for summarizing the GD. Try to show that you are involved throughout the GD.

Round: HR Interview
Experience: There will be two guys, one from technical and the other HR. They both ask questions at the same time and they discuss among each other as well. They mostly try to detect any fraud or fake thing you did in your project or intern. All the technical questions come from your CV. So, your fate is kind of in your hands only.
Tips: Prepare hard for Projects, Internships etc. Don’t panic. They try to see how you react in a pressure situation and actually behave as if you are not impressing them. Just be calm and keep on speaking. If there is something you want to say and they interrupt you, its better you ask them to give you a chance to explain it in details. Do have a few questions in mind to ask them about your job profile and Wipro. That is the final nail in the coffin.

Skill Tips: A minimum CGPA of 8.0 was mentioned and later they relaxed it to 7.9. They were giving quite some importance to the Internships and Projects undertaken and were trying to judge if you actually did something new and genuine. They were dwelling deep into it. As I said, prepare well for them just like you prepare for BTech Project Viva. They do ask a lot of questions.HR questions should be prepared thoroughly. A background check of Wipro and IT sector companies is a must. Prepare well for group discussions. Try to get background information about the IT sector and the company. Prepare your CV thoroughly.
College Name: IIT KHARAGPUR

Interview Questions & Answers

Deloitte user image Anonymous

posted on 20 Jan 2015

Interview Questionnaire 

2 Questions

  • Q1. Why IT consultancy?
  • Q2. What would be the advantages of chemical background?

Interview Preparation Tips

Round: Test
Experience: CAT type questions were asked in English and DI.
Tips: Accuracy will matter and preparations for CAT will help.
Duration: 30 minutes
Total Questions: 40

Round: Technical Interview
Experience: Questions were based on Data Abstraction. Internship was the main topic around which the rest of the interview went on.
Tips: Coding skills should be good.

Round: HR Interview
Tips: Work on communication skills.

College Name: IIT KANPUR

N/A Interview Questions & Answers

HCLTech user image Anonymous

posted on 27 Jan 2015

Interview Preparation Tips

Round: Other Interview
Experience: 1 round of 10 minutes duration.
Depends very much on what position they are trying to fill in and area of expertise of the interviewer(s). They asked me basic questions on Image Processing. Interview went decent

College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: Simple Aptitude - just brush up basics - be quick in your solving.
Duration: 120min minutes
Total Questions: 50+10

Round: HR Interview
Experience: Pretty simple interview round - was asked few HR questions. Majorly it was a informative session where i was told about the job profile and tested whether I was willing to take up the responsibility & commitment.

College Name: IIT MADRAS
Motivation: Just applied gen. Got through.

Interview Preparation Tips

Round: Test
Experience: Coding questions were comparatively easy. There were three questions.1. Given a string map each character of which to the corresponding digit in a 10 digit mobile phone keypad.2. Don't remember, will add when it comes to my mind.3. Don't remember, will add when it comes to my mind.

Skills: Coding ability, Complete knowledge of working of internet.,
College Name: IIT Bombay

Banking Interview Questions & Answers

ICICI Bank user image Anonymous

posted on 24 May 2015

Interview Questionnaire 

18 Questions

  • Q1. How would your friends describe you?
  • Q2. Are you a low/medium or high risk taker? Substantiate your stand
  • Q3. Are you are loner?
  • Q4. Are you an imaginative person?
  • Q5. What are your strengths and weaknesses?
  • Q6. What is your family background and what have you learned from it?
  • Q7. What profile are you looking for?
  • Q8. Why are you fit for investment banking and not corporate finance?
  • Q9. Why do I want to get into ICIC and what do I know about it-
  • Q10. Why ICICI?
  • Q11. What do you know about the company?
  • Q12. What interesting projects are there on your CV? Explain one of them?
  • Q13. Discussed in and out on valuation specific questions related to a project like what projections for Sales, growth Rate, S&A, how to calculate cost of capital?
  • Q14. What approach did you take?
  • Q15. What lines of businesses did you value and how?
  • Q16. What are other competitors doing and how are they growing?
  • Q17. If you are the CEO of the same company what measures will you take to make the company grow to the next level?
  • Q18. What is the difference between bank and private investor?

Interview Preparation Tips

General Tips: Company was very impressed and wanted to make an offer but with a different profile in the interview itself but I was consistent on what I wanted and through strong negotiation finally convinced them that I am fit for Investment banking or global markets and hence that worked
Skills: Economics, Banking
College Name: NA

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

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.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview