Mahanagar Telephone Nigam Interview Questions and Answers

Q1. Call flow 4G 5G
Add your answer
Q2. Troubleshooting of subscriber issues
Add your answer

Q1. PCRF AND CLOUD INFRASTRUCTURE
Add your answer
Q2. Telecommunication knowledge
Add your answer

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Assignments in marketing and sales involve processes related to product development, technology, and service taxation, as well as the enhancement of listening skills and other developmental processes beyond the same assignments.

Q1. What is the marketing What is the tax What are good and service tax
Add your answer
Q2. What are good and service tax
Add your answer
Q3. What is theDeveploment skills
Add your answer
Q4. How is skills and service
Add your answer
Q5. What istha markating skills
Add your answer

Q1. Basic techno managerial questions on tech you worked on work, interests, challenges you faced. Was fairly short.
Add your answer

Initially had a string based coding problem. Then was asked technical questions and then had a small break before doing system design with same interviewer for building book my show system and db schema.

Q1. Had a discussion with hiring manager on expectations, salary and growth.
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
Ans. 
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOP focuses on creating objects that interact with each other to solve complex problems.

• Fundamental concepts include classes, objects, inheritance, encapsulation, and polymorphism.

• Classes are blueprints for creating objects, while objects are instances of classes.

• Inheritance all...read more
Answered by AI
Add your answer
Q2. What is the definition of an array, and what are the different types of arrays?
Ans. 
An array is a data structure that stores a collection of elements of the same type. There are different types of arrays such as one-dimensional, multi-dimensional, and associative arrays.
• One-dimensional array: Stores elements in a single row or column.

• Multi-dimensional array: Stores elements in multiple rows and columns.

• Associative array: Uses key-value pairs to store elements.

• Example: ['apple', 'banana', 'orange']
Answered by AI
Add your answer
Q3. What is the clr
Ans. 
CLR stands for Common Language Runtime, a virtual machine component of the .NET framework responsible for managing code execution.
• CLR provides services such as memory management, exception handling, and security.

• It compiles code into Intermediate Language (IL) and then translates it into machine code at runtime.

• CLR allows for language interoperability within the .NET framework, enabling different languages to work toge
Answered by AI
Add your answer

The content is based on HTML, Windows, and ADO.NET.

Q1. What motivates you to pursue this job?
Ans. 
I am motivated to pursue a career as a Customer Care Executive because I enjoy helping others and providing excellent service.
• I have a passion for assisting customers and resolving their issues

• I thrive in a fast-paced environment where I can use my communication skills effectively

• I find satisfaction in ensuring customer satisfaction and building positive relationships

• I believe in the importance of delivering exceptiona...read more
Answered by AI
Add your answer
Q2. What is your expected salary?
Ans. 
My expected salary is based on my experience, skills, and the market rate for web developers.
• I have researched the average salary for web developers in this location.

• I am open to negotiation based on the overall compensation package offered.

• I am looking for a salary that reflects my expertise and contributions to the team.
Answered by AI
Add your answer

Q1. Are you willing to do this job
Add your answer
Q2. U have to manage ur team
Add your answer
Q3. Salary expectation
Add your answer

Q1. About myself and family
Add your answer
Q2. Regarding the job
Add your answer

Q1. Pcap analysis and log analysis
Add your answer
Q2. Feature testing
Add your answer

Q1. Kubernetes and docker
Add your answer
Q2. Amazon web service
Add your answer

Q1. 100k feet over view
Ans. 
A high-level overview of a topic or project, typically focusing on key points and goals.
• Summarize the main objectives and goals of the project

• Highlight key milestones and deliverables

• Provide a brief overview of the team structure and roles

• Discuss any potential challenges or risks

• Outline the overall impact and benefits of the project
Answered by AI
Add your answer
Q2. Technical overview of all technology
Add your answer

Q1. Difference between concepts
Ans. 
Difference between concepts refers to the distinctions or contrasts between two or more ideas, theories, or principles.
• Concepts are abstract ideas or mental representations, while differences are variations or distinctions between them.

• Understanding the difference between concepts helps clarify their meanings and applications.

• For example, the difference between velocity and speed in physics is that velocity includes di
Answered by AI
Add your answer
Q2. Basic understanding of concepts and technology
Add your answer

Q1. Salary expectation
Add your answer
Q2. Why you want to jump
Add your answer