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.
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
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