Thank you for the opportunity to complete this challenge! I recently implemented a similar system to ingest our carrier's policies, contacts, and enrollments, so my solution is based on things I learned during and after that process. My code snippets are pretty short and given more time I'd love to show you more error handling, logging, and testing. This document includes my solution, next steps, and answers to the assessment questions.
Assumptions:
- Every broker sends policy, carrier, and client data
- Every broker sends all files at the same time
- Every broker sends their data in force
- Every broker includes the carrier and client foreign key in the policies file