i
Wipro
Filter interviews by
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 Recruitment Consultant and was interviewed in Jul 2021. There were 3 interview rounds.
What people are saying about Wipro
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 Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
I want to join Infosys because of its reputation for innovation and growth opportunities.
Infosys is known for its cutting-edge technology solutions and innovative projects.
I am impressed by Infosys' commitment to employee development and career growth.
I believe that joining Infosys will provide me with the opportunity to work on challenging projects and enhance my skills.
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Questions on software and system designs
Helps employer identify particular personality traits like leadership, confidence, interpersonal and teamwork skills of potential employees
More questions about coding in sql & pyspark
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
Coalesce is used to reduce the number of partitions in a DataFrame, while repartition is used to increase the number of partitions.
Coalesce is a narrow transformation that can only decrease the number of partitions without shuffling data.
Repartition is a wide transformation that can both increase or decrease the number of partitions and involves shuffling data across the cluster.
Coalesce is more efficient for reducing ...
Rank vs dense rank quetions ctes
Python data structure
I applied via Naukri.com and was interviewed in Jul 2023. There were 2 interview rounds.
Spark internal working and optimization techniques
Spark uses Directed Acyclic Graph (DAG) for optimizing workflows
Lazy evaluation helps in optimizing transformations by combining them into a single stage
Caching and persistence of intermediate results can improve performance
Partitioning data can help in parallel processing and reducing shuffle operations
based on 7 reviews
Rating in categories
Project Engineer
32.6k
salaries
| ₹1.8 L/yr - ₹8.3 L/yr |
Senior Software Engineer
22.9k
salaries
| ₹5.8 L/yr - ₹22.5 L/yr |
Senior Associate
21.1k
salaries
| ₹0.8 L/yr - ₹5.5 L/yr |
Senior Project Engineer
20.6k
salaries
| ₹5 L/yr - ₹19.3 L/yr |
Technical Lead
18.6k
salaries
| ₹8.2 L/yr - ₹30 L/yr |
TCS
Infosys
Tesla
Amazon