Basic questions about SQL and ETL
Data Engineer Interview Questions
21,097 data engineer interview questions shared by candidates
L1 round has questions on SQL, Hive, Python, Spark.Cleared the first round. L2 was F2F where i was asked to write code on Python. SparkCore, SQL, SparkSQL. The question were to read the files and find out max sold product basis of each product. And then was F2F which was on Hadoop: Rack Awarness Map and FlatMap Map and Reduce Partititon and Bucketting. Could not answer 2 questions on Hadoop Architecture.
SQL JOINS , sets, what do you exactly mean by entrepreneur
Can you briefly walk me through your background and explain what makes you a good fit for a Data Engineering role here at Goldman Sachs?
The technical interview covered the take-home assessment, which required me to explain why I did it a certain way. The questions would require one to think critically about one's methodology. Other questions include when to use TDD, how to build a data pipeline given X, Y, Z tables. The cultural interview consisted of questions on past experiences/situations, as well as hypothetical scenarios (e.g. being stuck in a situation between two stakeholders). The bar raiser round was similar to the cultural/behavioural interview.
Previous experience and resume requested.
Employee and Incentives are seperate table...retrieve total sum of incentive amount for all employees...if employee didnt get salary then 0....
Leetcode question with lists and strings
SCHEMAS: cards customer_id (INT) card_number (VARCHAR) open_date (DATE) 3612 4733-8080 2/15/2020 1825 5743-6687 2/3/2020 1825 4521-3390 5/15/2020 transactions transaction_id (INT) card_number transaction_datetime (UTC) transaction_amount (DECIMAL) 2214 5743-6687 02/20/2020 17:00 122.76 2652 5743-6687 02/27/2020 08:15 3.63 3456 4521-3390 06/02/2020 13:44 89.17 daily_customer_addresses customer_id home_address state report_date 2051 123 Main St NY 08/29/2020 2051 123 Main St NY 08/30/2020 2051 123 Main St NY 08/31/2020
(after introducing their cloud system): What is the problem of high resource consumption in our app containers?
Viewing 2071 - 2080 interview questions