Mphasis Interview Questions, Process, and Tips

Q1. What is the agile methodology?
Ans. 
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.
• Agile focuses on delivering small, incremental releases and adapting to change quickly.

• It promotes collaboration between cross-functional teams and encourages frequent communication.

• Key principles include customer satisfaction, responding to change, and delivering working software.

• Common agile framewo...read more
Answered by AI
Add your answer
Q2. What is the waterfall model in software development?
Ans. 
Waterfall model is a linear sequential software development process where progress flows in one direction like a waterfall.
• Involves distinct phases such as requirements, design, implementation, testing, and maintenance.

• Each phase must be completed before moving on to the next.

• Changes are difficult to implement once a phase is completed.

• Example: Traditional software development approach.

• Example: Construction projects.
Answered by AI
Add your answer

Q1. Pyspark architecture
Add your answer
Q2. Optimisation in pyspark
Ans. 
Optimisation in PySpark involves improving performance and efficiency of Spark jobs.
• Use partitioning to distribute data evenly across nodes

• Avoid shuffling data between nodes as much as possible

• Use broadcast variables for small lookup tables

• Cache intermediate results to avoid recomputation

• Optimize transformations and actions for better performance
Answered by AI
Add your answer
Q3. Null handling in spark
Ans. 
Null handling in Spark involves handling missing or null values in data processing.
• Use functions like coalesce, na.fill, na.drop to handle null values

• Consider using when and otherwise functions for conditional null handling

• Be cautious of potential null pointer exceptions when working with null values
Answered by AI
Add your answer
Q4. Operators in airflow
Ans. 
Airflow operators are used to define the tasks to be executed in a workflow.
• Operators are classes that define the logic to execute a task in Airflow.

• There are various types of operators such as BashOperator, PythonOperator, and more.

• Operators can be customized to suit specific task requirements.

• Operators can be chained together to create complex workflows.

• Example: BashOperator executes a bash command, PythonOperator ru
Answered by AI
Add your answer
Q5. Sql coding for average rolling , lead lag
Ans. 
SQL coding for calculating average rolling, lead, and lag functions.
• Use window functions like ROWS BETWEEN and ORDER BY for calculating rolling averages.

• Use LEAD and LAG functions to access data from previous or next rows.

