Tiger Analytics Senior Data Engineer Interview Questions and Answers

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. 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