GlobalLogic ETL Developer Interview Questions and Answers

Q1. Informtica with date functions
Ans. 
Informatica is a popular ETL tool used for data integration and transformation. It has built-in functions to handle date operations.
• Informatica is a powerful ETL tool used for extracting, transforming, and loading data.

• It provides a variety of built-in functions for handling date operations such as date calculations, formatting, and conversions.

• Examples of date functions in Informatica include TO_DATE, TO_CHAR, ADD_TO_
Answered by AI
Add your answer

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. Some in depth questions about python and java
Add your answer

Asked some problem solving questions they will allow to choose the language it's good

Q1. What is Dependency Injection?
Ans. 
Dependency Injection is a design pattern in which components are given their dependencies rather than creating them internally.
• Allows for easier testing by providing mock dependencies

• Promotes loose coupling between components

• Improves code reusability and maintainability

• Examples: Constructor injection, Setter injection, Interface injection
Answered by AI
Add your answer
Q2. How to handle exception in java
Ans. 
In Java, exceptions can be handled using try-catch blocks to catch and handle specific exceptions.
• Use try-catch blocks to catch exceptions and handle them gracefully

• Use multiple catch blocks to handle different types of exceptions

• Use finally block to execute code regardless of whether an exception is thrown or not

• Throw custom exceptions using throw keyword
Answered by AI
Add your answer

Q1. In Java8, different between flatmap and map
Ans. 
map transforms each element in a stream, while flatMap transforms each element into multiple elements
• map applies a function to each element in a stream and returns a new stream of the results

• flatMap applies a function that returns a stream for each element in the original stream, then flattens the streams into a single stream

• Example: map - stream.map(x -> x * x), flatMap - stream.flatMap(str -> Arrays.stream(str.split(
Answered by AI
Add your answer
Q2. How to handle the ConcureentModificationException
Ans. 
ConcurrentModificationException occurs when a collection is modified while iterating over it.
• Use Iterator to iterate over the collection instead of foreach loop.

• If modification is necessary, use Iterator's remove() method instead of collection's remove() method.

• Consider using synchronized collections or ConcurrentHashMap to avoid ConcurrentModificationException.
Answered by AI
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

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

Basic core java, reasoning,english

Dsa question of arrays

Q1. Tell me about yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Stacks and queues
Add your answer
Q3. Time complexity
Add your answer