Intuit | SDE 2 | LLD | Craft Demo | Rejected

Given 2 documents "Buyer.csv" & "Supplier.csv", build a solution that reconciles / matches the txns. The solution should -:

  1. categorize the txns into Exact / Partial / Only in Buyer / Only in Supplier categories
  2. handle matching of number / string / date

Definitions

Exact Match - 2 elements are an exact match if they are exactly the same
Partial Match -
A. Number1, Number2 match partially if Number2 is in range of Number1 +/- threshold
B. String1, String2 match partially if String2 is similar to String1
C. Date1, Date2 match partially if Date2 is in range of Date1 +/- threshold
D. If there are multiple partial matches, the ‘best partial match’ should show up

My design and working code - https://github.com/KeshavGoswami/TransactionMatchingService

Comments (5)