Skip to content

Instantly share code, notes, and snippets.

@mindbend0x

mindbend0x/interview.md

Last active May 29, 2022 17:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mindbend0x/7a3e0d95f2c88ab423a99db3bcd6ac3d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mindbend0x/7a3e0d95f2c88ab423a99db3bcd6ac3d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Faisal Al-Tameemi revised this gist May 29, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion interview.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@
    * The aggregation function will run either daily or weekly, must return the correct response either way
    * How would you optimize this function?

    > API Endpoint: https://e5f7-217-165-229-71.ngrok.io/transactions
    > API Endpoint: https://530a-5-107-84-27.ngrok.io/transactions
    2. Given the same API method above, write a function which returns the counts of each transaction type

  2. Faisal Al-Tameemi created this gist Apr 27, 2022.
    25 changes: 25 additions & 0 deletions interview.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,25 @@
    ## Coding Questions

    1. Given an API response which returns a list of transactions, aggregate (sum) the transactions' `amount`s of a specific type
    * The aggregation function will run either daily or weekly, must return the correct response either way
    * How would you optimize this function?

    > API Endpoint: https://e5f7-217-165-229-71.ngrok.io/transactions
    2. Given the same API method above, write a function which returns the counts of each transaction type

    3. Extend the function written in Question #1 to allow multiple runs without recounting values already aggregated
    * For example, if running the function once on type = 'Interest Payout' yeilds a response of 10, running it again immediately should return 0 since all the previous transactions were already considered.

    4. Write a cron scheduler to run daily


    ## Whiteboard Questions

    1. How would you design a payment processing (specifically billing) system for an e-commerce website?
    * Describe the endpoints necessary
    * Describe the data models necessary
    * Describe the code services necessary
    * The system should also deal with creating the order

    2. How would you implement a Postgres Joins optimizer?