ScatterPie Analytics Senior Data Engineer Interview Questions and Answers

Q1. Basic QA related Questions
Add your answer

Q1. 1. Types of cloud 2.Different Activity in ADF 3.Advance SQL 4.Basic OPPS concepts
Ans. 
Questions related to cloud types, ADF activities, advanced SQL, and basic OOPs concepts.
• Types of cloud include public, private, and hybrid

• ADF activities include data ingestion, transformation, and loading

• Advanced SQL includes window functions, subqueries, and joins

• Basic OOPs concepts include encapsulation, inheritance, and polymorphism
Answered by AI
Add your answer

Q1. 1. Secenario bases case study. 2.Performance tuning in Datebases and warehouse. 3.SQL Logics
Add your answer

Basics of SQL, Python

Experience based questions, SQL and Python

Q1. Tell me about the projects you worked on
Ans. 
I have worked on projects involving building data pipelines, optimizing data storage, and developing machine learning models.
• Built data pipelines using Apache Spark and Airflow

• Optimized data storage by implementing partitioning and indexing strategies

• Developed machine learning models for predictive analytics
Answered by AI
Add your answer
Q2. Based on experience some questions related to projects.
Add your answer

Q1. Code any program in 2 languages
Ans. 
I can code a program in Python and Java.
• I am proficient in both Python and Java programming languages.

• I have experience in developing web applications using Python and Java frameworks.

• I can write efficient and optimized code in both languages.

• I can develop programs for data analysis, machine learning, and automation using Python.

• I can develop enterprise-level applications using Java.

• Examples: Python - a program to scra...read more
Answered by AI
Add your answer
Q2. Behavioral questions on why you want to join?
Add your answer

Q1. SQL problems to solve nth highest salary
Ans. 
Use SQL query with subquery to find nth highest salary
• Use ORDER BY and LIMIT to get the nth highest salary

• Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary
Answered by AI
Add your answer

Q1. GCP big query Architecture
Add your answer