Question 1

Why leaving within a year from previous organisation?

Accepted Answer

Situation: Short tenure. Task: Honest, reassuring. Action: Role mismatch, company change, opportunity. Not lightly. Committed to long-term fit; this role is it. Acknowledge unusual; learned what I need. Emphasize intention to stay....

Question 2

Why still looking out if you already have an offer?

Accepted Answer

Situation: Offer + exploring. Task: Thorough decision. Action: Have offer; very interested. Informed decision, best fit. This role compelling. Transparent on timeline. Not leveraging. Genuine interest. Result: Trust through transparency.

Question 3

How does ADF help streamline data movement in your project?

Accepted Answer

Benefits: (1) 100+ connectors. (2) SHIR for on-prem. (3) Copy and Data Flows. (4) Scheduling, triggers. (5) Parameters for reuse. Example: One pipeline for SAP, Salesforce, on-prem SQL → lake; another to Synapse....

Question 4

What I understand about the profile

Accepted Answer

'From the JD, this role focuses on [X,Y,Z]. You need someone to [responsibility] using [tech]. The team [structure/culture]. I'm drawn to [aspect] because [experience]. I'd bring [skill] to [challenge].' Show research; connect to strengths; ask clarifying question.

Question 5

What do I know about Nasdaq?

Accepted Answer

Research Nasdaq. 'Global tech—exchanges, data, analytics. Market infrastructure, listings, data products. Scale of market data—real-time, high-throughput; regulatory environment. Interesting for data engineering—systems powering global markets.' Connect to role.

Question 6

Write a query to calculate Monthly Active Users (MAUs) for July 2022

Accepted Answer

SELECT COUNT(DISTINCT user_id) AS mau FROM events WHERE event_date BETWEEN '2022-07-01' AND '2022-07-31'. Or EXTRACT(YEAR/MONTH). **Why**: MAU = unique users in month. **Scalability**: Partition by month; approximate COUNT_DISTINCT (HyperLogLog) at scale....

NASDAQ Data Engineer Interview Questions

Other Companies