UST ETL Developer Interview Questions and Answers

Q1. Explain SSIS and ite use cases
Ans. 
SSIS is a Microsoft tool used for ETL processes in data integration and data warehousing.
• SSIS stands for SQL Server Integration Services

• It is used for extracting, transforming, and loading data from various sources to destinations

• SSIS can be used for automating workflows, data cleansing, and data migration tasks

• It provides a visual interface for designing data flow tasks and control flow tasks

• Example: Using SSIS to ext...read more
Answered by AI
Add your answer

Q1. Basic Question Answer
Add your answer
Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Add your answer

Q1. Run time polymorphism code
Add your answer
Q2. Linked list code
Add your answer
Q3. Deep copy shallow copy differences
Ans. 
Deep copy creates a new copy of an object with its own unique memory space, while shallow copy creates a new object that references the same memory locations as the original object.
• Deep copy duplicates all nested objects, while shallow copy only duplicates the references to nested objects.

• Deep copy ensures that changes to the copied object do not affect the original object, while shallow copy may lead to unintended sid...read more
Answered by AI
Add your answer

Q1. More deep questions about polymorphism code
Add your answer
Q2. Code for interchange of strings without strcpy
Ans. 
Use a loop to swap characters of two strings without using strcpy function.
• Create two arrays of characters to store the strings

• Use a loop to iterate through each character of the strings and swap them

• Ensure to handle cases where strings have different lengths
Answered by AI
Add your answer

3 coding problems
1 aptitude
1 puzzle
3 hrs duration

Q1. Sorting algorithms
Add your answer
Q2. 1 puzzle - burning candles
Add your answer

Q1. General discussion on resume
Add your answer
Q2. Few reasoning questions
Add your answer

Q1. About company work culture
Add your answer

Q1. Difference between linked list and array list
Ans. 
Linked list is a data structure where elements are stored in nodes with pointers to the next node. Array list is a dynamic array that can grow or shrink in size.
• Linked list allows for efficient insertion and deletion of elements anywhere in the list.

• Array list provides fast access to elements using index, but slower insertion and deletion compared to linked list.

• Example: Linked list - 1 -> 2 -> 3 -> 4 -> 5, Array list
Answered by AI
Add your answer
Q2. Difference between @controller and @ Rest controller
Ans. 
The @Controller annotation is used for traditional MVC controllers, while @RestController is used for RESTful web services.
• The @Controller annotation is used to define a class as a Spring MVC controller, which can handle HTTP requests and return a view.

• The @RestController annotation is used to define a class as a controller for RESTful web services, which can handle HTTP requests and return data in JSON or XML format.

• T...read more
Answered by AI
Add your answer

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer