hey Dan, i am not a data scientist but I found your videos on mock interviews really relevant for my preparation for facebook's data engineering role. I just wanted to give you a shoutout and hoping that you continue making these videos. (and yes, I actually did land the job as E5 at FB)
@@joshisaiah2054 oh man, thats solid. Im thinking of breaking into the space as well so unfortunately I cant give any. Question for you however - What have you done so far to transition into the space?
Thanks for making this video! Currently preparing for the interview and I found the whole process really beneficial and an awesome learning experience. :)
This is amazing i searched many channel for this but i couldn't find that.you are truly an amazing channel. But please sir increase the frequency of the video's Also make video on end to end projects. It would be great for ous.
I'd say quantitative analysis is vital. Plugging an algorithm on a dataset is the easy step. But, analyzing the result and explaining WHY it's relevant to the readers is another step.
Thank you for your video! I was wondering if there is no algo coding test for DS internship technical interview? (like the leetcode for algo which is usually for SWE role)
Hey Dan, nice to hear from great time and I like the way you explain interview process, i have few questions 1. can software developer (dot net developer) become data scientist? 2. Even if I m from not from top 50 Universities, how to get into top companies for data scientist position? 3. Which masters degree will be best for pursuing data science job 4. How fresher needs to approach data science job to get experience and land into great company (as a fresher and not from great school)?
Thank you for the post. Very helpful. Question about 30 day moving median of post count per user on each date. Is this calculated by getting post count per user on each date and then calculating a rolling 30 day median ? OR is this calculated by just getting median post count over the last 30 days for each Date? thanks once again!
Hi Dan, I have just started to explore the field of data science and my dream company is FB. Loved your video and would like to talk to you more about this. Would you be open to meeting with me on a zoom call if you have time? Would really appreciate it . Thanks a lot for putting up the video
Hey Dan, Just a question. As a data scientist, you've worked with open source tools like scikit learn and tensorflow or you just write everything from scratch?
at 4:00 you show the TC for DS only? What if i have worked as Software Developer for 15 years and as DS last 3 years, - which Level is applicable to me? thanks!
Thanks Alexei, first and foremost, it depends on what aspect of the DS you are pursuing. Given that you have 10+ YoE in SWE and 3 years of DS, if you were to apply for DS -MLE role, then you could expect a higher level than if you were to pursue a DS - Product role when you do not have AB testing experience. So, first of all, the level largely depends on what you are pursuing. But, we can reasonable assume that you won't be placed IC3 given your 10+ YoE in career. IC4 and/or IC5 could be reasonable, but you need to factor in (1) your current leadership experience (2) interview performance and (3) how well your background fits with the role.
Is this the correct SQL for "What % of users post within a month of their birthdays?" SELECT A.NUM/B.DEN*100 FROM ( SELECT COUNT( DISTINCT U.USER_ID) AS NUM FROM USER U LEFT JOIN POST P ON U.ID = P.ID WHERE MONTH(P.POST_DATE) = MONTH(U.BIRTH_DAY) ) A INNER JOIN ( SELECT COUNT( DISTINCT U.USER_ID) AS DEN FROM USER )B ON 1=1
hey Dan, i am not a data scientist but I found your videos on mock interviews really relevant for my preparation for facebook's data engineering role. I just wanted to give you a shoutout and hoping that you continue making these videos.
(and yes, I actually did land the job as E5 at FB)
Hey G Tang, thank you. Will continue to publish content that can help out candidates in the data community! - Dan
Wooooooooow, congratulations.
I'm looking to join junior data science at Facebook any tips??
Thank you Dan for taking the time clarify the process. I have a the technical phone screen in a few weeks
How did it go ?
Just started my data science transition. I’ll definitely be hitting you up when I’m ready to start interviewing. Thanks, this is a great resource!
Sounds good :)
Hows that journey going so far man?
@@donndonnn Funny. Just completed. Now working on resume and planning to start applying. Any advice?
@@joshisaiah2054 oh man, thats solid. Im thinking of breaking into the space as well so unfortunately I cant give any. Question for you however - What have you done so far to transition into the space?
@@donndonnn capstone projects and self studying
Thanks for making this video! Currently preparing for the interview and I found the whole process really beneficial and an awesome learning experience. :)
This is amazing i searched many channel for this but i couldn't find that.you are truly an amazing channel.
But please sir increase the frequency of the video's
Also make video on end to end projects. It would be great for ous.
Awesome video Dan! I wanted to ask what you think are important qualities or aspects in a personal project that displays skill and knowledge.
I'd say quantitative analysis is vital. Plugging an algorithm on a dataset is the easy step. But, analyzing the result and explaining WHY it's relevant to the readers is another step.
Thank you for your video! I was wondering if there is no algo coding test for DS internship technical interview? (like the leetcode for algo which is usually for SWE role)
Hey Dan, nice to hear from great time and I like the way you explain interview process, i have few questions
1. can software developer (dot net developer) become data scientist?
2. Even if I m from not from top 50 Universities, how to get into top companies for data scientist position?
3. Which masters degree will be best for pursuing data science job
4. How fresher needs to approach data science job to get experience and land into great company (as a fresher and not from great school)?
1. Totally 2. I went to VT (not a top school) 3. Any technical M.S. such as CS, STATS, Math 4. Internships, blogs, network
@@DataInterview Is a Master's degree mandatory? For a Data Sciencce/Machine Learning role if you have relevant experience in the industry?
@@ds_test9687 Nope, look at my background: www.linkedin.com/in/danleedata/
Thank you for the post. Very helpful. Question about 30 day moving median of post count per user on each date.
Is this calculated by getting post count per user on each date and then calculating a rolling 30 day median ?
OR
is this calculated by just getting median post count over the last 30 days for each Date?
thanks once again!
This is so informative and helpful! Thank you! :)
Hi Dan, I have just started to explore the field of data science and my dream company is FB. Loved your video and would like to talk to you more about this. Would you be open to meeting with me on a zoom call if you have time? Would really appreciate it . Thanks a lot for putting up the video
Thank you for this! Can you do a similar one for LinkedIn 🙂
Yes! Coming soon!
Is there an open source library on ATS system?
Not that I know of.
Hey Dan,
Just a question.
As a data scientist, you've worked with open source tools like scikit learn and tensorflow or you just write everything from scratch?
I use scikit, tensorflow, Pandas, and other open source packages. 90% are open source; 10% are my own internal library.
at 4:00 you show the TC for DS only? What if i have worked as Software Developer for 15 years and as DS last 3 years, - which Level is applicable to me? thanks!
Thanks Alexei, first and foremost, it depends on what aspect of the DS you are pursuing. Given that you have 10+ YoE in SWE and 3 years of DS, if you were to apply for DS -MLE role, then you could expect a higher level than if you were to pursue a DS - Product role when you do not have AB testing experience. So, first of all, the level largely depends on what you are pursuing. But, we can reasonable assume that you won't be placed IC3 given your 10+ YoE in career. IC4 and/or IC5 could be reasonable, but you need to factor in (1) your current leadership experience (2) interview performance and (3) how well your background fits with the role.
now I know what I'm gonna practice for the next months...😁 Thank you Dan. very informative.
Thank you! Really enjoyed creating and presenting this content!
Is this the correct SQL for "What % of users post within a month of their birthdays?"
SELECT A.NUM/B.DEN*100 FROM
(
SELECT
COUNT( DISTINCT U.USER_ID) AS NUM
FROM
USER U
LEFT JOIN
POST P
ON U.ID = P.ID
WHERE MONTH(P.POST_DATE) = MONTH(U.BIRTH_DAY)
) A
INNER JOIN
(
SELECT
COUNT( DISTINCT U.USER_ID) AS DEN
FROM
USER
)B
ON 1=1