IMHO the generic leadership qualities are every bit as valid for the CIO as for any other senior leader. Additional qualifications of the CIO would include but not be limited to:
1-a solid understanding of pure data processing fundamentals. Sadly, the era of drag and drop programming has rendered this essential background to the heap of dinosaur bones - to many enterprises detriment.
2- a broad background in code design or software engineering which has been implemented with a wide variety of programming languages and environments.
3- data management strengths to protect corporate (single source) data whle allowing deltas for subsystem specific requirements.
4- experience across many levels and sizes of prcessors and hardware subsystems.
In most non-trivial enterprises the notion that "one size fits all" produces no best of breed solutions and quite often results in unstable, unscaleable and extremely costly to maintain solutions.