Q: how do you query tune? if a query is taking more time then it initially did, what may be the checkpoints and order of things to check to look at the cause Q: [python] find non duplicate numbers in first list and preserve the order of list [1,1,3,2,5,6,5] --> [1,3,2,5,6] Q: [python]flatten a nested list Q: [sql] Rank, row_number, dense rank questions
Data Engineer Interview Questions
Data Engineer Interview Questions
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.
Meest gestelde sollicitatievragen voor een data engineer (M/V/X) en hoe te antwoorden
Vraag 1: Kunt u tot in detail uw kennisniveau van programmeertalen omschrijven?
Vraag 2: Leg in uw eigen woorden uit wat data engineering inhoudt.
Vraag 3: Kunt u uw ervaring met Apache Hadoop en databeheer in een cloudomgeving beschrijven?
20,944 data engineer interview questions shared by candidates
1. Given the sample: id, status 1, active 2, active 3, active 4, pending 5, expired 6, expired 7, expired 8, pending Pull the unique statuses that show up consecutively 3 times, e.g. from the sample, the output would be 'active', 'expired'. 2. Given the sample: employee, in_out, time A, IN, 6:00 B, IN, 7:00 A, OUT, 8:00 C, IN, 9:30 A, IN, 9:00 A, OUT, 10:00 B, OUT, 11:00 C, OUT, 10:00 Determine which employees are in the building at 10:30.
The questions around your experience in the initial rounds. The case round consists of analyzing data using Pandas or Pyspark. More analytical than technical. Time management is crucial.
How to sum all values in a range of values between A and B?
Remove duplicate consecutive spaces from a given string, in-place. For example: "Have a nice day" should become "Have a nice day". Removal of leading and trailing spaces was not specifically mentioned.
5 Python problems and 5 SQL problems at phone screen round
Given a Problem statement,had to figure out the KPI's immediately.
Are you willing to work on 3AM Production Support without hesitation ?
General high level system designs for use cases
Using Python, write a one-liner function to return a list containing only the unique elements of the given list. Order doesn't matter. Next, write a function to return an order-preserving list containing only the unique elements of the given list.
Viewing 51 - 60 interview questions