Fidelity Investments Engineering Manager Interview Questions and Answers

Maths ,accounts and business written test was taken in first round

Q1. Current role brief explanation was asked
Add your answer

Q1. Onshore team asked about the current role, financial reports number
Add your answer

Normal entry level test easy to crack

Q1. Questions related to old profile and some questions on capital market and wealth management
Add your answer

Q1. SQL query using joins
Ans. 
SQL query using joins
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. Why do you want to join State Street.
Add your answer

Q1. Difference between TWRR and MWRR.
Add your answer

Q1. Data load process to hadoop
Add your answer
Q2. How to test Batch data
Ans. 
Batch data can be tested by running automated scripts to validate data accuracy, completeness, and consistency.
• Create test scripts to validate data input/output

• Compare batch data with expected results

• Check for data accuracy, completeness, and consistency

• Perform data profiling to identify anomalies

• Use data visualization tools to analyze batch data
Answered by AI
Add your answer

Q1. About Prior job experience
Add your answer
Q2. Accounting Questions
Add your answer
Q3. GL and US GAAP
Add your answer
Q4. Reconciliation and Reporting
Add your answer

Q1. About prior Job Experience
Add your answer

Q1. Salary Expectation
Add your answer

Q1. Multiple Questions
Add your answer