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
I Data engineer sono professionisti informatici richiesti pressoché in tutti i settori. Si occupano di monitorare i trend dei dati per pianificare le azioni più adeguate che un'azienda deve intraprendere. Uno degli aspetti più critici del lavoro di un Data engineer è l'elaborazione dei dati grezzi e la loro trasformazione in dati utilizzabili per creare pipeline e sistemi di dati.
Domande tipiche dei colloqui per Data engineer e come rispondere
Domanda 1: Puoi descrivere in dettaglio il tuo livello di competenza nell'ambito dei linguaggi di programmazione?
Domanda 2: Spiega a parole tue che cos’è il data engineering.
Domanda 3: Puoi descrivere un'esperienza lavorativa con Apache Hadoop e in ambienti di gestione dei dati nel cloud?
20,133 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