Derive customer's account status as of month end for all the months in 2019. If for given month, there are more than one rows, pick the data from the latest date within the month. If for given month, there is no data, pick the data from latest date prior to the month You can use last_day function to get month ending date(Eg: last_day(01/01/2015) = 01/31/2015) customer_id event_date status credit_limit 1 1/1/2019 C 1000 1 1/5/2019 F 1000 1 3/10/2019 1000 1 3/10/2019 1000 1 8/27/2019 L 1000 2 1/1/2019 L 2000 2 1/5/2019 2500 2 3/10/2019 2500 3 1/1/2019 S 5000 3 1/5/2019 6000 3 3/10/2019 B 5000 4 3/10/2019 B 10000
Developer Support Engineer Interview Questions
1,134,896 developer support engineer interview questions shared by candidates
Possibilly ask the design based question e.g Mechanical engineers what is pump suction head
I cannot share specific questions. But they will check the basics of your dev knowledge.
How many race heats are needed to find the 3 fastest pinewood derby cars out of a field of 8, if only 4 cars can run at a time (assuming that every car will always run the way/speed and each lane is exactly equivalent)?
Find shortest substring in a string that contains all of a set of characters.
Imagine dropping a Rubik's Cube into a bucket of paint. How many of the cubes will get paint on them?
Intersection of two numerical arrays
Return the max k numbers from an unsorted integer array. Each number in the array is in the range [0, 10000).
Design an algorithm to find the first unique element in an array.
Question was "Given a pattern and a string input - find if the string follows the same pattern and return 0 or 1. Examples: 1) Pattern : "abba", input: "redblueredblue" should return 1. 2) Pattern: "aaaa", input: "asdasdasdasd" should return 1. 3) Pattern: "aabb", input: "xyzabcxzyabc" should return 0. I saw someone else had a similar question, but it was much much easier as the other candidate was given spaces between words to help identify individual words to pattern match.
Viewing 311 - 320 interview questions