Goldman Sachs Data Engineer Interview Questions and Answers

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

1 Python and 1 sql question

Q1. Technical sql and dsa
Add your answer
Q2. Dsa ,sql,spark, project understanding
Add your answer
Q3. Puzzle related questions
Add your answer
Q4. Dsa focused array and string
Add your answer

Q1. Spark Optimizations
Add your answer