If you want to be a college grad hired by Google, college name matters. If you want to move across the country, college name matters. If you want to stay in the region/state, not choose a garbage tier college is all that matters. It's not Ivy league or bust, but choosing top 100 university for chosen field is a good bet.