AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Mep Media Interview Questions, Process, and Tips
Mep Media Interview Experiences
1 interview found
Selected
I applied via Walk-in and was interviewed before Jan 2024.ย There were 3 interview rounds.
(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
- 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
- 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;
- 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...
- 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)
- 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;
- 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
- 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.
- 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...
(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...
- 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
- 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...
- 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...
- 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...
- 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.
- 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...
- 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...
- 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
- 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
- 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
- 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
- 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
- Q15. Workspace & App
(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
- 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.
- 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
- Q4. Salery discussion
Interview Preparation Tips
- Power Bi
- SQL
Skills evaluated in this interview
Top Mep Media Junior Data Analyst Interview Questions and Answers
Junior Data Analyst Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
I was interviewed in Aug 2024.
Attended the TCS NQT, depending on how many advanced questions and the test cases you pass in coding section, you'll get assigned Ninja (3L) Digital (7L) or prime (9L)
(8 Questions)
- Q1. Code to get prime nos
- Q2. What do you know about cloud computing
- Q3. Self introduction
- Q4. Difference between cloud computing and computer networking
- Q5. If you know any os like linux
- Q6. Oops based questions, very basic if you're not from it or cse related fields but they might ask advanced questions if you're related to cs/it fields
- Q7. If you're okay Relocation
- Q8. Questions about your projects
Interview Preparation Tips
It depends on what type of questions the interviewer asks you though! Good luck, prepare well
Customer Service Executive Interview Questions & Answers
Tech Mahindra
Anonymous
posted on 9 Feb 2025
Selected
(2 Questions)
- Q1. Tell me about yourself.
- Q2. What makes you the ideal candidate for this position?
(1 Question)
- Q1. They will Voice test
(1 Question)
- Q1. Tell me about your self, what are languages you know, what do you know about phone pe
(1 Question)
- Q1. They will check our typing test
Interview Preparation Tips
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Interview Preparation Tips
Functional Testing Senior Consultant Interview Questions & Answers
Deloitte
Anonymous
posted on 4 Feb 2025
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Current CTC, Expected CTC, Notice Period, Skill set
- Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
- Ans.
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
Open for fixed term hire
Willing to work from client location at Gurgaon for 3 days a week
(10 Questions)
- Q1. Introduction, Current role and responsibilities
- Q2. List out the achievements in current project, Tools used
- Ans.
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
Implemented automated testing framework using Selenium WebDriver
Utilized JUnit for test case management
Worked in Agile environment to ensure continuous testing and integration
- Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
- Ans.
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
Pilot testing involves a small group of users testing the functionality in a controlled environment.
Beta testing involves a larger group of users testing the functionality in a real-world environment.
...
- Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
- Ans.
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
Primary key enforces uniqueness and not null constraint on a column
Unique key enforces uniqueness but allows null values
To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
- Q5. Explain Software Testing Life Cycle, Defect Life Cycle
- Ans.
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
STLC includes requirements analysis, test planning, test design, test execution, and test closure.
Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.
STLC ensures that the so...
- Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
- Ans.
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
303 status code indicates that the resource can be found at a different URI and should be retrieved from there
PUT method is used to update an existing resource in the API
DELETE method is used to remove a resource from the API
3 point esti...
- Q7. What kind of links and labels can be tagged to a bug in jira?
- Ans.
Links and labels that can be tagged to a bug in Jira
Links: related issues, documents, websites
Labels: priority, severity, type, status
- Q8. Have you done shell scripting? What does grep, href commands do in unix?
- Ans.
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
Shell scripting automates tasks by writing scripts in a Unix/Linux environment
Grep command is used to search for specific patterns in text files
Example: grep 'search_pattern' file.txt
Href is not a standard Unix command, it may be a typo or a custom script
- Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
- Ans.
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
Listen to the team member's perspective and concerns
Communicate openly and calmly about the issue
Find common ground and areas of agreement
Work together to find a solution that benefits both parties
Seek input from other team members or a mediator if ne
- Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...
- Ans.
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
Yes, open to relocating to Bangalore and working from client's office
Yes, open to working in night/rotational shifts
Yes, open to working in long extendable hours or 24X7 culture
Goal is to excel in automation testing
Interview Preparation Tips
I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)
During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off
Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
P2P Accounts Payable Executive Interview Questions & Answers
Accenture
Anonymous
posted on 6 Jan 2025
Selected
I applied via Naukri.com and was interviewed in Dec 2024.ย There was 1 interview round.
(5 Questions)
- Q1. How many variance in sap?
- Ans.
The number of variances in SAP can vary depending on the specific processes and transactions being analyzed.
The number of variances in SAP can be influenced by factors such as data entry errors, system glitches, or discrepancies in invoice processing.
Variances in SAP may be identified through reconciliation processes, exception reports, or manual reviews of accounts payable transactions.
Examples of variances in SAP inc...
- Q2. We cac explain the all accounts receivable and accounts payable
- Ans.
Accounts receivable and accounts payable are two important aspects of a company's financial operations.
Accounts receivable refers to money owed to a company by its customers for goods or services provided.
Accounts payable refers to money owed by a company to its suppliers or vendors for goods or services received.
Accounts receivable is an asset on the balance sheet, while accounts payable is a liability.
Managing accoun...
- Q3. What is the cost element and cost center?
- Ans.
Cost element and cost center are key concepts in accounting for tracking and allocating costs within an organization.
Cost element refers to the specific types of costs incurred by an organization, such as materials, labor, or overhead.
Cost center is a specific department, team, or function within an organization that is responsible for incurring costs.
Cost elements are assigned to cost centers to track and allocate cos...
- Q4. How many we have currencies in sap?
- Ans.
SAP supports over 160 currencies worldwide.
SAP supports over 160 currencies for global transactions.
Currencies can be configured in SAP using transaction code OB22.
Each currency is assigned a unique currency code (e.g. USD for US Dollar, EUR for Euro).
- Q5. How many types of projects
- Ans.
There are various types of projects, including internal projects, external projects, research projects, and development projects.
Internal projects focus on improving processes within the organization.
External projects involve working with external partners or clients.
Research projects aim to gather data and analyze findings.
Development projects focus on creating new products or services.
Examples: IT system implementati...
Interview Preparation Tips
- mba fresher
* Identify Your Strengths & Weaknesses:
* Strengths: What are you good at? What do you enjoy doing? What are your unique skills and talents?
* Weaknesses: What areas do you need to improve? What are your biggest challenges?
* Define Your Career Goals:
* Short-term: What kind of job are you looking for? What industry are you interested in? What salary range are you targeting?
* Long-term: What is your ideal career path? What are your long-term professional aspirations?
2. Enhance Your Job Search Strategy
* Build a Strong Online Presence:
* LinkedIn: Create a professional and engaging LinkedIn profile.
* Portfolio/Website: If applicable, showcase your work through a portfolio or personal website.
* Network, Network, Network:
* Attend industry events: Conferences, meetups, and workshops.
* Informational interviews: Connect with people working in your field of interest.
* Leverage your existing network: Let your friends, family, and former colleagues know you're job searching.
* Tailor Your Resume & Cover Letter:
* Customize: Tailor your resume and cover letter to each specific job application.
* Keywords: Use keywords from the job description to increase your chances of getting noticed by Applicant Tracking Systems (ATS).
* Quantify your achievements: Use numbers and data to demonstrate your accomplishments.
* Master the Job Interview:
* Practice: Prepare for common interview questions (behavioral, technical, etc.).
* Research: Learn about the company and the role you're interviewing for.
* Ask insightful questions: Demonstrate your interest and engagement.
3. Continuous Improvement
* Skill Development:
* Online courses: Platforms like Coursera, Udemy, and edX offer a wide range of courses.
* Certifications: Obtain relevant industry certifications to enhance your credentials.
* Volunteer work: Gain valuable experience and build your network.
* Stay Updated:
* Industry news: Keep up-to-date with the latest trends and developments in your field.
* Job market trends: Monitor job boards and industry publications to understand the current job market.
Key Advice:
* Be patient and persistent: The job search process can be challenging, but don't give up.
* Stay positive and maintain a growth mindset: Focus on your strengths and opportunities for improvement.
* Take care of yourself: Prioritize your physical and mental well-being during your job search.
Remember: The job market is constantly evolving. Be adaptable, proactive, and resourceful in your job search efforts. Good luck!
I applied via Company Website and was interviewed in Nov 2024.ย There were 13 interview rounds.
(2 Questions)
- Q1. What is the Entity-Relationship (ER) model?
- Ans.
The Entity-Relationship (ER) model is a data model used to describe the relationships between entities in a database.
Entities are objects or concepts in the real world that can be distinguished from each other.
Relationships describe how entities are related to each other.
Attributes are properties that describe entities and relationships.
ER diagrams visually represent the ER model, showing entities, relationships, and a...
- Q2. What are the advantages of using threads compared to processes?
- Ans.
Threads are lighter weight than processes, share memory space, and are more efficient for multitasking.
Threads share the same memory space, making communication between them faster and more efficient.
Threads are lighter weight than processes, as they share resources such as memory and file descriptors.
Threads are more efficient for multitasking, as they can run concurrently within the same process.
Threads are easier to...
Google primarily focuses on pure data structures and algorithms-based questions during coding interviews. Other computer science core topics are typically not covered in Google's interviews. Therefore, it is essential to be proficient in data structures and algorithms to succeed in the Google coding interview.
An aptitude test is a tool used to evaluate a person's skills, abilities, and potential for success in a specific role or activity.
Group discussion is a process of exchanging ideas and opinions among individuals on a specific topic. It is a structured form of communication in which participants have the opportunity to express their views while also listening to others' perspectives on the same subject.
(2 Questions)
- Q1. What are your strengths and weaknesses?
- Ans.
My strengths include problem-solving skills and attention to detail. My weaknesses include time management and public speaking.
Strengths: problem-solving skills
Strengths: attention to detail
Weaknesses: time management
Weaknesses: public speaking
- Q2. What reasons can you provide for why we should consider hiring you?
- Ans.
I have a strong foundation in web development, a passion for learning, and a proven track record of delivering high-quality projects.
I have a solid understanding of HTML, CSS, and JavaScript
I am proficient in using various web development tools and frameworks such as React and Node.js
I have successfully completed several web development projects, including a responsive e-commerce website for a local business
An assignment is a task or piece of work that you are given to complete, particularly as part of your job or studies. The assignment for the course includes written assignments and practical tests, similar to tasks, work, jobs, or charges.
A case study is a detailed description and assessment of a specific situation in the real world, created for the purpose of deriving generalized insights and understanding. It can focus on an individual, a group of people, an organization, or an event, among other subjects.
(2 Questions)
- Q1. What do you consider your greatest accomplishment?
- Ans.
My greatest accomplishment was successfully leading a team to launch a new website for a major client ahead of schedule.
Successfully led a team to launch a new website
Completed the project ahead of schedule
Received positive feedback from the client
- Q2. What factors motivate you in your professional life?
- Ans.
I am motivated by challenges, learning opportunities, and the ability to make a positive impact.
Challenges push me to grow and improve my skills.
Learning opportunities allow me to stay updated with the latest technologies and trends.
Making a positive impact through my work gives me a sense of fulfillment and purpose.
(2 Questions)
- Q1. What does your ideal work environment look like?
- Ans.
My ideal work environment is a collaborative space with supportive colleagues, opportunities for growth, and a healthy work-life balance.
Collaborative team environment where ideas are shared and valued
Supportive colleagues who are willing to help and provide feedback
Opportunities for growth and learning new technologies
Healthy work-life balance with flexible hours and remote work options
- Q2. How would you impact employee retention?
- Ans.
By creating a positive work environment, offering growth opportunities, and implementing employee recognition programs.
Creating a positive work environment through open communication and support
Offering growth opportunities such as training programs and career advancement
Implementing employee recognition programs to acknowledge and reward hard work
Providing competitive salaries and benefits to attract and retain top ta
(2 Questions)
- Q1. What are real-time operating systems?
- Ans.
Real-time operating systems are designed to provide predictable response times and prioritize tasks based on timing constraints.
Real-time operating systems prioritize tasks based on timing constraints
They are designed to provide predictable response times
Examples include VxWorks, QNX, and FreeRTOS
- Q2. Are the applicants first asked several questions regarding data structures and algorithms?
(2 Questions)
- Q1. What topics are typically discussed during the final round of interviews, particularly regarding salary expectations, working hours, and other job requirements?
- Q2. Are you comfortable working night shifts, considering that many roles at Genpact support international clients?
- Ans.
Yes, I am comfortable working night shifts to support international clients.
I have previous experience working night shifts in a customer service role.
I am a night owl and tend to be more productive during late hours.
I understand the importance of supporting international clients and am willing to adjust my schedule accordingly.
(2 Questions)
- Q1. A process associate is crucial in ensuring the smooth operation of various business processes across different industries
- Q2. What are the operational tasks necessary to maintain efficiency and quality?
- Ans.
Operational tasks for maintaining efficiency and quality include regular testing, monitoring performance, updating software, and implementing best practices.
Regularly test website functionality to ensure it is working properly
Monitor website performance metrics such as load times and user experience
Update software and plugins to the latest versions to prevent security vulnerabilities
Implement best practices for coding,
(2 Questions)
- Q1. How can you prepare examples demonstrating your leadership, conflict resolution, and prioritization skills to excel in a managerial round interview?
- Ans.
Prepare examples showcasing leadership, conflict resolution, and prioritization skills for a managerial round interview.
Leadership: Discuss a project where you led a team to success, highlighting your ability to motivate and guide others.
Conflict Resolution: Share a situation where you successfully resolved a conflict within a team or project, emphasizing your communication and problem-solving skills.
Prioritization: Ta...
- Q2. How do you demonstrate adaptability, leadership, and a commitment to fostering a positive work environment?
- Ans.
I demonstrate adaptability, leadership, and commitment by actively seeking feedback, taking on new challenges, and fostering collaboration within the team.
Seek feedback from colleagues and supervisors to continuously improve
Volunteer for new projects or tasks to expand skills and knowledge
Encourage open communication and teamwork among team members
Lead by example by showing a positive attitude and willingness to help o...
Interview Preparation Tips
(2 Questions)
- Q1. Azure cloud platform tech
- Q2. Informatica tech stack ques
(2 Questions)
- Q1. Adf tech stack que
- Q2. Scd type 2 implementation
- Ans.
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
Identify the columns that need to be tracked for changes
Add effective start and end dates to track the validity of each record
Insert new records for changes and update end dates for previous records
Maintain a surrogate key to uniquely identify each version of the record
(2 Questions)
- Q1. Dw related que ans
- Q2. Solution design related que
(2 Questions)
- Q1. Aspiration from my end
- Q2. How soon can join
- Ans.
I can join the team within 2 weeks.
I can start within 2 weeks of receiving the offer.
I need to give notice to my current employer.
I may need to relocate, which could affect my start date.
Interview Preparation Tips
Then after putting my lot of time and efforts when finally it comes to release the offer, then they stop picking up the calls and stop responding and the final excuses which I got from them for not releasing the offer is that their software will not allow them to release any offer which is more that 2 days of joining.
Such a pathetic company who even don't know that atleast if you are not releasing the offer, it's your duty to atleast tell the person that either they are not able to provide the compensation as discussed or they are looking parallelly for someone who can settle in less compensation.
Due to all this I have wasted almost my 3-4 weeks of time expecting that I will receive the offer, and didn't focus on other organisations which was ready to provide slightly lower than this.
Hence it's a total scam which is going here suggesting not to get trapped otherwise you will not only waste your time but also other good opportunities as well.
It's a total boycott for me, expecting the same from your end as well, so that they will understand that playing with someone's job is not a joke.
Skills evaluated in this interview
(6 Questions)
- Q1. Write a code for febonacci series
- Q2. Dynamic webElements handling using Xpath?
- Q3. What is spike in agile?
- Q4. Difference between agile and waterfall based model?
- Q5. Sprint point system? Explain?
- Q6. Payment failure by debit card in e-commerce site? Make test scenarios?
Selected
For example, a โน10 LPA CTC could mean an in-hand salary of โน70,000โโน75,000 per month, depending on deductions and benefits.
โจ ๐ฃ๐ฟ๐ผ ๐ง๐ถ๐ฝ: Always request a detailed salary structure during negotiationsโitโs your roadmap to making informed decisions
๐๐ง๐ ๐๐ ๐๐ป-๐๐ฎ๐ป๐ฑ ๐ฆ๐ฎ๐น๐ฎ๐ฟ๐: ๐ง๐ต๐ฒ ๐ฅ๐ฒ๐ฎ๐น๐ถ๐๐ ๐๐ต๐ฒ๐ฐ๐ธ ๐๐๐ฒ๐ฟ๐ ๐ฃ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น ๐ก๐ฒ๐ฒ๐ฑ๐!
Weโve all been thereโexcitedly discussing job offers and hearing about the impressive CTC (Cost to Company). But when payday arrives, you wonder
(2 Questions)
- Q1. 2๏ธโฃ ๐๐ป-๐๐ฎ๐ป๐ฑ ๐ฆ๐ฎ๐น๐ฎ๐ฟ๐: This is the actual amount you take home after deductions like: โข Employeeโs contribution to PF โข Income tax (TDS) โข Professional tax
- Q2. ๐๐ง๐ ๐๐ ๐๐ป-๐๐ฎ๐ป๐ฑ ๐ฆ๐ฎ๐น๐ฎ๐ฟ๐: ๐ง๐ต๐ฒ ๐ฅ๐ฒ๐ฎ๐น๐ถ๐๐ ๐๐ต๐ฒ๐ฐ๐ธ ๐๐๐ฒ๐ฟ๐ ๐ฃ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น ๐ก๐ฒ๐ฒ๐ฑ๐! Weโve all been thereโexcitedly discussing job offers and hearing about the impressi...
Interview Preparation Tips
Weโve all been thereโexcitedly discussing job offers and hearing about the impressive CTC (Cost to Company). But when payday arrives, you wonder:
โ๐๐ฉ๐บ ๐ฅ๐ฐ๐ฆ๐ด๐ฏโ๐ต ๐ฎ๐บ ๐ช๐ฏ-๐ฉ๐ข๐ฏ๐ฅ ๐ด๐ข๐ญ๐ข๐ณ๐บ ๐ฎ๐ข๐ต๐ค๐ฉ ๐ต๐ฉ๐ฆ ๐๐๐ ๐ ๐ธ๐ข๐ด ๐ฑ๐ณ๐ฐ๐ฎ๐ช๐ด๐ฆ๐ฅ?โ
Mep Media Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Mep Media Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Mep Media Interview Questions
