❓⚡ Shashank, could you please share the source of a complete & perfect course/tutorial of Python and SQL required for Business Analyst, Data Engineer & Data Scientist ⚡❓
Since most of you do not know,The actual CTC is the 2nd year CTC and this is important because if you make a switch / look for a new job, then this actual CTC is used to consider for new offer. The high CTC is not taken into consideration… Let’s say at Microsoft your quoted CTC is Rs 39,40,000 (~39.4 lakhs). Base Salary: Rs 12,00,000 which is further divided into two components: Basic salary and flexible Base Plan (FBP) Basic: Rs 4,72,000 and FBP: Rs 5,28,000 Joining bonus of Rs 3,00,000 (Rs 1,50,000 in the first month and Rs 1,50,000 after 1st year) Stock Award: $30,000 (given over 4 years) ~ Rs 22,00,000-23,00,000 Relocation bonus: Rs 1,00,000 (given if you are coming from another city) Note: This is not included in CTC so this is extra as you will get this only if you claim it. Performance bonus: Rs 2,40,000 (20% of Base salary) Note: 20% is the maximum if your company (Microsoft in this case) hits its overall goal. It can be less than 20% and even 0%. So, it varies. There are other components where you can get extra money provided you claim those. These are not included in CTC. These include: Medical expenses (Within a given limit) Travel expenses and others. Therefore, the following components are added to arrive at the final CTC Base Salary: Rs 12,00,000 Joining bonus: Rs 3,00,000 Stock Award: Rs 22,00,000 Performance bonus: Rs 2,40,000 This gives the CTC as Rs 39,40,000. The following components are one-time that is these components are not considered in the CTC of your 2nd year at Microsoft. So, the 2nd year CTC is always less than the 1st year CTC: Joining bonus: Rs 3,00,000 Stock Award: Rs 22,00,000 Therefore, your 2nd year CTC will be Rs 14,40,000.. In New tax regime, you cannot do tax saving. In Old tax regime, you can do tax saving like in Fixed deposit, Interest in loans and much more. This is useful only if you have to pay a large amount of interest for loans like education loan, house loan and others. Let us calculate the minimum salary: You are doing no tax saving and are in New tax regime. You did not receive any bonus (0%). Then, you get the base salary of Rs 12,00,000 only. On this, you pay tax of 20%. Tax = 2.5 * 0.05 + 2.5 * 0.1 + 2.5 * 0.15 + 2 * 0.2 = 1.15 So, you pay Rs 1.15 lakhs in salary. Your in-hand salary is Rs 10.85 lakhs. So, your monthly in-hand salary is Rs 90,417. Let us calculate maximum salary: Let us assume you do tax saving investments and are in Old tax regime. If you have loan and give interests, you can save tax on the interest up to FBP. So, you have to pay tax on Basic salary of Rs 4,72,000. Tax = 2.22 * 0.05 = Rs 11,100 You get the performance bonus of Rs 2,40,000 and tax is deducted on it. So, in-hand bonus is Rs 2,28,000. So, in-hand salary is Rs 11,88,900 per year and it is Rs 99,000. Therefore, your in-hand monthly salary range from Rs 90,417 to Rs 99,000. Your 2nd year CTC / actual CTC will be Rs 14,40,000 per year and not Rs 33,40,000 per year. Note -You’ll be getting stocks worth 22 lakhs but you’ll have to pay 30% tax +10 % long term capital gains tax on them and if you leave the company in between the unvested stocks will be forfeited It’s great to get into these product based companies ( better than service based ones ) but you should be knowing all these things credits: am
Dude she is already having her engineering degree...... And these skills helped her alot to make her career in data science.. nothingness found in this video but ofc she shared her experience that was helpful, undoubtedly.
Many many congratulations to you Shailja di🎉 The amount of hard work you did to be where you're now, you sure deserve all of it ! Just wishing you more and more success ❤️
Nice interview, motivating for whoever studying python data analytics without bachelor degree. Good thing in this interview mostly on English so that all laugange people can understand.
She didn't talked about Statistics, Visualisation tools like PowerBI. How to do pipelining (can had talked on overview only). Statistics plays an important role in data science field. Should talked about usage of Statistics and their resources. But yeah it was nice interview. Very helpful. Thanx a lot and Many Many Congratulations to you Shailja Mishra.
This is SUCH a knowledgeable podcast... So happy for you Shailja di, you really are my guide in so many ways ❤️ Wish you only the best for your life ahead coz you deserve it!! 💕
Both of them don't look like from great English speaking background. But still they are using it quite effectively for the understanding purpose of the audience based on high level of confidence in their professional field. Simply amazing.
Yeha just like the way you wrote the statements makes me feel that you are not from a great English speaking background. Aaajkal log na kuch bhi analysis karte hain.
Congratulations salja di after listening your interview experience i thik its not very hard to get job ..like you ..but ya like you said skill matters ...rather than experience..tq for sharing your experience di
I'm a data Scientist, recently completed my course and hold a good grip on software like python ML MySQL Tableau Powerbi Azure But in LinkedIn every company is asking for experience upto 2-3 years There's no job for freshers in data analyst
Yeah so top 5 skills are 1 python or R(Both are prefdered) 2 SQL and Mongo(for structureed and non structured both) 3 Medium ML knowledge like basic models 4 powerbi Or tablue 5 DSA( basic as mam told) And most important experience and skills if you want to enter FAANG
DSA basics if u are going for entry level... she must also be lucky enough to get interviewed basic questions but usually it will be intermediate to advance.
I have been in the industry for 10 years. The term Data scientists is just a hype. 98% of the time the data scientist is cleaning the data rather than building algorithms or solving problems.
Actually you are right the kind of work that most expect is the ones in CV and NLP but most of the jobs are Big data and analytics which is kind of bitch work cleaning as you said .
I am completely from mathematics background have a master's degree in maths and currently pursuing diploma in ds from IIT Madras would love to see someone with non tech background in this role.
Sir pls reply 🙏🙏🙏 Make a podcast of a FINANCIAL ANALYST who is using (all skills of data analyst like SQL,BI, EXCEL) and working in good in company???? Pls sir
I don’t have even bachelor degree , I have worked various MNC. Currently working for one of the big bank in brazil 🇧🇷, currently I’m living in Brazil, so I guess degree only helps you to get first job once you have some experience only matter is your portfolio and previous experience etc
Key takeaways: **00:00: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🤖 Salary of data scientists in top tech companies: 30 to 40 LPA in India. **00:56: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 📊 Interview process for data scientist role at Microsoft: Resume screening 2 coding rounds 1 system design round 1 behavioral round **01:11: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Preparation for data scientist interview: Practice coding problems on LeetCode Learn about system design principles Be prepared to discuss your data science projects and experience **02:22: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 📚 Resources for learning data science: Online courses from Coursera, Udacity, and Udemy Books like "An Introduction to Statistical Learning" and "Hands-On Machine Learning" **03:18: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🛠 Tech stack for data science: Python SQL Statistics Power BI **03:32: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🎉 Guest introduction: Shelja is a data and applied scientist at Microsoft. She has a computer science degree from Banasthali Vidyapith Jaipur. She worked as a big data engineer at Fractal Analytics before joining Microsoft. **04:53: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 📈 Transition from data engineering to data science: Shelja decided to pursue a career in data science after working on a natural language processing project in her college. She learned the necessary skills and experience by working as a data engineer at Fractal Analytics. Please note that I have not included all of the key takeaways from the video, as there are more than 5. I have focused on the most important and relevant information for aspiring data scientists. Key takeaways: 06:58: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💼 Applying for data science jobs: It is possible to get an interview call for a data science job by applying through the company's career portal. 07:27: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Microsoft data science interview rounds: The Microsoft data science interview process typically consists of four rounds: Round 1: Domain knowledge test (e.g., Spark, big data concepts, SQL) Round 2: Problem-solving skills test (e.g., Python coding) Round 3: System design/case study Round 4: Hiring manager round 09:31: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🎓 Data science interview coding questions: The coding questions asked in data science interviews are typically easy to medium level, covering topics such as arrays, strings, and linked lists. 10:29: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🤖 Hiring manager round: The hiring manager round is a fitment round where the interviewer will assess your skills and experience to determine if you are a good fit for the role and the company. 12:06: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 🗺 Data science roadmap: A good data science roadmap should start with the basics of Python and SQL, followed by machine learning and big data tools. It is important to have an overall understanding of the data science pipeline, from data cleaning to data analysis. Please note that I have only included the most important and relevant key takeaways for aspiring data scientists. Here are the key takeaways in English: 14:11: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Master's degree not required for data science: A master's degree is not required for data science jobs. Skills are more important than experience. 15:06: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Focus on skills rather than experience: Companies are more aligned towards getting skills rather than exactly matching the year of experience. 16:56: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 How to switch to data science from a different job profile: Upskill yourself with the required skill set. Make sure your resume highlights your skills in a relevant manner. Apply for jobs and be prepared to interview. 17:52: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Resources for learning data science: Leetcode for SQL practice Learnpython.org and GeeksforGeeks for Python Spark website and sparkexamples.com for Spark Coursera courses for AI and Python 20:52: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💰 Salary for data scientists with 1.5 years of experience: The salary for data scientists with 1.5 years of experience is typically 35+ LPA in India. I hope this is helpful! Here are the key takeaways in English: 21:07: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💰 Salary for data scientists with 2-3 years of experience: The salary for data scientists with 2-3 years of experience is typically between 30 and 40 LPA in India, including base salary, stocks, and other components. 22:44: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Myths about data science roles: Myth: Data science is the most hyped and demanded job profile, so everyone should run for it. Reality: Data science is a great job profile, but it's not the right fit for everyone. Make sure you have the interest and skills required before applying for data science jobs. Myth: Data scientists are paid much higher than any other role. Reality: Data scientists are paid well, but their compensation is not much different from other roles, such as software development. Myth: Data scientists only implement machine learning algorithms. Reality: Data scientists spend 80% of their time cleaning and transforming data, and only 20% of their time implementing machine learning algorithms. 24:22: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-USxab2QN3hA.html 💡 Key takeaways from this podcast: Data science is a great job profile, but it's not the right fit for everyone. Make sure you have the interest and skills required before applying for data science jobs. Data scientists are paid well, but their compensation is not much different from other roles, such as software development. Data scientists spend 80% of their time cleaning and transforming data, and only 20% of their time implementing machine learning algorithms.
Hi Shashank, We are getting good guidance. Thank you very much. Kindly make more videos on how to get data science related jobs aboard like in Singapore, Korea, Japan etc. Thank you in advance
There is special female quote in MNC. So for girls getting into MNC is bit easy. P.S. plz concentrate on the adjective "bit", I'm not saying it is super easy for female. There is huge difference and if you see there many women centric programs and scholarships in Academia.
@@shashank_mishra I work in mnc and they specifically hire females or to say they have female drive. In some companies they have female leadership programs. It is not new I guess you took it other way around.
IT is total business dude they hire people who can sustain their business, that is where talent is required. You might be right for some exceptional cases but in majority they bend down to talent
How are IIM pgdm BA courses from jigsaw or nulearn ? How are these courses compared to Coursera, coding invaders, or coding ninjas? Which one would you recommend? It would be great if you would make a comparison video on this! Tia!
She is amazing and to the point to every question the anchor puts in. Super video and good channel. My son is in deloitte and he shapes his carreer here. He has done masters in data science with 6 yrs exp. Deloitte is very good with compensation but not like Microsoft. This podcast is an eye opener how Microsoft pays.
Hii Shashank bhaiya.. I have got an intenship at ellicium solutions private limited which is a company based on AI/ML and big data analytics. It is offering me a stipend of around 10k and expecting a long term cooperation and has offered a package 4.5LPA which I think is really less. Do you think I should join the company for internship or I should try off-campus to get internship in companies that operate on other technologies like java, cpp which are more known to people. Please share your views.
Hello sir.thank you for making such amazing potcast it is really helpful.I have done my mechanical engineering this year.and i want to get into the data scientist field so Is it possible for mech engg to get into DS and will you please guide me for it. Thank you
Matt Karo bhai data analyst ka kuch bhi...ab bohot log karr lie h..no jobs in this field. Rather try coding because ye log darte h karne s, you will get job quickly..but don't get into data analyst field Please sir dont delete this comment let everyone knows what is the current market.
Sahi kaha bhai I'm a data Scientist, recently completed my course and hold a good grip on software like python ML MySQL Tableau Powerbi Azure But in linked every company is asking for experience upto 2-3 years There's no job for freshers in data analyst
Hello you are doing wonderful job.. I only have one request can you do a podcast of a business analyst and how to get into consulting companies and top tier companies
Hi Shashank, One request - Can you please make a podcast with Data Analyst working in top notch companies? I am sure this one would be highly admired and everyone would be waiting for it. Thanks in advance!
Hi Shashank Sir, Iam in java domain from past 2.7 years and 2019 passout, I want to switch to data science domain and Iam unable to find any video content that how to switch domain while being in a job,what all resources to follow and all. It would be really helpful to me and for many people like me who are neither fresher nor too much experienced and now wanted to switch domain. Hoping for a reply on this and a video too. THANKS in advance.
Hi there! Well i am a physics student. During my semester break i just complete data science track by datacamp.... Now i am confused what to do.... Need help and suggestion!
Sir, please make a video with someone who has come from other background (commerce/life science) into data analytics field. It would of great help. Please.
Hi, I wanted to switch my career from web development to data science with my current job so how can I do that simultaneously? Can you please help me out regarding the same. Thanks You
This job is just in trend. That's why you are getting this 35+lpa package as freshers. Python,SQL,Spark,Hive,Big Data has been there for decades. A data scientist is made after >20 years. You guys are just associates.
Hello Bro, I have confusion between Blockchain, Data science and AI & Ml. Can you please guide and advise on it which course to choose. As you are working on IT company so might be have more details about each technology. I'm more interested on Blockchain can you please give more details where choosing this course will be good for future or not.
Hard work is paramount in this sector. You have to learn every day. There is no stopping which is wonderful. Be humble enough and keep learning. There is no ceiling in this field.
What has "Master's degree" got to do with getting a Data Scientist's job anyway? I know people who're from a totally Non tech background and got an opportunity as a Data Scientist after just successfully completing a bootcamp.
hi sashank!! First of all a big thanks for such amazing and motivational contents. i am the student of final year pursuing computer science engineering. i have a keen interest in the field of data science. As i am applying off campuses i am finding it a little hard to get selected for interviews. could you please help me out what else i can add in my resume or where i can apply for this role. could you please give a brief about fractal analytics as it is hiring for data engineeers only not data analyst or data scientist. i have required skills as well since i am preparing for it from my 2nd year. i hope you will definitely reply to it. it will be very helpful foe me.
@6:44 you said to the audience what will you choose data engineer or data scientists. Isn't data scientist a level up from data engineer and how can one choose when we are just beginners
Hi, thanks for such wonderful interview Shashank, can you please review her Resume in a video or share it on ur community tab, it will be really helpful.
Iam aspiring data scientist,i passed out in 2019,now I working as a process consultant 1.5+ experience,and i learnt data science.how much package I can get as a data scientist.
Hii Shashank in web 3.0 data will be protected then how will data professionals like data engineer data scientist data analyst business analyst will work Will they loose jobs in near future I know it's silly question but I wanted to know from you
I beg to differ here. Being a Masters graduate from IISc, what I have experienced so far is that, with a bachelors degree you can reach this far only. It should not be a matter of pride. Those who don’t have Research skills tend to not have a prosperous career in ML.
@@Luffytaro27 Let me clarify this for you, if merely a bachelor’s degree and experience can make someone competent enough to conduct research, then probably all of the institutes in the world should shut down all PG programs. PG programs are not just mere degrees, they are much more than that.
@@Luffytaro27 Speaking on facts, I would like to disagree on you call this as bias. What eventually this candidate and alike will face is a skill ceiling due to lack of the exposure needed. In industry, every thing is fast paced and leaving certain leading labs every other ML/AI group are just revenue driven and often do not invest much into research. Which I feel in this ever changing field of ML, innovation is key. Hence, in the long run, the research skills gained in such PG programs come into the picture. FYI, I am an experienced individual and not a recent grad🤭
@@Luffytaro27 It is sad to see you making assumptions about me without even knowing a bit. Keep guessing, I hope you will be able to predict better about me someday. As far as jealousy is concerned, Im pretty sure you would want to reconsider your statement once you know what I do. Anyways, cheers 🥂!
Which platform is best to learn all these tech points coz there are lots of adds of several learning firms likewise scaler,e-learning,etc are there on internet? Which source should we refer?Please guide for transition career from mechanical background to tech..
Hi sir could you please let me know how much of python knowledge is required for data scientist? Means do we need to be strong in OOPS concepts or else we have to be strong in data cleaning part which is numpy and pandas libraries?
Sir r program is better for big data engineer please Sir i know java python for big data engineer is better but i have one question r program is good for big data engineer
Sir I've joined Jain college They are offering business analytics specialisation as an mba Is both data analytics and business analytics both the same or different..??
Hey Sir At this moment i'm in class 10 after passing when i will go in 11 i will choose commerce because i can't understand physics that's why i will choose commerce over Science So After taking commerce How Can I Become A Data Engineer ?