Interview process consisted of a Zoom interview with two people on the team, then an in-person interview. The in-person interview consisted of 6 non-marketing professionals asking questions at once. Half of these interviewers treated it like an interrogation, and it was impossible to establish any kind of rapport with so many people at once. I was told to bring copies of my portfolio, and I ended up spending a not insignificant amount of money printing multiple full-color copies and buying folders. In the conference room, there was a TV that could have been hooked up to a laptop to project it to everyone at once. This was upsetting because I was on a tight budget at the time. When I inquired about getting the copies back after hearing my interview was unsuccessful, I was told they were thrown out. I suppose that is for the best, because some of the interviewers treated the copies like their own personal notepad to take notes on. Additionally, it was very warm in the conference room, and I was not offered any water (everyone who was interviewing me had their own bottles). This in and of itself isn't terrible, but when my voice cracked towards the end of the interview (due to no water and the interview being over an hour long) one of the interviewers condescendingly said "You don't have to start crying" and everybody laughed, which didn't make me feel very good.
I applied through a staffing agency. The process took 3 weeks. I interviewed at Oklahoma Turnpike Authority
Interview
They told me that you will make 30 SSRS reports for every 1 PowerBI report. Short 30 min long virtual interviews. One technical with the team one technical with the manager.
Interview questions [1]
Question 1
They made an offer and I asked through my recruiter for a week to compare offers as I was far along with another more senior role. OTA responded by recending my offer.
I applied through a recruiter. The process took 2 weeks. I interviewed at Oklahoma Turnpike Authority
Interview
They were very nice and prompt in their communication. The interview was fairly layed back. They asked a lot of questions about the databases I currently support: how many databases and tables, largest database and table, how many procedures created, how many stored procedures have you edited, etc. They also asked some technical questions: difference between a primary and foreign key, types of relationships, temp tables, indexes, etc.
Interview questions [3]
Question 1
How many databases, tables, procedures, and jobs do you support?