Data engineers zijn IT-professionals en zijn in bijna elke bedrijfstak nodig. Data engineers volgen gegevenstrends voor het vaststellen van de beste vervolgstappen voor bedrijven. Een cruciaal onderdeel van het werk van een data engineer bestaat uit het verwerken van ruwe gegevens tot bruikbare gegevens door datapipelines te creëren en gegevenssystemen te bouwen.
Asked by the interviewer a "Data Engineer" to join 2 tables together to label start/end of a track play , only when I proposed a working solution he diverted me to another solution that he had in mind all along, thinking it was better as it didn't require window functions, but it did require them. He just didn't know they are called window functions. Admittedly, the "Data Engineer" said he hasn't worked on spark in a while, and is quite junior.
Resume Questions
Implement a sampling function with nominal distribution.
Why you are using your pipeline as it is why you are not a decision maker in your organization?
What are the 3 V's
Draw a clock. What is the degree difference between the hour and minute hand if the time is 3:15?
The only concern was with SQL Scripts
1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
Validate an IP Address. Multiple test cases given.
Phone Interview: Intermediate level Python and SQL questions. 5 questions each for 30 minutes.
Viewing 161 - 170 interview questions