Tredence Data Engineer Interview Questions and Answers

1 good coding question and 33 mcqs

Q1. Easy questions are asked
Add your answer
Q2. Like create a database of the collages composes of students and professors
Ans. 
Create a database to store information about colleges, students, and professors.
• Create tables for colleges, students, and professors

• Include columns for relevant information such as name, ID, courses, etc.

• Establish relationships between the tables using foreign keys

• Use SQL queries to insert, update, and retrieve data

• Consider normalization to avoid data redundancy
Answered by AI
Add your answer

Q1. Some hr questions
Add your answer
Q2. Project discussions
Add your answer

Q1. Hr questions about family
Add your answer

Q1. What is data bricks
Ans. 
Data bricks is a unified analytics platform that provides a collaborative environment for data scientists, engineers, and analysts.
• Data bricks simplifies the process of building data pipelines and training machine learning models.

• It allows for easy integration with various data sources and tools, such as Apache Spark and Delta Lake.

• Data bricks provides a scalable and secure platform for processing big data and running ...read more
Answered by AI
Add your answer
Q2. How do you optimize your code?
Ans. 
Optimizing code involves identifying bottlenecks, improving algorithms, using efficient data structures, and minimizing resource usage.
• Identify and eliminate bottlenecks in the code by profiling and analyzing performance.

• Improve algorithms by using more efficient techniques and data structures.

• Use appropriate data structures like hash maps, sets, and arrays to optimize memory usage and access times.

• Minimize resource us...read more
Answered by AI
Add your answer
Q3. What is SQL window function?
Ans. 
SQL window function is used to perform calculations across a set of table rows related to the current row.
• Window functions operate on a set of rows related to the current row

• They can be used to calculate running totals, moving averages, rank, etc.

• Examples include ROW_NUMBER(), RANK(), SUM() OVER(), etc.
Answered by AI
Add your answer

Q1. Salary expectations?
Add your answer
Q2. When can you join
Ans. 
I can join immediately or at a mutually convenient date, depending on your needs and my current commitments.
• I am available to start immediately if needed.

• If you prefer a specific start date, I can accommodate that as well.

• I can discuss my current commitments to find a suitable start time.

• For example, if you need someone to start within a week, I can make that work.
Answered by AI
Add your answer

Q1. 1. asked about CDC and CDT difference 2. Transient table Vs temp table 3. SCD type 2 & Type 3 diff 4. A window function based question to found the latest updated designations on employee table on basi...read more
Add your answer
Q2. Rest questions were on basis of Azure Databricks , Deltalake , ADF on basis of experience
Add your answer

Q1. Snowflake warehouse sizes.
Add your answer
Q2. SQl listagg queries
Add your answer