Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by FactSet Team. If you also belong to the team, you can get access from here

FactSet Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

FactSet Associate Product Specialist Interview Questions, Process, and Tips

Updated 5 Aug 2024

Top FactSet Associate Product Specialist Interview Questions and Answers

FactSet Associate Product Specialist Interview Experiences

4 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Hackerearth coding test

Round 2 - Technical 

(4 Questions)

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

  • Answered by AI
  • 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
  • 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
Round 3 - HR 

(1 Question)

  • 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

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

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

Associate Product Specialist Interview Questions Asked at Other Companies

asked in MasterCard
Q1. There are 25 horses among which you need to find fastest 3. You d ... read more
asked in FactSet
Q2. Write python code to read from and write to a file
asked in FactSet
Q3. What is tcp protocol?
asked in FactSet
Q4. Join statements in SQL and their purpose
asked in FactSet
Q5. Types of normalizations

Interview Questionnaire 

2 Questions

  • Q1. I was asked about SQL,Database Design questions, Normalization, Joins and Index .Also I was asked about my achievements ,what challenges in faced in previous role and how did I cope up with ?
  • Q2. Prepare for SQL and database concepts thoroughly.And be fluent in answering behavioral questions

I applied via Naukri.com and was interviewed before Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Scrum lifecycle

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about agile and scrum throughly

FactSet interview questions for designations

 Product Specialist

 (1)

 Associate Data Specialist

 (1)

 Senior Associate Specialist

 (1)

 Specialist

 (1)

 Senior Product Analyst

 (1)

 Content Specialist

 (1)

 Process Specialist

 (1)

 Associate Engineer

 (1)

Interview questions from similar companies

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

It was a cumulative test

  • Q1. 

    Trapping Rainwater Problem Statement

    You are given an array ARR of long type, which represents an elevation map where ARR[i] denotes the elevation of the ith bar. Calculate the total amount of rainwater t...

  • Ans. 

    Calculate the total amount of rainwater that can be trapped within given elevation map.

    • Iterate through the array to find the maximum height on the left and right of each bar.

    • Calculate the amount of water that can be trapped above each bar by taking the minimum of the maximum heights on the left and right.

    • Sum up the trapped water above each bar to get the total trapped water for the elevation map.

  • Answered by AI
Round 2 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Medium

It was sophisticated in nature and a good brain buster.

  • Q1. 

    Candies Distribution Problem Statement

    Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...

  • Ans. 

    Determine the minimum number of candies needed to distribute to students based on their performance and ratings.

    • Iterate through the array of student ratings and assign 1 candy to each student initially.

    • Then iterate from left to right and check if the current student's rating is higher than the previous student, if so, assign candies accordingly.

    • Similarly, iterate from right to left to handle cases where the current stu...

  • Answered by AI
Round 3 - Face to Face 

(1 Question)

Round duration - 1 hour
Round difficulty - Medium

  • Q1. DBMS

    It revolved around basic concepts

  • Ans. 

    DBMS is a software system that manages databases and allows users to interact with data stored in them.

    • DBMS stands for Database Management System

    • It helps in creating, updating, and managing databases

    • Examples of DBMS include MySQL, Oracle, SQL Server

    • It ensures data integrity, security, and efficient retrieval

  • Answered by AI
Round 4 - Group Discussion 

Round duration - 70 minutes
Round difficulty - Hard

It was a great experience

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in HyderabadEligibility criteriaGood Resume and 7 CGPA +Morgan Stanley interview preparation:Topics to prepare for the interview - I have done a rigourous training on Data Structure and Algorithms. It really helped me a lot to excel in life. Also I did vocational courses which enhanced my personality. I did analytical mindset training with problem solving methodologies. The hands on training on Python and Unix helped me a lot.Time required to prepare for the interview - 8 monthsInterview preparation tips for other job seekers

Tip 1 : Stay consistent with your efforts
Tip 2 : Work hard with honesty
Tip 3 : Try to set goal of +1 level from the goal you want to achieve

Application resume tips for other job seekers

Tip 1 : Present yourself with honesty
Tip 2 : Mention about the Workshops, hackathons, achievements, and the projects.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. What are the types of derivatives?
  • Ans. 

    Derivatives are financial instruments that derive their value from an underlying asset or security.

    • Types of derivatives include futures, options, swaps, and forwards.

    • Futures are contracts to buy or sell an asset at a predetermined price and date.

    • Options give the buyer the right, but not the obligation, to buy or sell an asset at a predetermined price and date.

    • Swaps involve exchanging cash flows based on different finan...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare on Derviatives and structure of funds.

