I applied through an employee referral. I interviewed at Aetna (New York, NY) in Dec 2020
Interview
self introduction
detailed discussion about me resume
my personal career planning and interest Insurance industry
his introduction of the company and the position
algorithms code panel
the last step is that he giving me reviews and feedback of my performance in the interview
I applied online. I interviewed at Aetna in Oct 2020
Interview
Interview with HR, then Full day technical interview with the team. The interview is first 2 coding interview, one for algorithm, other with SQL, then in depth questions on Spark, Hive, SQL.
Interview questions [1]
Question 1
Hive, Spark, Union - Union All, Spark coding, Algorithm , sql coding questions
I applied through a recruiter. The process took 2 weeks. I interviewed at Aetna
Interview
I talked to the recruiters and to the hiring manager. The interview with the hiring manager was longer than 2 hours. This was successful and they set up another tech interview with one of their engineers. After that, the recruiter reached out to me again asking for base salary. After that, they all disappeared, the tech interview was unattended. I think my base salary was more than their allocated budget. This should have been asked earlier on. A total waste of time. The people I talked to did not seem to know well their business.
Interview questions [1]
Question 1
Behavioural, experiences, basic questions on used technologies