ABB Junior Data Analyst Interview Questions and Answers

Q1. What is the difference between AI, deep learning and machine learning
Ans. 
AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart. Machine learning is a subset of AI that allows machines to learn from data. Deep learning is a subset of machine learning that uses neural networks with many layers to model and solve complex problems.
• AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart.

• Machine ...read more
Answered by AI
Add your answer

Q1. Tell me a project you did in school that shows innovation?
Add your answer

Duration - 45 mins
Spark Scala - csv and json data provided, implement a class to transform it a certain way
MCQs on Spark performance and cluster configurations

Q1. Duaration 45 mins DF vs Datasests vs RDDs implementation of word count Groupby vs GroupbyKey spark context lifecycle joins
Ans. 
Comparison and implementation of data structures and operations in Spark for data engineering
• DataFrames are structured data with named columns, Datasets are type-safe structured data, RDDs are resilient distributed datasets

• Word count can be implemented using Spark transformations like flatMap, map, reduceByKey

• GroupBy is a DataFrame operation, GroupByKey is an RDD operation

• Spark context is the entry point for Spark func...read more
Answered by AI
Add your answer

Design a end to end scalable data pipeline and talk about considerations

Q1. Write a python program for list/dictionary (comprehensions)
Ans. 
Python program for list/dictionary comprehensions
• List comprehension: [expression for item in iterable]

• Dictionary comprehension: {key_expression: value_expression for item in iterable}

• Example: squares = [x**2 for x in range(10)]

• Example: dict_squares = {x: x**2 for x in range(10)}
Answered by AI
Add your answer
Q2. Write a python program to convert a number to words. For ex: i/p 123, o/p - One hundred twenty three
Ans. 
Python program to convert a number to words.
• Use a dictionary to map numbers to words.

• Divide the number into groups of three digits and convert each group to words.

• Handle special cases like zero, negative numbers, and numbers greater than or equal to one billion.
Answered by AI
Add your answer
Q3. Questions on AWS glue/EMr cluster. How to filter a dataframe in PySpark ?
Add your answer

Q1. Questions based on Terraform
Add your answer
Q2. Write a python program for list/dictionary comprehensions.
Ans. 
Python program for list/dictionary comprehensions.
• List comprehension: [expression for item in iterable]

• Dictionary comprehension: {key_expression: value_expression for item in iterable}

• Example: squares = [x**2 for x in range(10)]

• Example: dict_squares = {x: x**2 for x in range(10)}
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer