AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Avanse Financial Services Business Risk Analyst Interview Questions and Answers
Avanse Financial Services Business Risk Analyst Interview Experiences
1 interview found
Selected
I was interviewed in Jan 2025.
(1 Question)
- Q1. Asking about previous company experience
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. Questions based on the understanding of joins in sql
- Q2. Convert row to columns using sql
- Ans.
Use SQL pivot function to convert rows to columns
Use the PIVOT function in SQL to convert rows into columns
Specify the columns you want to pivot on and the values you want to display in the new columns
Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name
Skills evaluated in this interview
(1 Question)
- Q1. Result of different sql joins
- Ans.
SQL joins combine data from two or more tables based on a related column between them.
Inner join returns rows that have matching values 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 all rows when there is a match in either left or right table
Skills evaluated in this interview
(1 Question)
- Q1. Joins, case when
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
Joins are used to retrieve data from multiple tables based on a related column
Case when is used to perform different actions based on different conditions in SQL queries
Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...
Skills evaluated in this interview
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Joins, SQL query execution
- Q2. Simple Sals Question - SQL
(1 Question)
- Q1. Explain your projects
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.
Aptitude tests + 3 Rounds
Interview Preparation Tips
1. The First Round was a basic guesstimate round.
2. The Second Round was a feature Discussion round about the Netflix search bar.
3. The final round was a mix of a Case Breakdown + HR + Questions about Groww.
Selected
I applied via Indeed and was interviewed before Dec 2022. There were 2 interview rounds.
(1 Question)
- Q1. Sql ,excel , python based question
(1 Question)
- Q1. Case studies and analytical puzzle
Business Analyst Interview Questions & Answers
Futures First info Services
Anonymous
posted on 25 Aug 2021
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell us about OPEC and the oil commodity business
- Ans.
OPEC is a group of oil-producing countries that work together to regulate the supply and price of oil in the global market.
OPEC stands for Organization of the Petroleum Exporting Countries
It was founded in 1960 and currently has 14 member countries
OPEC controls around 44% of the world's oil production
The organization meets regularly to set production quotas and adjust oil prices
OPEC's decisions can have a significant i
Interview Preparation Tips
Avanse Financial Services Interview FAQs
Tell us how to improve this page.
Avanse Financial Services Interviews By Designations
- Avanse Financial Services Cluster Manager Interview Questions
- Avanse Financial Services Operations Executive Interview Questions
- Avanse Financial Services Relationship Manager Interview Questions
- Avanse Financial Services Assistant Manager Interview Questions
- Avanse Financial Services Branch Credit Manager- Credit & Operations Interview Questions
- Avanse Financial Services Business Analyst Interview Questions
- Avanse Financial Services Business Risk Analyst Interview Questions
- Avanse Financial Services Compliance Officer Interview Questions
- Show more
Interview Questions for Popular Designations
- Risk Analyst Interview Questions
- Transaction Risk Investigator Interview Questions
- Credit Risk Analyst Interview Questions
- Risk and Compliance Analyst Interview Questions
- Risk Manager Interview Questions
- Senior Risk Analyst Interview Questions
- Business Analyst Interview Questions
- Assistant Risk Manager Interview Questions
- Show more
Avanse Financial Services Business Risk Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Sales Executive
64
salaries
|  ₹2 L/yr - ₹3.3 L/yr |
|
Assistant Manager
51
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Deputy Manager
49
salaries
| ₹4.8 L/yr - ₹10.5 L/yr |
|
Operations Executive
46
salaries
| ₹1.7 L/yr - ₹3.1 L/yr |
|
Branch Credit Manager
36
salaries
| ₹4 L/yr - ₹9 L/yr |
Bajaj Finance
HDFC Bank
ICICI Bank
Kotak Mahindra Bank
- Home >
- Interviews >
- Avanse Financial Services Interview Questions >
- Avanse Financial Services Business Risk Analyst Interview Questions
