Deloitte interview question and answer | Data Engineer Role | Interview Process| Package Offered

In this video, I have talked about questions asked during interview of mine in deloitte.
Directly connect with me on:- topmate.io/manish_kumar25
My Gear:-
Rode Mic:-- amzn.to/3RekC7a
Boya M1 Mic-- amzn.to/3uW0nnn
Wireless Mic:-- amzn.to/3TqLRhE
Tripod1 -- amzn.to/4avjyF4
Tripod2:-- amzn.to/46Y3QPu
camera1:-- amzn.to/3GIQlsE
camera2:-- amzn.to/46X190P
Pentab (Medium size):-- amzn.to/3RgMszQ (Recommended)
Pentab (Small size):-- amzn.to/3RpmIS0
Mobile:-- amzn.to/47Y8oa4 ( Aapko ye bilkul nahi lena hai)
Laptop -- amzn.to/3Ns5Okj
Mouse+keyboard combo -- amzn.to/3Ro6GYl
21 inch Monitor-- amzn.to/3TvCE7E
27 inch Monitor-- amzn.to/47QzXlA
iPad Pencil:-- amzn.to/4aiJxiG
iPad 9th Generation:-- amzn.to/470I11X
Boom Arm/Swing Arm:-- amzn.to/48eH2we
My PC Components:-
intel i7 Processor:-- amzn.to/47Svdfe
G.Skill RAM:-- amzn.to/47VFffI
Samsung SSD:-- amzn.to/3uVSE8W
WD blue HDD:-- amzn.to/47Y91QY
RTX 3060Ti Graphic card:- amzn.to/3tdLDjn
Gigabyte Motherboard:-- amzn.to/3RFUTGl
O11 Dynamic Cabinet:-- amzn.to/4avkgSK
Liquid cooler:-- amzn.to/472S8mS
Antec Prizm FAN:-- amzn.to/48ey4Pj

