FactSet Senior Product Analyst 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

Q1. Basic questions regarding why do you want to work here, tell me about a challenge you faced & how you overcame it, why this role etc.
Add your answer

Q1. Job discussion, quality questions
Add your answer

GD with panel of 6 members

Auto lending case study and framework used

Q1. Data science questions
Add your answer

Q1. Pay related questions
Add your answer
Q2. How to ensure quality
Ans. 
Ensuring quality involves implementing strict quality control measures and continuous monitoring of production processes.
• Implementing quality control measures such as regular inspections and testing

• Training employees on quality standards and procedures

• Utilizing quality management systems to track and analyze production data

• Addressing any issues or defects promptly to prevent reoccurrence
Answered by AI
Add your answer

Panel of 6 members were present

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.