Really smooth, hiring manager reached out to me and scheduled a phone interview and then onsite with 5 different folks. Mostly behavioral questions and role related scenarios. Received offer after couple of days, which I accepted

Interview process included HR screening, Hiring manager screen (45 mins), Senior Leader screen (45 mins) and Final Technical Round with 4 interviews (45 mins each). Hiring manager was mainly behavioral as they try to understand your skillset and background in relation to the job profile. My senior leader round did not happen as the interviewer no showed because the recruiter didn't check their availability and know that they were OOO. I was moved on to the final round instead and was told by the hiring manager and recruiter that someone in this role needs to know PL/SQL but not be a "programmer" and will not be getting coding interviews. Final round interviews had 3 PLSQL coding interviews with difficult questions a DBA/programmer would know. Suffice to say the interviews didn't go well. The other interview only delved into my resume with no questions on my program sense or technical TPM questions. Big disconnect between HR and the team here.