Cloudsek SDE-1 Data Acquisition Interview Experience
Anonymous User
641
Interview

Interview Experience (Python / Backend)

YOE - 2 (including 3 months internship)

Round 1 (1 hour)

  • Introduction
  • Asked to rate myself in Python and SQL (out of 10)
  • Coding question:
  • Python concepts:
    • *args and **kwargs
    • What are decorators? Create a simple decorator
  • SQL & Database:
    • If a query is taking a lot of time, what steps would you take to improve query execution speed?
    • Indexes and types of indexes
    • Query execution flow for: 
      SELECT * FROM students WHERE user_name = 'test' LIMIT 10;
    • If a table has a composite primary key, does the order of columns matter?
  • System concepts:
    • What is a rate limiter? Write pseudocode for any type of rate limiter
    • Do you know Docker and Kubernetes?

Round 2 (1 hour)

Problem 1: Extract pattern between two URLs

Problem 2: Convert unstructured data into structured format

a = """babu,
babu@info.com|
gopi,gopi@info.com|john,
john@info.com
""".split('\n')

Expected output:
[
  {'name': 'babu', 'email': 'babu@info.com'},
  {'name': 'gopi', 'email': 'gopi@info.com'},
  {'name': 'john', 'email': 'john@info.com'}
]

After these problems, I was asked some additional questions on Python.

Round 3 (1 hour)

  • Extract data from https://news.ycombinator.com/ such that the result is a dictionary where:

    Key → username
    Value → news title

  • You are working on building a crawling system where users can submit a batch of seed URLs,( let's say 100 in number, and also their email-id).
    Your system needs to take those 100 Urls, and crawl it up-to level 3 in depth.
    Once all the 100 URLs submitted by the User are completed processing, you need to notify the user. Assume you already have a 3rd party service available /get_page_details( url, meta_data ) which returns ( page_content, child_pages, meta_data)
    The 3rd party service can handle 10 concurrent requests. Please respect it’s limits. Asked me to design an API, db schema etc.,

  • Asked some basic system design questions

Verdict: Rejected

Hope this help. Happy Coding :)

Comments (3)