AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Wipro
Compare
Filter interviews by
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
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
(3 Questions)
- Q1. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, while also summing the values in column 'C' ?
- Ans.
Group data by column 'A', calculate mean of column 'B' and sum values in column 'C' for each group.
Use groupby() function in pandas to group data by column 'A'
Apply mean() function on column 'B' and sum() function on column 'C' for each group
Example: df.groupby('A').agg({'B':'mean', 'C':'sum'})
- Q2. Explain the difference deepcopy() and copy() methods in Python's copy module. Provide a scenario where you would use deepcopy() over copy().
- Ans.
deepcopy() creates a new object with completely independent copies of nested objects, while copy() creates a shallow copy.
deepcopy() creates a new object and recursively copies all nested objects, while copy() creates a shallow copy of the top-level object only.
Use deepcopy() when you need to create a deep copy of an object with nested structures, to avoid any references to the original object.
Use copy() when you only ...
- Q3. Discuss the concept of Python decorators and provide an example of how you would use decorators to measure the execution time of a function.
- Ans.
Python decorators are functions that modify the behavior of other functions. They are commonly used for adding functionality to existing functions without modifying their code.
Decorators are defined using the @ symbol followed by the decorator function name.
They can be used to measure the execution time of a function by wrapping the function with a timer decorator.
Example: def timer(func): def wrapper(*args, **kwargs...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Questions related to the current and past projects.
- Q2. Aws related questions.
- Q3. Data warehousing basics
(2 Questions)
- Q1. Explain about the roles and responsibilities.
- Q2. Discussion about the role in Genpact.
(2 Questions)
- Q1. Asked about expectated salary
- Q2. Why are you switching
Interview Preparation Tips
(2 Questions)
- Q1. Dataguard architecture
- Q2. Rman backup and restoration
(1 Question)
- Q1. Why you join inm
- Ans.
I joined inm because of the company's reputation for innovation and growth in the tech industry.
Attracted to company's reputation for innovation
Excited about opportunities for growth in tech industry
Impressed by company culture and values
Piyusha Mohanty
Selected
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Data Modeling Concepts, SQL Query
- Q2. Data Governance, Data Lineage, ETL process,
SQL Scripts to write and also also asked to design an data model of my choice in Telecom Domain
Selected
(2 Questions)
- Q1. What is database architecture?
- Ans.
Database architecture refers to the design and structure of a database system.
Database architecture includes the organization of data, storage, retrieval, and security mechanisms.
It involves defining the relationships between data elements and how they are stored and accessed.
Examples of database architectures include hierarchical, network, relational, and object-oriented.
Database architecture also includes the choice ...
- Q2. Difference between delete and truncate
- Ans.
Delete removes rows one by one, while truncate removes all rows at once.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.
Example: DELETE FROM table_name WHERE condi
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Architecture of sql
- Ans.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
- Q2. Recovery models
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. Data stage scenario
- Q2. Difference between Data Stage and informatica
- Ans.
Data Stage is an ETL tool by IBM, while Informatica is a popular ETL tool by Informatica Corporation.
Data Stage is developed by IBM, while Informatica is developed by Informatica Corporation.
Data Stage is known for its parallel processing capabilities, while Informatica is known for its ease of use and flexibility.
Data Stage has a graphical interface for designing jobs, while Informatica uses a more traditional workflo...
Interview Preparation Tips
- Complete Data Stage
Skills evaluated in this interview
Oracle Database Administrator Interview Questions & Answers
DXC Technology
Anonymous
posted on 9 Sep 2024
(1 Question)
- Q1. Tell about yourself
- Ans.
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
5+ years of experience as an Oracle DBA
Proficient in database management, performance optimization, and data security
Skilled in troubleshooting and resolving database issues
Strong knowledge of Oracle database architecture and SQL
Certified Oracle Database Administrator (OCA/OCP)
Wipro Interview FAQs
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
|  ₹1.8 L/yr - ₹8.2 L/yr |
|
Senior Software Engineer
23.1k
salaries
| ₹5.8 L/yr - ₹23 L/yr |
|
Senior Associate
21.3k
salaries
| ₹0.9 L/yr - ₹5.5 L/yr |
|
Senior Project Engineer
20.4k
salaries
| ₹5 L/yr - ₹19.5 L/yr |
|
Technical Lead
18.7k
salaries
| ₹8.3 L/yr - ₹36.5 L/yr |
TCS
Infosys
Tesla
Amazon
- Home >
- Interviews >
- Wipro Interview Questions >
- Wipro Lead Data Engineer Interview Questions
