FactSet Product Specialist Interview Questions and Answers

Q1. Talk about your previous projects
Add your answer
Q2. How did you align a person not perfoming well
Ans. 
I addressed poor performance by setting clear expectations, providing feedback, offering support, and creating a performance improvement plan.
• Set clear expectations and goals for the individual

• Provide constructive feedback on areas of improvement

• Offer support and resources to help the person succeed

• Create a performance improvement plan with specific steps and timelines

• Regularly monitor progress and provide ongoing feed
Answered by AI
Add your answer

Q1. Resume questions
Add your answer

It was good but prepared on technical basis

Q1. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: In a table of students, student ID can be a primary key
Answered by AI
Add your answer
Q2. What is foreign key
Ans. 
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
• A foreign key establishes a relationship between two tables in a database.

• It ensures referential integrity by enforcing a link between the data in the two tables.

• Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.

• Example: In a dat...read more
Answered by AI
Add your answer

Case study was regarding Banking sector

Q1. What are different type of payment files you worked on?
Ans. 
I have worked on various types of payment files including ACH, wire transfers, and credit card transactions.
• ACH (Automated Clearing House) files

• Wire transfer files

• Credit card transaction files
Answered by AI
Add your answer
Q2. What is the minimum response time?
Ans. 
The minimum response time is the shortest amount of time it takes for a system to respond to a request.
• The minimum response time can vary depending on the system and its capabilities.

• Factors that can affect the minimum response time include network latency, server load, and processing speed.

• For example, a high-performance website may have a minimum response time of 100 milliseconds, while a slower system may have a min
Answered by AI
Add your answer

Q1. Data science questions
Add your answer

Q1. Job discussion, quality questions
Add your answer

GD with panel of 6 members

Auto lending case study and framework used

Tell me about yourself.
[Please note that I stands for Interviewer and C stands for Candidate]

C - Standard prepared answer

I- Asked how I used data in my work experience (As my work ex revolved around data analytics)

Explained the relevance of data at my firm and how it is used. Now he jumped to the situation-based questions.

Situation 1:

I- How will you identify whether a person who had earlier defaulted on paying the credit card dues can now pay assuming we have all the data sources?

C- 1. Reduced it to know if the person has the ability to pay or not.

2. Broke it down to 2 things: Expenditure and Savings.

3. For savings, we can look at bank balance and earnings. Then deep dived into how can we know these things.

4. For Expenditure, I broke it into necessity and luxury and then looking at how can we identify these.

Situation 2:

I- Suppose you have to open a store for musical instruments and you have access to all the data, what all sources of data can you think of and how will they be relevant?

C- 1. Firstly, I started by looking at some direct connection to the music industry like previous purchase of musical instruments they have made or their affiliation with some music-related society.

2. Listed 5-6 different ways but the interviewer kept on asking for more so then shifted to indirect connections like time spent on TV watching music channels. Listed 4-5 indirect ways and the interview ended.


It was a 20 min round with 8 min for each of the situation.

I- How will you build an IPL fantasy team for a match using the Cricbuzz data?
[Please note that I stands for Interviewer and C stands for Candidate]

C- 1. I asked about constraints like there are only 100 points.

2. Decided on a structure for the team to be made: 4 batsmen, 1 keeper, 3 bowlers, 3 all-rounders.

3. Reduced it into a utility maximization problem where each player will have some utility and cost associated with them. Now I had to devise a method to tell about the utility of each player as costs are already given.

4. Started with batting, listed various factors.

5. Then I deep dived into each factor as in how to quantitatively represent the data for every factor.

It went on for around 25 min and the entire interview revolved around this particular case.