I’m so glad to hear that this information is helpful, And if you haven’t already, please consider subscribing-it really motivates me to keep creating content that helps you on your journey. Thanks again for being a part of the community!
Who would've thought going from Microsoft to TCS would be considered rare? Embracing the change, I see!.... actually its our trainer he attended just to check the way of interview and to know the market requirement, it helps him to teach better in regular sessions...
If I have no experience in Azure Data engineering field, was in some different technology and want to switch job to azure data engineer . So what kind of interview questions and how I should prepare for that?
Hi Sayoneeray! Transitioning to an Azure Data Engineering role is a great move, and preparing for the interview is crucial. Here are some tips and types of questions to focus on: Key Areas to Prepare: Azure Fundamentals: Understand the basics of Azure services related to data engineering, such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics. Data Storage Solutions: Familiarize yourself with Azure storage options like Azure Blob Storage, Azure SQL Database, and Azure Cosmos DB. ETL Processes: Learn about Extract, Transform, Load (ETL) processes and how they work in Azure. Common Interview Questions: Azure Services: Can you explain what Azure Data Factory is and how it is used? What are the differences between Azure SQL Database and Azure Cosmos DB? Data Modeling: How would you design a data pipeline for a specific use case? Can you explain normalization and denormalization? SQL and Data Manipulation: Write a SQL query to retrieve specific data from a table. How do you optimize a query for performance? Preparation Tips: Hands-On Practice: Work on projects using Azure to get practical experience. Online Courses: Consider taking online courses focused on Azure Data Engineering to build your knowledge. Mock Interviews: Practice with mock interviews to get comfortable answering technical questions. Feel free to reach out if you have more specific questions or need resources to help with your preparation!
same person is giving interviews on this channel saying i have 4 years of ex and only one company i have worked till now and now same saying 9 years microsft wtf
Hi Sir, please be noted that, trainer attends interview to know about interview pattern. Trainer either joins the other company nor stops giving interview. As per KSR, trainer will be attending multiple interviews with difference experience. Even if you create one resume with 8 years with different number and if you create one resume with 4 years. Its obvious you too will get interview calls
Hi Aditya! You're correct! Broadcasting in data processing is indeed used to reduce shuffling. By replicating smaller tables across all nodes, it allows for more efficient joins without the need to shuffle large datasets, which can significantly improve performance. If you have any specific questions or need further clarification, feel free to ask!
Great video. @ 21:41, question What is the difference between watermark and autoscaling? I understood watermark part, but didn't understood autoscaling part. can you please explain?
Autoscaling is not directly related to autoloaders. It's a concept more commonly associated with cloud computing and infrastructure management. Here's a breakdown: Autoscaling Definition: Autoscaling is the automatic adjustment of resources, such as servers or virtual machines, to meet changing demand. This prevents underutilization of resources when demand is low and ensures sufficient capacity during peak usage. Benefits: Cost Efficiency: Reduces costs by avoiding unnecessary resource allocation. Performance: Ensures optimal performance by scaling resources up or down based on demand. Reliability: Helps maintain system stability by preventing resource bottlenecks. Common Use Cases: Web Applications: Scaling up to handle increased traffic during peak times. Batch Processing: Scaling down resources after a large processing job is complete. Real-time Analytics: Scaling up to handle incoming data streams.
Great question! In data warehousing, especially for the banking domain, the choice of tools can depend on factors like data size, complexity, and integration needs. Here are a few commonly used tools and platforms: ETL Tools: Informatica or Talend: These are widely used for extracting, transforming, and loading data from various banking systems into the data warehouse. Apache Nifi: For real-time data streaming and handling large-scale data movement. Data Warehousing Platforms: Amazon Redshift, Google BigQuery, or Snowflake: These are popular cloud-based data warehousing solutions. They are highly scalable and suitable for handling large volumes of transactional data in the banking sector. Microsoft SQL Server (with SSIS, SSAS): This is often used by banks that prefer on-premise solutions. BI Tools for Reporting: Tableau or Power BI: These tools are used to visualize data and provide insights for decision-making in the banking domain. You can also mention that depending on your organization’s infrastructure (cloud vs. on-premise), the tools can vary. I hope this gives you some direction! Feel free to ask more questions, and don’t forget to subscribe for more useful content like this-it keeps us motivated to share more insights!
Our Team will attend interviews regular to understand the market requirements, we captured those interviews for students ref.. he was not going to join for TCS . However its not wrong to join TCS from Microsoft. TCS would be the best for me ( Personally : Mahesh replying to this ) as TCS Declared no layoff even in this situation where Microsoft removed 10000 employs in this financial year. also TCS recently collaborated with Microsoft to work on few projects ( Project Bonsai). for more details.: www.tcs.com/who-we-are/newsroom/press-release/tcs-launches-new-collaboration-with-microsoft
why not ? there is lot many reasons some people joining from Big 4 companies to startups, might be better position, better salary, or some other reasons tooo. however this interview was attended my team just for our youtube purpose, we will attend initially and will recreate same questiosn and answers after the actual interview to make better experiance and to avoid any leagl issues.
Me As a Data Engineering Aspirant currently at my 4th year of college degree , Can I get into TCS as Data Engineer Role as fresher ? If yes Please tell me the steps I should take .
es, you can definitely get into TCS as a Data Engineer fresher with a 4-year college degree. TCS is a large IT company with a strong focus on data engineering and analytics, and they frequently hire freshers for their data engineering roles. Here are the steps you can take to increase your chances of getting into TCS as a Data Engineer: 1. Build a strong academic foundation: Focus on your core computer science subjects like algorithms, data structures, programming, and database systems. Aim for good grades to demonstrate your academic capabilities. 2. Acquire relevant skills: Learn programming languages like Python, SQL, and Java, which are essential for data engineering. Gain hands-on experience with data engineering tools and technologies like Hadoop, Spark, Kafka, and cloud platforms (AWS, Azure, GCP). Practice data cleaning, transformation, and analysis techniques. 3. Build projects: Work on personal projects or contribute to open-source projects to showcase your skills and practical knowledge. Choose projects that align with your interests and demonstrate your ability to solve data-related problems. 4. Participate in hackathons and coding competitions: These events provide opportunities to showcase your skills, learn from others, and network with industry professionals. 5. Network with professionals: Connect with data engineers on LinkedIn, attend industry events, and participate in online forums to learn from experienced professionals. Building relationships can provide valuable insights and potential job opportunities. 6. Apply to TCS through their campus recruitment process: Keep an eye out for TCS's campus recruitment drives and attend their presentations and workshops. Prepare for the technical and aptitude tests, as well as the interview rounds. 7. Highlight your skills and projects in your resume and cover letter: Tailor your resume and cover letter to highlight your relevant skills, projects, and experiences. Emphasize your passion for data engineering and your ability to contribute to TCS's data-driven initiatives. 8. Be prepared for the interview: Research TCS's data engineering projects and initiatives to demonstrate your knowledge and interest. Practice answering common data engineering interview questions, such as data cleaning techniques, SQL queries, and problem-solving scenarios. Remember, the competition for data engineering roles can be high. By following these steps and continuously developing your skills, you can increase your chances of securing a position at TCS as a Data Engineer fresher.
That's a valid point. While Notepad is a basic text editor, it might not be the most efficient tool for coding in 2023, especially for larger projects or complex tasks. will try to use in future
yup looks funnly only ... however it may happens some time.. as the same guy now working for KSR, and we are woeking to gether to develop an AI based product for conducting Mock interviews. some people resigned to their bigger MNC companies and started thier own and make those as Bigger gaints and competitors for their previus org. Ex: SAP Labs. 5 former emplyes left IBM and started this org.. Even Microsoft sold its OS to IBM to use in IBM computers and taken fee as Royalty In 1985, IBM requested Microsoft to develop a new operating system for their computers called OS/2. Microsoft produced that operating system, but also continued to sell their own alternative, which proved to be in direct competition with OS/2. Microsoft Windows eventually overshadowed OS/2 in terms of sales. When Microsoft launched several versions of Microsoft Windows in the 1990s, they had captured over 90% market share of the world's personal computers. even if we have offers from Microsoft and IBM mostly we prefer to go to IBM only. so time can change everything . lastly Microsoft Revenue for the year 2022 was $198.270 billion where tata groups Revenue was $150 billion. not too less and might be not as a competitors Thank you
@@KSRDatavizon That is a detailed reply. Although, No applicant would care about the company's history/past or future. An individual will always look at how much the company is paying him/her rather than how big is the company or what is their annual turn over. TCS is a service based company with a huge employee count, So the pay will always be less than the market standards. Coming back to the topic, I again ask - Microsoft to TCS? Really? lol
Crap interview. Even college graduates will ask questions better. I am azure data engineer and he did even touch the surface of data engineering and other cloud services.
Thank you for your feedback, its mock Interview, we want to make sure how much reality we can expect, we are taking the same questions that asked in a company and trying to re construct the process. during this time we are trying to act as a aspirant, how much tence he may have too.
Very informative.. it is very useful for Data engineers from Beginner to Intermediate level. Thank you brother keeping sharing videos like this..
Thanks and welcome
Keep posting. Learning so much from your channel. Thanks
Hey Vision Board; Thank You for Your valuable Feeback.! will keep updating with the latest content more and more.!
It was really helpful for the candidates who are preparing for the data engineering interview
I’m so glad to hear that this information is helpful, And if you haven’t already, please consider subscribing-it really motivates me to keep creating content that helps you on your journey. Thanks again for being a part of the community!
9 yrs exp, working in MS and you are asking total sales by country in SQL?
😂😂😂
The guy is a proxy 😂
From this to incremental load , spark cluster RDD etc...that escalated quickly I guess 😂
Yes, everything is misleading I guess
@@callmeruks😂😂😂
This is one of the best interview I have come across 🔥
thanks a lot
@@KSRDatavizon very nice , what i can say honestly if u wanna value tats most valuable series
Best Interactive Inteview
Thank You
From Microsoft to tcs rare
Who would've thought going from Microsoft to TCS would be considered rare? Embracing the change, I see!.... actually its our trainer he attended just to check the way of interview and to know the market requirement, it helps him to teach better in regular sessions...
Really Nice answers, I think Interviewer from Telugu States
Thank you so much for your kind words! Please subscribe our channel for regular updates and its motivates us a lot
Very Helpful👍👍
Glad to hear that
If I have no experience in Azure Data engineering field, was in some different technology and want to switch job to azure data engineer . So what kind of interview questions and how I should prepare for that?
Hi Sayoneeray! Transitioning to an Azure Data Engineering role is a great move, and preparing for the interview is crucial. Here are some tips and types of questions to focus on:
Key Areas to Prepare:
Azure Fundamentals: Understand the basics of Azure services related to data engineering, such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
Data Storage Solutions: Familiarize yourself with Azure storage options like Azure Blob Storage, Azure SQL Database, and Azure Cosmos DB.
ETL Processes: Learn about Extract, Transform, Load (ETL) processes and how they work in Azure.
Common Interview Questions:
Azure Services:
Can you explain what Azure Data Factory is and how it is used?
What are the differences between Azure SQL Database and Azure Cosmos DB?
Data Modeling:
How would you design a data pipeline for a specific use case?
Can you explain normalization and denormalization?
SQL and Data Manipulation:
Write a SQL query to retrieve specific data from a table.
How do you optimize a query for performance?
Preparation Tips:
Hands-On Practice: Work on projects using Azure to get practical experience.
Online Courses: Consider taking online courses focused on Azure Data Engineering to build your knowledge.
Mock Interviews: Practice with mock interviews to get comfortable answering technical questions.
Feel free to reach out if you have more specific questions or need resources to help with your preparation!
It was really great.
Thank you! Cheers! Please share with your friends too. and subscribe our channel
same person is giving interviews on this channel saying i have 4 years of ex and only one company i have worked till now and now same saying 9 years microsft wtf
Hi Sir, please be noted that, trainer attends interview to know about interview pattern. Trainer either joins the other company nor stops giving interview. As per KSR, trainer will be attending multiple interviews with difference experience. Even if you create one resume with 8 years with different number and if you create one resume with 4 years. Its obvious you too will get interview calls
its great interview plz cover a more video with specific azure questions like adf , databricks ,adls,blob
!
We will! thank you for supporting, please subscribe our channel for regular updates
Thanks for the video. Can u make video on data engineer interview for fresh data science graduate
You are most welcome, Please subscribe our channel, it motivates a lot
Good one but looks like only touching high level concepts didn't ask tougher or in depth questions.
will make another interview session
It was really great.
Thank you
Pyspark use case won't work. Which dataframe its gonna aggregate. Syntax also not correct.
I think broadcast is used to reduce shuffiling
correct
Hi Aditya! You're correct! Broadcasting in data processing is indeed used to reduce shuffling. By replicating smaller tables across all nodes, it allows for more efficient joins without the need to shuffle large datasets, which can significantly improve performance. If you have any specific questions or need further clarification, feel free to ask!
Great video. @ 21:41, question What is the difference between watermark and autoscaling? I understood watermark part, but didn't understood autoscaling part. can you please explain?
Very helpful 👌 ☺ 🙂 👏
Glad to hear.. Thanks
SQL can be case sensitive, if you choose the case sensitive option while installing SSMS
Thank you,
Correct
Who gives a crap? You want a developer who can think and develop. Not some monkey who can memorize how many hairs are in his arm pit.
@@joev5336 Better than a donkey when he gets error when he is writing queries in lower case and getting issues and thinking what he developed wrong
Thanks for sharing
I'm glad you found the content helpful! please subscribe our channel for regular updates and it motivates us
This is more of Databricks specific
yes mam it depends on job requirement.
thanks for the video
You're welcome, please subscribe our channel for regular updates
Awesome bro
You are most welcome, Please subscribe our channel, it motivates a lot
million thanks
Thank you so much, Please subscribe our channel for regular updates and it motivates us a lot.
The interviewer is from TCS and Interviewee from Microsoft.
Hi Sir !! from ksr perspective, trainers attends interview regularly to understand what types of questions will be asked.
Auto scaling is something related to the node allocation right? Is it about autoloader?
Autoscaling is not directly related to autoloaders. It's a concept more commonly associated with cloud computing and infrastructure management.
Here's a breakdown:
Autoscaling
Definition: Autoscaling is the automatic adjustment of resources, such as servers or virtual machines, to meet changing demand. This prevents underutilization of resources when demand is low and ensures sufficient capacity during peak usage.
Benefits:
Cost Efficiency: Reduces costs by avoiding unnecessary resource allocation.
Performance: Ensures optimal performance by scaling resources up or down based on demand.
Reliability: Helps maintain system stability by preventing resource bottlenecks.
Common Use Cases:
Web Applications: Scaling up to handle increased traffic during peak times.
Batch Processing: Scaling down resources after a large processing job is complete.
Real-time Analytics: Scaling up to handle incoming data streams.
Well explained
Thank you so much, Please subscribe our channel for regular updates.
EXCELLENT
Thank you so much, Please subscribe our channel for regular updates and it motivates us a lot.
But I have a question for the data warehousing, which tool you are using in the same scenario
Great question! In data warehousing, especially for the banking domain, the choice of tools can depend on factors like data size, complexity, and integration needs. Here are a few commonly used tools and platforms:
ETL Tools:
Informatica or Talend: These are widely used for extracting, transforming, and loading data from various banking systems into the data warehouse.
Apache Nifi: For real-time data streaming and handling large-scale data movement.
Data Warehousing Platforms:
Amazon Redshift, Google BigQuery, or Snowflake: These are popular cloud-based data warehousing solutions. They are highly scalable and suitable for handling large volumes of transactional data in the banking sector.
Microsoft SQL Server (with SSIS, SSAS): This is often used by banks that prefer on-premise solutions.
BI Tools for Reporting:
Tableau or Power BI: These tools are used to visualize data and provide insights for decision-making in the banking domain.
You can also mention that depending on your organization’s infrastructure (cloud vs. on-premise), the tools can vary. I hope this gives you some direction! Feel free to ask more questions, and don’t forget to subscribe for more useful content like this-it keeps us motivated to share more insights!
Best interview
Thank You so much
When we assign structure to data frame it becomes dataset. I was under this impression can anyone correct me?
Dataframe is a dataset[row]
could you please share any interview questions with 2 years of experience
blog.ksrdatavision.com/interview-questions/ Please follw this link for more details.
Are interviews usually done this way? I have done mostly q and a with a small project that they ask me to do.
Interviews can vary a lot depending on the company and role, so it's great that you're getting different experiences!
Why Microsoft guy will com to TCS..
Our Team will attend interviews regular to understand the market requirements, we captured those interviews for students ref.. he was not going to join for TCS . However its not wrong to join TCS from Microsoft.
TCS would be the best for me ( Personally : Mahesh replying to this ) as TCS Declared no layoff even in this situation where Microsoft removed 10000 employs in this financial year.
also TCS recently collaborated with Microsoft to work on few projects ( Project Bonsai).
for more details.:
www.tcs.com/who-we-are/newsroom/press-release/tcs-launches-new-collaboration-with-microsoft
@@KSRDatavizon this is for Students ref... that's all..
Tcs never lay off
It's like govt job..in pvt sector😅
Security
why would someone to jump from Microsoft to TCS ??
why not ? there is lot many reasons some people joining from Big 4 companies to startups, might be better position, better salary, or some other reasons tooo.
however this interview was attended my team just for our youtube purpose,
we will attend initially and will recreate same questiosn and answers after the actual interview to make better experiance and to avoid any leagl issues.
Is this a real technical interview experience never seen they put it across youtube platforms?
Thank you for watching! I'm glad you found the content interesting.
How many years of experience we can expect these types of questions?
4-7 years
Is there any ADF engineer job profiles exist in ADE, because i don't know python, pyspark, i know only sql and ADF
Pyspark is more in demand
python, pyspark and sql is mandatory. pandas and numpy can be optional
Me As a Data Engineering Aspirant currently at my 4th year of college degree , Can I get into TCS as Data Engineer Role as fresher ? If yes Please tell me the steps I should take .
es, you can definitely get into TCS as a Data Engineer fresher with a 4-year college degree. TCS is a large IT company with a strong focus on data engineering and analytics, and they frequently hire freshers for their data engineering roles.
Here are the steps you can take to increase your chances of getting into TCS as a Data Engineer:
1. Build a strong academic foundation:
Focus on your core computer science subjects like algorithms, data structures, programming, and database systems.
Aim for good grades to demonstrate your academic capabilities.
2. Acquire relevant skills:
Learn programming languages like Python, SQL, and Java, which are essential for data engineering.
Gain hands-on experience with data engineering tools and technologies like Hadoop, Spark, Kafka, and cloud platforms (AWS, Azure, GCP).
Practice data cleaning, transformation, and analysis techniques.
3. Build projects:
Work on personal projects or contribute to open-source projects to showcase your skills and practical knowledge.
Choose projects that align with your interests and demonstrate your ability to solve data-related problems.
4. Participate in hackathons and coding competitions:
These events provide opportunities to showcase your skills, learn from others, and network with industry professionals.
5. Network with professionals:
Connect with data engineers on LinkedIn, attend industry events, and participate in online forums to learn from experienced professionals.
Building relationships can provide valuable insights and potential job opportunities.
6. Apply to TCS through their campus recruitment process:
Keep an eye out for TCS's campus recruitment drives and attend their presentations and workshops.
Prepare for the technical and aptitude tests, as well as the interview rounds.
7. Highlight your skills and projects in your resume and cover letter:
Tailor your resume and cover letter to highlight your relevant skills, projects, and experiences.
Emphasize your passion for data engineering and your ability to contribute to TCS's data-driven initiatives.
8. Be prepared for the interview:
Research TCS's data engineering projects and initiatives to demonstrate your knowledge and interest.
Practice answering common data engineering interview questions, such as data cleaning techniques, SQL queries, and problem-solving scenarios.
Remember, the competition for data engineering roles can be high. By following these steps and continuously developing your skills, you can increase your chances of securing a position at TCS as a Data Engineer fresher.
Thanks for the catch 🤣
you are welcome, please subscribe our channel for regular updates
Will there be a Data Structures and Algorithms technical round like in SDE interviews when I apply for Azure Data Engineer?
No
If u applying for product based company.. u may encounter
It doesn't make sense to work in Notepad in 2023. Maybe dump Windows, and get a Linux desktop. Then use an AI IDE.
That's a valid point. While Notepad is a basic text editor, it might not be the most efficient tool for coding in 2023, especially for larger projects or complex tasks. will try to use in future
Everything asked about databricks
yes.. its critical developing pipeline
Bhai scripted lag Raha hai
Yes it's scripted, I think they have mentioned TCS just to have mass views.
Hope this session may helpful for your practice and attend for interviews. Thank you
Hope this session may helpful for your practice and attend for interviews. Thank you
Bhai, it's better than your fresher guy interview
I do not think this guy is really working in Microsoft. In most of the cases instead of how l. He is explaining what
He is fooling 😂
@@saucyy2406 he is contract employee like me
It’s just mock -
this is mock interview. posted this for understand way of explaination
this is mock interview. posted this for understand way of explaination
First of all this is not interview 2 people are discussing this topics like interview
Microsoft to TCS? Really? lol
yup looks funnly only ... however it may happens some time..
as the same guy now working for KSR, and we are woeking to gether to develop an AI based product for conducting Mock interviews. some people resigned to their bigger MNC companies and started thier own and make those as Bigger gaints and competitors for their previus org. Ex: SAP Labs. 5 former emplyes left IBM and started this org..
Even Microsoft sold its OS to IBM to use in IBM computers and taken fee as Royalty In 1985, IBM requested Microsoft to develop a new operating system for their computers called OS/2. Microsoft produced that operating system, but also continued to sell their own alternative, which proved to be in direct competition with OS/2. Microsoft Windows eventually overshadowed OS/2 in terms of sales. When Microsoft launched several versions of Microsoft Windows in the 1990s, they had captured over 90% market share of the world's personal computers.
even if we have offers from Microsoft and IBM mostly we prefer to go to IBM only.
so time can change everything .
lastly
Microsoft Revenue for the year 2022 was $198.270 billion
where tata groups Revenue was $150 billion. not too less and might be not as a competitors
Thank you
@@KSRDatavizon That is a detailed reply. Although, No applicant would care about the company's history/past or future. An individual will always look at how much the company is paying him/her rather than how big is the company or what is their annual turn over. TCS is a service based company with a huge employee count, So the pay will always be less than the market standards. Coming back to the topic, I again ask - Microsoft to TCS? Really? lol
Not a genuine interview
As it was give n by working professionals to books your confidence the real time questions we presented here to make you more confidant.
Hello men can u plz suggest where am get genuine interview like channel or video
Crap interview. Even college graduates will ask questions better. I am azure data engineer and he did even touch the surface of data engineering and other cloud services.
please be informed that its round 1.. also each panel will have different way of evaluating
When will H1s get sent back home in bulk??
It seems both are lacking depth knowledge
Thank you for your feedback, its mock Interview, we want to make sure how much reality we can expect, we are taking the same questions that asked in a company and trying to re construct the process. during this time we are trying to act as a aspirant, how much tence he may have too.
THIS IS FAKE USELESS INTERVOEW...I WILL REPORT YOU FOR THIS BASELESS FAKE INTERVIEW...😡🤬👎🏻