i
Sopra Steria
Filter interviews by
I appeared for an interview in Oct 2023.
Different types of join conditions in SQL
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns rows when there is a match in either table
What people are saying about Sopra Steria
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 Walk-in and was interviewed before Nov 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.
I have 3 years of experience as a Business Analyst in the finance industry.
Worked closely with stakeholders to gather and analyze business requirements
Conducted market research and competitor analysis to identify opportunities and risks
Created detailed reports and presentations to communicate findings and recommendations
Collaborated with cross-functional teams to implement process improvements
Utilized data analysis too...
I applied via Referral and was interviewed before Oct 2020. There were 5 interview rounds.
I applied via Naukri.com and was interviewed before May 2021. There were 5 interview rounds.
I applied via Company Website and was interviewed before May 2021. There were 2 interview rounds.
They had ask the simple question during my interview process, here is the list if all questions:
1) what is df.copy()
2)why we choose inplace = True
3) Tfidf
4) confusion Matrix
5) can we use continuous variables for logistic regression
6)list and tuple diff
7)N grams, bag of words
8)access a column
9)lambda fn
10)method and object oops concepts
11) how to tackle Nan values
12) what is index in SQL
13)what is gini coefficient
14)when will you use linear regression and when you will use Decision Tres.
15) Random forest
16)Oops concepts
17)how to calculate the coefficient
18)PCA
19)SL/USL
20) classification/Regression
21)SVM
22)DT, RF, Hyper parameters in RF
23)how neural network works
24)NlP
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
Sample code for basic queries
Use SELECT statement to retrieve data from a table
Use WHERE clause to filter data based on conditions
Use ORDER BY clause to sort data in ascending or descending order
Use GROUP BY clause to group data based on a column
Use JOIN clause to combine data from multiple tables
I applied via Referral and was interviewed before Jul 2021. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Module Lead
1.8k
salaries
| ₹6.4 L/yr - ₹20.5 L/yr |
Senior Software Engineer
1.8k
salaries
| ₹4.8 L/yr - ₹18.5 L/yr |
Technical Lead
1.1k
salaries
| ₹9 L/yr - ₹26.5 L/yr |
Software Engineer
1k
salaries
| ₹3.5 L/yr - ₹11 L/yr |
Process Associate
498
salaries
| ₹1.5 L/yr - ₹5 L/yr |
Accenture
Wipro
Cognizant
Capgemini