i
TCS
Filter interviews by
I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.
Interview questions for a PySpark Developer
Explained current project and its implementation
Differentiated between managed and external table
Described Spark architecture and RDD
Discussed characteristics of RDD and lazy nature
Provided insert statement for managed and external table
Explained deployment related to code in PySpark
Answered Python related questions
Explained how to convince manager/scrum master for code change
I applied via Walk-in and was interviewed in Nov 2024. There were 3 interview rounds.
Optimization techniques in Apache Spark improve performance and efficiency.
Partitioning data to distribute work evenly
Caching frequently accessed data in memory
Using broadcast variables for small lookup tables
Optimizing shuffle operations by reducing data movement
Applying predicate pushdown to filter data early
Coalesce reduces the number of partitions without shuffling data, while repartition increases the number of partitions by shuffling data. Cache and persist are used to persist RDDs in memory.
Coalesce is used to reduce the number of partitions without shuffling data, while repartition is used to increase the number of partitions by shuffling data.
Coalesce is more efficient when reducing partitions as it avoids shuffling...
SQL query to find the second highest rank in a dataset
Use the ORDER BY clause to sort the ranks in descending order
Use the LIMIT and OFFSET clauses to skip the highest rank and retrieve the second highest rank
Example: SELECT rank FROM dataset ORDER BY rank DESC LIMIT 1 OFFSET 1
The SQL code for calculating year-on-year growth percentage with year-wise grouping.
Use the LAG function to get the previous year's value
Calculate the growth percentage using the formula: ((current year value - previous year value) / previous year value) * 100
Group by year to get year-wise growth percentage
To connect Google Cloud Platform with Apache Spark, tools like Dataproc, Cloud Storage, and BigQuery can be used.
Use Google Cloud Dataproc to create managed Spark and Hadoop clusters on GCP.
Store data in Google Cloud Storage and access it from Spark applications.
Utilize Google BigQuery for querying and analyzing large datasets directly from Spark.
Orchestrating code in GCP involves using tools like Cloud Composer or Cloud Dataflow to schedule and manage workflows.
Use Cloud Composer to create, schedule, and monitor workflows using Apache Airflow
Utilize Cloud Dataflow for real-time data processing and batch processing tasks
Use Cloud Functions for event-driven serverless functions
Leverage Cloud Scheduler for job scheduling
Integrate with other GCP services like BigQ...
I was interviewed in Sep 2024.
Hadoop + Spark MCQ online test
Transformations are lazy operations that create new RDDs, while Actions are operations that trigger computation and return results.
Transformations are operations like map, filter, and reduceByKey that create a new RDD from an existing one.
Actions are operations like count, collect, and saveAsTextFile that trigger computation on an RDD and return results.
Transformations are lazy and are only executed when an action is c...
Spark is used for big data processing due to its speed, scalability, and ease of use.
Spark is used for processing large volumes of data quickly and efficiently.
It offers in-memory processing which makes it faster than traditional MapReduce.
Spark provides a wide range of libraries for diverse tasks like SQL, streaming, machine learning, and graph processing.
It can run on various platforms like Hadoop, Kubernetes, and st...
RDDs and DataFrames are data structures in Apache Spark for processing and analyzing large datasets.
RDDs (Resilient Distributed Datasets) are the fundamental data structure of Spark, representing a collection of elements that can be operated on in parallel.
DataFrames are distributed collections of data organized into named columns, similar to a table in a relational database.
DataFrames are built on top of RDDs, providi...
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
1. Find duplicate
2. 2,3 highest salary
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
Basic python coding, list, dict, generators etc
Coalesce reduces the number of partitions without shuffling data, while repartition reshuffles data to create a specific number of partitions.
Coalesce is used to reduce the number of partitions without shuffling data
Repartition is used to increase or decrease the number of partitions by shuffling data
Coalesce is more efficient when reducing partitions as it avoids shuffling
Repartition is useful when you need to explici...
DataFrame is a higher-level abstraction built on top of RDD, providing more structure and optimization capabilities.
DataFrames are distributed collections of data organized into named columns, similar to tables in a relational database.
RDDs are lower-level abstractions representing a collection of objects distributed across a cluster, with no inherent structure.
DataFrames provide optimizations like query optimization a...
A program to count the occurrences of each word in a text document.
Use Spark RDD to read the text file and split the lines into words
Apply transformations like map and reduceByKey to count the occurrences of each word
Handle punctuation and case sensitivity to ensure accurate word count results
Azure linked services are connections to external data sources, while Azure datasets are structured data objects within Azure Data Factory.
Azure linked services are used to connect to external data sources such as databases, storage accounts, and SaaS applications.
Azure datasets are structured data objects within Azure Data Factory that represent data from linked services or other sources.
Linked services define the con...
based on 3 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
51.1k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.9k
salaries
| ₹2.2 L/yr - ₹5.6 L/yr |
Associate Consultant
28.7k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture