Writing software is essentially solving problems.

Some of these puzzle/problems are stupid, but if you do not know how to solve problems well and frequently you probably will not be a good (let alone excellent) software developer.