Upload Button Icon Add office photos

Filter interviews by

dezerv Investment Analyst Interview Questions and Answers

Updated 29 Oct 2024

dezerv Investment Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

It was conducted on quizzes and time limit of 45 min and 100 question.

Round 2 - Video Call 

(3 Questions)

  • Q1. Yet to be taken
  • Q2. Tell me about the company
  • Q3. Where do you see yrself in 5 years
  • Ans. 

    In 5 years, I see myself as a senior investment analyst leading a team and making strategic investment decisions.

    • Advancing to a senior position within the company

    • Leading a team of analysts

    • Making strategic investment decisions

    • Continuing professional development through certifications or further education

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Yet to be taken

Interview Preparation Tips

Interview preparation tips for other job seekers - It's a good company overall

Interview questions from similar companies

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role
Round 1 - Assignment 
Round 2 - One-on-one 

(1 Question)

  • Q1. Guesstimates, SQL, MS-Excel related questions.
Round 3 - Case Study 

A case study, few HR questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, Excel are must. Python is good to have.

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.

I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Coding Test 

The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.

Round 3 - Technical 

(3 Questions)

  • Q1. Describe different types of joins
  • Ans. 

    Different types of joins are used in database queries to combine data from multiple tables.

    • Inner join: Returns only the matching records from both tables.

    • Left join: Returns all records from the left table and the matching records from the right table.

    • Right join: Returns all records from the right table and the matching records from the left table.

    • Full outer join: Returns all records when there is a match in either the ...

  • Answered by AI
  • Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
  • Q3. Calculated the rows based on joins and told the answer.
Round 4 - One-on-one 

(4 Questions)

  • Q1. Describe your previous experience
  • Ans. 

    I have 3 years of experience as a Business Analyst in the IT industry.

    • Worked on gathering and analyzing business requirements

    • Created functional specifications and user stories

    • Conducted stakeholder interviews and facilitated meetings

    • Performed data analysis and created reports

    • Collaborated with cross-functional teams to implement solutions

    • Utilized tools like JIRA and Confluence for project management

    • Improved business proc

  • Answered by AI
  • Q2. Shared the details regarding my experience
  • Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
  • Q4. Solved using lag function.
Round 5 - Case Study 

The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.

Interview Preparation Tips

Topics to prepare for Meesho Business Analyst interview:
  • SQL
  • Problem solving
Interview preparation tips for other job seekers - SQL and problem solving are the most important for this interview.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Coding Test 

HackerRank Test - 3 questions
SQL - Window functions and Joins

Round 2 - Technical 

(1 Question)

  • Q1. SQL - Joins, window functions and stored procedure
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL BASED SCENARIO QUESTIONS

Interview Preparation Tips

Interview preparation tips for other job seekers - NA

dezerv Interview FAQs

How many rounds are there in dezerv Investment Analyst interview?
dezerv interview process usually has 3 rounds. The most common rounds in the dezerv interview process are Aptitude Test, Video Call and One-on-one Round.
How to prepare for dezerv Investment 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 dezerv. The most common topics and skills that interviewers at dezerv expect are Business Economics, Data Analytics, Data Visualization, Data Warehousing and Investment Analysis.

Tell us how to improve this page.

dezerv Investment Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Reliance Retail Interview Questions
3.9
 • 1.6k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Paytm Interview Questions
3.3
 • 752 Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
CARS24 Interview Questions
3.5
 • 333 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
View all

dezerv Investment Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

3.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Investment Specialist
17 salaries
unlock blur

₹8 L/yr - ₹17 L/yr

Content Editor
6 salaries
unlock blur

₹7.2 L/yr - ₹7.2 L/yr

Business Development Associate
5 salaries
unlock blur

₹9 L/yr - ₹10 L/yr

Software Engineer
4 salaries
unlock blur

₹14 L/yr - ₹20 L/yr

Software Developer
4 salaries
unlock blur

₹15 L/yr - ₹19 L/yr

Explore more salaries
Compare dezerv with

Swiggy

3.8
Compare

Udaan

4.0
Compare

CARS24

3.5
Compare

Meesho

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