In this article, we will see the list of questions asked in Wipro Company Interview for Data Engineers.
Let’s see the Questions:
1) Describe the concept of imputations (handling missing data) in Spark.
2) What is the difference between executor memory, on-heap memory, and off-heap memory in Spark?
3) Write an SQL query to count occurrences of a specific character within a column.
4) Given a scenario where a person has traveled through 6 locations, starting from New Delhi to London, London to Paris, and Paris to another country, how would you determine the start and end locations using SQL, based on input columns for start and end locations? Focus on analyzing the start for customer 1.
5) Provide PySpark code to remove or manage reverse pair duplicates from a table.
6) What optimization techniques have you utilized in PySpark? How do you determine which one to implement?
7) How would you encrypt PII (Personally Identifiable Information) such as mobile numbers and PAN numbers in Spark?
8) Explain the process of connecting to an Oracle database using Spark.
9) If you are loading data that lacks headers, how would you create a DataFrame in Spark?
10) Describe the different join strategies in Spark.
11) What are jobs, stages, and tasks in Spark? How do you calculate their numbers in a Spark job?
12) What strategies would you employ to handle large datasets in Spark?
13) Explain the differences between Avro and Parquet file formats.
14) What do the awk and sed commands do in Unix?
15) Differentiate between internal and external tables in Hive.
16) Compare RDBMS with NoSQL databases.
17) What are explode and posexplode functions in spark? Provide examples.
18) Discuss SQL window functions.
19) How would you approach SQL query optimization?
I hope these questions assist anyone preparing for their interviews.
Check out the given link for knowing about this company: Wipro | Digital, Technology, Business Solutions
Check out the given link for knowing about this company rating on Glassdoor: Wipro | Glassdoor
Check out the given link for this company profile on LinkedIn: Wipro | LinkedIn
Thank you for reading this post.