My team only uses SQL for everything: analysis, pipelines, ML. Is this a bad job due to not using more advanced things (Python, Spark, Hadoop, Java) or is this an industry norm?
Can you share more about your team, the make up, the vertical it supports and the type of projects it gets?
Whlle u are at it also share Manager and director name , and ur phone number and Instagram ID
Is this your current team at Google?
Yep
Okay how can I join and get paid big Google bucks just using sql
what’s ur title?
SQL Engineer probably
This is very common at FANG. Everything is abstracted away from you because near perfect solutions and architecture has already been implemented. This is why I advice people to stay away from any data positions at FANG because you will have a hard time getting an equivalent title somewhere else. For example, using tools such as Protobuff, Kafka, Flink, Spark, Airflow, MLFlow, etc. I highly recommend FANG for new grads, but definitely something to consider after you gained some experience.
Thanks, this is really insightful. Why do you think FAANG is still good for data new grads? Just to learn how to be a good employee?
Also how would you deal with this given current layoff market w non FANG companies?
SQL is quite a strong tool. Tools are only a means to an end. Apart from not using fancy tools, does the team manage to do what they are up to? If so, then that's a good story to sell to your new employer if you're not sure how this team will help your career. If you have reason to believe that a certain task could be more optimised using other tools then that's a good discussion to have with them and you might see the change you want. Be prepared to speak with seniors and managers and showcase your arguments using examples from the industry.
I don’t see spark and Hadoop used much outside of the older large co’s in analytics roles. Python is useful for certain cases, and mandatory for certain other cases. I assume your team doesn’t do any modeling
I agree with Hadoop but spark is still hot.
Modeling can be done by SQL only right?
If you’re throwing out completely different catch phrases (Java, Python, etc) to try to make a point of why not to use SQL, then you’ve completely missed the point. Those are programming languages that are not mutually exclusive to SQL. Perhaps you should research and understand why your team needs a relational database in the first place
Yes, I'm not sure what their point is here. They aren't discussing data query functionality or speed which is all that SQL and competitors come down to.
r/whoosh
Yeah that is normal, Not sure how you are using SQL for ML though .
Then wtf is the leetcode interview for lol!!
leetcode also has questions on sql lol
That's not....cool story.
How do you use SQL for ML…?
👀
Look up something like Amazon Redshift ML