I recently interview with FNZ for Senior Analyst Role in C# .NET

OA:

1. Write a SQL query based on certain conditions
2. LLD question. We need to write in C# only.
3. 1 DSA question (Leetcode - Medium)

Round1:
This was a 30 mins round. Was asked questions related to SQL, C#, ASP.NET, OOPS, Design patterns.

Round2:
This round was heavily focused on SQL.

1. Given a complete dataset, I was asked to write 5–6 SQL queries.
2. Some questions involved improving the performance of SQL queries.
3. I’m not very proficient in SQL, so this part didn’t go very well.

After SQL, we moved on to C#:

1. Discussed OOP principles and various design patterns
2. I was shown a C# code snippet and asked to identify bugs
3. Then I was given a coding task to complete in Visual Studio
4. They were very particular about coding standards and best practices

Waiting for Round 2 result, If passed, recruiter told there will be one more round, in person in there Gurgaon office.