Add office photos
Filter interviews by
ARCTERN CONSULTING Business Analyst Interview Questions and Answers
Updated
23 Feb 2022
1 interview found
Sort by:
Popular
Anonymous
I applied via Approached by Company and was interviewed before Feb 2021.
3 Interview Rounds
1
HR Round (1 Question)
- Q1. Why are you looking for a change? View Answers (1)
2
Technical Round
3
One-on-one Round
Interview Preparation Tips
Interview preparation tips for other job seekers - Loosen up. Read the job description carefully. Be clear of what you know and what you don't. Sharply articulate the things which you know and before the interview try to learn little about the things which you don't. Show the willingness to learn new things. Make the interviewer understand what you can actually do in the job and what you have never done according to the JD. Don't show false information about your previous jobs. This won't help only for this company's interview but it would be a great suggestion for the whole career. Thanks!
Interview questions from similar companies
Interview experience
Average
Difficulty level
-
Duration
-
Result
Selected
3 Interview Rounds
1
Technical Round (3 Questions)
- Q1. Finance questions - related to option pricing, derivatives, securities such as ABS, CLOs Add Answer
- Q2. Questions on hedge fund structure, ecosystem, hedge fund strategies Add Answer
- Q3. Why do you want to join IVP? Why not sell side core finance roles? Add Answer
2
One-on-one Round (4 Questions)
- Q1. Math puzzles, Statistics, Probability problems Add Answer
- Q2. Do you have any technical experience? Data visualization and SQL based Add Answer
- Q3. Why do you want to join us? Add Answer
- Q4. What do you know about IVP and the exact nature of work we do? Add Answer
3
HR Round (2 Questions)
- Q1. What keeps you going everyday? Add Answer
- Q2. Why do you want to join IVP and what strengths will make you thrive here? Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Walk-in and was interviewed in Jan 2024.
3 Interview Rounds
1
Pen paper test about user sto Round (1 Question)
- Q1. Got an application and you have to write user stories on it Add Answer
2
Technical Round (2 Questions)
- Q1. Interaction with client as business analyst Add Answer
- Q2. Agile methodology Add Answer
3
HR Round (1 Question)
- Q1. About family and how soon will you join Add Answer
Interview experience
Poor
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Referral and was interviewed in Jul 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Technical Round (2 Questions)
- Q1. SQL and domain - Use case scenarios and real time examples View Answers (1)
- Q2. SQL questions and domain related questions. Add Answer
Interview Preparation Tips
Topics to prepare for Affine Business Analyst interview:
If you are bit low in SQL and expert in your domain area, You will be eventually rejected.
- SQL
If you are bit low in SQL and expert in your domain area, You will be eventually rejected.
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. Tell me about your previous
work experience? Add Answer
- Q2. Why do you want to switch to IVP? View Answers (1)
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Walk-in and was interviewed in Aug 2023.
3 Interview Rounds
1
Assignment Round
It's a basic assignment to test your thinking they just give you a topic or a application and you have to write some features to that should be present on that app
2
Technical Round (3 Questions)
- Q1. What is Software development life cycle. View Answers (1)
- Q2. A scenario base question Add Answer
- Q3. There are some more basic questions Add Answer
3
HR Round (1 Question)
- Q1. Easy round they just check your interest and communication Add Answer
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed before Aug 2023.
3 Interview Rounds
1
Coding Test Round
Sql, Python mcq test
2
Technical Round (1 Question)
- Q1. Joins, Rank Dense Rank Rownumber, Window Function, Query to find 2nd highest salary Add Answer
3
HR Round (2 Questions)
- Q1. Why do you want to change job View Answers (1)
- Q2. See yourself in 5yrs View Answers (1)
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Referral
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What are the characteristics of a bond? View Answers (1)
- Q2. Tell me about yourself Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Walk-in and was interviewed in Sep 2023.
3 Interview Rounds
1
User Stories Round Round (1 Question)
- Q1. We were given a company name and were asked to write user stories for that organisation. Add Answer
2
Technical Round (1 Question)
- Q1. Scenario based question, like they gave me a scenario where I have to act as a Business Analyst and talk to the client about the requirements. Add Answer
3
HR Round (1 Question)
- Q1. General HR question about family background , etc Add Answer
I applied via Job Portal and was interviewed in May 2021.
6 Interview Rounds
Interview Questions
- Q1. How would you rate yourself
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - be truefull
ARCTERN CONSULTING Interview FAQs
How many rounds are there in ARCTERN CONSULTING Business Analyst interview?
ARCTERN CONSULTING interview process usually has 3 rounds. The most common rounds in the ARCTERN CONSULTING interview process are One-on-one Round, HR and Technical.
How to prepare for ARCTERN CONSULTING 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 ARCTERN CONSULTING. The most common topics and skills that interviewers at ARCTERN CONSULTING expect are Agile, Business Analysis, PeopleSoft finance, Project Management and Release management.
Tell us how to improve this page.
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
19%
more
than the average Business Analyst Salary in India
View more details
|
Team Lead
11
salaries
|  ₹10 L/yr - ₹15.2 L/yr |
|
Financial Analyst
8
salaries
| ₹7 L/yr - ₹8 L/yr |
|
Accounts Payable Analyst
6
salaries
| ₹4.5 L/yr - ₹8.1 L/yr |
|
Analyst
6
salaries
| ₹4.6 L/yr - ₹4.9 L/yr |
|
Senior Accounts Payable Analyst
5
salaries
| ₹5 L/yr - ₹9.5 L/yr |
Explore more salaries
Compare ARCTERN CONSULTING with
Accenture
Compare
Deloitte
Compare
KPMG India
Compare
PwC
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- ARCTERN CONSULTING Interview Questions >
- ARCTERN CONSULTING Business Analyst Interview Questions
Share an Interview