I appeared for an interview in May 2017.

Interview Questionnaire 

6 Questions

  • Q1. Can string class be extended
  • Ans. 

    Yes, the string class can be extended in most programming languages.

    • Inheritance can be used to extend the functionality of the string class.

    • By creating a new class that inherits from the string class, additional methods and properties can be added.

    • Extending the string class allows for customization and adding specific functionality to strings.

    • Example: In Python, the string class can be extended by creating a new class

  • Answered by AI
  • Q2. What are the implecit object in JSP
  • Ans. 

    Implicit objects in JSP are predefined objects that are available for use without any declaration or initialization.

    • Implicit objects in JSP include request, response, session, application, out, config, pageContext, page, exception, and others.

    • These objects provide access to various aspects of the JSP environment and can be used to perform common tasks.

    • For example, the request object allows access to HTTP request parame...

  • Answered by AI
  • Q3. How does hash map works
  • Ans. 

    A hash map is a data structure that uses a hash function to map keys to values.

    • Hash map stores key-value pairs

    • It uses a hash function to compute an index for each key

    • Collisions can occur when two keys hash to the same index

    • Hash maps provide fast access to values based on their keys

  • Answered by AI
  • Q4. Difference between string buffer and string builder
  • Ans. 

    StringBuffer and StringBuilder are both used to manipulate strings, but StringBuffer is thread-safe while StringBuilder is not.

    • StringBuffer is synchronized, making it safe for use in multi-threaded environments.

    • StringBuilder is not synchronized, making it faster but not thread-safe.

    • StringBuffer is preferred when multiple threads are involved, while StringBuilder is preferred for single-threaded scenarios.

    • Both classes p...

  • Answered by AI
  • Q5. What is MVC
  • Ans. 

    MVC is a software architectural pattern that separates an application into three main components: Model, View, and Controller.

    • Model represents the data and business logic of the application.

    • View is responsible for displaying the user interface.

    • Controller handles user input, updates the model, and interacts with the view.

    • MVC promotes separation of concerns and modularity in software development.

    • Example: In a web applica...

  • Answered by AI
  • Q6. What are the annotation used in RESTFULL web services
  • Ans. 

    Annotations used in RESTful web services

    • 1. @Path - Specifies the URI path for the resource

    • 2. @GET - Specifies that the method handles HTTP GET requests

    • 3. @POST - Specifies that the method handles HTTP POST requests

    • 4. @PUT - Specifies that the method handles HTTP PUT requests

    • 5. @DELETE - Specifies that the method handles HTTP DELETE requests

    • 6. @PathParam - Binds the value of a URI template parameter to a method paramete...

  • Answered by AI

Interview Preparation Tips

Skills: Java Application Development

Skills evaluated in this interview

I appeared for an interview in Jan 2017.

Interview Questionnaire 

3 Questions

  • Q1. 1. Why do you want to join Citi?
  • Ans. 

    I want to join Citi because of its global presence, strong reputation, and opportunities for growth.

    • Citi is a global company with a presence in over 100 countries, which provides an opportunity to work with diverse teams and gain international exposure.

    • Citi has a strong reputation in the financial industry, known for its expertise and innovative solutions.

    • Citi offers excellent career development opportunities, includin...

  • Answered by AI
  • Q2. 2. Why do you want a career in banking? And not consulting or finance?
  • Ans. 

    I am interested in a career in banking because of the opportunities for growth, the dynamic nature of the industry, and my passion for financial analysis.

    • Opportunities for growth: Banking offers a wide range of career paths and opportunities for advancement. I am excited about the potential to develop my skills and progress within the industry.

    • Dynamic nature of the industry: Banking is constantly evolving, with new tec...

  • Answered by AI
  • Q3. 3. How has the Indian Economy performed in the past 2 years?
  • Ans. 

    The Indian economy has experienced mixed performance in the past 2 years.

    • GDP growth rate has fluctuated

    • Demonetization and GST implementation impacted the economy

    • Unemployment rate has been a concern

    • Inflation has remained relatively low

    • Foreign direct investment has increased

    • Agricultural sector faced challenges due to weather conditions

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: My resume had gotten shortlisted for the profile of an Analyst. This was the first stage.

Round: Group Discussion
Duration: 20 minutes

College Name: Lady Shri Ram College

