Exponentia.ai Associate Data Engineer Interview Questions and Answers

They give you SQL assignment to complete based on that select for technical interview

Q1. What are window functions in SQL
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. Difference between group by and distinct
Ans. 
Group by is used to group rows that have the same values into summary rows, while distinct is used to remove duplicate rows from a result set.
• Group by is used with aggregate functions like COUNT, SUM, AVG, etc.

• Distinct is used to retrieve unique values from a column or set of columns.

• Group by is used to perform operations on groups of rows, while distinct is used to filter out duplicate rows.

• Group by is used in conjunc...read more
Answered by AI
Add your answer

Q1. Sql questions and python
Add your answer

Q1. About last projects
Add your answer

Q1. The HR representative will seek to understand your experience and its alignment with the role.
Add your answer
Q2. Salary expectations, Offers in hand
Add your answer

Q1. What are the key features and functionalities of Snowflake?
Ans. 
Snowflake is a cloud-based data warehousing platform known for its scalability, performance, and ease of use.
• Snowflake uses a unique architecture called multi-cluster, which separates storage and compute resources for better scalability and performance.

• It supports both structured and semi-structured data, allowing users to work with various data types.

• Snowflake offers features like automatic scaling, data sharing, and ...read more
Answered by AI
Add your answer
Q2. The interviewer asked several complex SQL questions that utilized analytical functions.
Add your answer
Q3. I was asked to write some syntax-level code for Jinja statements in dbt.
Add your answer

Q1. The interviewer, who was part of the senior management, inquired about dbt, its features, and my experience with dbt thus far.
Add your answer
Q2. The interviewer reviewed my resume and inquired about the challenges I encountered in my previous roles and the methods I used to resolve them.
Add your answer

Q1. Salary negotiations, Bonus discussions
Add your answer

I cannot recall the platform, but it featured a combination of Python and SQL questions, with the majority being focused on SQL.

Q1. SQL basics like Indexes, Clustering, Keys, Data warehousing concepts, Normalization and Denormalization etc..
Add your answer
Q2. SQL coding questions
Add your answer

Q1. SQL questions to solve using different types of joins
Add your answer
Q2. Questions based on project and data quality checks
Add your answer

Q1. Behavioral questions
Add your answer
Q2. Culture fit
Add your answer

Basic Pyspark/python question with some mcqs

Q1. Project overview
Add your answer
Q2. Pyspark, python , sql related questions.
Add your answer

Q1. Basic technical question on spark and one python Dasa question and one sql
Add your answer
Q2. Sql + python + spark + Adf + Databricks
Add your answer

Q1. Why you want to join even though you have offers from good mnc
Ans. 
I am passionate about data engineering and believe this company offers unique opportunities for growth and learning.
• Exciting projects and challenges at this company

• Opportunities for growth and learning in data engineering

• Alignment with company values and culture

• Potential for career advancement and development

• Interest in the industry or specific technologies used by the company
Answered by AI
Add your answer
Q2. Salary expectations and work culture
Add your answer

A general round having mix of maths,aptitude,english,puzzle and quiz. level was easy

Q1. Tell about yourself
Add your answer
Q2. What step would you take in this situatiion
Ans. 
I would analyze the situation, identify the root cause, and propose a solution based on data-driven insights.
• Analyze the data to understand the problem

• Identify the root cause of the issue

• Propose a solution based on data-driven insights
Answered by AI
Add your answer

Basic sql online assessment with some queries and mcq

Q1. Explain project
Ans. 
Developed a data pipeline to ingest, process, and analyze customer behavior data for targeted marketing campaigns.
• Designed and implemented ETL processes to extract data from various sources

• Utilized Apache Spark for data processing and analysis

• Built machine learning models to predict customer behavior

• Collaborated with marketing team to optimize campaign strategies
Answered by AI
Add your answer
Q2. Pipeline optimization
Add your answer

Q1. Behavioral question
Add your answer