First stage was a 30 minute interview with hr, she explained the job to me as well as the hiring process and we discussed my motivations. The second stage was a 45 minute interview with the hiring manager which involved technical questions and asked about my current position. The third stage was a take home technical test which was around 15 questions involving SQL, debugging, c# and some financial definitions such as VaR. The 4th stage was an interview with the hiring manager and a member of the team which took about 30 minutes. 3 weeks after this stage I was informed that they had selected another candidate.

Asked about myself and work experience on Java coding. They haven't mentioned anything about Java in JD. In JD it was mentioned as SQL, Linux, Python scripting, production support. But in interview they specifies we needed one with Java work experience.