Comcast India Engineering Center Data Engineer Interview Questions and Answers

Q1. How to build data pipeline
Add your answer
Q2. IICS
Add your answer

Q1. About the project and technical aspect
Add your answer

Q1. Write a lambda function in python
Ans. 
A lambda function in Python is a small anonymous function defined using the lambda keyword.
• Lambda functions can have any number of arguments, but can only have one expression.

• Syntax: lambda arguments : expression

• Example: lambda x, y : x + y
Answered by AI
Add your answer
Q2. Dbutils in databricks
Ans. 
dbutils is a utility provided by Databricks for interacting with files and directories in the Databricks environment.
• dbutils.fs.ls('/') - list files in root directory

• dbutils.fs.cp('dbfs:/file.txt', 'file.txt') - copy file from DBFS to local file system

• dbutils.fs.mkdirs('dbfs:/new_dir') - create a new directory in DBFS
Answered by AI
Add your answer
Q3. Persist and cache
Add your answer
Q4. What is commit in SQL
Ans. 
A commit in SQL is a command that saves all the changes made in a transaction to the database.
• A commit is used to make all the changes made in a transaction permanent.

• Once a commit is issued, the changes cannot be rolled back.

• It is important to use commit to ensure data integrity and consistency.

• Example: COMMIT; - this command is used to commit the changes in a transaction.
Answered by AI
Add your answer
Q5. Rank and dans_rank
Add your answer

Hackerearth problem on reversing the string & one more array question

Q1. Reverse the string
Ans. 
Reverse a given string
• Use built-in functions like reverse() in Python

• Iterate through the string in reverse order and append characters to a new string

• Use stack data structure to reverse the string
Answered by AI
Add your answer
Q2. SQL based windowing function
Add your answer

Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
Add your answer

Q1. Salary discussion with roles and responsiblity
Add your answer

Logical questions which are highly useful

Multiple coding questions they asked in pyspark

Q1. About project what are optimization you have done
Add your answer

Q1. General questions about previous experience
Add your answer

Q1. A system design question about searching on web and deep doving and grilling from there
Add your answer

Q1. General interview questions on background, why I left other jobs and few SQL questions
Add your answer