What are the key responsibilities of an SDET at Microsoft?

I'm curious to learn about the day-to-day tasks and challenges that a Software Development Engineer in Test (SDET) faces while working at a major tech company like Microsoft. What skills are essential for excelling in this role, and how does the position contribute to the overall success of software development projects within the company?