AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Wipro
Compare
Filter interviews by
Clear (1)
Wipro Lead Data Engineer Interview Questions, Process, and Tips
Top Wipro Lead Data Engineer Interview Questions and Answers
- Q1. Write SQL to find the users who purchased 3 consecutive month in a year
- Q2. Write SQL to find the second highest sal of emp in each dep
- Q3. Working of kafka with spark streaming
Wipro Lead Data Engineer Interview Experiences
2 interviews found
Anonymous
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(3 Questions)
- Q1. SQL Question on window functions to find the highest sale amount per day of the stores
- Q2. Build an ETL Pipeline to read json files which are dropping at irregular times into storage. So how do you transform and match the schema etc.,
- Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does?
Priyanshu Singh
Selected
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
(6 Questions)
- Q1. Architecture of spark
- Ans.
Spark is a distributed computing framework that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.
Spark is built around the concept of Resilient Distributed Datasets (RDDs) which are immutable distributed collections of objects.
It supports various programming languages like Java, Scala, Python, and R.
Spark provides high-level APIs like Spark SQL for structured data...
- Q2. Methods to optimizing spark jobs
- Ans.
Optimizing Spark jobs involves tuning configurations, partitioning data, caching, and using efficient transformations.
Tune Spark configurations for memory, cores, and parallelism
Partition data to distribute workload evenly
Cache intermediate results to avoid recomputation
Use efficient transformations like map, filter, and reduce
Avoid shuffling data unnecessarily
- Q3. Write SQL to find the second highest sal of emp in each dep
- Ans.
SQL query to find the second highest salary of employees in each department
Use a subquery to rank the salaries within each department
Filter the results to only include the second highest salary for each department
Join the result with the employee table to get additional information if needed
- Q4. Write SQL to find the users who purchased 3 consecutive month in a year
- Ans.
SQL query to find users who purchased 3 consecutive months in a year
Use a self join on the table to compare purchase months for each user
Group by user and year, then filter for counts of 3 consecutive months
Example: SELECT user_id FROM purchases p1 JOIN purchases p2 ON p1.user_id = p2.user_id WHERE p1.month = p2.month - 1 AND p2.month = p1.month + 1 GROUP BY p1.user_id, YEAR(p1.purchase_date) HAVING COUNT(DISTINCT MONT
- Q5. Working of kafka with spark streaming
- Ans.
Kafka is used as a message broker to ingest data into Spark Streaming for real-time processing.
Kafka acts as a buffer between data producers and Spark Streaming to handle high throughput of data
Spark Streaming can consume data from Kafka topics in micro-batches for real-time processing
Kafka provides fault-tolerance and scalability for streaming data processing in Spark
- Q6. Fibonacci series
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
(3 Questions)
- Q1. Explain OOPs w.r.t Java
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
- Q2. Explain about the projects that you have worked on
- Q3. Explain how Java solves machine dependency of code execution
- Ans.
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
(2 Questions)
- Q1. Why should we hire you?
- Q2. Tell me about yourself.
Interview Preparation Tips
- Java
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
(1 Question)
- Q1. Print 1 to 100 without for loop
- Ans.
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
(1 Question)
- Q1. General questions as per your cv
Interview Preparation Tips
- Aptitude
I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.
Attended the codevita competition in final year of college.
(3 Questions)
- Q1. About College Project
- Q2. Some very basics of java
- Q3. Experience of college project as a team
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
It was a basic aptitude test.
(1 Question)
- Q1. Interview was fine. Mostly asked about my final year project.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
(1 Question)
- Q1. Explain the mini projects and main project completed during Engineering.
Interview Preparation Tips
- DBMS
- Software Engineering
- Basic coding
Be confident and have a smiling face in the interview round.
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
- basic programming on C
(1 Question)
- Q1. - question based on your resume
Interview Preparation Tips
whatever project you are including , you should know enough to explain everything.
Wipro Interview FAQs
Recently Viewed
DESIGNATION
COMPANY BENEFITS
Tata Motors
No Benefits
INTERVIEWS
HCL Infosystems
No Interviews
REVIEWS
Tata Motors
No Reviews
REVIEWS
Tata Motors
No Reviews
INTERVIEWS
Wipro
No Interviews
REVIEWS
Tata Motors
No Reviews
INTERVIEWS
Jio
No Interviews
INTERVIEWS
IBM
No Interviews
INTERVIEWS
Wipro
No Interviews
Tell us how to improve this page.
Wipro Interviews By Designations
- Wipro Project Engineer Interview Questions
- Wipro Software Engineer Interview Questions
- Wipro Software Developer Interview Questions
- Wipro Associate Interview Questions
- Wipro Senior Software Engineer Interview Questions
- Wipro Technical Lead Interview Questions
- Wipro Senior Associate Interview Questions
- Wipro Process Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Data Architect Interview Questions
- Senior Database Administrator Interview Questions
- Database Engineer Interview Questions
- Datastage Developer Interview Questions
- Database Architect Interview Questions
- Show more
Wipro Lead Data Engineer Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Wipro Lead Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Project Engineer
32.8k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
23.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
21.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Project Engineer
20.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
18.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Tesla
Amazon
- Home >
- Interviews >
- Wipro Interview Questions >
- Wipro Lead Data Engineer Interview Questions
