Add office photos
i
TCS
Compare
Filter interviews by
TCS Azure Data Engineer Interview Questions and Answers for Experienced
TCS Azure Data Engineer Interview Experiences for Experienced
4 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Various performance optimization techniques in Databricks
(2 Questions)
- Q1. Rdd vs dataframe
- Ans.
RDD is a basic abstraction in Spark representing data as a distributed collection of objects, while DataFrame is a distributed collection of data organized into named columns.
RDD is more low-level and less optimized compared to DataFrame
DataFrames are easier to use for data manipulation and analysis
DataFrames provide a more structured way to work with data compared to RDDs
RDDs are suitable for unstructured data process...
- Q2. Adf triggers and connectors
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. About the project architecture
- Q2. Joins,views,scenario based questions. Focused on basics
Interview Preparation Tips
- Adf
- databricks
- SQL
What people are saying about TCS
Anirudha Khandagale
I was interviewed in Mar 2024.
(1 Question)
- Q1. How do you read files in notebook What are configuration needed to read data Why you have not used adf trigger only What is parquet format Window functions vs group by How to read a CSV file and store it i...
- Ans.
Reading files in notebook, configuring data, using ADF trigger, parquet format, window functions vs group by, reading CSV file and storing in parquet, dataset vs dataframe, transformations, delta lake
To read files in notebook, use libraries like pandas or pyspark
Configuration needed includes specifying file path, format, and any additional options
ADF trigger can be used for automated data processing, but may not be nec...
Skills evaluated in this interview
TCS interview questions for designations
Interview questions from similar companies
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(5 Questions)
- Q1. Project Architecture, spark transformations used?
- Ans.
The project architecture includes Spark transformations for processing large volumes of data.
Spark transformations are used to manipulate data in distributed computing environments.
Examples of Spark transformations include map, filter, reduceByKey, join, etc.
- Q2. Advanced SQL questions - highest sales from each city
- Ans.
Use window functions like ROW_NUMBER() to find highest sales from each city in SQL.
Use PARTITION BY clause in ROW_NUMBER() to partition data by city
Order the data by sales in descending order
Filter the results to only include rows with row number 1
- Q3. Data modelling - Star schema, Snowflake schema, Dimension and Fact tables
- Q4. Databricks - how to mount?
- Ans.
Databricks can be mounted using the Databricks CLI or the Databricks REST API.
Use the Databricks CLI command 'databricks fs mount' to mount a storage account to a Databricks workspace.
Alternatively, you can use the Databricks REST API to programmatically mount storage.
- Q5. Questions on ADF - pipeline used in the project
(1 Question)
- Q1. Questions on Databricks - optimizations, history, autoloader, liquid clustering, autoscaling
Skills evaluated in this interview
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Pyspark questions
- Q2. SQL queries based on join , case and row to column changes
Interview Preparation Tips
- Azure
- pyspark
- sql join
pooja
I was interviewed in May 2024.
(2 Questions)
- Q1. What is copy activity
- Ans.
Copy activity is a tool in Azure Data Factory used to move data between data stores.
Copy activity is a feature in Azure Data Factory that allows you to move data between supported data stores.
It supports various data sources and destinations such as Azure Blob Storage, Azure SQL Database, and more.
You can define data movement tasks using pipelines in Azure Data Factory and monitor the progress of copy activities.
- Q2. Data bricks architecture
Skills evaluated in this interview
(1 Question)
- Q1. Multiple Question on Azure services like Databricks, ADF, Delta Lake, Blob Storage, How to connect with Azure SQL.
I applied via Naukri.com and was interviewed in Oct 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. 1) Online hackathon test. 2) Azure ADF, Databricks, Spark and python(enough for big data) knowledge. 3) SQL Advance(Analytical Fun)
Interview Preparation Tips
It was a SQL-related question that required you to solve the problem.
Interview Preparation Tips
TCS Interview FAQs
The duration of TCS Azure Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Ninja Interview Questions
- TCS Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Azure DevOps Engineer Interview Questions
- Azure Administrator Interview Questions
- Azure Developer Interview Questions
- Azure Cloud Engineer Interview Questions
- Azure Cloud Administrator Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Show more
TCS Azure Data Engineer Interview Process for Experienced
based on 4 interviews in last 1 year
Interview experience
People are getting interviews through
Azure Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
TCS Azure Data Engineer Reviews and Ratings
based on 62 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
67.9k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
|
AST Consultant
51k
salaries
| ₹8 L/yr - ₹25 L/yr |
|
Assistant System Engineer
31.3k
salaries
| ₹2.2 L/yr - ₹5.6 L/yr |
|
Associate Consultant
28.6k
salaries
| ₹8.9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture
Calculate your in-hand salary
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Azure Data Engineer Interview Questions for Experienced
