Fidelity International Interview Questions, Process, and Tips

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

Q1. Previous experience about your profiles
Ans. 
I have worked as a Test Analyst for 3 years in a software development company.
• Conducted functional, regression, and integration testing on various software applications

• Created and executed test cases and reported defects using JIRA

• Collaborated with developers and business analysts to ensure quality of software products

• Participated in Agile ceremonies such as sprint planning, daily stand-ups, and retrospectives
Answered by AI
Add your answer
Q2. Share your exp positively
Ans. 
I have extensive experience in testing various software applications and have consistently delivered high-quality results.
• I have worked on multiple projects and have gained expertise in manual and automation testing.

• I have a strong understanding of testing methodologies and have implemented them effectively.

• I have collaborated with cross-functional teams to identify and resolve issues, ensuring timely delivery of proje...read more
Answered by AI
Add your answer