Interview Preparation Tips

Round: Technical Interview
Experience: Technical on paper test questions:(dis was only for 12 among d 26 shortlisted ppl after apti...others directly had interviews)
5 wer selected in this test who wer nw sent for interviews
TECHNICAL INTERVIEW: (pls list the questions asked in all the rounds)
26 shortlisted after apti (14 directly for interviews & 12 had one more technical on paper test...mentioned above)
der wer min 2 technical rounds for each of them...max were 5

- You are given course dependencies
A->B,C
B->D
C->A
D->nothing
The above dependencies mean...if you want to take course A...you should take courses B and C first....To take B,Course D must be taken first....D is an independent course and can be taken without any prior requirements.
Now you are told these dependencies.Come up with an appropriate data structure to represent these dependencies.Then write a code that finds out all the courses that the student can take up...in this case the student can first take course D because its independent.Now that course D has been taken he can next take up B as it depends on B alone...But the courses A and C can never be taken because they depend on each other...So here all the courses that can be taken are B and D.
After i wrote the code....he asked for all possible test cases
-Given an array of length N....It can be filled with nos. only from 1 to N....find which nos are repeated in the array
-Given pointers to two nodes in a binary tree....find their least common ancestor...each node has pointer to only the parent node...not the left and right child..
-In a binary tree(Not necessarily a BST)...suppose the weight of any node is defined as the product of the key value of the node and the level of the node(Root at level 1)...find the node with maximum weight in the binary tree
-A sorted array of size n is right circularly rotated k times and this rotated array is given to you as input...Find out the value of k in log n time .
-There are some processes running at time T....and there are processes running at time T+30.
You have to find out
1)Which processes died at time T+30,which were alive at time T
2)Which are the new processes at time T+30,which were not there at time T
3)Which are the processes that were there at time T and are still running at time T+30
What data structure will you use to represent the process lists and write code to find out the answers to the 3 questions above
-Given a binary search tree...and a target sum...starting at the root...which all paths add up to the target sum?...if there are multiple paths....return the path with least no. of nodes.


College Name: Veermata Jijabai Technological Institute, Mumbai [ VJTI ]

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

FactSet Interview FAQs

How many rounds are there in FactSet Associate Product Specialist interview?
FactSet interview process usually has 2 rounds. The most common rounds in the FactSet interview process are Technical, Coding Test and HR.
How to prepare for FactSet Associate Product Specialist interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at FactSet. The most common topics and skills that interviewers at FactSet expect are SQL, Analytical, Bloomberg, Stock Exchange and Troubleshooting.
What are the top questions asked in FactSet Associate Product Specialist interview?

Some of the top questions asked at the FactSet Associate Product Specialist interview -

  1. Write python code to read from and write to a f...read more
  2. What is tcp protoc...read more
  3. Join statements in SQL and their purp...read more

Tell us how to improve this page.

FactSet Associate Product Specialist Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 585 Interviews
Citicorp Interview Questions
3.7
 • 573 Interviews
HSBC Group Interview Questions
3.9
 • 491 Interviews
American Express Interview Questions
4.1
 • 367 Interviews
BNY Interview Questions
3.8
 • 352 Interviews
UBS Interview Questions
3.9
 • 339 Interviews
Morgan Stanley Interview Questions
3.6
 • 293 Interviews
View all
FactSet Associate Product Specialist Salary
based on 94 salaries
₹5.4 L/yr - ₹11 L/yr
7% more than the average Associate Product Specialist Salary in India
View more details

FactSet Associate Product Specialist Reviews and Ratings

based on 9 reviews

4.1/5

Rating in categories

4.2

Skill development

4.8

Work-life balance

3.2

Salary

4.6

Job security

4.9

Company culture

3.2

Promotions

3.7

Work satisfaction

Explore 9 Reviews and Ratings
Research Analyst
2.9k salaries
unlock blur

₹1.8 L/yr - ₹5.2 L/yr

Senior Research Analyst
743 salaries
unlock blur

₹2.8 L/yr - ₹9 L/yr

Equity Research Analyst
361 salaries
unlock blur

₹1.8 L/yr - ₹4.8 L/yr

Software Engineer III
258 salaries
unlock blur

₹9 L/yr - ₹23.4 L/yr

Software Engineer
257 salaries
unlock blur

₹6.6 L/yr - ₹26 L/yr

Explore more salaries
Compare FactSet with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Cholamandalam Investment & Finance

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview