Teradata Developer interview questions

Had a phone interview with an engineer. Went extremely well and seemed as though I was going to move forward. They didn't email me back for over a month and then finally told me that the position had been changed. Not cool man

(This is from 2017) I had applied online for a new grad position. Interview began with a phone call from a recruiter who asked some questions about me, my experience etc. Received a multiple-day coding challenge next which was to design a REST API for a data dump they provided a link to. After submitting this, I had to follow up with the recruiter after 2 weeks to go ahead in the process. For the onsite, I had around 4 rounds (3 technical and 1 with the hiring manager). Overall they went well, but I wasn't able to answer some questions about scalability since I had no prior experience. After the onsite, I was told to expect a decision in a week. I got ghosted by the recruiter for around a month, before being informed they were planning on extending an offer. However, the recruiter again went AWOL and I got a call after a month informing they were not proceeding with an offer since they wanted to hire someone more senior. Overall, the process 2.5 months and was just time wasted.