NTT Data Financial Analyst and Specialist Interview Questions and Answers

Q1. About revenue recognition
Add your answer
Q2. Forecasting, Budgeting
Add your answer

Q1. Technical and process knowledge and scenario questions
Add your answer

Q1. What you know about Trade Life Cycle
Ans. 
Trade life cycle refers to the stages involved in a trade from initiation to settlement.
• Trade initiation: Trade is proposed and agreed upon by parties involved.

• Trade execution: Trade is executed on the exchange or over-the-counter market.

• Trade confirmation: Parties confirm the details of the trade.

• Trade settlement: Payment and transfer of securities occur to complete the trade.

• Trade reconciliation: Any discrepancies ar
Answered by AI
Add your answer

Q1. What is sql process
Ans. 
SQL process refers to the steps involved in executing a SQL query to retrieve or manipulate data from a database.
• SQL process starts with writing a SQL query to retrieve or manipulate data.

• The query is then sent to the database management system (DBMS) for processing.

• The DBMS parses the query, creates an execution plan, and retrieves the data from the database.

• The retrieved data is then returned to the user or applicati
Answered by AI
Add your answer
Q2. What is pl sql process
Ans. 
PL/SQL (Procedural Language/Structured Query Language) is a programming language used to create stored procedures, functions, and triggers in Oracle databases.
• PL/SQL is an extension of SQL that allows for procedural programming capabilities.

• It is used to create reusable code blocks that can be called within SQL statements.

• PL/SQL can be used to automate tasks, enforce business rules, and improve performance.

• Examples of ...read more
Answered by AI
Add your answer

Q1. Very bad people never ever expect your interview will result in offer letter , they will keep you on infinite hold and will start searching for guy with less salary , they do interview for time pass neithe...read more
Add your answer
Q2. Simple Finance terms
Ans. 
Simple finance terms refer to basic financial concepts and terminology used in the field of finance.
• Simple finance terms include concepts like assets, liabilities, revenue, expenses, profit, and cash flow.

• Understanding these terms is essential for analyzing financial statements and making informed financial decisions.

• Examples of simple finance terms: ROI (Return on Investment), EBITDA (Earnings Before Interest, Taxes, ...read more
Answered by AI
Add your answer

Q1. Very bad experience after 4-5 round of interview and taking my documents and salary slips they started keeping me on hold and looking for candidate with less salary.
Add your answer

Q1. If the HR is Santosh or Krish please withdraw your application they are never going to create offer letter
Add your answer

Aptitude skills is helpful for you to boost your confidence and develop your decision making skills

Q1. Why did you decide to apply this role
Ans. I have to gain more knowledge of working skills in our company
Answered Anonymously
Add your answer

Basic Aptitude test with Quants, Reasoning, and reading comprehension with 30 questions each

Very Basic Level, three questions like finding whether a number is prime or not and adding two numbers

Q1. Introduce yourself
Ans. 
I am a financial analyst with expertise in financial planning, analysis, and reporting.
• I have a Bachelor's degree in Finance and have been working in the finance industry for 5 years.

• I have experience in budgeting, forecasting, and financial modeling.

• I am skilled in using financial software and tools such as Excel, SAP, and Tableau.

• I have a strong attention to detail and can analyze complex financial data to provide in...read more
Answered by AI
Add your answer
Q2. Why do you want to join this job with an engineering background
Ans. 
I believe my engineering background provides me with a unique perspective and skill set that can be valuable in the financial analyst role.
• My engineering background has equipped me with strong analytical and problem-solving skills, which are essential in financial analysis.

• I have a solid foundation in mathematics and statistics, which are crucial for analyzing financial data and making accurate projections.

• Engineering ...read more
Answered by AI
Add your answer
Q3. You don't have any foundation in finance. How will you cope?
Ans. 
I will cope by leveraging my strong analytical skills and willingness to learn.
• I have a strong background in quantitative analysis, which is applicable to finance.

• I am a quick learner and have a track record of quickly grasping complex concepts.

• I am willing to invest time and effort in self-study and taking relevant courses.

• I will seek guidance and mentorship from experienced finance professionals.

• I will leverage my pr...read more
Answered by AI
Add your answer
Q4. What did you learn from your engineering years
Ans. 
During my engineering years, I learned problem-solving skills, analytical thinking, and attention to detail.
• Developed strong problem-solving skills through complex engineering projects

• Enhanced analytical thinking by analyzing data and making informed decisions

• Learned to pay attention to detail to ensure accuracy and precision in engineering designs

• Gained experience in working collaboratively in teams to achieve project
Answered by AI
Add your answer
Q5. Do you know basic-level Excel
Ans. 
Yes, I have basic-level Excel knowledge.
• I am proficient in basic Excel functions such as data entry, formatting, and basic formulas.

• I can create and edit spreadsheets, charts, and graphs.

• I have experience with functions such as SUM, AVERAGE, and IF statements.

• I am familiar with Excel shortcuts and can work efficiently with the software.
Answered by AI
Add your answer

Q1. What is the difference between EV and Equity Value
Ans. 
EV includes both debt and equity while Equity Value only includes equity.
• EV = Equity Value + Debt - Cash

• Equity Value = Market Capitalization + Preferred Stock + Minority Interest - Cash

• EV is used to determine the total value of a company while Equity Value only represents the value of the shareholders' equity

• EV is often used in M&A transactions while Equity Value is used to determine a company's stock price
Answered by AI
Add your answer