Don't Fail the Management Round: Essential Tips and Tricks

00:27:13
https://www.youtube.com/watch?v=8poQD9GvUig

Ringkasan

TLDRIn this video, Santosh, a manager at Microsoft, shares valuable insights for candidates preparing for the second round of interviews in data-related roles. He emphasizes the importance of management questions, which often combine technical and general inquiries. Santosh discusses his extensive experience in data technologies and offers practical advice on how to answer common interview questions effectively. He highlights the significance of being confident, honest, and precise in responses, as well as the need to handle conflicts and challenges professionally. The video serves as a comprehensive guide for candidates to enhance their interview skills and improve their chances of success.

Takeaways

  • 🎤 Prepare for management questions in interviews.
  • 💼 Confidence and honesty are key in responses.
  • 📊 Understand the importance of data validation.
  • 🛠️ Use tools like Jira for task tracking.
  • 🤝 Teamwork is essential for project success.
  • 📅 Prioritize tasks effectively to manage workload.
  • 📚 Stay updated with new technologies through research.
  • 🔄 Learn from mistakes and take responsibility.
  • 🗣️ Ask insightful questions at the end of the interview.
  • 🚀 Focus on continuous improvement and skill development.

Garis waktu

  • 00:00:00 - 00:05:00

    The video introduces the speaker, Santosh, a manager at Microsoft with nine years of experience in data-related technologies. He emphasizes the importance of preparation for management interviews, highlighting that many candidates fail to clear the second round despite being technically strong. Santosh shares tips for answering questions confidently and honestly, stressing the need for candidates to be aware of their responses during the management round.

  • 00:05:00 - 00:10:00

    Santosh begins answering common interview questions, starting with an introduction about his background and current role. He explains his responsibilities in a project, including requirement gathering, report building, and collaboration with data engineers. He emphasizes the importance of being thorough in his work and ensuring the quality of reports.

  • 00:10:00 - 00:15:00

    He describes his daily activities, which include analyzing data, handling ad-hoc requests, and participating in meetings to discuss project progress and challenges. Santosh also explains how he validates data to ensure accuracy and how he tracks tasks using tools like Jira, highlighting the importance of organization in project management.

  • 00:15:00 - 00:20:00

    Santosh shares experiences of overcoming challenges in his projects, such as team ramp-downs and managing changing requirements. He discusses his strengths and weaknesses, emphasizing his commitment to delivering accurate results and his approach to conflict resolution, which involves collaboration and documentation.

  • 00:20:00 - 00:27:13

    The video transitions to non-technical questions, where Santosh discusses his methods for upskilling, managing stress, and prioritizing tasks. He reflects on his experiences with both individual and team roles, expressing a preference for teamwork while being adaptable. He concludes by discussing his future aspirations and the importance of asking questions during interviews to demonstrate interest.

Tampilkan lebih banyak

Peta Pikiran

Video Tanya Jawab

  • What is the focus of the video?

    The video focuses on management interview questions for data-related roles.

  • Who is the presenter of the video?

    The presenter is Santosh, a manager at Microsoft with nine years of experience.

  • What types of questions are covered in the video?

    The video covers both technical and non-technical management questions.

  • What is a key tip for interview preparation?

    Be confident, honest, and precise in your answers.

  • How does Santosh suggest handling conflicts?

    He suggests giving others a chance to speak and focusing on team solutions.

  • What methodology does Santosh's team follow?

    They follow agile methodology for project management.

  • What should candidates do if they make a mistake?

    Learn from the mistake and take responsibility for it.

  • How does Santosh prioritize his work?

    He creates a to-do list and starts with complex tasks first.

  • What is Santosh's approach to upskilling?

    He stays updated with new technologies through research and reading.

  • What should candidates ask at the end of the interview?

    They should ask about the challenges of the role to show interest.

Lihat lebih banyak ringkasan video

