Mobileum Big Data Analyst Interview Questions and Answers

Q1. Find second max salary of employee by department in sql
Ans. 
Find second max salary of employee by department in SQL
• Use GROUP BY clause to group employees by department

• Use MAX() function to find the maximum salary

• Use subquery to find the second maximum salary
Answered by AI
Add your answer
Q2. Find second max salary 9f employee by department using python pandas dataframe
Ans. 
Find second max salary of employee by department using pandas dataframe
• Group the dataframe by department

• Sort the salaries in descending order

• Select the second highest salary for each department
Answered by AI
Add your answer
Q3. Python code to download file from aws s3 to local using boto3
Ans. 
Python code to download file from aws s3 to local using boto3
• Install boto3 library using pip

• Create an S3 client using boto3

• Use the download_file method to download the file from S3 to local
Answered by AI
Add your answer
Q4. Write word count program in pyspark
Ans. 
A program to count the number of words in a text file using PySpark.
• Read the text file using SparkContext

• Split the lines into words using flatMap

• Map each word to a tuple of (word, 1)

• Reduce by key to count the occurrences of each word

• Save the output to a file
Answered by AI
Add your answer

Q1. Build ETL pipeline, Airflow, Projects
Ans. 
Building ETL pipelines using Airflow for data engineering projects.
• Define data sources and destinations

• Design data transformation processes

• Implement ETL workflows in Airflow

• Schedule and monitor pipeline executions

• Handle error handling and data quality checks
Answered by AI
Add your answer

Tableau intensive assignment with few questions on SQL and basic Python

Q1. Discussion on submitted assignment and current job role
Add your answer
Q2. What kind of analysis have you done in your current role?
Add your answer

Q1. Basic discussion on why I am switching from my current company and salary discussion
Add your answer