Atlassian 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. About project what are optimization you have done
Add your answer

Easy to medium (30 mins, offline)

Q1. 1. search algorithm 2. sorting
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