They asked about my experience managing projects and how I handle resistance from stakeholders. The technical portion included an Excel exercise (mainly using VLOOKUP, IF, COUNTA, COUNT, etc.) on a virtual desktop that lagged frequently, likely due to internet speed. The SQL exercise used outdated software with no autocomplete or script support, requiring manual coding for basic queries and INNER JOINs to combine tables, sort results, and present findings. The computer provided had only a single small screen with no option to project your work, which made it more difficult to manage multiple windows and added frustration during an already stressful process. Candidates should be prepared for these technical and environmental challenges, as they differ from the tools and setups common in modern industry environments.