Пікірлер: 68

  • @maheshbhatm9998
    @maheshbhatm9998 Жыл бұрын

    Thank you so much bro this presentation is very much helpful. Keep doing these.

  • @satyamkumarjha4185
    @satyamkumarjha4185 Жыл бұрын

    Your videos are more relatable somehow than flashy channel offerings. accept the gratritude and oken of appreciation from a fellow Bihari. 🤝

  • @ranjithrampally7982
    @ranjithrampally79827 ай бұрын

    bhai, you are the CHAMP, i respect your efforts.

  • @rekhasingh4945
    @rekhasingh4945 Жыл бұрын

    Hello manish , your videos is very helpful for me thank you 😊

  • @divakarchavan2255
    @divakarchavan2255 Жыл бұрын

    please post a video on your way of introducing and directing an interview into your project base questions

  • @krishnasahoo6172
    @krishnasahoo61725 ай бұрын

    Hi Manish, Big Thank you for the videos u post. Its really helpful. Just wondering if you have the PPT which u are showing in this video?

  • @SurajitMetya
    @SurajitMetya Жыл бұрын

    at 6:11 I tried the same code but I am getting this error: '>' not supported between instances of 'str' and 'int'

  • @sytejaswini6905
    @sytejaswini69052 ай бұрын

    Thank you bro 🎉

  • @avinash7003
    @avinash70035 ай бұрын

    check pointed RDD stored in Disk?

  • @Sharath_NK98
    @Sharath_NK986 ай бұрын

    12:46 even lineage graph too doing a same. wts the difference ??

  • @The_Amy_Show
    @The_Amy_Show4 ай бұрын

    @manish_kumar_1, i have one question setting the configuration for spark based on my data, suppose i am processing the 100 GB data weekly, How much configuration my cluster should be and with that cluster size how much time it will take to completed the task? i have been asked multiple times this question but interviewer is not impressed with the answer i am giving.? please help on this questions?

  • @apurvakhomane4992
    @apurvakhomane4992 Жыл бұрын

    Please post HR interview questions

  • @krishnaveninair6293
    @krishnaveninair629311 ай бұрын

    please provide the answers of SQL questions

  • @manish_kumar_1
    @manish_kumar_1 Жыл бұрын

    Directly connect with me on:- topmate.io/manish_kumar25

  • @pankajsolunke3714
    @pankajsolunke3714 Жыл бұрын

    Hi Manish sir can you please make video on how to handle schema evalution

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    What do you mean by schema evaluation?

  • @Akshay-if5im
    @Akshay-if5im Жыл бұрын

    Sir , was there any aptitude and reasoning round for Deloite , I mean for data engineering role is there any aptitude round or they direct start from the technical interview

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    If you are experienced then most of the company direct go for interviews. But there are some companies where you will get aptitude test in 1st round

  • @tusharjain2607
    @tusharjain2607 Жыл бұрын

    when we switch from analyst to data engineer role then does personal projects sufficient to crack the role?

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    If you don't have any DE related project then make one personal project to showcase your skill in DE.

  • @krushnadeshmukh3967
    @krushnadeshmukh3967 Жыл бұрын

    bhai Azure data engineer banane ke liye kya rodmap hona chahiyae for Non IT person zero knowledge of coding?

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    Minimum requirements:- Sql Python/Java coding (any one of these two) Spark Azure services like ADF, synapse, Blob storage etc

  • @rh334
    @rh33427 күн бұрын

    How to prepare SQL

  • @__oo__._._._._._._._.___00007
    @__oo__._._._._._._._.___000076 күн бұрын

    Today had gone through Interview Process for capgemini: 1. You have 3 tables Cutomer, material and Category(having three values c1, c2 and c3) , how would you ingest data at 10 AM on Cutomer, 11 AM Material and c1, c2 12 1PM and c3 at 2 PM 2. You have 10 GB of files 1 exeutor 16 cores how would you process it, you cannot increse the resources, how will you assign number of partitions dynamically based on number of cores? 3. How do you repartion your data based on low cardinal columns, based on memory size 4. What functions you used in Pandas, basedon answer asked difffrence between loc and iloc in pandas, how do you loop over pandas df. 5. You have 20 GB of file how would you put objcet in s3, will you face any issue? 6. Have you ever process data in ADLS and put data in s3?

  • @rekhasingh4945
    @rekhasingh4945 Жыл бұрын

    i want to switch my careers SEO to data engineer, Mai last 6 month se tyari kr rhi hu mujhe sql, basics python ,hive and spark aata hai but mujhe company hands on experience nhi hai or fresher k liye job nhi mil rhi please seggest me kya mai experience dikha skti hu 1 ya 2 years ka , please seggest me

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    Aapko Agar data analyst ka v job mil raha to le lijiye and in company you can move internally to DE related project.

  • @raviyadav-dt1tb
    @raviyadav-dt1tb7 ай бұрын

    Hello manish thank you 🙏 do you have concentrix interview questions and answers? Provide

  • @manish_kumar_1

    @manish_kumar_1

    7 ай бұрын

    No I don't have it

  • @raviyadav-dt1tb

    @raviyadav-dt1tb

    7 ай бұрын

    @@manish_kumar_1 how to crack interview I’m very scared now but thank you 🙏

  • @trustgainer
    @trustgainer10 ай бұрын

    Hi manish please reply deloitte Hr release the offer letter without dlany discussion.. they offerrd me 9 lakh i want to keep my expectation upyo 12lakh will hr revised my offerletter???

  • @manish_kumar_1

    @manish_kumar_1

    10 ай бұрын

    They may revise if you counter this with any other offer

  • @anushakulkarni8490
    @anushakulkarni84903 ай бұрын

    What about 1 year of experience in DE can we switch are there enough openings

  • @manish_kumar_1

    @manish_kumar_1

    3 ай бұрын

    For 1 yoe there is not much openings

  • @ArpitSharma-kk9tl
    @ArpitSharma-kk9tl Жыл бұрын

    Bhai ek spark ke playlist baata do yaa fir baana do

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    Will start soon. Aap Mera video dekhiye jiska title hai "how I bagged 12 offers". Usme ye sab bataya hai

  • @djsahu98
    @djsahu983 ай бұрын

    Hi @MANISH Kumar, what were the question on HR round

  • @manish_kumar_1

    @manish_kumar_1

    3 ай бұрын

    Simple discussion. Just learn about the company what they do, when it was established and general info available on their website

  • @rh334
    @rh33427 күн бұрын

    How to prepare DSA round? Important questions - Leetcode there are 1000s of questions which one should we do

  • @saisri6404
    @saisri64049 ай бұрын

    Is playlist m JIO interview question and answer missing h

  • @manish_kumar_1

    @manish_kumar_1

    9 ай бұрын

    Let me check

  • @raghavendrakm9083
    @raghavendrakm90836 ай бұрын

    Q14: I believe answer is wrong With out doing list_agg /pivot How the result will be displayed I believe the query we are executing in Oracle SQL window or different one

  • @user-sd4df3db3c
    @user-sd4df3db3c11 ай бұрын

    How to get data engineer job? I have 1 year of experience in Mu Sigma. Kindly guide me

  • @manish_kumar_1

    @manish_kumar_1

    11 ай бұрын

    Av Thora early hai aapka. 2+ ke liye openings jada aata hai. Wherever you see less than 3yoe. Apply kar dijiye

  • @prajju8114

    @prajju8114

    6 ай бұрын

    @@manish_kumar_1 konsa job portal best hai? mujhe abhi kuch dikh nhi rha hai data engineer roles ke liye

  • @aishmash5325
    @aishmash5325 Жыл бұрын

    Ye live interview tha Kya?

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    Yes

  • @pradnyakoli800
    @pradnyakoli80010 ай бұрын

    hi manish I am having 2 years of experience in GCP Data Engineer I just interview in deloitte. How much should I put my expectation my current ctc is 6.5lakh

  • @manish_kumar_1

    @manish_kumar_1

    10 ай бұрын

    If you don't have any offer to counter then you can easily ask for 100% hike.

  • @pradnyakoli800

    @pradnyakoli800

    10 ай бұрын

    @@manish_kumar_1 please reply I got selected in deloitte. They asked me my expectation for fixed pay so I asked for 15lpa fixed pay.. please tell me if 15lpa is fixed pay how much will be my inhand salary

  • @VijethMoudgalya

    @VijethMoudgalya

    10 ай бұрын

    ​@@pradnyakoli800any update on this? Did they agree for this offer? I'm also in the same state as you are

  • @pradnyakoli800

    @pradnyakoli800

    10 ай бұрын

    @@VijethMoudgalya deloitte will ask the increment letter or counter offer letter then only they will increase

  • @parasupadhyay2568

    @parasupadhyay2568

    9 ай бұрын

    ​​​@@pradnyakoli800How much are they giving without counter offer? And what was your notice period?

  • @kaviyaa5671
    @kaviyaa56717 ай бұрын

    Pls do in English

  • @beingrishi6450
    @beingrishi6450 Жыл бұрын

    Please do give solution to the questions

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    Which question?

  • @beingrishi6450

    @beingrishi6450

    Жыл бұрын

    @@manish_kumar_1 regarding what type of questions being asked in Deloitte for data analyst BI analyst designation? So that i can b able to get an idea

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    @@beingrishi6450 I don't have any idea. I was interviewed for Data engineering role

  • @itsprosenjitsardar

    @itsprosenjitsardar

    Жыл бұрын

    @@manish_kumar_1 Kitna package offer kiya tha deloitte ne ?

  • @itsprosenjitsardar
    @itsprosenjitsardar Жыл бұрын

    Kitna package offer kiya tha deloitte ne ?

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    20

  • @unknown_fact1586

    @unknown_fact1586

    Жыл бұрын

    ​@@manish_kumar_1 what was your CTC at the time of the interview.

  • @manish_kumar_1

    @manish_kumar_1

    Жыл бұрын

    @@unknown_fact1586 11

Келесі