i
Mphasis
Filter interviews by
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
Pivoting a table in SQL involves rotating the data from rows into columns.
Use the PIVOT keyword in SQL to pivot a table
Specify the aggregation function and columns to pivot on
Example: SELECT * FROM table_name PIVOT (SUM(value) FOR column_name IN (value1, value2, ...))
Make sure to handle NULL values appropriately
To find the product wise second highest sales item, sort the sales data for each product and select the second highest value.
Sort the sales data for each product in descending order
Select the second value from the sorted list to find the second highest sales item
Consider ties and handle them accordingly
I applied via Company Website and was interviewed in Oct 2020. There were 3 interview rounds.
UL and VUL are both types of life insurance policies, but VUL offers investment options while UL does not.
UL stands for Universal Life Insurance, which offers a fixed premium and death benefit but no investment options
VUL stands for Variable Universal Life Insurance, which offers investment options in addition to a flexible premium and death benefit
VUL policyholders can choose to invest in stocks, bonds, and mutual fun...
Non-forfeiture options are the choices available to a policyholder when they stop paying premiums.
Non-forfeiture options allow policyholders to retain some value from their policy even if they stop paying premiums.
Common non-forfeiture options include reduced paid-up insurance, extended term insurance, and cash surrender value.
Reduced paid-up insurance provides a smaller death benefit but does not require further premi...
Reinsurance is a process where an insurance company transfers a portion of its risk to another insurance company.
Reinsurance helps insurance companies manage their risk exposure.
It allows insurance companies to protect themselves against large losses.
Reinsurance can be either proportional or non-proportional.
Proportional reinsurance involves sharing both premiums and losses with the reinsurer.
Non-proportional reinsuran...
Underwriting is the process of evaluating and assessing the risk of insuring a person or entity.
Underwriting involves analyzing the potential risks and determining the appropriate premium to charge for insurance coverage.
It is commonly used in the insurance industry for various types of insurance policies such as life, health, and property insurance.
Underwriting also involves reviewing the applicant's financial and med...
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
posted on 14 Mar 2021
I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.
I applied via Company Website and was interviewed in May 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
Experienced business analyst with a background in data analysis and process improvement.
Over 5 years of experience in analyzing business processes and identifying areas for improvement
Skilled in data analysis tools such as Excel, SQL, and Tableau
Strong communication and problem-solving skills
Certified in Business Analysis Professional (CBAP)
Previously worked on a project to streamline inventory management processes, re
BAU tasks of a Business Analyst include gathering requirements, analyzing data, creating reports, and facilitating communication between stakeholders.
Gathering and documenting business requirements from stakeholders
Analyzing data to identify trends and insights
Creating reports and presentations to communicate findings
Facilitating communication between different teams and stakeholders
Participating in meetings to discuss
API in Business Analysis refers to Application Programming Interface, which allows different software systems to communicate with each other.
APIs define the methods for accessing and interacting with software applications
They enable data sharing and functionality between different systems
APIs are commonly used in business analysis to integrate various software tools and systems
Examples include using APIs to connect a C
I rate myself as proficient in SQL knowledge.
I have extensive experience writing complex SQL queries for data analysis and reporting.
I am comfortable working with joins, subqueries, and aggregations.
I have optimized database performance by creating indexes and tuning queries.
I have experience with stored procedures, triggers, and functions.
I am familiar with database management systems like MySQL, SQL Server, and Oracl
Use cases are descriptions of how a system will be used by end users to achieve specific goals.
Use cases describe interactions between users and a system
They outline specific goals or tasks that users want to accomplish
Use cases help in understanding system requirements and functionality
Examples include 'User login', 'Place order', 'Generate report'
User stories are written in a specific format to capture requirements from the perspective of an end user.
Start with 'As a
Keep user stories small, focused, and independent
Include acceptance criteria to define when a user story is complete
Acceptance criteria are conditions that a product must meet to be accepted by stakeholders.
Acceptance criteria are defined during the requirements gathering phase.
They are used to determine if a product or feature is working as expected.
Acceptance criteria are usually written in a specific format such as 'Given-When-Then'.
Example: 'Given a user is logged in, when they click on the submit button, then the form should be
I applied via Campus Placement and was interviewed in Nov 2021. There were 4 interview rounds.
Questions were medium level and quants Questions, english Questions include vocabulary test etc were also there.
based on 1 interview
Interview experience
Software Engineer
6.5k
salaries
| ₹2 L/yr - ₹9.5 L/yr |
Senior Software Engineer
5.7k
salaries
| ₹6 L/yr - ₹24 L/yr |
Associate Software Engineer
4.7k
salaries
| ₹2 L/yr - ₹6 L/yr |
Module Lead
2.4k
salaries
| ₹9.5 L/yr - ₹36 L/yr |
Transaction Processing Officer
2.3k
salaries
| ₹1.4 L/yr - ₹4.5 L/yr |
Cognizant
Wipro
Accenture
TCS