Verizon Data Engineer Interview Questions and Answers

Python and SQL Questions (Easy to Medium)

Q1. Project Work Discussion
Add your answer
Q2. SQL Coding (Can be with an online compiler)
Add your answer
Q3. Python Coding (Can be with an online compiler)
Add your answer
Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
Add your answer
Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
Add your answer

Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
Add your answer
Q2. Python (Easy) (Maybe on compiler)
Add your answer
Q3. Scenario-based questions on the project
Add your answer

Q1. Sql question related to windows function
Add your answer
Q2. Unix basics - find a word in a set of files
Ans. 
Using Unix command 'grep' to find a word in a set of files
• Use 'grep' command followed by the word you want to search for and the file(s) you want to search in

• Add the '-r' flag to search recursively in all files in a directory

• Use '-i' flag for case-insensitive search

• Example: grep 'hello' file.txt

• Example: grep -r 'error' /path/to/directory

• Example: grep -i 'apple' file1.txt file2.txt
Answered by AI
Add your answer
Q3. Python question related to file system, regex
Add your answer

Basic aptitude test asking questions very basic

Coding questions based on dsa

Q1. Basic hr question
Add your answer

Q1. What is the difference between start schema and snowflake schema
Ans. 
Star schema is a denormalized schema with a single fact table and multiple dimension tables, while snowflake schema is a normalized schema with multiple dimension tables normalized into sub-dimension tables.
• Star schema has a single fact table surrounded by multiple dimension tables, while snowflake schema has dimension tables normalized into sub-dimension tables.

• In star schema, dimensions are denormalized, while in sno...read more
Answered by AI
Add your answer
Q2. How do you load data into bigquery using dataflow
Ans. 
Data can be loaded into BigQuery using Dataflow by creating a pipeline in Dataflow that reads data from a source and writes it to BigQuery.
• Create a Dataflow pipeline using Apache Beam SDK

• Read data from a source such as Cloud Storage or Pub/Sub

• Transform the data as needed using Apache Beam transformations

• Write the transformed data to BigQuery using BigQueryIO.write()
Answered by AI
Add your answer

Q1. Current Project
Add your answer

Q1. Current Project
Add your answer