Cloudsek SDE-1 Data Acquisition Interview Experience
Summary
Applied for SDE-1 position at Cloudsek. Interview process included three rounds with a mix of coding, system design, and Python concepts. Despite thorough preparation, the candidate was rejected.
Full Experience
Interviewed for the SDE-1 Data Acquisition role at Cloudsek. With 2 years of experience, I went through three rounds of interviews. In the first round, I was asked to rate my Python and SQL skills, followed by a coding question on Roman to Integer. I also discussed Python concepts like *args, **kwargs, decorators, and SQL topics such as query optimization, indexes, and execution flow. In the second round, I tackled two Python problems: extracting patterns between URLs and converting unstructured data into a structured format. The third round focused on system design, including crawling a website and managing concurrent requests. Despite the challenges, I was rejected.
Interview Questions (4)
Given two URLs, extract the common base URL. For example, from the URLs http://www.openrce.org/forums/topics/22/12/11 and http://www.openrce.org/forums/topics/22/13/11, the expected output is http://www.openrce.org/forums/topics/22/.