Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
messages
notification
notification
Login
Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Wipro Team. If you also belong to the team, you can get access from here

Wipro Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 58.6k Reviews

Play video Play video Video summary

Filter interviews by

Wipro Lead Data Engineer Interview Questions and Answers

Updated 6 Dec 2024

7 Interview questions

A Lead Data Engineer was asked 7mo ago
Q. How would you build an ETL pipeline to read JSON files that are irregularly dropped into storage, transform the data, and match the schema?
Ans. 

Design an ETL pipeline to handle irregularly timed JSON file uploads for data transformation and schema matching.

  • Use a cloud storage service (e.g., AWS S3) to store incoming JSON files.

  • Implement a file watcher or event-driven architecture (e.g., AWS Lambda) to trigger processing when new files arrive.

  • Utilize a data processing framework (e.g., Apache Spark or Apache Beam) to read and transform the JSON data.

  • Define ...

A Lead Data Engineer was asked 7mo ago
Q. Write an SQL query using window functions to find the highest sale amount per day for each store.
Ans. 

Use SQL window functions to identify the highest sale amount for each store per day.

  • Use the ROW_NUMBER() function to rank sales within each day and store.

  • Partition the data by store and date to isolate daily sales.

  • Order the sales in descending order to get the highest sale at the top.

  • Example SQL query: SELECT store_id, sale_date, sale_amount, ROW_NUMBER() OVER (PARTITION BY store_id, sale_date ORDER BY sale_amount...

Lead Data Engineer Interview Questions Asked at Other Companies

asked in Accenture
Q1. Given a DataFrame df with columns 'A', 'B','C' how would you grou ... read more
View answer (1)
asked in Innova Solutions
Q2. Given a string containing alphanumeric characters, how would you ... read more
View answer (1)
asked in Wipro
Q3. Write an SQL query to find the users who made purchases in 3 cons ... read more
View answer (1)
asked in Wipro
Q4. How would you build an ETL pipeline to read JSON files that are i ... read more
View answer (1)
asked in Accenture
Q5. Discuss the concept of Python decorators and provide an example o ... read more
View answer (1)
View All
A Lead Data Engineer was asked
Q. How does Kafka work 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

A Lead Data Engineer was asked
Q. Write an SQL query to find the users who made purchases in 3 consecutive months within 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...

What people are saying about Wipro

View All
a software developer
1w
Wipro Elite to Turbo Upgrade: How To?
Got a 3.5 LPA Project Engineer (Elite) offer at Wipro and aiming for the 6.5 LPA Turbo package. Just received my LOI a month ago. What's the process to upgrade my package?
Got a question about Wipro?
Ask anonymously on communities.
A Lead Data Engineer was asked
Q. What methods do you use to optimize 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

A Lead Data Engineer was asked
Q. Write SQL to find the second highest salary of employees in each department.
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

Wipro HR Interview Questions

1.1k questions and answers

Q. Can you explain your final year project in detail?
Q. What were the reasons for your resignation?
Q. Why do so many companies undergo changes?
View all HR interview questions
A Lead Data Engineer was asked
Q. 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...

Are these interview questions helpful?

Wipro Lead Data Engineer Interview Experiences

2 interviews found

Lead Data Engineer Interview Questions & Answers

user image Anonymous

posted on 6 Dec 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. SQL Question on window functions to find the highest sale amount per day of the stores
  • Ans. 

    Use SQL window functions to identify the highest sale amount for each store per day.

    • Use the ROW_NUMBER() function to rank sales within each day and store.

    • Partition the data by store and date to isolate daily sales.

    • Order the sales in descending order to get the highest sale at the top.

    • Example SQL query: SELECT store_id, sale_date, sale_amount, ROW_NUMBER() OVER (PARTITION BY store_id, sale_date ORDER BY sale_amount DESC...

    • Answered by AI
    Add your answer
  • 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.,
  • Ans. 

    Design an ETL pipeline to handle irregularly timed JSON file uploads for data transformation and schema matching.

    • Use a cloud storage service (e.g., AWS S3) to store incoming JSON files.

    • Implement a file watcher or event-driven architecture (e.g., AWS Lambda) to trigger processing when new files arrive.

    • Utilize a data processing framework (e.g., Apache Spark or Apache Beam) to read and transform the JSON data.

    • Define a sch...

    • Answered by AI
    Add your answer
  • Q3. Write a pyspark code to join two tables and explain broadcastjoin() & what it does?
    • Add your answer

Skills evaluated in this interview

Lead Data Engineer Interview Questions & Answers

user image Priyanshu Singh

posted on 17 Jun 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(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...

    • Answered by AI
    Add your answer
  • 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

    • Answered by AI
    Add your answer
  • 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

    • Answered by AI
    Add your answer
  • 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...

    • Answered by AI
    Add your answer
  • Q5. Working of kafka with spark streaming
    • Add your answer
  • Q6. Fibonacci series
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on SQL,Spark basic

Skills evaluated in this interview

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Accenture user image Anonymous

posted on 7 Jan 2020

Interview Questionnaire 

6 Questions

Compare Wipro with

TCS

3.5
Compare

Infosys

3.6
Compare

Tesla

4.1
Compare

Amazon

4.0
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
write
Share an Interview