Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Motilal Oswal Financial Services Team. If you also belong to the team, you can get access from here

Motilal Oswal Financial Services Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Motilal Oswal Financial Services Data Analyst Interview Questions and Answers

Updated 10 Jan 2025

Motilal Oswal Financial Services Data Analyst Interview Experiences

4 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 10 Jan 2025

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Interview was taken in malad on interface 7 building The relationship officer Vaibhav Panchal . He assigned Interviewer the way he was talking he was not able to speak in english half of the question i was...
  • Q2. His english was poor How you will get the customer count who speak in english? he didn't gave me which table to fetch from ? * question changed get the customer from one table and count from the other ...

Interview Preparation Tips

Interview preparation tips for other job seekers - They intend to hire from internal referrals, why waste our time and your

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 5 Aug 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Walk-in

Round 1 - Technical 

(2 Questions)

  • Q1. Explain Data types in SQL?
  • Ans. 

    Data types in SQL define the type of data that can be stored in a column of a table.

    • Data types include integer, float, text, date, boolean, etc.

    • Each data type has specific properties and constraints.

    • Examples: INT for integers, VARCHAR for variable-length character strings.

  • Answered by AI
  • Q2. Explain the difference between DBMS and RDBMS?
  • Ans. 

    DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.

    • DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

    • RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

    • RDBMS e...

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Apr 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

It contained python coding questions as well as machine learning questions

Round 2 - Technical 

(3 Questions)

  • Q1. Sql joins, python codes
  • Q2. Complete codes and correct erros
  • Q3. Machine learning
Round 3 - Case Study 

Case study related to my project and background and internship

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well be confident

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Mar 2023

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

I applied via Walk-in and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Group Discussion 

We started with our friends who is Business associate of Motilal Oswal finance services and those 2 friends are take brokership of financial firm, I was already there as a Tech Guy and Reasearcher for Stock Market and Fundamental Analytics , conducted more than 100 stocks analysis to advise clients to reduce the risk.

Round 2 - Behavioral 

(2 Questions)

  • Q1. We friends just do a group discussion for the customer relationship
  • Q2. Investment and products related interview

Interview Preparation Tips

Interview preparation tips for other job seekers - If you want to take a part in motilal oswal either you should choose entry level brokership or if you join as other designation you got and do walkin interview.

Motilal Oswal Financial Services interview questions for designations

 Senior Data Analyst

 (1)

 Business Analyst

 (1)

 Data Scientist

 (2)

 Investment Banking Analyst

 (1)

 Business Analyst Intern

 (1)

 Financial Advisor

 (13)

 Senior Executive

 (9)

 Assistant Manager

 (7)

Data Analyst Jobs at Motilal Oswal Financial Services

View all

Interview questions from similar companies

Round 1 - Assignment 

Python based EDA assignment

Round 2 - One-on-one 

(1 Question)

  • Q1. Nilllllllllllllllllllllllll

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your Python and sql skills strong enough
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. NANANANANANANANA
  • Q2. NANANANANANANANANA
Round 2 - One-on-one 

(2 Questions)

  • Q1. NANANANAANANANA
  • Q2. NANANANANANANANANANA
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Feb 2023. There were 3 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 Resume tips
Round 2 - Coding Test 

Hackerrank test medium difficulty

Round 3 - Case Study 

Presenting the case study which was given as a take-home assignment

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for all the basic concepts in Statistics, Database related. Most of the questions will be easy
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself and the current projects you are working on.
Round 2 - Technical 

(1 Question)

  • Q1. Sql Questions on regex, json , window functions were there.
Round 3 - Technical 

(1 Question)

  • Q1. Questions on current project, Tableau related question were there.

I applied via Recruitment Consultant

Interview Questionnaire 

6 Questions

  • Q1. Were location me to company and
  • Q2. Were location gone me location
  • Q3. When you me take me constant
  • Q4. Because me best for edelweiss
  • Q5. Location give me I will best
  • Q6. How give me Edelweiss

Interview Preparation Tips

Interview preparation tips for other job seekers - I were beast for edelweiss good in
Stargate home location B D work
Operation work and also CHM
Because edelweiss is my best company
So I will best for edelweiss
In all work me interested so beast future in edelweiss so

I applied via Referral and was interviewed in Mar 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About Capital Market Domain
  • Q2. How you can add value to product.
  • Ans. 

    I can add value to a product by identifying and analyzing customer needs, improving processes, and implementing innovative solutions.

    • Conduct market research to identify customer needs and preferences

    • Analyze data to identify areas for improvement in product design and functionality

    • Collaborate with cross-functional teams to develop and implement innovative solutions

    • Streamline processes to improve efficiency and reduce co...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You must know about Agile methodology.
NISM certification will add value.
How to write Business requirement documents.
You must know about SQL.
Contribute & help others!
anonymous
You can choose to be anonymous

Motilal Oswal Financial Services Interview FAQs

How many rounds are there in Motilal Oswal Financial Services Data Analyst interview?
Motilal Oswal Financial Services interview process usually has 2 rounds. The most common rounds in the Motilal Oswal Financial Services interview process are Technical, Resume Shortlist and Group Discussion.
How to prepare for Motilal Oswal Financial Services Data 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 Motilal Oswal Financial Services. The most common topics and skills that interviewers at Motilal Oswal Financial Services expect are Data Analysis, SQL, Advanced Excel, Power BI and Analytical Skills.
What are the top questions asked in Motilal Oswal Financial Services Data Analyst interview?

Some of the top questions asked at the Motilal Oswal Financial Services Data Analyst interview -

  1. Explain the difference between DBMS and RDB...read more
  2. Explain Data types in S...read more
  3. Interview was taken in malad on interface 7 building The relationship officer V...read more

Recently Viewed

REVIEWS

Aditya Birla Capital

No Reviews

REVIEWS

Aditya Birla Capital

No Reviews

REVIEWS

Aditya Birla Capital

No Reviews

REVIEWS

Aditya Birla Capital

No Reviews

REVIEWS

Aditya Birla Capital

No Reviews

SALARIES

Aditya Birla Capital

LIST OF COMPANIES

Motilal Oswal Financial Services

Locations

REVIEWS

Aditya Birla Capital

No Reviews

INTERVIEWS

Motilal Oswal Financial Services

No Interviews

SALARIES

Aditya Birla Capital

No Salaries

Tell us how to improve this page.

Motilal Oswal Financial Services Data Analyst Interview Process

based on 5 interviews

Interview experience

3
  
Average
View more
Motilal Oswal Financial Services Data Analyst Salary
based on 29 salaries
₹2.4 L/yr - ₹10.7 L/yr
At par with the average Data Analyst Salary in India
View more details

Motilal Oswal Financial Services Data Analyst Reviews and Ratings

based on 3 reviews

4.3/5

Rating in categories

4.3

Skill development

4.1

Work-life balance

4.1

Salary

4.1

Job security

4.3

Company culture

4.1

Promotions

4.1

Work satisfaction

Explore 3 Reviews and Ratings
Data Analyst (Team Leader)

Mumbai,

Mumbai Suburban

4-7 Yrs

₹ 4-9 LPA

Explore more jobs
Assistant Manager
866 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
819 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
641 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Equity Advisor
550 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Financial Advisor
373 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Motilal Oswal Financial Services with

Edelweiss

3.9
Compare

ICICI Securities

3.9
Compare

HDFC Securities

3.6
Compare

Kotak Securities

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent