Company: Microsoft\nPosition:  Data Engineer \n\n**Round 1:**\n* 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. \n* Project discussions in-depth\n\n**Round 2:**\n* https://leetcode.com/problems/longest-increasing-subsequence/description/\n* Design E-commerce site database schema ( products, orders,customers Tables) and SQL questions on the same.\n* Questions revolving around Spark performance optimizations \n\n**Round 3:**\n* Questions on resource configuration in spark ecosystem for different sizes of input data\n* Design question on data reconcillation & data validation. \n\n\nCompany: Microsoft\nPosition:  Senior Software Engineer ( Data ) \n\n**Round 1:**\n* Heap Sort Implementation\n* https://leetcode.com/problems/merge-sorted-array/description/\n\n**Round 2:**\n* https://leetcode.com/problems/find-peak-element/description/\n* Spark Partitoning , shuffling , broadcasting topics\n\n**Round 3:**\n* 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\n* How much memory of executors do we need to load 1 tb data\n* SQL questions\n* Project discussions in-depth \n\n**Verdict:** Rejected for both roles as my last round\'s feedback were not positive. \n \n\n\n\n\n

Company: Microsoft\nPosition:  Data Engineer \n\nRound 1:\n Design a schema for hours spent on application using check in and check out timestamps by employee c