Upload Button Icon Add office photos

Filter interviews by

National Stock Exchange of India Data Analyst Interview Questions and Answers

Updated 25 Nov 2024

National Stock Exchange of India Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Gopal Bathula

posted on 25 Nov 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 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Asked about oops
  • Q2. And also aked SQL related queries

Interview Preparation Tips

Interview preparation tips for other job seekers - go hard

Interview questions from similar companies

Round 1 - Aptitude Test 

Double entry, isin, balance sheet

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go through your CV once and answer

I applied via Referral and was interviewed before Jan 2020. There were 6 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. What is amortization?
  • Ans. 

    Amortization is the process of spreading out a loan into smaller, regular payments over a period of time.

    • It is used to pay off a debt over time with regular payments

    • Each payment includes both principal and interest

    • The amount of interest decreases over time as the principal is paid off

    • Examples include mortgages, car loans, and student loans

  • Answered by AI
  • Q2. What is WASO, TSO and EPS?
  • Ans. 

    WASO is Wake After Sleep Onset, TSO is Total Sleep Time, and EPS is Earnings Per Share.

    • WASO is the amount of time spent awake after initially falling asleep.

    • TSO is the total amount of time spent sleeping, including both REM and non-REM sleep.

    • EPS is a financial metric that represents the portion of a company's profit allocated to each outstanding share of common stock.

    • WASO and TSO are commonly used in sleep studies, whi

  • Answered by AI
  • Q3. What are the elements which are present in all the financial statements like BS,IS and CF.
  • Ans. 

    The financial statements (BS, IS, CF) have common elements such as assets, liabilities, equity, revenue, expenses, and cash flows.

    • Assets: resources owned by the company

    • Liabilities: obligations owed by the company

    • Equity: residual interest in the assets of the company

    • Revenue: income generated by the company

    • Expenses: costs incurred by the company

    • Cash flows: inflows and outflows of cash

  • Answered by AI
  • Q4. What is the effect of stock split on market capitalisation of a company?
  • Ans. 

    A stock split increases the number of shares outstanding and decreases the price per share, but does not affect the market capitalisation.

    • Stock split does not affect the total value of the company

    • Market capitalisation remains the same after a stock split

    • Stock split increases the number of shares outstanding and decreases the price per share

    • For example, if a company has 1 million shares outstanding and the stock splits ...

  • Answered by AI
  • Q5. Components of Cash flow statements?
  • Ans. 

    Cash flow statements have three main components: operating activities, investing activities, and financing activities.

    • Operating activities: cash inflows and outflows from the company's core business operations.

    • Investing activities: cash inflows and outflows from buying or selling long-term assets.

    • Financing activities: cash inflows and outflows from borrowing or repaying debt, issuing or buying back stock, and paying di...

  • Answered by AI
  • Q6. How is EPS caluclated?
  • Ans. 

    EPS is calculated by dividing the company's net income by the number of outstanding shares.

    • EPS = Net Income / Outstanding Shares

    • Net Income is the company's total earnings after expenses and taxes

    • Outstanding Shares are the total number of shares issued by the company

    • EPS is an important metric for investors to evaluate a company's profitability

    • Higher EPS indicates better profitability and potential for higher dividends

  • Answered by AI
  • Q7. About your last company and role? Why you want to leave the company?
  • Q8. Abou the role,. Any info on the role that you are applying?

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the financial statements. Check all ratios with respect to statements. Be clear about the job profile. Read about the company.

Skills evaluated in this interview

I appeared for an interview in Dec 2020.

Interview Questionnaire 

1 Question

  • Q1. 30 equity and 30 aptitude

Interview Preparation Tips

Interview preparation tips for other job seekers - When u apply for job. Start working on your knowledge after applying only. Don't wait for email bcz email comes at night and online test was there at day after only at afternoon. If u pass u will get selection email and thereafter 3 round of interview is there.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Join and window functions
  • Q2. Python questions and puzzles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL related PL SQL , Stored PRocedures
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Simple and basic coding knowledge is enough to clear this round

Round 2 - Technical 

(2 Questions)

  • Q1. Technical questions
  • Q2. Varied based on person

Interview Preparation Tips

Topics to prepare for Mr Cooper Data Analyst interview:
  • Python
  • C++
  • Java
  • Communication Skills
Interview preparation tips for other job seekers - Coding skills are mandatory to get recruited in the company. Communication skills are must.
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I appeared for an interview in Aug 2023.

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 - Technical 

(1 Question)

  • Q1. I attended this round in DLF IT park Porur.There were 3 persons in F2F technical interview.Questions based on SQL(full concepts in SQL),tableau, python and projects mentioned in resume.
Round 3 - One-on-one 

(1 Question)

  • Q1. Second round was AVP round where the interviewer asked to explain the line by line code of my project
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 Feb 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

30 questions: aptitude ,output questions, 3 coding questions

Round 2 - Assignment 

Mostly to connect front end and backend

Interview Preparation Tips

Topics to prepare for Mr Cooper Data Analyst interview:
  • datastructures
  • heap
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Top 7 th employee salary
Find Duplicates

Round 2 - Technical 

(3 Questions)

  • Q1. Trigger Stored procedure
  • Ans. 

    A trigger is a special type of stored procedure that is automatically executed when certain events occur in a database.

    • Triggers are used to enforce business rules, maintain data integrity, and automate tasks.

    • They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

    • For example, a trigger can be created to update a log table whenever a new record is inserted into a main table.

  • Answered by AI
  • Q2. Gateway Different modes in power bi
  • Ans. 

    Power BI has different modes like View, Edit, and Data Source.

    • View mode allows users to interact with reports and dashboards

    • Edit mode enables users to modify existing reports and create new ones

    • Data Source mode allows users to connect to and manipulate data sources

  • Answered by AI
  • Q3. Nothing to get importance no words

Skills evaluated in this interview

National Stock Exchange of India Interview FAQs

How many rounds are there in National Stock Exchange of India Data Analyst interview?
National Stock Exchange of India interview process usually has 1 rounds. The most common rounds in the National Stock Exchange of India interview process are Technical.
What are the top questions asked in National Stock Exchange of India Data Analyst interview?

Some of the top questions asked at the National Stock Exchange of India Data Analyst interview -

  1. and also aked SQL related quer...read more
  2. asked about o...read more

Tell us how to improve this page.

National Stock Exchange of India Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
National Stock Exchange of India Data Analyst Salary
based on 15 salaries
₹3 L/yr - ₹10 L/yr
At par with the average Data Analyst Salary in India
View more details
Deputy Manager
776 salaries
unlock blur

₹5 L/yr - ₹14.5 L/yr

Manager
388 salaries
unlock blur

₹8 L/yr - ₹28 L/yr

System Analyst
213 salaries
unlock blur

₹5 L/yr - ₹12.9 L/yr

Senior Manager
167 salaries
unlock blur

₹15 L/yr - ₹42 L/yr

Assistant Manager
115 salaries
unlock blur

₹4 L/yr - ₹9.2 L/yr

Explore more salaries
Compare National Stock Exchange of India with

SBI Cards & Payment Services

3.7
Compare

Axis Direct

3.8
Compare

Kotak Securities

3.6
Compare

Aadhar Housing Finance

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