Mphasis Senior Software Engineer Interview Questions, Process, and Tips

Q1. Java Intermediate level
Add your answer

Q1. Technical questions based on java
Add your answer

Q1. Basic behaviour test
Add your answer

Leetcode easy problem

Q1. Java collections
Add your answer
Q2. Microservice design pattern
Ans. 
Microservice design pattern focuses on breaking down a large application into smaller, independent services.
• Each microservice is responsible for a specific function or feature

• Communication between microservices is typically done through APIs

• Microservices can be deployed independently, allowing for scalability and flexibility
Answered by AI
Add your answer

Q1. How to convert rows to columns
Ans. 
To convert rows to columns, use the PIVOT function in SQL or transpose function in Excel.
• Identify the column to be transposed as the new row header

• Identify the column to be used as the new column header

• Use PIVOT function in SQL or transpose function in Excel

• Example: SELECT * FROM table_name PIVOT (MAX(column_to_be_transposed) FOR column_to_be_used AS new_column_header)

• Example: Select the data to be transposed in Excel,...read more
Answered by AI
Add your answer
Q2. Rate your skills in SQL, Informatica
Ans. 
I rate my SQL skills as advanced and my Informatica skills as intermediate.
• Advanced SQL skills include complex queries, stored procedures, and performance tuning.

• Intermediate Informatica skills include ETL development, mapping design, and workflow scheduling.

• I have experience with both SQL Server and Oracle databases.

• I am constantly learning and improving my skills in both areas.
Answered by AI
Add your answer

Q1. Questions regarding SQL Transformation, Java Transformations, and SCD type 2
Add your answer
Q2. Questions regarding Unix commands
Add your answer

Q1. What is Angular component life cycle? What are the hooks provided by Angular framework?
Ans. 
Angular component life cycle includes various hooks provided by Angular framework for managing component initialization, change detection, and destruction.
• ngOnChanges: Called when input properties of a component change

• ngOnInit: Called once when the component is initialized

• ngDoCheck: Called during every change detection run

• ngAfterContentInit: Called after content (ng-content) has been projected into the component

• ngAfter...read more
Answered by AI
Add your answer

Q1. What is box model in CSS? How to create responsive websites and web applications?
Ans. 
The box model in CSS defines the design and layout of elements on a webpage.
• The box model consists of content, padding, border, and margin.

• Content is the actual content of the element, padding is the space between the content and the border, border is the border around the element, and margin is the space outside the border.

• To create responsive websites and web applications, use media queries to adjust styles based on ...read more
Answered by AI
Add your answer

Q1. Overall experience and salary expectations
Add your answer