Mphasis Technical Dotnet Lead Interview Questions, Process, and Tips

Q1. Azure cloud platform tech
Add your answer
Q2. Informatica tech stack ques
Add your answer

Q1. Adf tech stack que
Add your answer
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
Answered by AI
Add your answer

Q1. Dw related que ans
Add your answer
Q2. Solution design related que
Add your answer

Q1. Aspiration from my end
Add your answer
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.
Answered by AI
Add your answer

Q1. Create Custom hook to fetch data
Ans. 
Custom hook to fetch data in React
• Create a custom hook using the 'useEffect' and 'useState' hooks

• Use 'fetch' or any other method to fetch data from an API

• Return the fetched data from the custom hook
Answered by AI
Add your answer
Q2. Javascript concept and output
Add your answer

Q1. React hooks and lifecycle
Add your answer
Q2. Custom hook and some tricky output question
Add your answer

Q1. What is Ppk and Cpk in Six Sigma??
Ans. 
Ppk and Cpk are process capability indices used in Six Sigma to measure the ability of a process to produce output within specification limits.
• Ppk and Cpk are statistical measurements that assess how well a process is performing in relation to its specification limits.

• Ppk measures the potential capability of a process to produce output within specification limits, while Cpk measures the actual capability of a process t...read more
Answered by AI
Add your answer
Q2. What are the different types of risks??
Ans. 
Different types of risks include financial, operational, strategic, compliance, and reputational risks.
• Financial risk: related to the potential loss of financial resources, such as market risk, credit risk, and liquidity risk.

• Operational risk: arises from internal processes, systems, or people, leading to errors, fraud, or disruptions.

• Strategic risk: involves the impact of business decisions on the organization's long-...read more
Answered by AI
Add your answer

Q1. Explain ISO 13485 implementation in your current employer?
Add your answer
Q2. What the curves on the Probability plot denotes?
Ans. 
Probability plot curves denote the distribution of data points compared to a theoretical distribution.
• Probability plot curves help visualize how well a dataset fits a particular distribution.

• The curves can indicate if the data is normally distributed or follows a different distribution.

• Examples of probability plots include Q-Q plots and P-P plots.
Answered by AI
Add your answer

Q1. Salary discussed
Add your answer
Q2. Nothing more than the salary discussed
Add your answer

Q1. Fake Interview, Didn't expect this from virtusa
Add your answer
Q2. FakeInterviews conducted, Didn;t expect this from virtusa
Add your answer
Q3. Virtusa Scammers
Add your answer

Q1. Describe 5 non functional requirements
Ans. 
Non functional requirements are criteria that specify how a system should behave, rather than what it should do.
• Performance - system should respond within 2 seconds for all user interactions

• Scalability - system should be able to handle 1000 concurrent users

• Reliability - system should have a 99.99% uptime

• Security - system should encrypt all sensitive data

• Usability - system should have a user-friendly interface
Answered by AI
Add your answer
Q2. How will you improve performance of legacy app which has to work with your latest microservice.
Ans. 
Improve legacy app performance by optimizing code, implementing caching, and scaling resources.
• Optimize code by identifying and removing bottlenecks

• Implement caching to reduce database calls and improve response time

• Scale resources by using containers or serverless architecture

• Use asynchronous processing for long-running tasks

• Upgrade hardware or infrastructure if necessary
Answered by AI
Add your answer

Q1. Explain security in microservices
Ans. 
Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.
• Implement authentication and authorization mechanisms to control access to microservices.

• Use encryption to secure communication between microservices and external clients.

• Implement monitoring and logging to detect and respond to security incidents.

• Consider using API gateways for central...read more
Answered by AI
Add your answer
Q2. Describe microservices architecture for a wealth management app
Ans. 
Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.
• Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.

• Services communicate through APIs, allowing for flexibility and scalability.

• Each microservice can be developed, deployed, and scaled independently, leading to faster develo...read more
Answered by AI
Add your answer

Hacker Rank test, problem solving. Java 8

Q1. Java 8 feature related questions.
Add your answer
Q2. Jvm architecture and memory management
Add your answer
Q3. Sql self join query and query tuning
Add your answer
Q4. Spring boot microservices design pattern discussion
Add your answer

Q1. Problem solving based on java and case study
Add your answer
Q2. Team handling and management skills
Add your answer
Q3. Docker and Orchetratetion framework
Add your answer
Q4. Aws cloud and cicd and related technologies
Add your answer

Q1. What is your Favorite movie ?
Ans. 
My favorite movie is The Shawshank Redemption.
• Directed by Frank Darabont

• Based on a Stephen King novella

• Set in a prison in Maine

• Themes of hope, friendship, and redemption

• Starring Tim Robbins and Morgan Freeman
Answered by AI
Add your answer
Q2. What is your Favorite colour?
Ans. 
My favorite color is blue because it reminds me of the calming ocean and clear skies.
• Blue is associated with calmness and tranquility

• It symbolizes trust, loyalty, and confidence

• Examples: navy blue, sky blue, royal blue
Answered by AI
Add your answer

Q1. What is power draining?
Ans. 
Power draining refers to the excessive consumption of power by a device or system, leading to decreased battery life or performance.
• Power draining can occur due to background apps running constantly on a device.

• Faulty hardware components can also contribute to power draining.

• Settings such as high screen brightness or frequent data syncing can increase power draining.

• Examples include a smartphone losing battery quickly ...read more
Answered by AI
Add your answer
Q2. What is VPN? When you use it?
Ans. 
VPN stands for Virtual Private Network. It is used to create a secure connection over the internet, allowing users to access private networks remotely.
• VPN encrypts data to ensure privacy and security

• It allows users to access restricted websites or content

• Commonly used for remote work, accessing company networks, and bypassing geo-restrictions

• Examples include NordVPN, ExpressVPN, and Cisco AnyConnect
Answered by AI
Add your answer

Q1. Design an weather app using android architecture components?
Ans. 
Design a weather app using Android architecture components.
• Use MVVM architecture pattern for separation of concerns

• Implement LiveData for real-time data updates

• Utilize Room database for offline data storage

• Integrate Retrofit for network calls to fetch weather data

• Use ViewModel to manage UI-related data in a lifecycle-conscious way
Answered by AI
Add your answer

Q1. Discussion on projects done
Add your answer