Unisys Data Engineer Interview Questions and Answers

Q1. Questions on Pyspark
Add your answer
Q2. Questions on SQL
Add your answer
Q3. Transformations
Add your answer
Q4. Questions on Sql optimizations
Add your answer
Q5. Questions About my current Project
Add your answer

Q1. What is Pyspark?
Ans. 
Pyspark is a Python API for Apache Spark, a powerful open-source distributed computing system.
• Pyspark is used for processing large datasets in parallel across a cluster of computers.

• It provides high-level APIs in Python for Spark programming.

• Pyspark allows seamless integration with other Python libraries like Pandas and NumPy.

• Example: Using Pyspark to perform data analysis and machine learning tasks on big data sets.
Answered by AI
Add your answer
Q2. What is Pyspark SQL?
Ans. 
Pyspark SQL is a module in Apache Spark that provides a SQL interface for working with structured data.
• Pyspark SQL allows users to run SQL queries on Spark dataframes.

• It provides a more concise and user-friendly way to interact with data compared to traditional Spark RDDs.

• Users can leverage the power of SQL for data manipulation and analysis within the Spark ecosystem.
Answered by AI
Add your answer
Q3. How to merge 2 dataframes of different schema?
Ans. 
To merge 2 dataframes of different schema, use join operations or data transformation techniques.
• Use join operations like inner join, outer join, left join, or right join based on the requirement.

• Perform data transformation to align the schemas before merging.

• Use tools like Apache Spark, Pandas, or SQL to merge dataframes with different schemas.
Answered by AI
Add your answer
Q4. What is Pyspark streaming?
Ans. 
Pyspark streaming is a scalable and fault-tolerant stream processing engine built on top of Apache Spark.
• Pyspark streaming allows for real-time processing of streaming data.

• It provides high-level APIs in Python for creating streaming applications.

• Pyspark streaming supports various data sources like Kafka, Flume, Kinesis, etc.

• It enables windowed computations and stateful processing for handling streaming data.

• Example: C...read more
Answered by AI
Add your answer

Q1. SQL questions and partitioning
Add your answer
Q2. 3rd highest salary
Add your answer

Q1. Technical interview
Add your answer
Q2. SQL and data warehousing
Add your answer

Q1. What joins you used
Ans. 
I have used various types of joins including inner join, left join, right join, and full outer join.
• Used inner join to retrieve records that have matching values in both tables

• Utilized left join to retrieve all records from the left table and matching records from the right table

• Employed right join to retrieve all records from the right table and matching records from the left table

• Utilized full outer join to retrieve ...read more
Answered by AI
Add your answer
Q2. Write query for joins
Ans. 
Query for joins in SQL to combine data from multiple tables
• Use JOIN keyword to combine data from two or more tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Just focus on the basics of pyspark.

Q1. Normalisation of database, views,stored procedures
Ans. 
Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• It helps in reducing data redundancy and inconsistencies.

• Views are virtual tables that are created based on the result of a query. They can be used to simplify complex queries.

• Stored procedures are precompiled...read more
Answered by AI
Add your answer

Easy questions related to DSA and Python and SQL

Q1. Query to join two table using different joins
Ans. 
Query to join two tables using different joins
• Use INNER JOIN to return rows that have matching values in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer
Q2. Delete and truncate difference
Ans. 
Delete removes rows from a table while truncate removes all rows from a table.
• Delete is a DML command while truncate is a DDL command.

• Delete operation can be rolled back while truncate operation cannot be rolled back.

• Delete operation is slower than truncate operation.

• Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;
Answered by AI
Add your answer

Q1. Easy HR questions related to your previous experience
Add your answer

Q1. Spark Architecture
Add your answer
Q2. Explain the Spark architecture with example
Ans. 
Spark architecture includes driver, cluster manager, and worker nodes for distributed processing.
• Spark architecture consists of a driver program that manages the execution of tasks on worker nodes.

• Cluster manager is responsible for allocating resources and scheduling tasks across worker nodes.

• Worker nodes execute the tasks and store data in memory or disk for processing.

• Example: In a Spark application, the driver progr...read more
Answered by AI
Add your answer