Adobe Data Engineer Interview Questions and Answers

Q1. About the project and technical aspect
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. What is the architecture of Spark?
Add your answer

Q1. Explain surrogate key
Ans. 
Surrogate key is a unique identifier used in databases to uniquely identify each record in a table.
• Surrogate keys are typically generated by the system and have no business meaning.

• They are used to simplify database operations and improve performance.

• Example: Using an auto-incrementing integer column as a surrogate key in a table.
Answered by AI
Add your answer

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

Q1. How to read files in pandas?
Ans. 
Pandas can read various file formats including CSV, Excel, JSON, HTML, and SQL.
• Use pandas.read_csv() to read CSV files

• Use pandas.read_excel() to read Excel files

• Use pandas.read_json() to read JSON files

• Use pandas.read_html() to read HTML tables

• Use pandas.read_sql() to read SQL tables

• Specify the file path or URL as the argument

• Additional parameters can be used to customize the reading process
Answered by AI
Add your answer
Q2. How to use lambda function
Ans. 
Lambda functions are anonymous functions that can be used to perform a single task or operation.
• Lambda functions are defined using the lambda keyword.

• They can take any number of arguments but can only have one expression.

• Lambda functions are often used as arguments for higher-order functions.

• Example: lambda x: x**2 defines a lambda function that squares its input.

• Example: sorted(my_list, key=lambda x: x[1]) sorts a lis...read more
Answered by AI
Add your answer

Factorial coding questions and SQL coding questions using group by

Q1. Java questions on oops concepts
Add your answer
Q2. SQL questions on having clause
Add your answer

Q1. Can you relocate
Add your answer
Q2. Brief info about amdocs
Ans. 
Amdocs is a software and services provider for communications, media, and entertainment industries.
• Founded in 1982 in Israel

• Headquartered in Chesterfield, Missouri

• Provides customer experience solutions for telecom companies

• Offers services such as billing, CRM, and data analytics
Answered by AI
Add your answer

Coding round of 2 questions of medium level