FactSet Associate Product Specialist Interview Questions, Process, and Tips

Hackerearth coding test

Q1. Write python code to read from and write to a file
Ans. 
Python code to read from and write to a file
• Use 'open()' function to open a file in read or write mode

• Use 'read()' method to read the contents of the file

• Use 'write()' method to write data to the file
Answered by AI
Add your answer
Q2. Types of normalizations
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Types of normalizations include 1NF, 2NF, 3NF, BCNF, and 4NF.

• 1NF (First Normal Form) ensures that each column contains atomic values.

• 2NF (Second Normal Form) eliminates partial dependencies by ensuring all non-key attributes are fully functional dependent on the primary key.

• 3NF (Third Normal Form) removes trans...read more
Answered by AI
Add your answer
Q3. Join statements in SQL and their purpose
Ans. 
Join statements in SQL are used 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

• 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
Q4. What is tcp protocol?
Ans. 
TCP (Transmission Control Protocol) is a communication protocol that ensures reliable and ordered delivery of data packets over a network.
• TCP is a connection-oriented protocol that establishes a connection before data transfer.

• It provides error-checking and guarantees delivery of data packets.

• TCP uses sequence numbers to reorder packets and ensure data integrity.

• Examples of applications using TCP include web browsing,
Answered by AI
Add your answer

Q1. Open to relocate
Ans. 
Yes, I am open to relocate for the right opportunity.
• I am willing to relocate for the right job opportunity

• I am open to exploring new locations and experiences

• I have relocated in the past for career advancement
Answered by AI
Add your answer

Q1. Portfolio theory
Add your answer
Q2. Fixed income knowledge
Add your answer
Q3. Structured products like MBS, CDO, bankloan, derivatives
Add your answer