Microsoft | Data Engineer | Senior Software Engineer | Hyderabad | Jan 2024

Company: Microsoft
Position: Data Engineer

Round 1:

• Design a schema for hours spent on application using check in and check out timestamps by employee code and few SQL questions on the same.
• Project discussions in-depth

Round 2:

• https://leetcode.com/problems/longest-increasing-subsequence/description/
• Design E-commerce site database schema ( products, orders,customers Tables) and SQL questions on the same.
• Questions revolving around Spark performance optimizations

Round 3:

• Questions on resource configuration in spark ecosystem for different sizes of input data

• Design question on data reconcillation & data validation.

Company: Microsoft
Position: Senior Software Engineer ( Data )

Round 1:

• Heap Sort Implementation
• https://leetcode.com/problems/merge-sorted-array/description/

Round 2:

• https://leetcode.com/problems/find-peak-element/description/
• Spark Partitoning , shuffling , broadcasting topics

Round 3:

• Design a data pipeline where you dump data for each day in s3 storage location and you need to ingest this on incremental basis into oracle db
• How much memory of executors do we need to load 1 tb data
• SQL questions
• Project discussions in-depth

Verdict: Rejected for both roles as my last round's feedback were not positive.