Live data from Hacker News

Today’s Top Tech Skills

hiringlab.org

41–50 of 373 posts

Re: Today’s Top Tech Skills

#41

I don't really understand the desire for skills to be in high demand. Obviously, you want your skills to be in demand in some capacity . But putting so much emphasis on whether some tech skill is a winner on a scoreboard can give people the wrong impression about other languages and technologies that appear to either be unpopular or dying. It's reassuring that Java and SQL are still in high demand after all these yea…

because price ( aka salary / fee) is a function of supply and demand and it grows the more the skill is in demand. As simple as that.

Let’s say you want to start a career as a freelance for example : what skill to you put forward ? You may say « but jobs requiring elixir are probably more interesting than sql/java ». I agree, but that is if there’s one position open at the time you’re looking , in the area you’re looking and with other qualifications matching

Re: Today’s Top Tech Skills

#42

In the recent two or so years I was surprised to see how many people don't _really_ know about SQL. Sure they can write a simple insert and update query and maybe a join, assuming they can just ignore that there actually are different types of joins. But if you ask them about other _still fundamental_ knowledge like a _rough_ idea about what the different transaction isolation level are/mean/imply for you, they fail…

My go to interview question to test basic SQL knowledge is use of “HAVING”.

It’s a surprisingly good filter.

EDIT: To clarify since this got more attention than I expected...I don’t disqualify any candidate based on the answer to a single question. I just use that question to assess their actual SQL experience. If you’ve spent any amount time writing raw queries by hand for reports or just to pass through to a web service, you’re going to have run into HAVING. It’s a simple part of the basic SELECT syntax without needing to involve joins, subqueries, index optimizations or specific knowledge of database internals.

It’s a fair question and the only way you wouldn’t have run into it is from working purely with ORMs or NoSQL. There’s a lot you can do without it, but it goes a long way in determining my ability to ask you to open up a query analyzer in different environments. It’s also going to tell me a lot about the way you think about data problems and where you are going to gravitate for certain types of logic.

Re: Today’s Top Tech Skills

#43

In the recent two or so years I was surprised to see how many people don't _really_ know about SQL. Sure they can write a simple insert and update query and maybe a join, assuming they can just ignore that there actually are different types of joins. But if you ask them about other _still fundamental_ knowledge like a _rough_ idea about what the different transaction isolation level are/mean/imply for you, they fail…

Regarding your 2nd point: commercial grade NoSQL db's can do all of these things now. I think the notion that they cannot is from the v1-2 era of Mongo about 7 years ago. You should read the Dynamo white paper and subsequent documentation on write consistency, transactions etc. and also look at the feature set available on Mongo V4.2.

Re: Today’s Top Tech Skills

#44
post #5

What about most compensated tech skill. Highly doubt SQL and Java rank highly there.

You think? A huge chunk of work at Google is Java.

The median pay might be quite low for Java, because there are also a hojillion poorly-paid enterprise wageslaves toiling away in the cubicle farms.

But the absolute number of people earning a lot (100k, 200k, whatever you think that is) might well be higher for Java than for anything else, because it's used in some significant big tech companies and in finance.

So, if you're of average ability, learning Java might not juice your pay much, but if you're highly talented, it might.

Re: Today’s Top Tech Skills

#45
post #14

It remains weird and disturbing to me that "AWS" is treated as a skill. Not "cloud system management", but " AWS ". Edit: I do understand why it can be lucrative to have expertise with a specific cloud provider. It's just the status quo of these services being their own unique silos that disturbs me: I would personally be wary of making "ability to effectively use Amazon's servers" a pillar of my career.

You can say smithing like, “weird to see Linux admin, instead of OS admin”. But doesn’t make sense in a business context, if you want a Linux admin.

Re: Today’s Top Tech Skills

#46
post #11

I don't really understand the desire for skills to be in high demand. Obviously, you want your skills to be in demand in some capacity . But putting so much emphasis on whether some tech skill is a winner on a scoreboard can give people the wrong impression about other languages and technologies that appear to either be unpopular or dying. It's reassuring that Java and SQL are still in high demand after all these yea…

