City Union Bank Data Engineer Interview Questions and Answers

Q1. I was asked to write code and some scenario based question on Big Data etc
Add your answer

2nd with VP which is easy but he seems not okay with my ECTC

The first round which is online assessment for eliminating candidates was conducted consist of medium level aptitude questions there were 3 sub sec have duration of 20 15 15 minutes and questions 15 10 10 respectively and you cannot move to further section there is time constraints for each then followed by 15 minutes psychometric section having 50 questions that's all for screening round the total duration was 65 min.
Total 24 candidates were selected from this round out of 200 plus

Q1. Normalisation in sql
Ans. 
Normalization in SQL is the 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.

• There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.

• Example: If we have a table with customer details and orders, we can normalize i...read more
Answered by AI
Add your answer
Q2. Stored procedure uses
Ans. 
Stored procedures are precompiled SQL statements stored in a database for reuse.
• Stored procedures help improve performance by reducing network traffic.

• They can be used to encapsulate business logic in the database.

• Stored procedures can be parameterized for flexibility.

• They provide a layer of security by controlling access to data.

• Examples: sp_GetCustomerById, sp_UpdateEmployeeSalary
Answered by AI
Add your answer

Q1. What is an index and what does it do
Ans. 
An index is a data structure that improves the speed of data retrieval operations in a database by allowing quick access to specific data.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on specific columns in a table to speed up queries that filter or sort by those columns.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer

Q1. Tell me a time you resolve conflict
Add your answer

Spark Sql and Spark Scripting

Data Modelling for retail brand like dmart

ETL Pipeline which handles streaming data as well

Q1. Questions on pyspark coding, windowing function and all
Add your answer
Q2. Questions on hive and yarn
Add your answer

Q1. What are joins of sql
Add your answer
Q2. Explain about self join
Add your answer

Q1. Explain spark stages and tasks
Ans. 
Spark stages are a collection of tasks that are executed together to perform a specific computation.
• Stages are created based on the transformations and actions in a Spark job.

• Each stage consists of a set of tasks that can be executed in parallel.

• Stages are divided into two types: narrow (one-to-one) and wide (one-to-many) transformations.

• Tasks within a stage are executed on different partitions of the data in parallel.

• ...read more
Answered by AI
Add your answer
Q2. Sql windoq questions
Add your answer

Q1. Advance delta table optimizatoins
Add your answer
Q2. Data modelling in previous project
Ans. 
Implemented data modelling using star schema in a retail analytics project.
• Designed star schema to optimize query performance

• Used fact and dimension tables to organize data

• Implemented ETL processes to populate the data warehouse

• Utilized tools like SQL, Python, and Apache Spark for data modelling
Answered by AI
Add your answer