Upload Button Icon Add office photos

Filter interviews by

Avanse Financial Services Business Analyst Interview Questions and Answers

Updated 12 Sep 2024

Avanse Financial Services Business Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.

    • Experienced in gathering and analyzing business requirements

    • Skilled in creating detailed reports and presentations

    • Proficient in using data visualization tools like Tableau

    • Strong communication and interpersonal skills

    • Certified in Agile methodologies

  • Answered by AI
  • Q2. What is your day 2 day activities
  • Ans. 

    As a Business Analyst, my day-to-day activities involve gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.

    • Conducting meetings with stakeholders to gather requirements

    • Analyzing data to identify trends and insights

    • Creating reports and presentations to communicate findings

    • Collaborating with cross-functional teams to implement solutions

    • Monitoring and evaluating

  • Answered by AI
  • Q3. How many applications have been made
  • Ans. 

    The number of applications made is confidential and not publicly disclosed.

    • The exact number of applications made is not publicly available.

    • The company may choose to keep this information confidential for competitive reasons.

    • It is important to respect the company's decision to not disclose this information.

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. CTC discussion present and expectations
  • Q2. When can you join
  • Ans. 

    I can join within 2 weeks of receiving an offer.

    • I can start within 2 weeks of receiving an offer.

    • My current notice period is 2 weeks.

    • I am available to start immediately.

  • Answered by AI

Business Analyst Jobs at Avanse Financial Services

View all

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain your projects

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about general knowledge and current affairs. Be careful about what you answer. Next question will be based on that
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Banking regarding Questions

Round 2 - Group Discussion 

The topic advantage and disadvantage of AI

I applied via LinkedIn and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Technical JAVA questions

Interview Preparation Tips

Interview preparation tips for other job seekers - The technical question difficulty was moderate level
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain your projects

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about general knowledge and current affairs. Be careful about what you answer. Next question will be based on that
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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 = ...

  • Answered by AI

Skills evaluated in this interview

Avanse Financial Services Interview FAQs

How many rounds are there in Avanse Financial Services Business Analyst interview?
Avanse Financial Services interview process usually has 2 rounds. The most common rounds in the Avanse Financial Services interview process are One-on-one Round and HR.
How to prepare for Avanse Financial Services Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Avanse Financial Services. The most common topics and skills that interviewers at Avanse Financial Services expect are Business Analysis, Project Management, corporate planning, Competitor Analysis and Data Analysis.
What are the top questions asked in Avanse Financial Services Business Analyst interview?

Some of the top questions asked at the Avanse Financial Services Business Analyst interview -

  1. How many applications have been m...read more
  2. CTC discussion present and expectati...read more

Tell us how to improve this page.

Avanse Financial Services Business Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Avanse Financial Services Business Analyst Salary
based on 15 salaries
₹6 L/yr - ₹15.5 L/yr
19% more than the average Business Analyst Salary in India
View more details

Avanse Financial Services Business Analyst Reviews and Ratings

based on 3 reviews

4.7/5

Rating in categories

4.7

Skill development

3.9

Work-life balance

4.0

Salary

4.7

Job security

4.7

Company culture

4.8

Promotions

4.7

Work satisfaction

Explore 3 Reviews and Ratings
Sales Executive
64 salaries
unlock blur

₹2 L/yr - ₹3.3 L/yr

Deputy Manager
55 salaries
unlock blur

₹4.8 L/yr - ₹10.5 L/yr

Assistant Manager
51 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Operations Executive
47 salaries
unlock blur

₹1.7 L/yr - ₹3 L/yr

Branch Credit Manager
36 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Explore more salaries
Compare Avanse Financial Services with

Bajaj Finance

4.0
Compare

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Kotak Mahindra Bank

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview