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 ?
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.
SQL - Between "Medium" and "Hard" on Leetcode. They expect you to know all of your JOINs, as well as subquerying and partition windows. Python - Around "Medium" on Leetcode. Mostly around data structures.
SQL ==> Sales, promotions, products DB I was able to complete only 3 questions. Python ==> solved only 3 questions. find giving letter in a string Replace None with previous element from List, there was some challenges [None] [None,1,2] ==> [None,1,2] [1,None,2] ==> [1,2,2] [1,4,None,None,3]===> [1,4,4,4,3] Forgot one question In the SQL part, please make sure you learn how to calculate %
Viewing 51 - 60 interview questions