The name of your college/tier would only matter for your first job. After that, few people talk about what school they went to as its generally not relevant. They’ll be more interested in your skills and abilities.
Contacts and maintaining a network are very important regardless of what school you went to - that’s important for your entire career.