Sumit Mittal
Sumit Mittal
  • 297
  • 4 599 955
Grand Award Ceremony | Star Data Engineers of TrendyTech 2024 Working @ TOP PRODUCT BASED COMPANIES
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me.
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
Most commonly asked interview questions when you are applying for any data based roles such as data analyst, data engineer, data scientist or data manager.
Link of Free SQL & Python series developed by me are given below -
SQL Playlist - ua-cam.com/play/PLtgiThe4j67rAoPmnCQmcgLS4iIc5ungg.html
Python Playlist - ua-cam.com/play/PLtgiThe4j67pQSwkaEF9uHXzr8Td9IEpV.html
Don't miss out - Subscribe to the channel for more such informative interviews and unlock the secrets to success in this thriving field!
Social Media Links :
LinkedIn - www.linkedin.com/in/bigdatabysumit/
Twitter - bigdatasumit
Instagram - bigdatabysumit
Student Testimonials - trendytech.in/#testimonials
Tags
#mockinterview #bigdata #career #dataengineering #data #datascience #dataanalysis #productbasedcompanies #interviewquestions #apachespark #google #interview #faang #companies #amazon #walmart #flipkart #microsoft #azure #databricks #jobs
Переглядів: 972

Відео

Big Data Interview | Mock | Problem Solving | Technical Round | Pyspark , SQL #interview #question
Переглядів 5 тис.Місяць тому
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me. I have trained over 20,000 professionals in the field of Data Engineering in the last 5 years. BIG DATA INTERVIEW SERIES This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development...
Big Data Engineer Mock Interview | Questions on Data Skewness | Salting | Out of Memory Error
Переглядів 6 тис.Місяць тому
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me. I have trained over 20,000 professionals in the field of Data Engineering in the last 5 years. BIG DATA INTERVIEW SERIES This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development...
Big Data Engineer Live Mock Interview | Topics: Pyspark, Delta Lake, Data Profiling, Data Governance
Переглядів 6 тис.Місяць тому
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me. I have trained over 20,000 professionals in the field of Data Engineering in the last 5 years. BIG DATA INTERVIEW SERIES This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development...
Top Big Data Interview Questions asked in 2024 | Cloud Data Engineer | Azure | Spark | SQL#interview
Переглядів 10 тис.Місяць тому
To enhance your career as a Cloud Data Engineer, Check trendytech.in/?src=youtube&sub=mockdec for curated courses developed by me. I have trained over 20,000 professionals in the field of Data Engineering in the last 5 years. BIG DATA INTERVIEW SERIES This mock interview series is launched as a community initiative under Data Engineers Club aimed at aiding the community's growth and development...
Azure Cloud Data Engineer Interview | Real-time Scenario based Questions & Expert Feedback | BigData
Переглядів 3,5 тис.Місяць тому
Azure Cloud Data Engineer Interview | Real-time Scenario based Questions & Expert Feedback | BigData
Azure Cloud Data Engineer Mock Interview | Important Questions asked in Big Data Interviews| Pyspark
Переглядів 3,8 тис.Місяць тому
Azure Cloud Data Engineer Mock Interview | Important Questions asked in Big Data Interviews| Pyspark
Live Must Watch Mock Interview for Experienced Big Data Engineers | Debug Production Issues | CICD
Переглядів 1,9 тис.Місяць тому
Live Must Watch Mock Interview for Experienced Big Data Engineers | Debug Production Issues | CICD
Must Watch Live Mock Interview for Aspiring Big Data Engineers | PySpark, Hive & SQL #interview
Переглядів 4,4 тис.Місяць тому
Must Watch Live Mock Interview for Aspiring Big Data Engineers | PySpark, Hive & SQL #interview
Important Data Structures and Algorithms Mock Interview for Data Engineers Spark | SQL #interview
Переглядів 3,5 тис.Місяць тому
Important Data Structures and Algorithms Mock Interview for Data Engineers Spark | SQL #interview
Must Watch Live Mock Interview for Aspiring Azure Data Engineers | Azure Data Pipeline, PySpark, SQL
Переглядів 1,2 тис.Місяць тому
Must Watch Live Mock Interview for Aspiring Azure Data Engineers | Azure Data Pipeline, PySpark, SQL
Real-time Data Modeling & System Design Mock Interview for Data Engineers #interview #important
Переглядів 3,4 тис.2 місяці тому
Real-time Data Modeling & System Design Mock Interview for Data Engineers #interview #important
Must Watch Live Mock Interview For Data Engineers | System Design | Data Modeling #interview
Переглядів 7 тис.2 місяці тому
Must Watch Live Mock Interview For Data Engineers | System Design | Data Modeling #interview
Everything that you need to know about the Big Data Interviews | Pyspark | Databricks | Azure | AWS
Переглядів 3,1 тис.2 місяці тому
Everything that you need to know about the Big Data Interviews | Pyspark | Databricks | Azure | AWS
PySpark Mock Interview | Basic Coding Round | Python | SQL | Join Optimizations #interview #bigdata
Переглядів 3 тис.2 місяці тому
PySpark Mock Interview | Basic Coding Round | Python | SQL | Join Optimizations #interview #bigdata
Live Big Data Project Interview Questions | Project Architecture | Data Pipeline #interview
Переглядів 2,4 тис.2 місяці тому
Live Big Data Project Interview Questions | Project Architecture | Data Pipeline #interview
Top Cloud Data Engineer Interview Questions | Azure | AWS | #interview #bigdata #question
Переглядів 1,5 тис.2 місяці тому
Top Cloud Data Engineer Interview Questions | Azure | AWS | #interview #bigdata #question
Big Data Mock Interview | DSA | APACHE SPARK | PYTHON | DATABRICKS #interview
Переглядів 4,6 тис.2 місяці тому
Big Data Mock Interview | DSA | APACHE SPARK | PYTHON | DATABRICKS #interview
Live Apache Spark Mock Interview | Spark | SQL | Databricks | Project based #interview #question
Переглядів 4 тис.2 місяці тому
Live Apache Spark Mock Interview | Spark | SQL | Databricks | Project based #interview #question
Top 15 Spark Interview Questions in less than 15 minutes Part-2 #bigdata #pyspark #interview
Переглядів 11 тис.2 місяці тому
Top 15 Spark Interview Questions in less than 15 minutes Part-2 #bigdata #pyspark #interview
15 Data Engineering Interview Questions in less than 15 minutes Part-1 #bigdata #interview
Переглядів 10 тис.2 місяці тому
15 Data Engineering Interview Questions in less than 15 minutes Part-1 #bigdata #interview
Live Databricks Developer Mock Interview | Azure | Spark | SQL #coding #interview
Переглядів 5 тис.2 місяці тому
Live Databricks Developer Mock Interview | Azure | Spark | SQL #coding #interview
Live Big Data Mock Interview | WALMART | Technical Round | Spark, SQL, Python #interview
Переглядів 6 тис.2 місяці тому
Live Big Data Mock Interview | WALMART | Technical Round | Spark, SQL, Python #interview
Live Big Data Mock Interview | Techno-Managerial Round | Scenario Based Questions #interview
Переглядів 3 тис.2 місяці тому
Live Big Data Mock Interview | Techno-Managerial Round | Scenario Based Questions #interview
Live Big Data Mock Interview | Technical Round 2 : PySpark | Slowly Changing Dimensions | Data Skew
Переглядів 3,8 тис.2 місяці тому
Live Big Data Mock Interview | Technical Round 2 : PySpark | Slowly Changing Dimensions | Data Skew
Apache Spark 1st Technical Round Live Interview | Spark Optimization Coding #interview #question
Переглядів 5 тис.2 місяці тому
Apache Spark 1st Technical Round Live Interview | Spark Optimization Coding #interview #question
Big Data Mock Interview for Freshers | Data Engineer Screening Round | Spark, Python, SQL #interview
Переглядів 1,9 тис.2 місяці тому
Big Data Mock Interview for Freshers | Data Engineer Screening Round | Spark, Python, SQL #interview
Live System Design Mock Interview Round for Data Engineers | Project & Scenario Based #interview
Переглядів 3 тис.2 місяці тому
Live System Design Mock Interview Round for Data Engineers | Project & Scenario Based #interview
Apache Spark 1st Technical Round Live Interview for Experienced Candidates | Azure | SQL #interview
Переглядів 4,7 тис.2 місяці тому
Apache Spark 1st Technical Round Live Interview for Experienced Candidates | Azure | SQL #interview
Live Azure Data Engineering Mock Interview | Technical Round | Out of Memory Issue | SQL #interview
Переглядів 3,4 тис.2 місяці тому
Live Azure Data Engineering Mock Interview | Technical Round | Out of Memory Issue | SQL #interview

