Goldman Sachs Data Engineer Interview Questions and Answers

Q1. Project related discussions
Add your answer
Q2. Meduim level SQl and DSA
Add your answer

Q1. This was data modelling round
Add your answer
Q2. Design a uber data model
Ans. 
Uber data model design for efficient storage and retrieval of ride-related information.
• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance
Answered by AI
Add your answer

Q1. About the project and technical aspect
Add your answer

Q1. How do you delete duplicate values
Ans. 
To delete duplicate values, use SQL queries with DISTINCT keyword or programming languages like Python with sets.
• In SQL, use SELECT DISTINCT to retrieve unique values

• In Python, convert list to set to automatically remove duplicates

• Use pandas library in Python to drop duplicates in a DataFrame
Answered by AI
Add your answer

Q1. Data warehouse concepts
Add your answer

Asked few questions on sql asked to write query for problem given on spot

Discussion of jd, technical questions on spark

Q1. Spark framework
Add your answer
Q2. Spark dataframes
Add your answer

Q1. Current ctc getting
Ans. 
I am currently earning $80,000 per year.
• My current annual salary is $80,000.

• I am earning $6,666.67 per month.

• I receive a monthly salary of $6,666.67.
Answered by AI
Add your answer
Q2. Expected CTC that is needed
Ans. 
Expected CTC should be based on industry standards, experience, skills, and location.
• Research industry standards for Data Engineers in your location

• Consider your level of experience and skills

• Factor in the cost of living in the area where the job is located

• Negotiate based on the value you bring to the company
Answered by AI
Add your answer