Fidelity International Interview Questions, Process, and Tips

Q1. Basic BA questions and capital market related questions
Add your answer

Functional specific documentation

English listening and understanding test

Q1. Tell us about mutual funds
Ans. 
Mutual funds are investment vehicles that pool money from multiple investors to invest in a diversified portfolio of stocks, bonds, or other securities.
• Mutual funds are managed by professional fund managers who make investment decisions on behalf of the investors.

• Investors can buy shares of mutual funds, which represent their ownership in the fund's portfolio.

• Mutual funds offer diversification, liquidity, and professio...read more
Answered by AI
Add your answer

Multiple choice questions includes coding

Q1. Questions on the programing language
Add your answer

Q1. DWH Concepts and ETL
Add your answer
Q2. Related to RDBMS, ETL and DWH
Add your answer

Q1. Stick to Basics to clear
Add your answer

Q1. Basic introduction
Add your answer

Q1. About previous company experience what are the challenges faced
Add your answer

Q1. What is Normalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by eliminating duplicate data

• Normalization improves data integrity by ensuring that each piece of data is stored in only one place

• There are different levels of normalization, such as First Normal F...read more
Answered by AI
Add your answer
Q2. What is sub-Query
Ans. 
A sub-query is a query nested within another query in SQL to retrieve data from multiple tables.
• Used to retrieve data from multiple tables

• Can be used in SELECT, INSERT, UPDATE, or DELETE statements

• Must be enclosed in parentheses
Answered by AI
Add your answer
Q3. What is joins ?explain
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right ta...read more
Answered by AI
Add your answer
Q4. What is Left outer join ?give ex
Ans. 
Left outer join is a type of join operation that returns all records from the left table and the matched records from the right table.
• Left outer join combines rows from two tables based on a related column between them.

• It includes all the rows from the left table, even if there are no matches in the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q5. What is constraint?
Ans. 
A constraint is a rule or limitation that must be followed in a system or process.
• Constraints restrict the actions or behaviors of users or systems.

• Constraints can be related to data validation, business rules, or system limitations.

• Examples of constraints include password length requirements, maximum file size limits, and budget constraints.
Answered by AI
Add your answer