AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
NucleusTeq Data Engineer Interview Questions and Answers
NucleusTeq Data Engineer Interview Experiences
3 interviews found
Anonymous
I applied via Job Portal and was interviewed in Jan 2024. There were 3 interview rounds.
(1 Question)
- Q1. 1 SQL problem 1 Pyspark Problem Few Data modelling question and project related.
(1 Question)
- Q1. 1 SQL problem Implement SCD using pyspark.
- Ans.
Implement Slowly Changing Dimension (SCD) using pyspark
Use pyspark to read the source and target tables
Identify the changes in the source data compared to the target data
Update the existing records in the target table with the new values
Insert new records for the new data in the source table
Handle historical data by maintaining effective start and end dates
(1 Question)
- Q1. Basic HR questions.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview before Mar 2023.
(1 Question)
- Q1. PySpark ,SQL, Python related questions
(1 Question)
- Q1. General Discussion
Selected
I appeared for an interview before Mar 2023.
(1 Question)
- Q1. Related Big Data, SQL, PySpark
Interview questions from similar companies
I applied via Walk-in and was interviewed before Feb 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Interview mainly asked about spark architecture.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Joined as a fresher, basic C program algo
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Feb 2022. There were 4 interview rounds.
Quants, psychological questions, basic programming and syntax along with a program to solve
Twelve members groups discussion on general topics
(2 Questions)
- Q1. Questions regarding relocation
- Q2. Tel me something interesting about yourself
- Ans.
I am an avid traveler and have visited over 20 countries.
I love exploring new cultures and experiencing different cuisines.
Some of my favorite travel destinations include Japan, Italy, and Thailand.
I enjoy documenting my travel experiences through photography and blogging.
Traveling has taught me to be adaptable and open-minded, which are valuable skills in the data engineering field.
Interview Preparation Tips
I applied via Referral and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Spark and give diff
- Q2. What is Smb join
- Ans.
Smb join is a method used to join two tables in SQL Server.
Smb join stands for Sort Merge Bucket join.
It is used when joining large tables.
It involves sorting the tables and then merging them.
It is an efficient join method for large tables with indexes.
Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column OPTION (HASH JOIN, MERGE JOIN, LOOP JOIN);
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Aug 2021. There were 3 interview rounds.
MCQ based online test for the technology being interviewed for
(1 Question)
- Q1. Multiple questions related to the technology being interviewed for
(1 Question)
- Q1. Employment and salary related questions
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Questions are mostly on azure concepts,SQL server, and data warehousing concepts
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(4 Questions)
- Q1. Lazy evaluation narrow wide tranform data brick utlity functions
- Q2. Dag,edges vertices
- Q3. Spark architecture
- Q4. Memory allocation
NucleusTeq Interview FAQs
Tell us how to improve this page.
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
NucleusTeq Data Engineer Interview Process
based on 3 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
|
Software Engineer
22
salaries
|  ₹5 L/yr - ₹7 L/yr |
|
Data Engineer
7
salaries
| ₹6.5 L/yr - ₹8 L/yr |
|
Senior Software Engineer
5
salaries
| ₹3.5 L/yr - ₹13.3 L/yr |
|
Software Developer
4
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Engineer
4
salaries
| ₹10 L/yr - ₹26 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- NucleusTeq Interview Questions >
- NucleusTeq Data Engineer Interview Questions
