Point72·Software Engineer·Online Assessment (OA)
- Write a SQL query that, for each candidate, shows the top three distinct vote totals by state, including state names and counts formatted into place columns (1st, 2nd, 3rd). States tied at the same vote count should be grouped together and sorted alphabetically.
- Implement several methods of a PySpark job class: initialize a Spark session, filter transactions to only valid ones based on account existence and balance rules, count distinct source accounts, and return the top 10 source accounts by transaction count as a dictionary.
“This one took me longer than it should have.”