Discussion about this post

User's avatar
Peter Andrew Nolan's avatar

Hello Andreas,

it would be a very good thing for AI to replace people who are calling themselves "Data Engineers". No man who calls himself a "Data Engineer" has earned the right to use the title "Engineer". "Engineer" has meaning. It is a title to be earned, not a title to be adopted by men who are not willing to earn it.

In terms of ETL and data warehousing?

I already invented the future of ETL in 2002 when I invented "typeless, codeless, mappingless" ETL. The enabled us to build much more reliable ETL. In 2009 we moved from using C++ as the software to run ETL to using generated SQL. The rate was 1000 fields mapped in a 220 hour work month. That rate stood from 1996 to 2017, more than 20 years. In 2017 I upped it to 6-8K fields mapped per 220 hour work month. And two years ago I upped that again to 12-15K field mapped per work month. So AIs for ETL development don't help people using my software. We are already much faster than any AI can generate code and my code is more reliable anyway.

Once I got to those productivity figures I changed focus a little to the time and effort of having multiple ETL systems and checked into the ability to have "mega models" implemented even on cheap databases like SQL Server SE. Turned out it's possible. My mega models I mean one data warehouse with one data model housing many customers data from a common large operational system like an ERP or telco billing system.

So with these two inventions data warehousing development costs will be reduced by 5-6X.

This is all free and published. You and anyone else can get my data models and software for free on the link in my BIO. For those men who are the smartest men in our sector? They are very likely to make a lot of money if they build a mega model data warehouse for a large operational system they are very familiar with. That's what my colleagues and I are doing, we shall see how it works out.

AI only does things that are so easy that they were very easily automated a long time ago by those of us who know what we are doing.

3 more comments...

No posts

Ready for more?