What can we learn from software development job posts? (SQL, Java, and XML will get you a job!)

About a year ago, I posted some analysis of what we can learn from job posts. Since then, the job outlook for at least the American economy has substantially declined, but there are still opportunities available if you have - or can develop - the skills in demand. A year ago, according to job posts on Dice.com, the hot job skills were Java, SAP, and Oracle. How about today?

Well, with a slight change to methodology, things look pretty much the same, but the changes are interesting. Last year, I only looked at terms that appeared in job post titles; this time around, I searched on terms that occurred anywhere in the job post. I can't say I used a totally comprehensive set of terms, or that the queries don't produce some false positives and negatives, but without further disclaimers, here are my findings.

The top 20 IT skills in demand on Dice.com:

1. SQL
2. Oracle
3. Java
4. Windows
5. Unix
6. Linux
7. XML
8. SQL Server
9. HTML
10. C#
11. Dynamics
12. C++
13. SAP
14. Perl
15. IBM
16. AJAX
17. PL/SQL
18. BASIS
19. PHP
20. MySQL

(For the rest of the list in the analysis, see the end of this post.)

A little surprising that Dynamics came in above SAP on this list, and perhaps there were some "false positives" putting BASIS above PHP, but probably nothing really shocking there. There was strong demand for many skills, but very little demand (relatively) for iPad (just 13 jobs!), HTML5 (34 jobs), Fortran, Azure, and eBay -- all under 100 job posts mentioning these skills.

Overall, your best bet is to learn Oracle, SQL Server, Java, and XML on your choice of platforms, and you've got job security 'til the end of time (or at least for the next few quarters).

Some additional findings:

• SQL is a great skill to have. Oracle and SQL Server are the best databases to learn in terms of job openings [NOTE: no analysis was done on salaries, so your mileage may vary if you care about earning potential. There was one job on Dice for a TPF programmer, and I bet that pays pretty well!]. DB2 and Sybase also had strong demand.
  
• Java, C#, and C++ are all continuing in strong demand. Perl, PHP, Ruby, and Python also have strong demand. There is some, but significantly less, demand for Flash, COBOL, and ABAP development skill.
  
• XML skills are greatly in demand. There is significant demand for AJAX skills as well.
• Dynamics came in very strong on the Applications front, with SAP also very strong. There is some continued demand for Peoplesoft and Siebel skills. Salesforce.com is significantly less, but there is still substantial demand for Salesforce.com skills.
• There is not a lot of demand for Mac, iPhone, or iPad developers, with none of those platforms cracking the 500 job posts mark. Blackberry was the only mobile phone platform above that mark, with some significant demand. Android is in slightly less demand than iPhone, but growing much faster.
• Amazon and Azure, two leading cloud platforms, had very little demand for candidates.
  

Overall results:

Skill Sought SQL	# of Posts Mentioning 17525
Oracle	12533
Java	12104
Windows	9877
Unix	8872
Linux	7703
XML	7600
SQL Server	7196
HTML	6198
C#	5773
Dynamics	5066
C++	4937
SAP	4713
Perl	3943
IBM	3306
AJAX	3244
PL/SQL	2656
BASIS	2306
PHP	2085
MySQL	2061
DB2	1996
VMWare	1776
Python	1629
Peoplesoft	1603
Embedded	1466
Sybase	1379
Mainframe	1342
Siebel	1153
Google	837
Ruby	786
Flash	604
Blackberry	580
COBOL	537
Salesforce.com	521
ABAP	479
iPhone	387
Mac	372
Android	316
Twitter	283
Facebook	248
Amazon	236
Assembler	191
Widget	174
Yahoo	165
Informix	153
Palm	133
PowerBuilder	111
eBay	62
Azure	53
FORTRAN	52
HTML5	34
iPad	13