Round 1 - Technical

Self-Introduction:

🔹Briefly introduce yourself, emphasising your tech stack and recent projects. Mention key technologies used and your role in those projects. It was more of a discussion to understand what Tech and Architecture I have worked with and how that would align myself with the job profile in that team.Interviewer explained in detail about the kind of work candidate would be working on. Here it was a great chance to showcase how my skills are aligned with the profile with real-life examples.

🔹Focussed on how requirement gathering is a crucial part of the DE project.

Technical Discussion:

1. Technology & Architecture:

🔹Discuss the technologies used in your current project and its architecture. Include your specific responsibilities.

🔹Follow up questions related to interaction with data sources. For example:

🔹Connecting from On-Prem sources.

🔹Interaction with external API. Experience with working on APIs.

🔹How ADF is being used the project.

2. SQL Skills:

🔹Prepare for questions on intermediate to advanced SQL, focusing on Windows functions (RANK(), DENSE_RANK()), Joins and Common Table Expressions (CTEs).

🔹Assume you're given a table containing information on user actions. Write a query to obtain number of monthly active users (MAUs) in July 2022, including the month in numerical format "1, 2, 3".

Hint: An active user is defined as a user who has performed actions such as 'sign-in', 'like', or 'comment' in both the current month and the previous month.

User Action Table Schema:

ColumnName Type

user_id integer

event_id integer

event_type string ("sign-in, "like", "comment")

event_date datetime

User action table sample data:

| user_id | event_id | event_type |event_date|

|---------|----------|------------|----------------------|

| 445 | 7765 | sign-in | 05/31/2022 12:00:00 |

| 742 | 6458 | sign-in | 06/03/2022 12:00:00 |

| 445 | 3634 | like | 06/05/2022 12:00:00 |

| 742 | 1374 | comment | 06/05/2022 12:00:00 |

| 648 | 3124 | like | 06/18/2022 12:00:00 |

Example output for June 2022:

|month| monthly_active_users |

|---------|----------------------|

| 6 | 1 |

3. Challenges faced in the project. Follow up questions on that. Example: How we managed to get around that, what are the steps taken to handle such challenges in future.

Round 2 - Managerial/Fitment:

Self-Introduction:

🔹Briefly introduce yourself, emphasising your tech stack and recent projects.

🔹Mention key technologies used and your role in those projects.

🔹What Tech and Architecture I have worked with and how that would align myself with the job profile in that team.

🔹What do I know about Nasdaq.

🔹Interviewer gave a brideye view on the profile and areas that it would be covering. Here it was a great chance to showcase how my skills are aligned with the profile with real-life examples. Also discussed, how things work internally in Nasdaq.

🔹Question from my side helped here to showcase my interest in the role and also understand the role better from management perspective.

Round 3 - Managerial/Fitment:

Self-Introduction:

🔹Briefly introduce yourself, emphasising your tech stack and recent projects. Mention key technologies used and your role in those projects.

🔹It was focussed on what I understand about the profile based on last two discussions.

🔹Followed up with expectation and focus from the leadership side. Here it was a great chance to showcase how my leadership skills and understanding the criticality of having a good understanding of the project and team.

Round 4 - HR/Fitment In-person Interview:

Self-Introduction:

🔹Briefly introduce yourself.

🔹What do I know about Nasdaq.

🔹Why leaving within a year from previous organisation. Follow up questions here based on the answer.

🔹Why still looking out if you already have an offer. Praise Nasdaq and put forward your genuine interest in Nasdaq.

🔹What I understand about the profile.

🔹Explained about Nasdaq work culture and policies.

🔹Requested to negotiate on the offer I already have. Feel free to give your numbers here. Don't shy away as this would be crucial.

🔹Emphasis was on joining Nasdaq for its Brand value and work culture not just compensation part.