There are certainly brilliant folks around in the valley, who can grasp concepts faster and more deeply than seems human, but they are a significant minority.
The prime requisites for success as an employee in the valley are still:
1) Good judgement (which tends to come from accurate self-reflection and critique)
2) Love of learning (so it takes you a couple hours or even days to grok redis's failure modes instead of 20 minutes, who cares -- the question is are you going to learn it (and every other useful thing that comes along, for years))
3) Basic sociability (the valley is a small world, everyone knows each other, if you are a jerk life will get more difficult).
For a much more eloquent description of how to thrive as a programmery type in the valley, consider http://www.cs.virginia.edu/~robins/YouAndYourResearch.html but translate research into "generally useful skills for building stuff."
"You and Your Generally Useful Skills for Building Stuff." :-)
Once you get to a high enough intelligence that you can understand what the people around you are telling you and follow their train of thought, intelligence really doesn't matter all that much. Other characteristics like perseverance, social & communication skills, and emotional stability become dominant. There's nothing "magical" about getting an 800 SAT-M (or working at Google, for that matter), it's just that the effect of having a large body of knowledge that we spent thousands of hours acquiring to draw upon.
Just look at the normal distribution of IQ scores: http://en.wikipedia.org/wiki/File:IQ_curve.svg
Sure, a lot of people are in the 120+ range on Hacker News, at top management consulting companies etc. but if you are 110+ IQ you are probably smart enough to do almost any job on the planet.
I'm not a programmer, but I imagine that like business, there are plenty of terrible programmers with 140 IQs that believe they are entitled to not working hard or being good with people.
They will always make less and even their high IQ will not allow them to figure it out.
(also, a perfect math score in the sat isn't impossibly hard - the level of mathematics is probably lower than your last school exam. it just takes a lot of practice to do that many questions fast and accurately.)
If you haven't seen the SAT math, it is a slightly creative twist on 10th grade math (Algebra and Geometry). Scoring an 800 means you could get an A grade in high school math, and are not so slow at solving the problems, and are careful enough to avoid sloppy mistakes in your work.
"120" IQ is supposedly 2 standard-deviations above the "(human?) population mean", which is ~98%ile of the population, which is well within the margin of error of these sorts of measurements.