Taro Logo

Data Engineer Interview Experience - New York, New York

May 1, 2024
Negative ExperienceNo Offer

Process

Mostly technical interviews, some fit.

Just know your comp sci and talk through some moderately hard problems.

Know the runtime of searching, adding, deleting, arrays vs lists and dicts.

One round of fit interviews, some interviews technical with Python and pandas questions.

Questions

Create an order book that adds orders or matches orders. How would you store buys and sales?

import typing """ Design an order book

  • Incoming orders are matched with the counterpart with the best price, assuming the prices cross
  • Best price is relative to the incoming order
  • E.g. if incoming order is a buy order, best price is the lowest price sell order
  • If there is a tie in price, the order that arrived first is matched first
  • Users can add, modify and cancel orders at any time
  • If a user modifies the price of their order, it should not retain its position """

class MagicLIFOQueue: pass

class Order(typing.NamedTuple): id: int quantity: int price: float is_buy: bool

class SingleStockOrderBook:

def init(self): self.orders = {"buys": {96.25: [], 98: [], 97.50: []}, "sales": {98: []}} [[96, [1,2,3,4]], 97, 97.50] def add_order(self, order: Order): pass

def modify_order(self, id: int, new_quantity: int = None, new_price: float = None): pass

def cancel_order(self, id: int): pass

def best_ask(self) -> float: pass

def best_bid(self) -> float: pass

def get_matching_orders(self, incoming_order: Order) -> list[Order]: pass

def example_usage(): book = SingleStockOrderBook()

(1) Sell 100 shares @ $100

(2) Sell 100 shares @ $99

(3) Sell 25 shares @ $98

(4) Sell 50 shares @ $98

book.add_order(Order(1, 100, 100, False)) book.add_order(Order(2, 100, 99, False)) book.add_order(Order(3, 25, 98, False)) book.add_order(Order(4, 50, 98, False))

(5) Buy 200 shares @ $100

buy_order = Order(5, 200, 100, True) matches = book.get_matching_orders(buy_order) """ In order, the expected matches here are

  • Order 3 (25 shares @ $98)
  • Order 4 (50 shares @ $98)
  • Order 2 (100 shares @ $99)
  • Order 1 (25 shares @ $100) """

return

example_usage()

Was this helpful?

Interview Statistics

The following metrics were computed from 1 interview experience for the Engineers Gate Data Engineer role in New York, New York.

Success Rate

0%
Pass Rate

Engineers Gate's interview process for their Data Engineer roles in New York, New York is extremely selective, failing the vast majority of engineers.

Experience Rating

Positive0%
Neutral0%
Negative100%

Candidates reported having very negative feelings for Engineers Gate's Data Engineer interview process in New York, New York.

Engineers Gate Work Experiences