McKinsey & Company - Data Engineer Interview Experience | Experienced | Must Watch 🔥Important Topics

Поділитися
Вставка
  • Опубліковано 18 лис 2024

КОМЕНТАРІ • 60

  • @MrMusic55123
    @MrMusic55123 2 роки тому +2

    I'm a data engineer but have never worked with Pyspark, I have only worked with SQL server, SSIS, SSRS. Where should I start to learn Pyspark and Python?

  • @krishnenduchakraborty2839
    @krishnenduchakraborty2839 4 роки тому +7

    Thanks for making this video. Could you please make a video how to get Data Engineering job in consulting firms like Mckinsey, BCG, Bain, Deloitte etc.

  • @ameygoes
    @ameygoes 2 роки тому +1

    Nice video, one suggestion, your information is getting distracted by the music

  • @Brijeshkumar-lk5mt
    @Brijeshkumar-lk5mt 4 роки тому +4

    Advance Congrats for 5K 🙌

  • @ankitsahvlogs4067
    @ankitsahvlogs4067 4 роки тому +2

    Sir ,, Kindly look at the lens of camera then you will be like looking at us 👍

    • @shashank_mishra
      @shashank_mishra  4 роки тому +2

      Sure Ankit, Thanks for letting me know this😊

  • @taniyasaini6830
    @taniyasaini6830 3 роки тому +6

    Hi Sir, Thanks for the amazing content, i have one query. I recently moved to DE role from web development role. I still do coding questions practice in c++. Should i move to Python or can i continue to code for the interview coding rounds in c++?

  • @saideepesh6036
    @saideepesh6036 4 роки тому +2

    Bayya, Congo for 5k

  • @zentamil
    @zentamil 3 роки тому +2

    Super....

  • @davidyolchuyev2905
    @davidyolchuyev2905 3 роки тому +2

    i have been invitied to data science interview questions on quanthub. do you have any tip on what i should study? i will give my test on SQL, Statistics, and Python

  • @aditi_tiny_reviews
    @aditi_tiny_reviews 3 роки тому +2

    Sir, could you please help me with the case study, how to practice and where to get the sample datasets.

  • @ballambikashbikash
    @ballambikashbikash 3 роки тому +1

    I wanted to know about the DE case study which i will get in the 2nd round...how to prepare for it?

  • @babuua
    @babuua 3 роки тому +1

    did you apply for mckinsey operations or quantum black?

  • @shalurajpoot7316
    @shalurajpoot7316 3 роки тому +1

    Please tell the resources from where we can prepare for interview

  • @rakeshdash5417
    @rakeshdash5417 3 роки тому +1

    Hi what are the sql question if you remember can you post here

  • @abhishekmote7250
    @abhishekmote7250 2 роки тому

    Ram functions ?? Rang functions? in sql? not clear

  • @anirudhnegi6087
    @anirudhnegi6087 3 роки тому +2

    Thanks for the video. What was the required year of experience in this role?

  • @ronit043
    @ronit043 4 роки тому +2

    The coding questions which you've solved in python, can be solved with Java as well?

  • @khanaffan4833
    @khanaffan4833 2 роки тому

    Sir plzz share ur resume through which u were selected in mckincy n company

  • @rajatraj1032
    @rajatraj1032 4 роки тому +1

    Bro maine apni b.tech life gf k chakker me barbaad krdi kya kru ab plz koi btao n😭😭

    • @babuua
      @babuua 3 роки тому +3

      UPSC ka tayari karo

    • @IamDanish99
      @IamDanish99 2 роки тому

      @@babuua 🤣🤣

    • @jayack1927
      @jayack1927 2 роки тому +1

      Girl friend is moved with other Boy i guess 😂

  • @mehroosali
    @mehroosali 4 роки тому +1

    Sir can you suggest some resources to practice medium to complex problems using window funtions.

    • @shashank_mishra
      @shashank_mishra  4 роки тому +3

      To be very honest, there is no dedicated resource for that even i struggled a lot for the same. I learned these things in bits and pieces, the important thing helped me was my basics & fundamentals about important SQL topics.

    • @ayushvishwakarma4488
      @ayushvishwakarma4488 2 роки тому

      Practice from Strata scratch

    • @shivarajhalageri2513
      @shivarajhalageri2513 2 роки тому

      @@ayushvishwakarma4488 bro do you have premium membership of strata scratch

  • @shalurajpoot7316
    @shalurajpoot7316 3 роки тому

    How you prepared for this interview please guide us

  • @chphanindrachintapalli5375
    @chphanindrachintapalli5375 3 роки тому +3

    I know python, pandas and sql. I'm new to pyspark. I understand the architecture of spark. Given this state, can I answer the case study round using python and pandas? And also did they ask you anything on unit testing? Or rewriting a piece of code In an efficient manner? In python.
    Thank you.. your content is awesome have watched other videos too ! All the best !

    • @jananisri6214
      @jananisri6214 2 роки тому

      Hi. I am having case study interview with mckinsey for data engineer intern role. Could you please tell me what questions you got for the case study and how to prepare for it.

    • @aydeeudeh3043
      @aydeeudeh3043 Рік тому

      @@jananisri6214 hi, I’m the the same shoes as you…can you help me with what you you asked about?

    • @jananisri6214
      @jananisri6214 Рік тому

      @@aydeeudeh3043 give me your email. I will help you what I have.

  • @pankajmahra3819
    @pankajmahra3819 3 роки тому

    Thanks for the video.
    For what year of experience you were asked these questions.

  • @vishalchauhan9832
    @vishalchauhan9832 3 роки тому +1

    Hi sir Informatica domain refers to data engineer?

  • @sachinlidhu7639
    @sachinlidhu7639 2 роки тому +2

    It's easy for him😂...

  • @nxtlvl4187
    @nxtlvl4187 4 роки тому +3

    Sir what was your ctc at mc kinsey

    • @shashank_mishra
      @shashank_mishra  4 роки тому +3

      I wish i could reveal it🙂 But we shouldn't break the IT ethics, companies always expect people to keep this things confidential🙂 Overall CTC was good enough, according to market standards.

    • @nxtlvl4187
      @nxtlvl4187 4 роки тому

      @@shashank_mishra ok thanks

    • @vishalchauhan9832
      @vishalchauhan9832 3 роки тому

      @@shashank_mishra sir pls reply Informatica domain( working with pl sql ETL tools is subset of data engineering domain.?

  • @AllClassist
    @AllClassist 3 роки тому +1

    I am scared of coding and even in my btech i scored less marks in coding part.
    Can I do data engineering?

    • @sachinlidhu7639
      @sachinlidhu7639 2 роки тому

      Yes u can do.. But interview mushkil hota hai data engineer ka

  • @ravikatiyar6530
    @ravikatiyar6530 4 роки тому +1

    Was code in Scala also acceptable ?

  • @kherakshay7854
    @kherakshay7854 4 роки тому

    BCA + MCA interview i interested

  • @Adi300594
    @Adi300594 3 роки тому

    6 rounds??

  • @deadpool8335
    @deadpool8335 3 роки тому

    Bhai can u refer me in your company I'm data engineer

  • @avnish.dixit_
    @avnish.dixit_ 3 роки тому +2

    Hey bro can you please tell how much they were offering? And do they pay according to their standard packages or it will depend on current CTC....
    Please don't say all the best or good luck to me 😀I feel nervous

    • @shashank_mishra
      @shashank_mishra  3 роки тому +2

      They pay according to industry standard.

    • @avnish.dixit_
      @avnish.dixit_ 3 роки тому

      @@shashank_mishra okay but this industry standard word is used by even those companies who don't have money to give. ...I believe they give more than average Indian MNC.
      But interview looks quite difficult

    • @shashank_mishra
      @shashank_mishra  3 роки тому

      @@avnish.dixit_ yes more than expected even.

  • @TheMan.0010
    @TheMan.0010 3 роки тому

    brother Mercedes Benz research and development center india(product based (captive)) vs boston consulting group , which to choose for data engineer role

  • @nagasasank6658
    @nagasasank6658 4 місяці тому

    @E-Learning Bridge whats the expected ctc