i
TCS
Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2022. There were 2 interview rounds.
Hive metastore is a central repository that stores metadata for Hive tables, including schema and location.
Hive metastore is used to manage metadata for Hive tables.
It stores information about the schema, location, and other attributes of tables.
The metastore can be configured to use different databases, such as MySQL or PostgreSQL.
It allows for sharing metadata across multiple Hive instances.
The metastore can be acces...
Spark architecture is a distributed computing framework that consists of a cluster manager, a distributed storage system, and a processing engine.
Spark architecture is based on a master-slave architecture.
The cluster manager is responsible for managing the resources of the cluster.
The distributed storage system is used to store data across the cluster.
The processing engine is responsible for executing the tasks on the ...
I applied via Job Portal and was interviewed in Sep 2023. There were 3 interview rounds.
Easy only so prepare well that's it
I use a combination of programming languages, tools, and frameworks to analyze and process large datasets.
Utilize programming languages like Python, Java, or Scala for data processing
Leverage tools like Hadoop, Spark, or Kafka for distributed computing
Implement frameworks like MapReduce or Apache Flink for data analysis
Use SQL or NoSQL databases for data storage and retrieval
Implemented a real-time data processing system using Apache Kafka and Spark for analyzing customer behavior.
Developed data pipelines to ingest, process, and analyze large volumes of data
Utilized Apache Kafka for real-time data streaming
Implemented machine learning algorithms for predictive analytics
Optimized data storage and retrieval for faster query performance
External tables are stored outside the database while internal tables are stored within the database.
External tables are created using the LOCATION clause to specify the data location.
Internal tables are created using the CREATE TABLE statement.
External tables can be accessed by multiple databases while internal tables are specific to a single database.
External tables are not managed by the database and can be deleted ...
TCS interview questions for designations
I applied via Referral and was interviewed before Jan 2024. There was 1 interview round.
Get interview-ready with Top TCS Interview Questions
I applied via campus placement at JNTU College of Engineering, Kakinada and was interviewed before Aug 2023. There were 4 interview rounds.
General maths and English
Basic program coding
I applied via Walk-in and was interviewed before May 2023. There was 1 interview round.
Tuples are immutable and fixed in size, while lists are mutable and can change in size.
Tuples are created using parentheses, while lists are created using square brackets.
Tuples are faster than lists for iteration and accessing elements.
Tuples are used for heterogeneous data types, while lists are used for homogeneous data types.
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
Different types of joins in SQL with examples
Inner Join: Returns rows when there is a match in both tables
Left Join: Returns all rows from the left table and the matched rows from the right table
Right Join: Returns all rows from the right table and the matched rows from the left table
Full Outer Join: Returns all rows when there is a match in either table
Large Spark datasets can be handled by partitioning, caching, optimizing transformations, and tuning resources.
Partitioning data to distribute workload evenly across nodes
Caching frequently accessed data to avoid recomputation
Optimizing transformations to reduce unnecessary processing
Tuning resources like memory allocation and parallelism for optimal performance
Spark configuration settings can be tuned to optimize query performance by adjusting parameters like memory allocation, parallelism, and caching.
Increase executor memory and cores to allow for more parallel processing
Adjust shuffle partitions to optimize data shuffling during joins and aggregations
Enable dynamic allocation to scale resources based on workload demands
Utilize caching to store intermediate results and avo...
To handle data skew and partition imbalance in Spark, strategies include using salting, bucketing, repartitioning, and optimizing join operations.
Use salting to evenly distribute skewed keys across partitions
Implement bucketing to pre-partition data based on a specific column
Repartition data based on a specific key to balance partitions
Optimize join operations by broadcasting small tables or using partitioning strategi
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Spark optimization techniques involve partitioning, caching, and tuning resource allocation.
Partitioning data to distribute workload evenly
Caching frequently accessed data to avoid recomputation
Tuning resource allocation for optimal performance
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
It was WeCP based test
Spark Architecture is a distributed computing framework that provides high-level APIs for in-memory computing.
Spark Architecture consists of a cluster manager, worker nodes, and a driver program.
It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.
Spark applications run as independent sets of processes on a cluster, coordinated by the SparkContext object.
It supports various data ...
Higher order functions, closures, anonymous functions, map, flatmap, and tail recursion are key concepts in functional programming.
Higher order function: Functions that can take other functions as arguments or return functions as results.
Closure: Functions that capture variables from their lexical scope, even when they are called outside that scope.
Anonymous function: Functions without a specified name, often used as a...
1 Interview rounds
based on 42 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
67.7k
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