Fidelity National Financial Data Analyst Interview Questions and Answers

Q1. SQL Query of case when then statement
Ans. 
SQL query using CASE WHEN THEN statement
• Use CASE WHEN statement to create conditional logic in SQL queries

• Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name

• Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers
Answered by AI
Add your answer
Q2. SQL Query of join
Ans. 
SQL query to join tables based on a common key
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be joined in the ON clause

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer

Basic aptitude test like distance problem , age etc

Top 7 th employee salary
Find Duplicates

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
Add your answer
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
Add your answer
Q3. Nothing to get importance no words
Add your answer

40 questions are there. The que have different categories. Reasoning , critical thinking

Q1. Tell me about your self
Add your answer
Q2. Question based on the resume
Add your answer
Q3. What are the project you have done?
Add your answer

Study hard that's it

Q1. Tell me about yourself
Add your answer

Basics in aptitude to be studied

Equity related then aptitude and grammer

Q1. What is promissory note?
Ans. 
A promissory note is a written promise to pay a specific amount of money at a certain time.
• It is a legal document that outlines the terms of a loan or debt.

• It includes the amount borrowed, interest rate, repayment schedule, and consequences of default.

• Examples include personal loans, student loans, and business loans.

• Promissory notes can be bought and sold as a form of investment.

• They are enforceable by law and can be
Answered by AI
Add your answer
Q2. What is bank reconciliation statement?
Ans. 
Bank reconciliation statement is a document that compares the bank statement with the company's accounting records.
• It helps to identify any discrepancies between the two records.

• It includes details of deposits, withdrawals, and bank charges.

• It ensures the accuracy of the company's financial records.

• It is usually prepared monthly.

• Example: If the bank statement shows a withdrawal of $100 but the company's records show a ...read more
Answered by AI
Add your answer
Q3. What do you mean by Payables turnover ratio?
Ans. 
Payables turnover ratio is a financial metric that measures how quickly a company pays off its suppliers.
• It is calculated by dividing the cost of goods sold by the average accounts payable balance.

• A high ratio indicates that a company is paying off its suppliers quickly, while a low ratio suggests that it is taking longer to pay its bills.

• The ratio can be used to assess a company's liquidity and its ability to manage i...read more
Answered by AI
Add your answer

Q1. How do you deal with monotonous work?
Add your answer
Q2. Features of promissory note.
Ans. 
A promissory note is a legal document that contains a promise to pay a specific amount of money to a person or entity.
• It is a written promise to pay a debt

• It includes the names of the parties involved

• It specifies the amount of money to be paid

• It outlines the terms of repayment, including interest rates and due dates

• It can be secured or unsecured

• It can be negotiable or non-negotiable
Answered by AI
Add your answer