Goldman Sachs Senior Data Engineer Interview Questions and Answers

Python and Spark code

Q1. Spark and Cloud question
Add your answer

Q1. Based on client interview
Add your answer

Q1. HR question and salary discussion.
Add your answer

Q1. Basics of SQL python
Add your answer

Python sql skills were tested and candidates are selected

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

First round will be aptitude test

Q1. Why should I hire you
Ans. 
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
• I have a degree in data analytics and relevant work experience

• I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• I have successfully completed projects where I identified trends and patterns in data to drive business decisions
Answered by AI
Add your answer
Q2. Tell me about your self
Add your answer

Q1. Salary expectation
Add your answer
Q2. Position of the candidate
Add your answer

It was about 45mins aptitude test .

Q1. I was asked about the double Linked list, stack ,Queue.
Add your answer

Q1. Logical questions
Add your answer

Q1. Reverse a string with spaces present in same position Ex: i am indian o/p:n ai dnimai
Ans. 
To reverse a string with spaces present in the same position, we can split the string by spaces, reverse each word, and then join them back together.
• Split the string by spaces to get individual words

• Reverse each word

• Join the reversed words back together with spaces in between
Answered by AI
Add your answer
Q2. Difference between put and post in sql
Ans. 
PUT is used to update an existing resource in SQL, while POST is used to create a new resource.
• PUT is idempotent, meaning multiple identical requests will have the same effect as a single request.

• POST is not idempotent, meaning multiple identical requests may have different effects.

• PUT is used to update specific resources identified by the request URI.

• POST is used to create new resources under the request URI.

• PUT is ty...read more
Answered by AI
Add your answer
Q3. What is bad request in api testing
Ans. 
A bad request in API testing is when the server cannot process the request due to incorrect syntax or missing parameters.
• Bad request status code is 400

• Common causes include missing or incorrect parameters, invalid data format, or unauthorized access

• Examples: missing required parameters, incorrect data type in request body
Answered by AI
Add your answer

Q1. Permutations of string of length n in string of length m
Ans. 
Generate all permutations of a string of length n within a string of length m.
• Use recursion to generate all possible permutations of the string of length n.

• Iterate through the string of length m and insert the permutations at different positions.

• Return an array of strings containing all permutations of the string of length n within the string of length m.
Answered by AI
Add your answer
Q2. Count ocurrence of characters in digit
Ans. 
Count occurrences of characters in a digit
• Iterate through each digit in the input array

• For each digit, convert it to a string and iterate through each character

• Use a hashmap to keep track of the count of each character
Answered by AI
Add your answer
Q3. Find second highest salary in sql
Ans. 
Use SQL query with ORDER BY and LIMIT to find the second highest salary.
• Use ORDER BY clause to sort the salaries in descending order

• Use LIMIT 1,1 to get the second row after skipping the first row

• Consider handling cases where there might be ties for the highest salary
Answered by AI
Add your answer
Q4. Http status in API
Ans. 
HTTP status codes are used to indicate the result of a HTTP request made to an API.
• HTTP status codes range from 1xx to 5xx, with each range representing a different type of response.

• Some common HTTP status codes include 200 (OK), 404 (Not Found), and 500 (Internal Server Error).

• Status codes starting with 2 indicate success, 4 indicate client errors, and 5 indicate server errors.
Answered by AI
Add your answer

Q1. Explain about your project
Add your answer
Q2. How do you run your automation Regression scripts
Ans. 
I run automation Regression scripts using a test automation framework and scheduling tools.
• I organize regression scripts into test suites based on functionality

• I use a test automation framework like Selenium or Appium to execute the scripts

• I schedule the regression runs using tools like Jenkins or TeamCity

• I analyze the test results and report any failures for further investigation
Answered by AI
Add your answer

Q1. All questions based on your resume and recent project you have done including OOPS concept, MVC , Design patterns, SOLID principles
Add your answer

Q1. Here test the communications, problem solving skills, Decision making skill, Situation handle, conflict management
Add your answer

Q1. Asked about SAAS, JS questions
Add your answer

Given a case study need to solve in 2 days

Q1. Explain the case study. Palindrome function in any prog language
Ans. 
A palindrome function checks if a given string reads the same forwards and backwards.
• A palindrome function typically involves reversing the input string and comparing it to the original string.

• Examples: 'racecar' is a palindrome, 'hello' is not a palindrome.

• Common languages for implementing a palindrome function include Python, Java, and C++.
Answered by AI
Add your answer

Q1. General Guidelines
Add your answer