КОМЕНТАРІ

  • @optionkingrobot
    @optionkingrobot День тому

    Really Enjoying Thanks sirji

  • @suvenduku2
    @suvenduku2 День тому

    Sir pls provide the questions in description

  • @Uda_dunga
    @Uda_dunga 2 дні тому

    If the column already exists then withcolumn update that col else it creates new column based on logic

  • @syedkamran4121
    @syedkamran4121 2 дні тому

    How many have transitioned from other role to data engineering?.. that's more interesting and important

  • @Uda_dunga
    @Uda_dunga 2 дні тому

    This is called explanation 😊

  • @rushirajkadge3995
    @rushirajkadge3995 2 дні тому

    Are row_number values correct shown at 22:00 ? I mean if we are partitioning by marks, then how can output look as shown in the video?

  • @rushirajkadge3995
    @rushirajkadge3995 2 дні тому

    The row_number values for marks are not correct (35:16). The correct output is: Marks Row_number 100 1 100 2 99 1 98 1 98 2 98 3 97 1 96 1 95 1

  • @Universalplaylist920
    @Universalplaylist920 2 дні тому

    Sir it's good advice as you always said to us.. Please give suggestions if we resign without offer is it risk ro get the first offer or how we can prepare for that..bcz of 90 days notice..

  • @maddyy1024
    @maddyy1024 3 дні тому

    does MYSQL and groomide have same features?? anyone please reply

  • @sumitmittal07
    @sumitmittal07 3 дні тому

    💻Visit my official website to make a career in Big Data- trendytech.in/?src=youtube

  • @gautampandey172
    @gautampandey172 3 дні тому

    DAG-Direct Acyclic Graph which contains the RDD states after each transformation it is only triggered when an action is called, that gives you data lineage. Stop confusing yourself and others with made up stories. DAG is not a sequence of actions!

  • @vandanapatil8182
    @vandanapatil8182 3 дні тому

    Sir konsa course Kiya tha enn sbb nee ? Fee's kitne ? Kitne months baad placement huve ? Course mode online tha ke offline ? Pls answer all this question one by one 😊 pls 🙏

    • @sumitmittal07
      @sumitmittal07 3 дні тому

      I am sharing the website link below. Please visit and raise an Inquiry. My team will connect and answer to all your queries. Website Link- trendytech.in/?src=youtube

  • @akashkhandagale7488
    @akashkhandagale7488 4 дні тому

    SQL CHAMPIONSHIP PROGRAM ke baare me batav...

    • @akashkhandagale7488
      @akashkhandagale7488 3 дні тому

      Oracle pai hai ky?

    • @sumitmittal07
      @sumitmittal07 3 дні тому

      MySQL will be used for practicing as it is relatively easier to work on and it is also a well-known one.

  • @skillhorizon
    @skillhorizon 4 дні тому

    You are doing great work. Lot of respect

  • @UjjwalSinghPal-um3pb
    @UjjwalSinghPal-um3pb 4 дні тому

    if i started learning for now than there are very less data engineering internships(if one has data internship it is easy to get a job ,and that person also get hand on experience ) ,,,,so should i do data analyst first only for internship and after that i will study for data engineering for job because it is also a good way , and i need to do an internship because it is in our college criteria , they do not support much if you do not have done internship?? "Congratulations on your well-deserved award! Your dedication and hard work have truly paid off"

  • @hdr-tech4350
    @hdr-tech4350 4 дні тому

    Date format, sum case, group by Array max occured number

  • @PiyushSingh0602
    @PiyushSingh0602 4 дні тому

    Solution for the first coding question is wrong , in both the loops they are incrementing the freq and also need to compare the length of both lists first , that'll be the base case

  • @hdr-tech4350
    @hdr-tech4350 4 дні тому

    Reverse string on every occurrence of I letter Avg of logged time

  • @skillhorizon
    @skillhorizon 4 дні тому

    Very nice content. Extremely useful

  • @user-gs8xh9ww9i
    @user-gs8xh9ww9i 5 днів тому

    like i had faced lots of similar questions and tried to answers but i noted lot of points in her explanation , very helpful for me

  • @hdr-tech4350
    @hdr-tech4350 5 днів тому

    Count the highest reportee for manager Tell all the class names who has atleast 5 students

  • @hdr-tech4350
    @hdr-tech4350 5 днів тому

    3rd txn of every user Cumulative sum of sales amount of each product id

  • @hdr-tech4350
    @hdr-tech4350 5 днів тому

    String n col name manipulation

  • @hdr-tech4350
    @hdr-tech4350 5 днів тому

    Users with max skills Remove space from col names Matrix using two list

  • @hdr-tech4350
    @hdr-tech4350 5 днів тому

    Source type, project discussion Handling duplicates Delta lake feature Spark vs dbx Power bi connect to synapse Spark architecture Dag Client mode vs cluster mode Df vs dataset Normalisation 2nd highest salary in dep

  • @pranyajain8526
    @pranyajain8526 6 днів тому

    This is amazing, very well explained Sumit Sir! Do you give career advice also?

  • @hdr-tech4350
    @hdr-tech4350 6 днів тому

    Spark core -Rdd (flexible) high level apis- Df and Spark sql (easy to write query) Transformation n action Spark submit process Deployment modes Types of transformation Repartition n coalesce Methods for schema enforcement - ddl, struct Consecutive wins in sql

  • @hdr-tech4350
    @hdr-tech4350 6 днів тому

    Java used in Hadoop Bound to work on mapreduce Can only work on batch process not real time in map reduce

  • @hdr-tech4350
    @hdr-tech4350 6 днів тому

    Data lake vs delta lake Unity catalog Data profiling Data governance

  • @hdr-tech4350
    @hdr-tech4350 6 днів тому

    Predicate pushdown What opt used in spark Transformation used Groupby n reduceby Faced oom error ? Salting Data skewness Data spillness Cache persists Lru Repartition vs coalesce Rnk densernk rno What happen submit spark job

  • @talknow2859
    @talknow2859 6 днів тому

    I definitely learnt something. Thanks.🎉

  • @gurupradeep9648
    @gurupradeep9648 7 днів тому

    first one Select name from salary_table as a where salary>(select salary from salary_table where id =a.managerid)

  • @MayankSharma-cp6yu
    @MayankSharma-cp6yu 8 днів тому

    What is the answer to the last question - 'When we align transformations and action in a DAG, what is that graph called?'

  • @abhishekn786
    @abhishekn786 9 днів тому

    Dear Sir, hope you are doing well, when can we expect the next video on Python? It's been more than 3 months now, that you haven't posted any followed video on Python. I guess everyone is eagerly waiting. Please post it asap. Thanks

  • @ANIRUDH6315
    @ANIRUDH6315 9 днів тому

    sir please upload more videos. We are waiting for the next

  • @janardhanreddy3267
    @janardhanreddy3267 9 днів тому

    interview Series are good , please upload remaining 10 questions , eagerly waiting sir

  • @user-oi5pw9ly7r
    @user-oi5pw9ly7r 9 днів тому

    Master and slave architecture we have driver node acts master node multiple worker nodes submitted spark jobs contexts of spark node - create jobs and execute plan spark cluster entry point driver will request resource manager send back to driver also do iteration of jobs

  • @VenkatBala-jv2yh
    @VenkatBala-jv2yh 10 днів тому

    Great questions....

  • @Sudeep-ow4pe
    @Sudeep-ow4pe 10 днів тому

    The interview series is really helpful, Thank you