NucleusTeq Interview Questions, Process, and Tips

Q1. 1 SQL problem 1 Pyspark Problem Few Data modelling question and project related.
Add your answer

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
Answered by AI
Add your answer

Q1. Basic HR questions.
Add your answer

Simple question from array and string along with one sql query and some computer science problems

Q1. Ask question according to resume
Add your answer
Q2. Sql query and DSA problem
Add your answer
Q3. Core java problem
Add your answer

Q1. Prepare Amazon Cart APIs in java, create Rest API s with proper code.
Ans. 
Create Amazon Cart APIs in Java for Rest API
• Use Spring Boot framework for creating Rest APIs

• Implement CRUD operations for managing cart items

• Secure APIs using authentication and authorization mechanisms

• Handle error responses and exceptions gracefully

• Test APIs using tools like Postman or JUnit
Answered by AI
Add your answer
Q2. Reverse words given in a string (java programme).
Ans. 
Reverse words in a string using Java program.
• Split the string into an array of words using split() method

• Iterate through the array in reverse order and append each word to a new string

• Return the reversed string
Answered by AI
Add your answer

Q1. Memory management introduced in java 1.8. Explain about that.
Ans. 
Java 1.8 introduced improvements in memory management with features like Metaspace and G1 garbage collector.
• Metaspace replaces the permanent generation (PermGen) for class metadata storage.

• G1 garbage collector is designed for better performance and predictability by dividing the heap into regions.

• These improvements help in reducing memory leaks and optimizing garbage collection.

• Example: Use of Metaspace allows for dyna...read more
Answered by AI
Add your answer
Q2. Prepare your project till the deepest level.
Ans. 
I will provide a detailed overview of my project, including its objectives, features, technologies used, and the overall architecture.
• Outline the project objectives and goals

• Describe the features and functionalities of the project

• Explain the technologies and tools used in the project

• Discuss the overall architecture and design of the project
Answered by AI
Add your answer

90 minutes aptitude + coding questions also there

Q1. Regarding oops and all its pillars
Add your answer
Q2. Regarding pointers
Add your answer