Perhaps this should influence my career decision somewhat, its hard to tell if talent or effort is more crucial for programming.

Effort. Always assume effort. Talent will speed up the learning process in the early stages, is likely to make effort easier (because it is more fun) and at the extreme upper ends of of performance probably gives a higher limit. But in general effort plus social politics skill will determine your career success.