Mphasis SD Analyst Interview Questions and Answers

Q1. About your self
Add your answer
Q2. Communication skills
Add your answer

Q1. Programming language
Add your answer
Q2. What tools do you utilize for data analysis?
Ans. 
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
• Excel for basic data manipulation and visualization

• Python for advanced data analysis and machine learning

• SQL for querying databases

• Tableau for creating interactive visualizations
Answered by AI
Add your answer
Q3. Pandas numpy seaborn matplot
Add your answer

Data analysis of code in the context of data analysis.

Coding logical question paper.

Q1. What do you know about customer service
Ans. 
Customer service involves providing assistance and support to customers before, during, and after a purchase.
• Customer service is essential for building and maintaining positive relationships with customers.

• It includes addressing customer inquiries, resolving complaints, and ensuring customer satisfaction.

• Examples of good customer service practices include active listening, empathy, and timely responses to customer need...read more
Answered by AI
Add your answer
Q2. How customer service is important
Ans. 
Customer service is important for building customer loyalty, resolving issues, and creating positive experiences.
• Customer service is crucial for building customer loyalty and retaining customers.

• It helps in resolving customer issues and complaints effectively.

• Good customer service can lead to positive word-of-mouth and repeat business.

• It plays a key role in creating a positive customer experience and building brand rep...read more
Answered by AI
Add your answer

Q1. What was your role and responsibilities
Add your answer
Q2. What do you know about router
Ans. 
A router is a networking device that forwards data packets between computer networks.
• Routers operate at the network layer of the OSI model

• They use routing tables to determine the best path for data packets to reach their destination

• Routers can be wired or wireless, and are commonly used in home and business networks

• Examples of popular router brands include Cisco, Netgear, and TP-Link
Answered by AI
Add your answer

Q1. DAX Related Syntax and Codes
Add your answer
Q2. Data Modelling, SQL, Python
Add your answer

Q1. No Response from HR after calling of selection after Round 1
Add your answer

The test level is moderate

Q1. Difference between c and java
Ans. 
C is a procedural language while Java is an object-oriented language.
• C is a low-level language, closer to the hardware, while Java is a high-level language.

• C requires manual memory management, while Java has automatic garbage collection.

• C is compiled directly to machine code, while Java is compiled to bytecode and runs on a virtual machine.

• C supports pointers, while Java does not.

• C is used for system programming, embed...read more
Answered by AI
Add your answer
Q2. Excel shortcuts
Add your answer

Q1. Can you provide a self-introduction?
Add your answer

Basics of mathematical ability and verbal ability

Q1. Introduction - explain projects
Add your answer
Q2. Data analytics explain
Add your answer

Q1. Explain pom xml
Ans. 
pom.xml is a configuration file used in Maven projects to define project settings, dependencies, and build process.
• pom.xml stands for Project Object Model XML

• It is used in Maven projects to manage project configuration, dependencies, and build process

• It contains information such as project name, version, dependencies, plugins, and repositories

• Example: <project><groupId>com.example</groupId><artifac...read more
Answered by AI
Add your answer
Q2. Explain test ng
Ans. 
TestNG is a testing framework for Java that supports various types of testing like unit, functional, end-to-end, etc.
• TestNG allows for easy configuration of test cases using annotations like @Test, @BeforeMethod, @AfterMethod, etc.

• It supports parameterization of test cases using @Parameters annotation.

• TestNG provides features like grouping of test cases, dependency management, parallel execution, and reporting.

• It integ...read more
Answered by AI
Add your answer

Q1. Explain about current project
Ans. 
Currently working on implementing automated testing for a web application using Selenium and Cucumber framework.
• Developing test scripts using Selenium WebDriver for automated testing

• Creating feature files and step definitions using Cucumber for behavior-driven development

• Executing test cases and analyzing results to ensure quality of the web application

• Collaborating with developers to identify and resolve defects

• Partic...read more
Answered by AI
Add your answer
Q2. Explain current role
Ans. 
I am currently working as a Quality Analyst, responsible for ensuring the quality of products or services meets the required standards.
• Conducting quality assurance tests on products or services

• Identifying defects or issues and working with teams to resolve them

• Creating and implementing quality control processes

• Analyzing data to identify trends and areas for improvement
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Speak anything you want in 5 minutes.
Ans. 
I will talk about my passion for data analysis and how I have used it to solve complex problems in previous projects.
• I have always been fascinated by the power of data analysis in uncovering insights and driving decision-making.

• In my previous role, I used data analysis to identify trends and patterns in customer behavior, leading to a 10% increase in sales.

• I am proficient in various data analysis tools such as Excel, S...read more
Answered by AI
Add your answer

Basic mapping questions.

Q1. Discused about salary and shifts.
Add your answer
Q2. They focoused on comunication.
Add your answer

Q1. How to perform Set Actions, LOD's
Add your answer