This sounds horrible but maybe the people who would take these lists seriously are precisely the kinds of people who are careerist programmers. And they really just want the maximum value from their “investment” in learning programming. In college I didn’t learn Java at all because it didn’t seem very fun. Python did and I learned that. Then Go came along which was easy to pick up. But once you know a general purpose…

> This sounds horrible but maybe the people who would take these lists seriously are precisely the kinds of people who are careerist programmers.

While I agree with the sentiment, I think there's a flipside to this. Certain communities cough cough ahem have the luxury of not caring at all about skills in broad demand, hopping from technology to technology because the market allows it.

I've seen a lot of "expert beginnerism" from that group of people, and a little bit of disdain for the people who do schlep work day in and day out to make a living. In my experience, a lot of the people who work with the boring technology have more seniority and depth because they're not relearning the window dressing that is syntax/framework/language constantly.

If anything, I think these reports (from Indeed... real data, not some meaningless top ten) just indicate that employers don't really care about whatever's hot right now, and that a surprising amount of the economy is powered by unglamorous tech.

Re: Today’s Top Tech Skills

#47
post #45
post #14

It remains weird and disturbing to me that "AWS" is treated as a skill. Not "cloud system management", but " AWS ". Edit: I do understand why it can be lucrative to have expertise with a specific cloud provider. It's just the status quo of these services being their own unique silos that disturbs me: I would personally be wary of making "ability to effectively use Amazon's servers" a pillar of my career.

You can say smithing like, “weird to see Linux admin, instead of OS admin”. But doesn’t make sense in a business context, if you want a Linux admin.

The difference is that Linux isn't owned by a single company. It runs on virtually every platform, including all of these hosting providers.

Re: Today’s Top Tech Skills

#48
post #15

I’m thinking about the future. What skills will dominate the software market 10-20 years from now? - Big companies use C++ heavily, besides being the language for deep learning/GPU programming. Will Rust/Go replace it anytime soon? - Will React still dominate front end development? - What about Python and the data analysis ecosystem?

React might go away, but javascript/typescript will probably be a good bet for the next 10 years (who knows beyond that). I'd like to think that people will come to their senses about Python and use sensible languages for ML + data once they relearn all the problems that software engineers learnt about it all that time ago (fast development != reliable/maintainable development, fast development != easily-scaled devel…

>but javascript/typescript will probably be a good bet for the next 10 years

Honestly how is javascript (and thus typescript) ever going away at this point? I honestly mean _ever_. Like until the day I die. Almost the entire web is using it. Frameworks like React, Angular, Vue have made it so I basically don't care that much about javascript. Most of my code is server-side and the client is largely handled by Angular as a framework so the amount of JS I have to write in my angular components is so minimal.

All that being said, I personally am not a fan of javascript.. at all. The learning curve to know what's going on is horrific in my opinion, and code is not meant to be written clearly but have a small footprint which is terrible. It's too flexible.. though typescript has solved 90% of that.

Even if something like Blazor completely transforms the web, it seems like there will ALWAYS be the case for streamlined simple sites that only need very simple javascript transformations..

Anyway- unfortunately I think javascript is here for the next billion years!

Re: Today’s Top Tech Skills

#49
post #9

I have to wonder if Java would be in demand if not for Android?

Here are some companies that run much, if not most, of their backend on Java: Amazon, Apple, Google, Netflix and Twitter, not to mention pretty much every government, military, bank, hospital, airport, and utility company.

Re: Today’s Top Tech Skills

#50

In the recent two or so years I was surprised to see how many people don't _really_ know about SQL. Sure they can write a simple insert and update query and maybe a join, assuming they can just ignore that there actually are different types of joins. But if you ask them about other _still fundamental_ knowledge like a _rough_ idea about what the different transaction isolation level are/mean/imply for you, they fail…

This is a side effect of the extremism that happens in our industry. A decade and a half ago there was a hard push on ORMs, to the point that people would refuse to work on a code base that didn’t use one. So a lot of developers simply “grew up” not learning SQL (properly).

We can easily enumerate dozens of other technologies that developers hard push on only to years later realize they’ve swung too far.

Post reply on HN