Upload Button Icon Add office photos

Filter interviews by

National Stock Exchange of India System Analyst Interview Questions and Answers for Experienced

Updated 21 Feb 2025

National Stock Exchange of India System Analyst Interview Experiences for Experienced

3 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL Queries, Views, trigger
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - Coding Test 

Questions related to Linux and Oracle.

System Analyst Interview Questions Asked at Other Companies for Experienced

asked in Accenture
Q1. Datagurd - how to sync databases if is there huge log gap. What a ... read more
Q2. what is agile and how business analyst work
Q3. What is your knowledge about windows and Linux based servers
Q4. How do you call a variable from one note book to another note boo ... read more
Q5. what is difference between medicaid and medicare
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 - Aptitude Test 

Profile and loss , speed and time etc

Round 3 - Technical 

(1 Question)

  • Q1. Different between union and structed different between primary key and foreign key MYSQL DML query
  • Ans. 

    Explaining the differences between union and struct, primary key and foreign key, and providing an example of a MYSQL DML query.

    • Union is used to combine data from two or more tables, while struct is used to group related data together.

    • Primary key uniquely identifies a record in a table, while foreign key refers to a field in another table.

    • Example of MYSQL DML query: INSERT INTO table_name (column1, column2, column3) VA

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Are okay with flexible shift? tell me about yourself? are okay with no trending clause policy?

Interview Preparation Tips

Interview preparation tips for other job seekers - do basic of c and oracle query
if u are ready with

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. How you classify your work

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Recruitment Consultant

Interview Questionnaire 

1 Question

  • Q1. Why do you want to join the organisation

Interview Preparation Tips

Interview preparation tips for other job seekers - Throughout the Interview process, you need to be patient. As per my experience, even if your interview went fine you need to be patient to get the results. It may take weeks to months to go ahead further. Sometimes you can just talk to the recruiter who has contacted you for the interview, because the he/she is the best person to guide you throughout the process.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Test was for 30 minutes and mathematics and Logical reasoning was the topic

Round 2 - HR 

(2 Questions)

  • Q1. HR asked me about my self and other details with communication skills
  • Q2. Why you think you are capable for this job

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for HR round. work on your communication skillls

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 applied via Naukri.com and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How would you segment a population based on certain attributes, which algorithm would you use. SAS and proc sql related questions are must for analyst interview. If lateral hire, expect questions based on ...
  • Ans. 

    To segment a population based on attributes, use clustering algorithms like k-means or hierarchical clustering.

    • Identify relevant attributes such as age, income, education level, etc.

    • Normalize the data to ensure all attributes are on the same scale.

    • Choose a clustering algorithm based on the size of the dataset and the desired number of segments.

    • Evaluate the results using metrics like silhouette score or within-cluster s...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your CV thoroughly. Why this approach, why this algorithm type of questions. Advantage, disadvantages of algorithms. What you learnt from this project, how this project helped business type questions

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. What are the financial statements? How cost sheet of bank different from cost sheet of manufacturing company? What is debt to equity ratio? What is stock option? What is Stock split? What is lease financin...
  • Ans. 

    Financial statements, cost sheet, debt to equity ratio, stock option, stock split, lease financing, profitability ratios.

    • Financial statements are reports that show the financial performance of a company.

    • Cost sheet of a bank includes interest expenses and income, while cost sheet of a manufacturing company includes direct and indirect costs.

    • Debt to equity ratio is a financial ratio that shows the proportion of debt and ...

  • Answered by AI

Interview Questionnaire 

1 Question

  • Q1. Finance questions, account concepts,ifrs

National Stock Exchange of India Interview FAQs

How many rounds are there in National Stock Exchange of India System Analyst interview for experienced candidates?
National Stock Exchange of India interview process for experienced candidates usually has 2 rounds. The most common rounds in the National Stock Exchange of India interview process for experienced candidates are Technical, Resume Shortlist and Aptitude Test.
What are the top questions asked in National Stock Exchange of India System Analyst interview for experienced candidates?

Some of the top questions asked at the National Stock Exchange of India System Analyst interview for experienced candidates -

  1. different between union and structed different between primary key and foreign ...read more
  2. sql indexes, joins, nested quer...read more
  3. SQL Queries, Views, trig...read more

Tell us how to improve this page.

National Stock Exchange of India System Analyst Interview Process for Experienced

based on 2 interviews

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Morningstar Interview Questions
3.9
 • 244 Interviews
Kotak Securities Interview Questions
3.6
 • 116 Interviews
TresVista Interview Questions
2.8
 • 115 Interviews
Pine Labs Interview Questions
3.4
 • 113 Interviews
Mr Cooper Interview Questions
4.0
 • 88 Interviews
Axis Direct Interview Questions
3.8
 • 79 Interviews
Synchrony Interview Questions
4.3
 • 78 Interviews
View all
National Stock Exchange of India System Analyst Salary
based on 213 salaries
₹5 L/yr - ₹12.9 L/yr
29% less than the average System Analyst Salary in India
View more details

National Stock Exchange of India System Analyst Reviews and Ratings

based on 31 reviews

3.5/5

Rating in categories

2.9

Skill development

3.0

Work-life balance

3.5

Salary

4.6

Job security

3.4

Company culture

3.2

Promotions

2.7

Work satisfaction

Explore 31 Reviews and Ratings
Deputy Manager
781 salaries
unlock blur

₹5 L/yr - ₹14.5 L/yr

Manager
387 salaries
unlock blur

₹8 L/yr - ₹26.1 L/yr

System Analyst
213 salaries
unlock blur

₹5 L/yr - ₹12.9 L/yr

Senior Manager
168 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.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview