This is specific to Dept of Environmental Health
Left vm to set up in-person interview as per email instructions. About a month later I got a call to set date for an in-person interview
Upon arriving, took a 25 min 3 question written test. One analysis and two db questions.
Question 1: takes 4 analysts and 2 engineers 3 days to complete a job. Takes 3 engineers 4 days to complete same job - how long does it take 4 analysts to complete the job? Answer should be 6
Question 2: looking at 3 db tables with 1 table having indexes, write the select statement
Question 3: what are 2 ways to remove redundant rows from the result?
Then went in to speak with few managers all at once where the questions are written out on paper