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

Logical intelligence

Any information can be discussed.

A comprehensive analysis of an individual, group, situation, or phenomenon over an extended duration.

The reporter vanished while on assignment in the war zone.

Q1. Denoting or referring to a situation in which two parties come into direct contact, opposition, or correspondence
Add your answer

Aptitude, core concepts and a code

Q1. What is the one thing you learnt from college club?
Ans. 
I learned the importance of teamwork and collaboration from my college club.
• Developed strong communication skills by working with diverse group of individuals

• Learned how to delegate tasks effectively to achieve common goals

• Gained experience in problem-solving and conflict resolution through group projects
Answered by AI
Add your answer
Q2. What is the one thing you want to expereince?
Ans. 
I want to experience living in a different country and immersing myself in a new culture.
• Traveling to a foreign country and learning about their customs and traditions

• Trying new foods and experiencing different ways of life

• Making friends with locals and exploring the local attractions
Answered by AI
Add your answer

Q1. Difference between relational and non relational dbms
Ans. 
Relational DBMS stores data in tables with predefined relationships, while non-relational DBMS stores data in flexible, schema-less formats.
• Relational DBMS uses structured query language (SQL) for querying data

• Non-relational DBMS can store data in various formats like key-value pairs, document-based, graph databases

• Relational DBMS ensures data integrity through normalization and constraints

• Non-relational DBMS offers be...read more
Answered by AI
Add your answer
Q2. Difference betweeen class,abstract class,interface in python
Ans. 
Class is a blueprint for creating objects, abstract class cannot be instantiated and can have abstract methods, interface is a contract for classes to implement certain methods.
• Class is a blueprint for creating objects with attributes and methods.

• Abstract class cannot be instantiated and can have abstract methods that must be implemented by subclasses.

• Interface is a contract for classes to implement certain methods, bu
Answered by AI
Add your answer
Q3. Project related questions were asked
Add your answer

It was an online assessment containing 3 DSA questions

Q1. Medium level array questions
Add your answer
Q2. Medium level DP questions
Add your answer

Q1. General behavioural question about
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