Multiple Rounds of interviews
The first interview was a simple phone interview. I applied through LinkedIn and was contacted via e-mail about my application to speak on the phone.
The second interview was done via Microsoft Teams Video [Virtual Position]. I spoke with two very knowledgeable, insightful, and personable managers and answered questions about my job history and interest in the position.
Third interaction is a Technical Aptitude test. It is exactly one hour long and it has logical questions [Two trains on one track heading towards one another and a bee flying in between. How many trips can the be make before the trains collide?], SQL Questions, and basic JavaScript IF/Boolean questions.
The final round is a follow up to the aptitude test where they go over some questions from the previous test and asked me for my reasoning on why I answered the way that I did along with more SQL Questions and vague CSV data interpretation questions.
After all these rounds in a span of about a week and roughly 3 plus hours of time. I was given an offer. The offer was a low-ball offer. I also got offered a similar position by a different company for 15k more a year. I did not let that be known because I think it is in bad taste to pit two companies against each other in that fashion. However, I explained in detail via e-mail with screenshots of my current salary and circumstance in relation to benefits[Currently 100% Employer paid]. They refused to negotiate and "rescinded" the offer [Although it is clear that it was never going to be accepted by me b/c it makes no sense to take a pay cut to work somewhere else]