- Видео 134
- Просмотров 58 943
Data Architect Studio
Индия
Добавлен 18 мар 2023
About: I'm a Data Architect with 12+ yrs of experience.
Welcome to Data Architect Studio, your ultimate destination for mastering the art of Data Engineering and Cloud Architecture! Whether you're preparing for interviews, pursuing certifications, or looking to build cutting-edge data pipelines in cloud services like AWS, Azure, and Google Cloud, this channel is your go-to resource.
We cover:
In-depth tutorials on data engineering concepts and tools like SQL, Python, and Spark.
Best practices for designing scalable, optimized data architectures.
Real-world projects on building data pipelines, automation, and production workflows.
Practical tips for optimizing cloud costs and boosting performance.
Insights into resolving common production and product issues in large-scale data systems.
Regular SQL quizzes and interview prep sessions to keep your skills sharp.
You can mail me on sudhakarbd2021@gmail.com
Welcome to Data Architect Studio, your ultimate destination for mastering the art of Data Engineering and Cloud Architecture! Whether you're preparing for interviews, pursuing certifications, or looking to build cutting-edge data pipelines in cloud services like AWS, Azure, and Google Cloud, this channel is your go-to resource.
We cover:
In-depth tutorials on data engineering concepts and tools like SQL, Python, and Spark.
Best practices for designing scalable, optimized data architectures.
Real-world projects on building data pipelines, automation, and production workflows.
Practical tips for optimizing cloud costs and boosting performance.
Insights into resolving common production and product issues in large-scale data systems.
Regular SQL quizzes and interview prep sessions to keep your skills sharp.
You can mail me on sudhakarbd2021@gmail.com
Snowflake Interview Questions and answers for 3-9 years Experienced | Data Engineer | Much Watch |P2
If you are preparing for snowflake Interview, this video is for you Snowflake Interview Questions for 3-9 years Experienced professionals. Prepare for your next Snowflake interview with these must-know questions and answers! This video covers:
Snowflake interview questions and answers.
Snowflake admin interview questions.
AWS Snowflake interview prep for Data Engineers, including Athena, Glue, and SQL.
snowflake full tutorial
crack any snowflake interview
Snowflake integration with AWS S3.
Advanced AWS interview questions for experienced professionals.
Snowflake testing interview questions and answers.
Common Snowflake questions and answers for all roles.
Snowflake solution architect interview que...
Snowflake interview questions and answers.
Snowflake admin interview questions.
AWS Snowflake interview prep for Data Engineers, including Athena, Glue, and SQL.
snowflake full tutorial
crack any snowflake interview
Snowflake integration with AWS S3.
Advanced AWS interview questions for experienced professionals.
Snowflake testing interview questions and answers.
Common Snowflake questions and answers for all roles.
Snowflake solution architect interview que...
Просмотров: 142
Видео
Snowflake Interview Questions and answers for 3-9 years Experienced | Data Engineer | Much Watch P1
Просмотров 202День назад
If you are preparing for snowflake Interview, this video is for you Snowflake Interview Questions for 3-9 years Experienced professionals. Prepare for your next Snowflake interview with these must-know questions and answers! This video covers: Snowflake interview questions and answers for 3 years experience Snowflake admin interview questions. snowflake tutorials for cracking interview must wat...
pyspark data engineer interview questions and answers || 3-7 years || Cache vs persist
Просмотров 36714 дней назад
pyspark data engineer interview questions and answers || 3-7 years || Cache vs persist
spark data engineer interview questions and answers | 3-7 years | Job Optimizations | p-3
Просмотров 27514 дней назад
spark data engineer interview questions and answers | 3-7 years | Job Optimizations | p-3
spark data engineer interview questions and answers | 3 to 7 years | Data frame vs dataset | p-2
Просмотров 41121 день назад
spark data engineer interview questions and answers | 3 to 7 years | Data frame vs dataset | p-2
spark data engineer interview questions and answers | 3 to 7 years | Dataframe vs dataset
Просмотров 1 тыс.21 день назад
spark data engineer interview questions and answers | 3 to 7 years | Dataframe vs dataset
AWS Data Engineer Interview Questions for Experienced || 5 - 9 years || System design round
Просмотров 243Месяц назад
AWS Data Engineer Interview Questions for Experienced || 5 - 9 years || System design round
Snowflake Interview Questions for 7 years Experienced || Data Engineer || Data modeling
Просмотров 683Месяц назад
Snowflake Interview Questions for 7 years Experienced || Data Engineer || Data modeling
Snowflake Interview Questions and Answers for experienced - Data Engineer || SQL || scenario based
Просмотров 690Месяц назад
Snowflake Interview Questions and Answers for experienced - Data Engineer || SQL || scenario based
Snowflake Interview Questions and Answers - Data Engineer | Athena, Glue, SQL
Просмотров 756Месяц назад
Snowflake Interview Questions and Answers - Data Engineer | Athena, Glue, SQL
Azure Data Engineer Interview Questions and Answers - II | 3 - 9 Years | Live Experience | Product
Просмотров 2,3 тыс.Месяц назад
Azure Data Engineer Interview Questions and Answers - II | 3 - 9 Years | Live Experience | Product
Azure Data engineer Interview Questions and Answers | Live Experience | 3-9 Years | Experienced
Просмотров 4 тыс.Месяц назад
Azure Data engineer Interview Questions and Answers | Live Experience | 3-9 Years | Experienced
Data Engineer Interview Questions and Answers | Scenario based | AWS
Просмотров 640Месяц назад
Data Engineer Interview Questions and Answers | Scenario based | AWS
Senior Data Engineer Live Interview questions and answers || spark || SQL || data analysts
Просмотров 560Месяц назад
Senior Data Engineer Live Interview questions and answers || spark || SQL || data analysts
Data Engineer Live Interview Experience | 3-9 Years | Spark, Python, SQL | DSA
Просмотров 1,1 тыс.2 месяца назад
Data Engineer Live Interview Experience | 3-9 Years | Spark, Python, SQL | DSA
Data Engineer Live Interview Experience | 3-9 Years | Spark, Python, SQL | Product-Based
Просмотров 16 тыс.2 месяца назад
Data Engineer Live Interview Experience | 3-9 Years | Spark, Python, SQL | Product-Based
How to handle 3 months notice period in telugu | no calls problem
Просмотров 2002 месяца назад
How to handle 3 months notice period in telugu | no calls problem
Spark Performance tuning with Advanced Optimization Techniques | EMR | speed
Просмотров 6213 месяца назад
Spark Performance tuning with Advanced Optimization Techniques | EMR | speed
Which cloud Should learn for better career growth | AWS | Azure | GCP | trending and Booming
Просмотров 133Год назад
Which cloud Should learn for better career growth | AWS | Azure | GCP | trending and Booming
most expensive mistakes ever in production database | Don't do in production
Просмотров 66Год назад
most expensive mistakes ever in production database | Don't do in production
What is Cloud computing🔥 | cloud engineer | Azure| AWS | GCP 👍| How to become cloud data engineer
Просмотров 84Год назад
What is Cloud computing🔥 | cloud engineer | Azure| AWS | GCP 👍| How to become cloud data engineer
What is chatgpt 2023 || what is ai || in telugu
Просмотров 38Год назад
What is chatgpt 2023 || what is ai || in telugu
IT Appraisal Process | Low Rating | End of March
Просмотров 39Год назад
IT Appraisal Process | Low Rating | End of March
What is Data Engineering 👍 | Use cases 😍 | High demand | High Pay 🔥
Просмотров 175Год назад
What is Data Engineering 👍 | Use cases 😍 | High demand | High Pay 🔥
Mass Layoffs 2024: Billable vs Non-Billable | 10 Tips to Avoid Layoffs & Protect Your Job
Просмотров 996Год назад
Mass Layoffs 2024: Billable vs Non-Billable | 10 Tips to Avoid Layoffs & Protect Your Job
Master Binary Tree SQL Queries | Complex SQL Problem Solved | Data Engineering Interview
Просмотров 70Год назад
Master Binary Tree SQL Queries | Complex SQL Problem Solved | Data Engineering Interview
How to Remove duplicated pairs| Tricky | SQL Problem
Просмотров 105Год назад
How to Remove duplicated pairs| Tricky | SQL Problem
Swap Two Records in SQL Table | Tricky SQL Interview Problem Explained
Просмотров 118Год назад
Swap Two Records in SQL Table | Tricky SQL Interview Problem Explained
Tricky sort | Data engineer | SQL Problem Statement | SQL Quiz
Просмотров 126Год назад
Tricky sort | Data engineer | SQL Problem Statement | SQL Quiz
Parquet with snappy
Yes, correct
Thanks for the content ❤
Thank you
Superb amazing!
Thank you !!!
Great analysis, thank you! I have a quick question: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How can I transfer them to Binance?
Great content, as always! A bit off-topic, but I wanted to ask: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How can I transfer them to Binance?
Appreciate the detailed breakdown! I need some advice: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). Could you explain how to move them to Binance?
Due to the high level competition, Nowadays companies take a interview for data engineer but don't hire the candidate. 😅😅😅😅
@Parwez_Irani : Yes, some ghost hiring is happening now but it will be good for job seekers if they use this opportunity to give some mock with free of cost. 😊
@DataArchitectStudio No it's called the worst scenario of job market in india. Even some manager gave me a feedback lthat you have a more knowledge so we can't hire you 😅😅😅 wtf. Sometimes HR gave me a feedback that if others candidates ready to work in 4lpa then why you demand 6lpa😅😅. Even the HR know that I spent around 1.5lakhs for courses and also do a hardwork but they just told us we don't care. Even some hiring happening on nepotism. Nowadays Nepotism is on a peak level in Utt*r Pradesh and B*haris. Utt*r Pradesh and B*haris are just ingest their people fraudulently and even you can see them in every corporate due to the nepotism.
@@Bhavik_P89 Thanks for brining up. That's really bad. I didn't came across this. Please try to target the product based companies, they prefer talent over budget or anything and also be Active in LinkedIn to know more updates about job markets. Please share the your profile to me, I will forward if i find any opportunity for you. Don't worry , Never give up. companies can survive with talent not based on nepotism 👍
i come to know how to explain to the Panel and how to impress panel.
Wow, that's great 👍
Delta tables relay on the parquet files? Isn't it delta format ? (Delta format is built ontop of parquet) But he said that way, is it ryt?
Delta tables stores the data in parquet file formats and along with the transaction logs in json format which is called delta format in Lake House world
group by not needed
@sunnyraut3243: Thanks for keen observation. some databases throws error but some can't. 👍
Great session to learn concept in deep from interview perspective
Glad you found it helpful for your interview prep!
So you Got 28 LPA with these questions 🤣
@ramswaroop1520: Thank you for commenting. To Answer the your Question, Yes, It seems silly but fundamental questions are always important because that can tells how well you understand the technology or tool. In fact some of these questions were asked even in my 75 LPA offer as well :)
@@DataArchitectStudio you are doing great work by helping community through interview question, keep posting and don’t focus on negative comments much
Very good information on pyspark
Appreciate it! PySpark is definitely a key skill in data engineering.
useful expecting more azure data engineer interviews
@DGVlogsss: Thank you ! Azure Data engineering Interviews also in Queue. Please keep an eye :)
Informative
@VamsiKrishna-dy8ww: Thank you !
Baap
@altamashqureshi3935 - Thanks for commenting. glad you find this informative
@ please make project or domain specific interviews like for finance , or advertising or healthcare. Will be very interesting and informative
how can i give mock interviews on kafka ?
@pralhadgadlegave2287 : Thanks for checking my channel. I'm not take taking any mock interviews at this time. will plan for it soon and invite you
The Kafka Interview was a bit easy to compare other technologies ,even if I don't have experience on that tool I cracked 5 interviews
@@Shivakumar-367can you suggest some important Topics?
@@Shivakumar-367 how we can connect?
@@Shivakumar-367 that's true but there can be hard level questions also depends on the experience range and role. mostly for data engineering the question will be easy to medium level.
snowflake does not support indexes rgt?
Yes, that's correct. Developers need not to worry about managing Indexes...
Which cloud have more job opportunities in current market aws or Azure.
Azure has good market but Managers can also hire if candidate has strong engineering skills + any cloud
Bro I had good knowledge on azure and basic knowledge aws data engineering but I write queries for data analytics and data science and pyspark optimisations that I have done on emr and synapse analytics and glue how much salary can I expect know a days I don’t know what is the current market trends so please reply for this text and according to this issue and make video
@nagaharshavardhan8778 : Thanks for checking my channel. to answer your question, I want to know few details from you like what is your experience in data engineering and what is your current pay and what companies that you target ? also, package will depends on the market conditions and role priority... many things included.
Very useful video and please do a video on how to explain project in interviews if possible
Sure, added this request to my backlog sprints 😊
An insightful video sir, I liked the video and subscribed ur channel for more such videos...thank you
Thanks for subscribing, I'll keep making more videos like this!
Great job, thanks for sharing, keep Posting such helpful more and more,I have one question Does snowflake having indexing when you are already using Cluster keys?
No, snowflake does not allow users to create indexes but internally maintain for reach micro partitions. developers can choose cluster keys wisely to get better performance
Where is the answer?
@isharkpraveen - you can do this using multiple ways but most simple less effort way is to by using Athena. Depends on your pipeline and use case, you can choose other services also like Glue or EMR or Lambda.
Thank you for sharing and it was so useful
Glad it was helpful!
Experience?
This interview questions asked for 8 yrs experience candidate and I have filtered above questions which are common for all levels of experience.
I really appreciate your efforts! I have a quick question: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
Hi @BrianJackson-y5l - Thanks for checking my channel but I didn't understand the Question. was it related to Data Engineering questions ?
Very informative 🎉
Glad it was helpful!
Hoping for more aws mock interview with scenerio based
@prasadmuthyala9625 Sure, will upload more scenario based and tricky questions....
Very helpful, thanks for the clear explanation. You really help people having experience and struggling to upskill in their DE roles. Please keep up the good work, guys you can reach out to him over his email id mentioned in bio.( Channel description )
Appreciate the feedback, I'll keep making more videos to help people in their DE journey!
Thankyou sir this will help me alot
Glad that you find this helpful, for these scenarios add as much info as you have to clear the interview.
Hi, Can you suggest some resources from which I can learn pyspark and data warehousing concepts
@prithvirajkumarnaidukt8662 you can refer this website for pyspark learning -coding side sparkbyexamples.com/pyspark-tutorial/ -- this is good to start with.
with cte as( select numbers.*,ROW_NUMBER()OVER() as x1,'A' as val FROM numbers where ID>=0 ORDER BY ID ),cte1 as( select numbers.*,ROW_NUMBER()OVER() as x2,'b' as val FROM numbers where ID<0 ORDER BY ID ),cte2 as( select * FROM cte UNION select * FROM cte1 ) select ID FROM cte2 ORDER BY val,x1;
@HARSHRAJ-gp6ve good but always think for simple solution. Hint: CASE WHEN statement comes handy in these scenarios.
we all with you
@janauppara Thank you
do keep Posting videos
@janauppara Sure, will post more video in coming days
I learned something new today! Thanks for the knowledge share❤
I'm glad you found it helpful!
I think is AQE handles the dynamic partitioning right
Yes , infact it's handle better than humans as we have seen 10X performance improvement when we didn't give partition count.
Hi, how can I contact you for Mentorship, I need an sr de to guide me in my interview prep. , tried all possible ways but no contact details mentioned
@srinirow5808 Thanks for checking my channel. Please mail me on sudhakarbd2021@gmail.com
Hi, how can I contact you for Mentorship, I need a sr guidance in my interview prep. , tried all possible ways but no contact details mentioned
@srinirow5808 Thanks for checking my channel. You can mail me on sudhakarbd2021@gmail.com
great video
Glad you liked it!
Thanks for sharing
You're welcome, glad you found it helpful!
Bro can you upload subtitle in english. I can't understand telugu.
Sure, will upload English subtitles
@@DataArchitectStudio I am eagerly waiting. Please confirm once it is done. Thanks a lot
@@chandanpatra1053 Apologies for the delay. Could you please share your email address, will send you the subject shared in the above video
Since email is personal . Will it be a right thing if I share here publicly. Is there any other way where I can share with you
@chandanpatra1053 you can share to this mail : sudhakarbd2021@gmail.com
super
Super information
Thanks, glad you found it helpful!
Thanks for sharing learned advanced techniques in Bigdata processing
You're welcome, glad you found it useful!
Good information..
Glad you found it helpful!
Nice information
Thanks
Informative video 👍
Glad you found it helpful!
a null can not be joined with other null so in inner join there should be just 7 records
Yeah, for Inner Join the output should be 7, not 8. Thanks for identifying.
Knowledge hai toh roh video banoa galat video dalkr confuse mat kro atleast changes krkr video upload kro
@Tushar-t1r Thank you for your feedback! I appreciate your concern and this has already identified and replied in the comments.