Verizon Data Engineer Interview Questions and Answers for Experienced

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. Spark and SQL and previous experience
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Project architect
Add your answer

Q1. Questions on spark and kafka
Add your answer

Q1. How soon you will join
Add your answer