The interview what 3 parts 1) initial call 2) 30 minute interview 3) 1 hour technical interview. Seeing as it was a new role they really didn’t prepare me enough for the interview and what was to come. But the interviewer was really nice and delved heavily in my experience and the relativity of my experience to the role. The part that threw me off was when they surprisingly showed me SQL script and asked me to let them know what was wrong with it in the interview. The interview was fairly standard the manual SQL scripting threw me off.

Initial phone interview with manager, then face to face interview with manager and head of dept. Both interviews were quite relaxed, and the questions were fairly straightforward and not designed to catch you out. Questions were mostly around competencies and the skills I use in my current role and how they can be applied to this role. Also some questions about my current managers, to determine whether I was used to working autonomously or not. Face to face interview included a SQL test (on paper not on a PC). Applied for a senior role but was offered a junior role, which better fits my skill set.