Goldman Sachs Data Analyst Interview Questions and Answers for Experienced

Q1. Basic Excel function
Add your answer
Q2. Scenario based questions
Add your answer

More questions about my experience & reason to join.

Q1. What is your skills ?
Add your answer
Q2. How was your previous experience if done any projects?
Add your answer
Q3. One case study related question?
Add your answer
Q4. Why you want to join the company?
Add your answer
Q5. Your future goals and are you ready to learn and gain more skills ?
Add your answer

Technical questions related to Python and SQL

Q1. SQL questions from beginner to advanced
Add your answer
Q2. Duplicates removal
Add your answer
Q3. Aggregate functions
Add your answer

Q1. Implement lag() and lead() without using lag() or lead()
Ans. 
Implement lag() and lead() functions without using lag() or lead()
• To implement lag(), shift the values in the array by one position to the right

• To implement lead(), shift the values in the array by one position to the left

• For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]

• For lead(), you can shift the values to get [2, 3, 4, null]
Answered by AI
Add your answer
Q2. How will you go about optimising a query?
Ans. 
Optimising a query involves identifying bottlenecks and improving efficiency.
• Identify slow-performing queries using tools like query execution plans.

• Optimize database indexes to speed up query performance.

• Limit the number of columns and rows returned in the query.

• Avoid using SELECT * and instead specify only the necessary columns.

• Use appropriate data types and avoid unnecessary data conversions.

• Consider denormalizing d...read more
Answered by AI
Add your answer
Q3. If the 3rd position in a string contains 'b' replace it with 'v'
Ans. 
Replace 'b' with 'v' in the 3rd position of each string in an array
• Iterate through each string in the array

• Check if the 3rd position contains 'b'

• If yes, replace 'b' with 'v'
Answered by AI
Add your answer

Q1. Difference between mutual and hedge funds
Ans. 
Mutual funds pool money from multiple investors to invest in a diversified portfolio, while hedge funds are more exclusive and use more aggressive strategies.
• Mutual funds are open to all investors, while hedge funds are typically only available to accredited investors.

• Mutual funds are regulated by the SEC, while hedge funds have more flexibility in their investment strategies.

• Mutual funds are more diversified and have ...read more
Answered by AI
Add your answer

Basic mathematical questionsand Related to share market news.

Q1. Basic question such as tell me something about your self.why you want to join Our company.
Add your answer

Q1. Basic questions and basic of accounting and ratio related questions were asked.
Add your answer

Q1. Mostly Manager ask from the CV Overall Experience in CDM right from STUDY START UP TO CLOSE OUT ACTIVITIES, EDC TOOLS WORKED ON
Add your answer
Q2. Explain phases in CDM
Ans. 
CDM stands for Common Data Model. It has three phases: Conceptualization, Design, and Maintenance.
• Conceptualization phase involves understanding the data requirements and defining the scope of the project.

• Design phase includes creating the data model, schema, and data flow diagrams.

• Maintenance phase focuses on data quality, data integration, and ongoing updates to the data model.
Answered by AI
Add your answer