• Example: SELECT col1, AVG(col2) OVER (ORDER BY col1 ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS rolling_avg FROM table_name;
Answered by AI
Add your answer
Q6. Mysql to gcs ,how to move 10 tables at a time?
Ans. 
Use Apache Sqoop to move 10 tables from MySQL to Google Cloud Storage.
• Use Apache Sqoop to import data from MySQL to HDFS

• Use Google Cloud Storage connector for Hadoop to move data from HDFS to GCS

• Create a script to automate the process for all 10 tables
Answered by AI
Add your answer
Q7. Explode json data
Add your answer
Q8. Error logs
Add your answer

Q1. Technical questions on Mainframes and TOSCA
Add your answer

Q1. Client round with technical questions on mainframes and tosca
Add your answer

Q1. Till date they have not enrolled me even after confirming and doing my documentation
Add your answer

Q1. Documentation round which is still going on and its been 2 months
Add your answer

10 min, simple question on programming skills

Q1. Which Microservice communication pattern you have used?
Ans. 
I have used the asynchronous messaging pattern for Microservice communication.
• Implemented messaging queues like RabbitMQ or Kafka for decoupled communication

• Used message brokers to enable communication between Microservices

• Leveraged event-driven architecture for real-time updates and scalability
Answered by AI
Add your answer
Q2. Which Application Insight tool you have used?
Ans. 
I have used Application Insights for monitoring and analyzing the performance of .NET applications.
• Used Application Insights to track application performance metrics

• Analyzed telemetry data to identify performance bottlenecks

• Set up alerts and notifications for critical issues

• Integrated Application Insights with Azure DevOps for continuous monitoring
Answered by AI
Add your answer
Q3. Caching Technique is used in your project
Ans. 
We use in-memory caching technique in our project to improve performance and reduce database load.
• In-memory caching is used to store frequently accessed data in memory for quick retrieval

• Helps reduce database load and improve application performance

• Examples: using MemoryCache in .NET, Redis caching, caching frequently accessed data like user profiles or product information
Answered by AI
Add your answer
Q4. Api Gateways is used in MicrosServices
Ans. 
Yes, API Gateways are used in Microservices to manage and secure communication between services.
• API Gateways act as a single entry point for clients to access multiple microservices

• They handle authentication, authorization, rate limiting, logging, and monitoring

• Examples of API Gateways include Kong, Apigee, and AWS API Gateway
Answered by AI
Add your answer
Q5. Which single sign on technology/Mechanism is used in project
Ans. 
We are using OAuth 2.0 for single sign on in the project.
• OAuth 2.0 is a widely used authorization framework that enables a third-party application to obtain limited access to an HTTP service.

• It allows users to log in once and access multiple applications without having to log in again.

• OAuth 2.0 provides secure delegated access to resources without sharing user credentials.
Answered by AI
Add your answer
Q6. What is JWT token,why we use it
Ans. 
JWT token is a JSON Web Token used for secure transmission of information between parties.
• JWT token is a compact and self-contained way to transmit information between parties.

• It is digitally signed to verify its authenticity and integrity.

• JWT tokens consist of three parts: header, payload, and signature.

• They are commonly used for authentication and information exchange in web applications.

• Example: JWT tokens are often
Answered by AI
Add your answer
Q7. How to implement exception handling and filters in .net core web api
Ans. 
Exception handling and filters in .NET Core Web API
• Use try-catch blocks to handle exceptions in the code

• Implement global exception handling middleware to catch unhandled exceptions

• Use filters like [Authorize] for authentication and [ValidateAntiForgeryToken] for CSRF protection

• Create custom exception filters by implementing IExceptionFilter interface
Answered by AI
Add your answer

Online test -math & quants,verbal,puzzle,computer programming,logical

Q1. They select everyone from this & nothing serious
Add your answer

Q1. Any program which you know.
Ans. 
One program I know is a simple calculator program written in Python.
• The program takes user input for two numbers and an operator (+, -, *, /).

• It then performs the operation and displays the result.

• Example: input 5, +, 3 -> output 8
Answered by AI
Add your answer
Q2. About the projects in the resume
Add your answer
Q3. About the internship
Add your answer

Q1. Tell about yourself
Add your answer
Q2. Can you relocate yourself(your answer should be yes)
Add your answer

Q1. Core java concepts concepts , multithreading, spring boot,jpa ,MySQL ,api
Add your answer
Q2. Collection framework , java8, coding Questions 2 nd largest number find
Add your answer

Q1. Only salary discussed
Add your answer

Q1. What is a constructor and it's purpose?
Ans. 
A constructor is a special type of method in a class that is automatically called when an object of that class is created.
• Constructors have the same name as the class they belong to

• They are used to initialize the object's state or perform any necessary setup

• Constructors can have parameters to customize the initialization process

• Example: public class Car { public Car(String color) { this.color = color; } }
Answered by AI
Add your answer
Q2. Can you override a Static Method?
Ans. 
Yes, a static method can be overridden in Java using the concept of method hiding.
• In Java, static methods cannot be overridden in the traditional sense like instance methods.

• When a subclass defines a static method with the same signature as a static method in the superclass, it is called method hiding.

• Method hiding does not follow polymorphism and is resolved at compile time based on the reference type.

• Example: class...read more
Answered by AI
Add your answer
Q3. Can you create a Static local variable inside a Static method
Ans. 
Yes, a static local variable can be created inside a static method.
• Yes, a static local variable can be declared inside a static method in programming languages like C++.

• Static local variables retain their values between function calls.

• Example: static void myStaticMethod() { static int count = 0; count++; }
Answered by AI
Add your answer
Q4. What is the memory allocation for a String?
Ans. 
String memory allocation is dynamic and depends on the length of the string.
• String memory allocation is dynamic and can change based on the length of the string.

• In Java, a String object is stored in the heap memory.

• Each character in a String typically takes up 2 bytes of memory.

• String objects in Java are immutable, meaning once a String object is created, it cannot be changed.
Answered by AI
Add your answer
Q5. Can you create a Static method inside an Abstract class or Interface?
Ans. 
Yes, you can create a static method inside an abstract class or interface.
• Static methods can be defined in interfaces since Java 8.

• Static methods in interfaces are used for providing utility methods that are not tied to any specific instance of the interface.

• Static methods in abstract classes can be used for common functionality that does not require an instance of the class.
Answered by AI
Add your answer
Q6. What is the Parent class of Java?
Ans. 
The parent class of Java is the Object class.
• All classes in Java are directly or indirectly derived from the Object class.

• The Object class is the root class in Java's class hierarchy.

• It provides methods that are common to all objects in Java, such as toString(), equals(), and hashCode().
Answered by AI
Add your answer
Q7. What is Window Handles in Selenium?
Ans. 
Window Handles in Selenium are unique identifiers used to handle multiple browser windows in a Selenium test script.
• Window Handles are unique alphanumeric strings assigned to each browser window opened by Selenium.

• They are used to switch between different browser windows during a test script execution.

• Window Handles can be obtained using getWindowHandles() method in Selenium.

• Example: Set handles = driver.getWindowHandl
Answered by AI
Add your answer