AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Tredence Data Engineer Interview Questions, Process, and Tips
Top Tredence Data Engineer Interview Questions and Answers
- Q1. How will you execute second notebook from first notebook?
- Q2. What activities you have used in data factory?
- Q3. like create a database of the collages composes of students and professors
Tredence Data Engineer Interview Experiences
7 interviews found
Vinay Gundam
I applied via Campus Placement
1 good coding question and 33 mcqs
(2 Questions)
- Q1. Easy questions are asked
- 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
(2 Questions)
- Q1. Some hr questions
- Q2. Project discussions
(1 Question)
- Q1. Hr questions about family
Anonymous
Selected
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(3 Questions)
- 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 ...
- 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...
- 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.
(2 Questions)
- Q1. Salary expectations?
- Q2. When can you join
Skills evaluated in this interview
Half hour with spark python azure databricks
(2 Questions)
- Q1. Architecture databricks
- Q2. Sql related questions
Selected
I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Copy activity in ADF
- Q2. Delta table, unity catalog , delta live table in Azure databricks
(2 Questions)
- Q1. Copy activity, Lookup, get metadata, if else, for each activity in ADF
- Q2. Conceptual ETL Questions like coalesce and repartition, cache, persist etc.
Interview Preparation Tips
- azure databricks
- azure data factory
- ETL
Tredence interview questions for designations
I applied via Naukri.com and was interviewed in Sep 2023. There was 1 interview round.
(3 Questions)
- Q1. What activities you have used in data factory?
- Ans.
I have used activities such as Copy Data, Execute Pipeline, Lookup, and Data Flow in Data Factory.
Copy Data activity is used to copy data from a source to a destination.
Execute Pipeline activity is used to trigger another pipeline within the same or different Data Factory.
Lookup activity is used to retrieve data from a specified dataset or table.
Data Flow activity is used for data transformation and processing.
- Q2. How will you execute second notebook from first notebook?
- Ans.
To execute a second notebook from the first notebook, you can use the %run magic command in Jupyter Notebook.
Use the %run magic command followed by the path to the second notebook in the first notebook.
Ensure that the second notebook is in the same directory or provide the full path to the notebook.
Make sure to save any changes in the second notebook before executing it from the first notebook.
- Q3. Difference between data lake storage and blob storage?
- Ans.
Data lake storage is optimized for big data analytics and can store structured, semi-structured, and unstructured data. Blob storage is for unstructured data only.
Data lake storage is designed for big data analytics and can handle structured, semi-structured, and unstructured data
Blob storage is optimized for storing unstructured data like images, videos, documents, etc.
Data lake storage allows for complex queries and ...
Skills evaluated in this interview
Get interview-ready with Top Tredence Interview Questions
Selected
I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.
(1 Question)
- Q1. Basic Sql and Spark questions
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
Data Engineer Jobs at Tredence
(1 Question)
- Q1. Python, sql, datawarehousing concepts, GCP
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.
Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.
Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P
General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore
I was interviewed in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Views on their recruiting process
- Ans.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
Interview Preparation Tips
Experience:
Selected
I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.
(2 Questions)
- Q1. How to decide upon Spark cluster sizing?
- Ans.
Spark cluster sizing depends on workload, data size, memory requirements, and processing speed.
Consider the size of the data being processed
Take into account the memory requirements of the Spark jobs
Factor in the processing speed needed for the workload
Scale the cluster based on the number of nodes and cores required
Monitor performance and adjust cluster size as needed
- Q2. Question on Spark internals
Implement a pipeline based on given conditions and data requirement
(1 Question)
- Q1. There were no questions as such. They want me join on very next day when the HR discussion was over and started itimidating me with aggressive approach even without discussing the salary part and the benef...
Interview Preparation Tips
Based on the HR behaviour, I can say there is no respect for an employee/ candidate.
The behaviour was like as if I am at the mercy of the employer and I don't have any other company in this world.
Skills evaluated in this interview
Tredence Interview FAQs
Tell us how to improve this page.
Tredence Interviews By Designations
- Tredence Analyst Interview Questions
- Tredence Data Analyst Interview Questions
- Tredence Data Scientist Interview Questions
- Tredence Business Analyst Interview Questions
- Tredence Consultant Interview Questions
- Tredence Senior Software Engineer Interview Questions
- Tredence Data Engineer Interview Questions
- Tredence Associate Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Tredence Data Engineer Interview Process
based on 8 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Tredence Data Engineer Reviews and Ratings
based on 25 reviews
Rating in categories
Pune,
Chennai
+16-11 Yrs
Not Disclosed
|
Consultant
374
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Associate Manager
358
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Business Analyst
263
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Engineer
207
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Business Analyst
173
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
LatentView Analytics
AbsolutData
- Home >
- Interviews >
- Tredence Interview Questions >
- Tredence Data Engineer Interview Questions