Dapatkan akses instan ke ringkasan video YouTube gratis yang didukung oleh AI!
Teks
en
Gulir Otomatis:
  • 00:00:00
    [Music]
  • 00:00:00
    foreign
  • 00:00:00
    [Music]
  • 00:00:08
    now this will be usually the second
  • 00:00:11
    round of every interview now
  • 00:00:12
    irrespective of which role you are
  • 00:00:14
    applying for it could be for data
  • 00:00:16
    science or data engineering or data
  • 00:00:18
    analyst we have picked the top 25
  • 00:00:20
    management questions and we are going to
  • 00:00:23
    give you with answers
  • 00:00:24
    those this will be definitely very
  • 00:00:26
    useful so I request each each everyone
  • 00:00:29
    to look at every question because every
  • 00:00:32
    question is repeated n number of times
  • 00:00:34
    in management round before starting I'll
  • 00:00:38
    just like to introduce myself well
  • 00:00:40
    myself Santosh I'm working as a manager
  • 00:00:44
    at Microsoft and along with that I'm
  • 00:00:46
    also taking care of the training part in
  • 00:00:48
    case a data vision and I do have around
  • 00:00:50
    nine years of experience working with
  • 00:00:52
    data related Technologies including data
  • 00:00:55
    science data analyst and data
  • 00:00:57
    engineering I have experience around
  • 00:00:59
    working with around 80 projects in
  • 00:01:02
    different domains with respect to
  • 00:01:04
    telecommunication Healthcare e-commerce
  • 00:01:06
    and Banking and for the last five years
  • 00:01:09
    I've been training people and different
  • 00:01:10
    Technologies now based on my experience
  • 00:01:13
    I have received n number of questions
  • 00:01:15
    and I also take lot of interviews at my
  • 00:01:18
    company that's so we have just collected
  • 00:01:20
    everything and this video is prepared
  • 00:01:23
    for your preparation for a management
  • 00:01:25
    round now the thing things which we'll
  • 00:01:28
    be covering is your management round
  • 00:01:30
    will be a combination of your Tech as
  • 00:01:33
    well as some of the general questions
  • 00:01:34
    and the fact is though you're
  • 00:01:37
    technically very strong 30 percent of
  • 00:01:39
    the people who are applying for the
  • 00:01:41
    second round don't clear it the reason
  • 00:01:43
    they may not have much experience to
  • 00:01:45
    talk about the answers let me talk about
  • 00:01:47
    a power bi developer role or a data
  • 00:01:50
    analysis rule or even a data engineer
  • 00:01:52
    role you may be technically very strong
  • 00:01:54
    where you can answer all of your
  • 00:01:55
    questions in the round one but in the
  • 00:01:57
    round two there will be some of the
  • 00:01:59
    scenarios that will be asked and you may
  • 00:02:02
    not be able to answer it well now this
  • 00:02:04
    video will really help you for your
  • 00:02:06
    preparation now as said if you see you
  • 00:02:09
    have to be very conscious about what you
  • 00:02:11
    are answering in your management round
  • 00:02:13
    because this is still at elimination
  • 00:02:15
    round even though you have given your
  • 00:02:16
    best in the round one this can still be
  • 00:02:19
    your elimination so don't rush up with
  • 00:02:21
    your answers so this is how some of the
  • 00:02:23
    tips and tricks which I am telling
  • 00:02:24
    before going into the question so try to
  • 00:02:26
    be precise and try to make sure that you
  • 00:02:29
    speak spontaneously okay and whatever
  • 00:02:31
    you're speaking just be confident and
  • 00:02:34
    one personal advice be honest
  • 00:02:37
    now that's where you have to score your
  • 00:02:39
    marks in case if you have not done on
  • 00:02:41
    the face you can tell that you have not
  • 00:02:43
    done right let's get into questions one
  • 00:02:46
    by one now we have splitted these
  • 00:02:48
    questions into both Tech and non-tech
  • 00:02:50
    technically yes they will start with
  • 00:02:51
    some small technical questions and then
  • 00:02:53
    they will move on to a non-technical
  • 00:02:55
    which I can even call it as a general
  • 00:02:57
    question now I'll be acting like a jewel
  • 00:03:00
    role I'll be asking the questions by
  • 00:03:02
    self and I'll be giving the answers
  • 00:03:04
    myself so please make sure that you keep
  • 00:03:06
    a track of who is a panel and who is the
  • 00:03:09
    candidate okay so the question which is
  • 00:03:11
    displayed on the screen will be like a
  • 00:03:13
    panel asking and then I'll be
  • 00:03:15
    elaborating the answers so that will be
  • 00:03:18
    the candidate's answer okay first
  • 00:03:20
    question hey thanks for joining the call
  • 00:03:22
    can you elaborate yourself or can you
  • 00:03:25
    introduce yourself well thank you so
  • 00:03:28
    much for this opportunity
  • 00:03:29
    myself Santosh I do have around 9 years
  • 00:03:32
    of experience working with Microsoft
  • 00:03:34
    well I started my career with SQL then
  • 00:03:37
    slowly moved on to a data analyst role
  • 00:03:39
    and Then followed by data engineering
  • 00:03:42
    now in my complete project I used to
  • 00:03:44
    work with end-to-end right from the
  • 00:03:46
    requirement Gathering until report
  • 00:03:47
    building
  • 00:03:48
    so responsible for
  • 00:03:50
    creating reports and dashboards to talk
  • 00:03:53
    about the current assignment which I'm
  • 00:03:55
    working I am working for e-commerce
  • 00:03:57
    company Amazon
  • 00:03:59
    so in Amazon we actually take off all
  • 00:04:02
    the data that is coming from different
  • 00:04:03
    data sources and we collect together
  • 00:04:06
    into a power query editor we build the
  • 00:04:08
    modeling and this is where we just bring
  • 00:04:10
    on to Power view by using different kind
  • 00:04:13
    of charts that is available in power bi
  • 00:04:16
    we should video reporting and then we
  • 00:04:19
    take forward to publishing the report
  • 00:04:21
    no the need of this project was we
  • 00:04:24
    wanted to create one centralized
  • 00:04:26
    dashboard and report so that our end
  • 00:04:28
    users can view the report and make some
  • 00:04:32
    decisions
  • 00:04:33
    now this is a small introduction about
  • 00:04:35
    myself
  • 00:04:36
    and I'm very happy to explain in detail
  • 00:04:41
    next question
  • 00:04:42
    so what is your current role in the
  • 00:04:44
    project
  • 00:04:45
    well in the current project my
  • 00:04:47
    responsibility is to take care of the
  • 00:04:49
    end-to-end activities I
  • 00:04:51
    interact with my clients
  • 00:04:54
    I get the requirements in the form of
  • 00:04:56
    documents or email
  • 00:04:58
    then I'll start preparing the design and
  • 00:05:00
    then we will reach out to certain team
  • 00:05:02
    for the data especially data engineers
  • 00:05:04
    and majority of the time they build in
  • 00:05:07
    report building
  • 00:05:08
    and we also think out of the box to make
  • 00:05:11
    sure that we provide the best solution
  • 00:05:13
    to the end users
  • 00:05:15
    okay
  • 00:05:16
    so can you describe your day-to-day
  • 00:05:18
    activities in your project
  • 00:05:20
    well my day starts with a simple
  • 00:05:22
    analysis where we'll be working with our
  • 00:05:25
    report
  • 00:05:26
    and there will be a lot of adobe
  • 00:05:27
    requests that will be coming on to the
  • 00:05:29
    plate when I say dog request so my
  • 00:05:32
    flight asks okay what happened the last
  • 00:05:34
    uh 10 Day sales what happened last one
  • 00:05:37
    week now let's say we have start we have
  • 00:05:39
    a start of the year how the sales has
  • 00:05:40
    been improving or can you compare your
  • 00:05:43
    last December sales to the January sales
  • 00:05:44
    now these are all a dog requests that
  • 00:05:46
    we'll be getting
  • 00:05:47
    we may not be doing power ba report for
  • 00:05:50
    that at least by using SQL or maybe
  • 00:05:52
    Advanced Excel we'll try to pull the
  • 00:05:54
    data and we show Taste to our clients so
  • 00:05:56
    that is where my day starts followed by
  • 00:06:00
    we will be having multiple meetings in
  • 00:06:02
    general meeting stand-up meeting and
  • 00:06:04
    then we discuss about the blockers what
  • 00:06:07
    is the current work we are doing and
  • 00:06:08
    always we interact with the team making
  • 00:06:11
    sure that if anyone is facing challenges
  • 00:06:13
    we try to solve it by using our
  • 00:06:15
    experience so that is something which we
  • 00:06:16
    do I'm Then followed by we work with our
  • 00:06:19
    actual development that is report
  • 00:06:21
    building so this is how my day ends and
  • 00:06:24
    it's mainly on the analytics side okay
  • 00:06:28
    now how do you validate your
  • 00:06:30
    data in your project
  • 00:06:32
    well thank you so much for bringing up
  • 00:06:34
    this question this is very important for
  • 00:06:36
    every project it's not about how you
  • 00:06:38
    build the report it's about the quality
  • 00:06:40
    of the report
  • 00:06:41
    now even if you make a small mistake in
  • 00:06:43
    the numbers that can spoil the entire
  • 00:06:45
    report so we have to take an extra step
  • 00:06:47
    and extra precautions in managing the
  • 00:06:49
    data and the way I validate the data is
  • 00:06:52
    we don't have the source and would have
  • 00:06:55
    done some calculations for maybe would
  • 00:06:56
    have written some tax functions so our
  • 00:06:59
    objective is to compare your source and
  • 00:07:01
    destination so whatever the data which
  • 00:07:03
    we are getting the source level after
  • 00:07:05
    Transformations we also go and check if
  • 00:07:07
    the data is matchy my basic way of
  • 00:07:10
    checking is you pick out One customer
  • 00:07:11
    check what is the sales before transmit
  • 00:07:13
    uh transforming and again at the tax
  • 00:07:16
    layer you can go and do the
  • 00:07:17
    Transformations and always try to create
  • 00:07:19
    a simple table check it and then
  • 00:07:21
    Implement on a larger table and we can
  • 00:07:24
    also write some store procedures where
  • 00:07:26
    we can compare your input and output So
  • 00:07:29
    This Is How We Do It
  • 00:07:30
    and basically our objective is to
  • 00:07:33
    compare your input and output if that is
  • 00:07:35
    not matching then we have to go and
  • 00:07:37
    research and do a deep dive where is the
  • 00:07:40
    issue
  • 00:07:41
    now
  • 00:07:43
    okay so how do you track your task in
  • 00:07:46
    your current project uh usually we get
  • 00:07:48
    the requirement in the form of a
  • 00:07:50
    business requirement document or either
  • 00:07:52
    a functional requirement document so
  • 00:07:55
    using this documents we usually collect
  • 00:07:57
    all the requirements and nowadays we
  • 00:07:59
    have also started using jira so jira is
  • 00:08:02
    a tracking tool where we can track each
  • 00:08:04
    and every task making sure that uh who
  • 00:08:07
    has been assigned and what is estimate
  • 00:08:09
    given and how long you're going to take
  • 00:08:11
    to do this work so these are the few
  • 00:08:13
    things which will be handling and we are
  • 00:08:15
    following jira tool for our other
  • 00:08:17
    project
  • 00:08:18
    okay
  • 00:08:19
    have you faced any challenges in your
  • 00:08:21
    project
  • 00:08:22
    uh if yes how did you overcome that well
  • 00:08:24
    challenges yes we do have a lot of
  • 00:08:26
    challenges and I'll share you one of the
  • 00:08:28
    experience which I have faced uh in the
  • 00:08:31
    early 2021 uh the team was rammed down
  • 00:08:35
    and immediately some of the team members
  • 00:08:37
    were being moved out and it was a very
  • 00:08:39
    tough for us to fill their shoes I would
  • 00:08:42
    say that the data Engineers were very
  • 00:08:44
    helpful in providing the data for us but
  • 00:08:46
    unfortunately due to the project ramp
  • 00:08:48
    down uh the team was actually shorted
  • 00:08:51
    from nine members it become four members
  • 00:08:53
    and this was a challenging phase because
  • 00:08:55
    the timelines very uh tight we have to
  • 00:08:58
    do the deliverables on time but
  • 00:09:01
    unfortunately we were not able to do
  • 00:09:02
    that so the way we have handled this
  • 00:09:05
    though it was not our cup of tea we have
  • 00:09:07
    to just jump in in data engineering role
  • 00:09:10
    we have to pull out right data from
  • 00:09:11
    right schema so we have put lot of
  • 00:09:13
    efforts we extended our time and made
  • 00:09:16
    sure that the deliverables was on safe
  • 00:09:18
    place now that's one of the challenges
  • 00:09:19
    which we add
  • 00:09:21
    that is data Gathering part and that is
  • 00:09:24
    how we have handled it and in between we
  • 00:09:26
    used to also get a lot of requirement
  • 00:09:28
    changes and this requirement changes uh
  • 00:09:32
    of course if requirements are changing
  • 00:09:33
    your timelines will not change so that's
  • 00:09:35
    the one thing about clients so we need
  • 00:09:38
    to manage that so switching here and
  • 00:09:41
    there between the requirements and
  • 00:09:42
    trying to manage your clients that was
  • 00:09:44
    the most difficult part and we have
  • 00:09:46
    handled it smoothly with the help of
  • 00:09:48
    team
  • 00:09:51
    now moving on uh slowly the shift will
  • 00:09:55
    be from Tech to non-tech okay so in no
  • 00:09:58
    particular order we have a set of
  • 00:10:00
    non-tech questions so please have a eye
  • 00:10:02
    on it
  • 00:10:03
    to start with
  • 00:10:05
    uh what is your strength and weakness
  • 00:10:08
    well uh my strength is definitely I'll
  • 00:10:11
    be confident of the work which I'm doing
  • 00:10:13
    and I'm always sticking on to the
  • 00:10:15
    timelines I'll be always up to Mark in
  • 00:10:18
    terms of delivering the product
  • 00:10:20
    so that is about my strength and my
  • 00:10:22
    weakness yes uh I would say that
  • 00:10:26
    um definitely yes I do have weakness
  • 00:10:28
    when I say weakness
  • 00:10:30
    uh
  • 00:10:31
    overthinking could be one of my weakness
  • 00:10:34
    and I do take some extra time in
  • 00:10:37
    providing the accurate results uh maybe
  • 00:10:39
    even whenever if given a requirement I
  • 00:10:42
    usually ask a buffer of two days
  • 00:10:44
    uh because for me all it matters is data
  • 00:10:46
    I don't want to go with the client with
  • 00:10:48
    the wrong numbers I want to go with the
  • 00:10:50
    accurate numbers so I take a couple of
  • 00:10:52
    days extra time in validating the
  • 00:10:53
    numbers because testing is very
  • 00:10:55
    important for me so that is where I
  • 00:10:56
    pushed by one or two days uh maybe I
  • 00:10:59
    call it that as an
  • 00:11:01
    um weakness because I take some extra
  • 00:11:03
    time but end of the day it's all about
  • 00:11:04
    getting the best results
  • 00:11:06
    okay
  • 00:11:08
    so how do you overcome conflicts with
  • 00:11:10
    your client or within the team well uh
  • 00:11:12
    conflicts are one thing which happens in
  • 00:11:14
    every project but people usually don't
  • 00:11:16
    showcase that uh being at a professional
  • 00:11:18
    working site but uh the way I handle
  • 00:11:21
    this uh whether this with the team or
  • 00:11:24
    with the clients I always give chance to
  • 00:11:26
    others to speak
  • 00:11:28
    uh maybe if you have couple of work that
  • 00:11:30
    is either done by you and your colleague
  • 00:11:32
    I always try to have the best solution
  • 00:11:34
    doesn't matter if that has to be my
  • 00:11:37
    solution I always support P for me team
  • 00:11:39
    comes first and then the individual
  • 00:11:42
    I don't look at the individual
  • 00:11:43
    performance I always consider the team
  • 00:11:45
    end of the day it's all about providing
  • 00:11:47
    the best report to the end users so in
  • 00:11:50
    terms of conflict I give the chance to
  • 00:11:52
    others
  • 00:11:53
    prove them in terms of a documentation
  • 00:11:54
    if let's say if there is a solution if
  • 00:11:57
    two resources has been doing the same
  • 00:11:59
    thing I ask them to present take the
  • 00:12:01
    best do the documentation do the testing
  • 00:12:03
    and that's so we handle it and that's
  • 00:12:06
    how I do it in terms of conflicts I try
  • 00:12:09
    to handle it smooth end of the day it's
  • 00:12:11
    all about a corporate so you need to be
  • 00:12:13
    professionally well matured so that is
  • 00:12:15
    something which I do for my projects
  • 00:12:17
    okay
  • 00:12:19
    how do you get upskilled with the new
  • 00:12:20
    technologies well this is something
  • 00:12:22
    which is very interesting because I am
  • 00:12:24
    very passionate about Technologies so I
  • 00:12:26
    always try to find the answers in
  • 00:12:28
    multiple ways try to find multiple
  • 00:12:30
    directions if there is a problem I
  • 00:12:32
    always wanted to reach that problem in a
  • 00:12:35
    shorter path and for that I used to do a
  • 00:12:38
    lot of research I read some articles uh
  • 00:12:41
    go with some documentation I know I
  • 00:12:43
    always keep prepared in terms of updates
  • 00:12:45
    and that is something which helped me to
  • 00:12:47
    solve the problem in multiple ways and
  • 00:12:49
    as well as said that I am passionate
  • 00:12:51
    about Technologies and I always keep
  • 00:12:53
    updated I put a lot of efforts in
  • 00:12:55
    understanding some of the Articles
  • 00:12:57
    documents and research papers and that
  • 00:13:00
    is how I keep myself updated
  • 00:13:03
    okay
  • 00:13:05
    so uh could you please describe a
  • 00:13:07
    situation where uh you added a difficult
  • 00:13:10
    time in your project
  • 00:13:12
    well uh yes definitely I had a lot of
  • 00:13:15
    uh difficult times so one such was uh
  • 00:13:20
    you have to manage both your
  • 00:13:22
    professional and personal time so that
  • 00:13:24
    is something which is uh there for every
  • 00:13:26
    individual person so that could be a
  • 00:13:28
    situation where you have to manage and
  • 00:13:30
    you have to plan accordingly and once
  • 00:13:32
    this time back you need you will not
  • 00:13:34
    even get support from the team you have
  • 00:13:36
    to put your efforts extend your ass uh
  • 00:13:39
    put some extra hours for the weekend
  • 00:13:41
    um that's something which I do it I'll
  • 00:13:43
    make sure that uh for me project
  • 00:13:46
    deliverables comes first and I take one
  • 00:13:48
    step at a time I don't prefer
  • 00:13:50
    multitasking but I always think about
  • 00:13:52
    the project and the task and I finish
  • 00:13:55
    one at a time so that's how I manage the
  • 00:13:58
    difficult types and as said in the
  • 00:14:00
    previous uh discussion as well like uh
  • 00:14:03
    there was difficult time in the project
  • 00:14:05
    where the team was ramped down and you
  • 00:14:07
    have to upskill yourself you have to
  • 00:14:09
    overcome all the challenges so that is
  • 00:14:11
    something which I add in my experience
  • 00:14:13
    and I just wanted to call that out
  • 00:14:15
    but do you work with multiple clients at
  • 00:14:17
    the same time if yes audio manage yes if
  • 00:14:20
    if that is a requirement from two
  • 00:14:23
    clients yes definitely we have to accept
  • 00:14:25
    it and we have to do it uh we cannot say
  • 00:14:27
    no to the other client and yesterday
  • 00:14:29
    other is client is to the other client
  • 00:14:30
    that's not the way you handle it you
  • 00:14:33
    have to manage you have to manage both
  • 00:14:34
    and that's why the company is paying for
  • 00:14:36
    so you have to take one step at a time
  • 00:14:38
    uh check out which project as the type
  • 00:14:43
    deadlines and which is a blocker for
  • 00:14:45
    example there could be two reports where
  • 00:14:47
    one report there is only 20 users are
  • 00:14:48
    who are using and the other report there
  • 00:14:50
    are 400 users are using so just try to
  • 00:14:52
    give priority to which one is needed and
  • 00:14:55
    just take that into your priority list
  • 00:14:58
    and that's how I do it
  • 00:15:01
    uh do you have experience in handling
  • 00:15:03
    team well uh I'm not a team reader but
  • 00:15:06
    yes
  • 00:15:07
    I can manage a team and I have done that
  • 00:15:10
    not a team leader on paper but yes I
  • 00:15:14
    have been responsible for handling the
  • 00:15:16
    task I daily get some tasks to Junius
  • 00:15:18
    and I take care of it in fact I will be
  • 00:15:20
    the person who will be facing a decline
  • 00:15:23
    so I'll be responsible for uh delivering
  • 00:15:25
    the product so definitely I take that
  • 00:15:27
    ownership and yes I do have experience
  • 00:15:29
    handling it with a larger team
  • 00:15:34
    okay
  • 00:15:35
    so which process do you follow in your
  • 00:15:37
    project
  • 00:15:38
    well in my project uh we usually follow
  • 00:15:40
    agile methodology so uh
  • 00:15:44
    for a couple of other projects I do have
  • 00:15:46
    experience working with waterfall but I
  • 00:15:48
    also like to work with agile so Arjun is
  • 00:15:51
    something which happens at every Sprint
  • 00:15:53
    so each print will be like around two
  • 00:15:55
    weeks or three weeks so Deliverance will
  • 00:15:57
    be done within two three weeks and the
  • 00:15:59
    good thing about going with agile is you
  • 00:16:01
    get a lot of feedbacks in improving
  • 00:16:03
    their reports and dashboards and
  • 00:16:04
    according to the business need so that
  • 00:16:06
    is something which we follow and we do
  • 00:16:08
    also have stand-up calls every day we do
  • 00:16:10
    connect with the team and discuss what
  • 00:16:12
    is a blockers we do ask three questions
  • 00:16:14
    uh what did you do yesterday what did
  • 00:16:17
    you what are you going to do today and
  • 00:16:18
    what is the blocker so those things we
  • 00:16:20
    will be discussing
  • 00:16:21
    and that is something which uh we'll be
  • 00:16:24
    doing for agile methodology and yes that
  • 00:16:27
    is what we are uh following the process
  • 00:16:29
    and in fact we also have some overlap
  • 00:16:31
    time between the clients and we try to
  • 00:16:34
    connect with the clients on a daily
  • 00:16:35
    basis as well
  • 00:16:37
    where do you see yourself in next three
  • 00:16:39
    years and next five years well next
  • 00:16:42
    three years uh I would definitely want
  • 00:16:44
    to be more strong uh towards the
  • 00:16:46
    technological Side and being at the
  • 00:16:48
    technology yes domain knowledge is very
  • 00:16:50
    important so knowing about multiple
  • 00:16:52
    domains uh will be the key factor and
  • 00:16:55
    that is something which I will be doing
  • 00:16:57
    it I want to improve my skills over the
  • 00:17:01
    domain domain knowledge and five years
  • 00:17:04
    down the line uh I wouldn't think about
  • 00:17:06
    future right away uh I just think one is
  • 00:17:08
    taking one step at a time but if still
  • 00:17:10
    this question is shooted at me I would
  • 00:17:12
    say that at five years I would
  • 00:17:14
    definitely like to lead a larger team
  • 00:17:16
    and take more responsibilities and a
  • 00:17:18
    higher role in the company
  • 00:17:22
    uh why are you leaving your current job
  • 00:17:25
    well uh two factors so one which I would
  • 00:17:28
    say this uh I'm not being that utilized
  • 00:17:31
    in the project uh I I work for five six
  • 00:17:34
    hours which uh could I could have done
  • 00:17:36
    it better so also the other thing is the
  • 00:17:39
    work has become stable uh there is no
  • 00:17:41
    much challenging and I'm a person who
  • 00:17:43
    likes to solve a lot of challenges and I
  • 00:17:46
    just wanted to get into a challenging
  • 00:17:47
    role where I'm technically strong so I
  • 00:17:49
    want to utilize that skill and that is
  • 00:17:51
    the one reason which I'm looking for a
  • 00:17:53
    job change
  • 00:17:55
    this role requires to work in a
  • 00:17:58
    different time zone any concept well not
  • 00:18:00
    at all uh all of my experience I work
  • 00:18:02
    with the US clients and UK clients so
  • 00:18:05
    definitely there will be overlap and I
  • 00:18:07
    usually log in at 12 o'clock and one
  • 00:18:09
    o'clock in the afternoon time and extend
  • 00:18:11
    my work in the nine to ten and also
  • 00:18:13
    there will be always overlap between our
  • 00:18:15
    time and U.S time so definitely time is
  • 00:18:17
    not at all a concern I am ready to work
  • 00:18:20
    in any shift that's one of the positive
  • 00:18:23
    side of my work
  • 00:18:25
    are you aware of the job description uh
  • 00:18:28
    yes I have gone to the job description
  • 00:18:30
    and I was really excited for this role
  • 00:18:32
    uh because this role requires a lot of
  • 00:18:34
    analytics to be done into a different
  • 00:18:36
    domain and coming from an e-commerce
  • 00:18:38
    Healthcare and finance I think this uh
  • 00:18:41
    domain could really help me to scale up
  • 00:18:44
    and that's one of the thing which I'm
  • 00:18:46
    looking for I'm looking forward to it
  • 00:18:48
    and uh first of all thank thanks for
  • 00:18:50
    this uh opportunity on this role as well
  • 00:18:54
    okay tell me a situation where you have
  • 00:18:57
    committed a mistake and how did you
  • 00:18:58
    handle it uh when uh yes this is a very
  • 00:19:02
    important for each and everyone to learn
  • 00:19:05
    from the mistake and in my experience I
  • 00:19:08
    would not say in the early days but in
  • 00:19:10
    the uh four five years back where I am
  • 00:19:13
    working with one of the SQL database and
  • 00:19:15
    I thought it's a temp table and I really
  • 00:19:17
    dropped it uh but later I got to know
  • 00:19:20
    that it's it's a original table that you
  • 00:19:21
    have dropped it and uh the entire report
  • 00:19:24
    got uh I mean it got affected uh the
  • 00:19:28
    report did not load properly then again
  • 00:19:30
    I have to reach back to the production
  • 00:19:31
    team uh raise a ticket uh copy the
  • 00:19:35
    production data to your development data
  • 00:19:36
    so that's one of the mistake which I did
  • 00:19:38
    and yes I have to face the consequence I
  • 00:19:42
    have to uh face my clients in terms of
  • 00:19:44
    this and end of the day it's all about
  • 00:19:46
    learning uh it's not about what mistake
  • 00:19:49
    you make but it's about what you learn
  • 00:19:50
    so propping a table in the development
  • 00:19:53
    database was one of the mistake which
  • 00:19:55
    I've done and from then on which I was
  • 00:19:57
    very conscious of what needs to be not
  • 00:19:59
    what may not be done so that
  • 00:20:01
    Consciousness I got from the Mystic and
  • 00:20:03
    from then onwards I take everything very
  • 00:20:07
    seriously and focused when I'm working
  • 00:20:09
    for a project
  • 00:20:11
    how do you prioritize your work uh for
  • 00:20:14
    your team and yourself well this is
  • 00:20:16
    something which most of the uh
  • 00:20:18
    employees fail to plan it so what we do
  • 00:20:22
    in our project is uh we actually create
  • 00:20:25
    a list of to-do lists as said that we
  • 00:20:28
    start our day with the team meetings so
  • 00:20:30
    in team meetings I give chance to
  • 00:20:32
    discuss everyone about their work they
  • 00:20:33
    are doing and also their challenges who
  • 00:20:36
    knows a person challenges may be solved
  • 00:20:38
    by other person in a previous assignment
  • 00:20:39
    or experience so I would like the entire
  • 00:20:42
    team to discuss and that will actually
  • 00:20:44
    solve the majority of the problem and I
  • 00:20:46
    keep it very short 15-20 minutes of
  • 00:20:48
    discussion so that they can start
  • 00:20:49
    sharing their to-do list and that's what
  • 00:20:52
    I do for the team and for coming for
  • 00:20:53
    myself I always look on to the mails
  • 00:20:55
    just check which is on priority and
  • 00:20:57
    prepare a to-do list uh put it in the
  • 00:21:00
    sticky notes and then solve one by one
  • 00:21:01
    so that's the thing which I do and
  • 00:21:03
    always start with a complex task first
  • 00:21:05
    so that you get rid of all these stress
  • 00:21:08
    and then you come back to the small task
  • 00:21:10
    and that's how I do it
  • 00:21:12
    okay so do you prefer individual role or
  • 00:21:15
    working with a team well uh both as pros
  • 00:21:18
    and cons but I have experience working
  • 00:21:19
    with both as an individual developer as
  • 00:21:21
    well as a team developer so when it
  • 00:21:24
    comes to the individual yes you need not
  • 00:21:26
    uh discuss with anything you can just
  • 00:21:27
    take care of your work you need to
  • 00:21:29
    report only to your clients and you can
  • 00:21:32
    put you a lot of efforts you can just do
  • 00:21:34
    as per your need well that's an
  • 00:21:36
    advantage but at end of the day that you
  • 00:21:38
    will not get some ideas or suggestions
  • 00:21:40
    from the team so that's the drawback so
  • 00:21:42
    when you're working with the team you
  • 00:21:43
    have to always sync with the team you
  • 00:21:44
    should have patience you have to
  • 00:21:46
    collaborately work with them and
  • 00:21:47
    teamwork is actually what is what why I
  • 00:21:49
    prefer because when working for
  • 00:21:51
    analytics you have will get a lot of
  • 00:21:53
    chance to think
  • 00:21:54
    you will have a lot of ideas to share so
  • 00:21:57
    your suggestions also will be valid so
  • 00:21:59
    I I usually prefer teamwork but I'm open
  • 00:22:02
    to work on any role
  • 00:22:05
    okay
  • 00:22:06
    so how do you handle stress well uh yeah
  • 00:22:10
    honestly stress is something which
  • 00:22:11
    everyone has to overcome in their career
  • 00:22:13
    path so yes sometimes you will be very
  • 00:22:16
    much stressed with hard deadlines and
  • 00:22:18
    you have to manage your all the things
  • 00:22:20
    as an individual as a human being yes
  • 00:22:23
    you will have stress to overcome that
  • 00:22:25
    something which is uh something you need
  • 00:22:27
    to think and make yourself comfortable
  • 00:22:28
    so I myself I take a small break uh come
  • 00:22:32
    back uh pick a fresh mine and try to
  • 00:22:35
    solve it so I I always prefer working
  • 00:22:38
    with gaps it's not about continuously
  • 00:22:40
    started uh work for all eight hours and
  • 00:22:43
    make yourself successful I here and
  • 00:22:45
    there I took technical of breaks and
  • 00:22:47
    then I come back with a fresh mag and
  • 00:22:50
    that's how I handle stress
  • 00:22:53
    tell me one thing which yourself which
  • 00:22:55
    is not there in your resume so uh okay
  • 00:22:58
    most of the things which is that in my
  • 00:22:59
    resume will be towards my technical side
  • 00:23:01
    where I do a lot of things over uh uh
  • 00:23:05
    the projects but something out of the
  • 00:23:07
    projects I'm very passionate about
  • 00:23:09
    sports so I do play a lot of sports to
  • 00:23:11
    keep myself out of the stress and I also
  • 00:23:14
    help people in terms of uh mentoring so
  • 00:23:16
    that's something which I do outside my
  • 00:23:18
    work and that will never be your resume
  • 00:23:21
    if I call one of your previous manager
  • 00:23:23
    and ask about you what would they say
  • 00:23:25
    about you
  • 00:23:27
    um well yes one thing which uh
  • 00:23:30
    any of my
  • 00:23:32
    previous Prius or managers will talk
  • 00:23:34
    about me is uh I'm very punctual and
  • 00:23:37
    that is something which I keep always in
  • 00:23:39
    mind even when going to an office or
  • 00:23:41
    attending a meeting I always be on time
  • 00:23:43
    so that special thing is one thing which
  • 00:23:46
    my uh others may speak about me and the
  • 00:23:49
    honesty and the work which I do which
  • 00:23:51
    will be on up to the mark So if I'm
  • 00:23:53
    doing any work it's why if if I do any
  • 00:23:56
    deliverables so it's like uh it will be
  • 00:23:58
    up to the mark As per the standard so
  • 00:24:00
    that is something which I've practiced
  • 00:24:01
    in my career and that's one of the
  • 00:24:03
    positive about me
  • 00:24:05
    how do you justify your the best fit at
  • 00:24:08
    the other candidates uh well yes uh
  • 00:24:11
    maybe you would have interviewed many
  • 00:24:12
    people for this role but definitely I
  • 00:24:15
    would justify myself that I'm a fast
  • 00:24:17
    learner
  • 00:24:19
    um you give me any technology I can
  • 00:24:21
    learn in uh 10 days so that's what I am
  • 00:24:23
    very good at I do a lot of research in
  • 00:24:26
    understanding the requirements uh the
  • 00:24:29
    usage of right tools the way we have to
  • 00:24:31
    progress so that is something which I do
  • 00:24:33
    it and uh to justify myself I am uh I'm
  • 00:24:37
    known of many Technologies I'm aware of
  • 00:24:39
    a lot of things I try to collect the
  • 00:24:42
    dots so what is a problem how to do a
  • 00:24:45
    breakdown and then how to solve each and
  • 00:24:46
    every problem so this is something which
  • 00:24:48
    I do it and that's one of my strength
  • 00:24:51
    and of course that I would justify that
  • 00:24:53
    I will be the best fit
  • 00:24:55
    okay
  • 00:24:57
    uh do you have any questions for me uh
  • 00:24:59
    yes definitely thank you so much for uh
  • 00:25:01
    sparing your time on asking these
  • 00:25:03
    questions I'm really glad that you were
  • 00:25:05
    able to uh I was able to justify all
  • 00:25:07
    these answers but I still wanted to know
  • 00:25:09
    uh what type of challenging role I can
  • 00:25:11
    expect here and I'm very much interested
  • 00:25:14
    in this role so if you can help you to
  • 00:25:16
    understand uh better about the job and
  • 00:25:18
    the role I would be really happy to hear
  • 00:25:20
    that okay
  • 00:25:22
    now this ends the all the questions
  • 00:25:25
    now uh
  • 00:25:28
    you would have gone through each and
  • 00:25:29
    every question and the way I answer is
  • 00:25:32
    I'm not prepared
  • 00:25:34
    honestly this is a something which you
  • 00:25:36
    have to do it without preparation just
  • 00:25:38
    keep in a mind what are the situation
  • 00:25:40
    you have come across and then speak
  • 00:25:42
    about it the last question is very
  • 00:25:44
    important don't just say that I don't
  • 00:25:46
    have any questions okay if you say that
  • 00:25:48
    you don't have any questions it's like
  • 00:25:50
    you are not showing interest to your
  • 00:25:51
    interviewer okay so please ask some
  • 00:25:53
    questions and always try to talk about
  • 00:25:56
    positive sites of yourself and
  • 00:25:58
    especially uh if they are asking about
  • 00:26:00
    the negatives you should be able to tell
  • 00:26:03
    that as well okay so please go through
  • 00:26:06
    this all these questions one by one I
  • 00:26:08
    know it's a lengthy video but I would
  • 00:26:10
    request this will be really helpful and
  • 00:26:12
    we already have top 25 SQL questions top
  • 00:26:14
    25 powerbeat questions and we also have
  • 00:26:17
    couple of other interview question
  • 00:26:19
    interview uh recorded uh in our YouTube
  • 00:26:22
    so this also will be added to the list
  • 00:26:25
    so please go through this as said in the
  • 00:26:28
    beginning 30 percent of them were
  • 00:26:31
    technically strong are not able to clear
  • 00:26:33
    the management role because lack of
  • 00:26:37
    answering skills just follow the video
  • 00:26:39
    write it down and speak it in your own
  • 00:26:41
    words this should clear 100 the answers
  • 00:26:45
    which I've said if you all were also
  • 00:26:47
    repeating in the interview your
  • 00:26:48
    interview will be cleared with that
  • 00:26:51
    thank you so much for listening Please
  • 00:26:53
    Subscribe our Channel we will upload
  • 00:26:55
    more videos and we also have an another
  • 00:26:58
    interview round that is coming with the
  • 00:27:00
    client so how to manage a client
  • 00:27:02
    interview and that video also will be
  • 00:27:05
    published shortly thank you so much
  • 00:27:08
    foreign
Tags
  • interview preparation
  • management questions
  • data science
  • data engineering
  • data analyst
  • Santosh
  • Microsoft
  • agile methodology
  • conflict resolution
  • upskilling