Banking Transaction System
Banking Transaction System
Design a system that parses and makes banking transactions available. The system receives transaction data in files dropped via FTP at various times throughout the day. Each transaction has the following schema:
BankId: stringAccountId: stringTransactionId: stringDescription: stringAmount: numberPostedDate: dateMemo: string
Architect this system.
AI interview prep
Core dilemma
Balancing the ingestion of potentially large, batched transaction files from an external source (FTP) with the need for timely, consistent, and queryable access to individual transactions, while handling potential data corruption or duplicates.
3 tradeoffs and 3 stress tests locked
Interview prep
Unlock the interviewer X-Ray rubric, tradeoff matrix, stress tests, clarifying questions, and key concepts.
Banking Transaction System
Banking Transaction System
Design a system that parses and makes banking transactions available. The system receives transaction data in files dropped via FTP at various times throughout the day. Each transaction has the following schema:
BankId: stringAccountId: stringTransactionId: stringDescription: stringAmount: numberPostedDate: dateMemo: string
Architect this system.