Talentica Software Associate Data Engineer Interview Questions, Process, and Tips

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

Sql assessment round

Q1. Python gcp biquery airflow dataflow sql
Add your answer

Q1. Recent projects experience, bigquery, sql
Add your answer

Q1. Salary discussion
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Add your answer

Q1. HR question and family background
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Q1. Ques -> Can you define difference b/w Azure data lake and Delta lake.
Ans. 
Azure Data Lake is a cloud-based storage and analytics service, while Delta Lake is an open-source storage layer that adds reliability to data lakes.
• Azure Data Lake is a service provided by Microsoft Azure for storing and analyzing large amounts of data.

• Delta Lake is an open-source storage layer that adds ACID transactions and schema enforcement to data lakes.

• Azure Data Lake is a cloud-based solution, while Delta Lake ...read more
Answered by AI
Add your answer
Q2. How to implemented Primary key and foreign key in delta tables.
Ans. 
Primary keys and foreign keys can be implemented in delta tables using constraints and references.
• Primary keys can be implemented using the PRIMARY KEY constraint, which ensures that each record in the table has a unique identifier.

• Foreign keys can be implemented using the FOREIGN KEY constraint, which establishes a link between two tables based on a common column.

• The referenced table must have a primary key defined, a...read more
Answered by AI
Add your answer
Q3. How to handle exception in python?
Ans. 
Exception handling in Python allows for the graceful handling of errors and prevents program crashes.
• Use try-except blocks to catch and handle exceptions.

• Multiple except blocks can be used to handle different types of exceptions.

• The finally block is executed regardless of whether an exception occurred or not.

• Exceptions can be raised using the 'raise' keyword.

• Custom exceptions can be defined by creating a new class that
Answered by AI
Add your answer
Q4. What is star schema and snowflake schema
Ans. 
Star schema is a data modeling technique where a central fact table is connected to multiple dimension tables. Snowflake schema is an extension of star schema with normalized dimension tables.
• Star schema is a simple and denormalized structure

• It consists of a central fact table connected to multiple dimension tables

• Dimension tables contain descriptive attributes

• Star schema is easy to understand and query, but can lead t...read more
Answered by AI
Add your answer
Q5. Which are the most frequently change
Ans. 
The most frequently changing data
• Customer preferences

• Market trends

• Weather data

• Stock prices

• Social media trends
Answered by AI
Add your answer

Well designed to test the aptitude competence of the candidate.

Q1. Explanations for the answers given to the aptitude questions.
Add your answer
Q2. Questions from python.
Add your answer