QS Quacquarelli Symonds ETL Developer Interview Questions and Answers for Experienced

Q1. Dependency Injection
Add your answer
Q2. Life Cycle Hooks in Angular
Ans. 
Life Cycle Hooks are functions that Angular calls at specific points in the life of a component.
• There are eight different life cycle hooks in Angular.

• They are: ngOnChanges, ngOnInit, ngDoCheck, ngAfterContentInit, ngAfterContentChecked, ngAfterViewInit, ngAfterViewChecked, ngOnDestroy.

• These hooks allow developers to perform specific actions at different stages of a component's life cycle.

• For example, ngOnInit is called...read more
Answered by AI
Add your answer

Basic coding and MySQL queries. Like Types of join, having and where difference etc.

Q1. Salary Discussion.
Add your answer

Q1. Practical questions regarding database like sp,trigger,rank
Add your answer
Q2. Difference b/w sp and function
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are blocks of code that can be called within SQL queries.
• Stored procedures are stored in the database and can be called using a specific name.

• Functions are defined using CREATE FUNCTION and can be called within SQL queries.

• Stored procedures can have input and output parameters, while functions can only return a single value.

• Stored pro...read more
Answered by AI
Add your answer

Q1. Salary negotiations
Add your answer

Q1. How was my overall experience during 3 year articleship?
Ans. It was basically related to internal audit of power industry based company.
Answered Anonymously
Add your answer
Q2. Do I have prepared the accounts of company?
Ans. Yes, to some extent i have also prepared the accounts of clients of our firm.
Answered Anonymously
Add your answer

Q1. Why i am choosing this company?
Ans. As it is a startup company I expect to learn new things from here as compared to other well established and system oriented organisation and also help the company to grow in near future.
Answered Anonymously
Add your answer

Q1. Why I am choosing this company when i have a offer letter from other company having package higher than this ?
Ans. The profile of mine in this company is such that at beginning of my career I want to start as same.
Answered Anonymously
Add your answer

Q1. What is OOPS concepts.
Ans. 
OOPS concepts refer to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation detail
Answered by AI
Add your answer
Q2. What is PDO and uses in PHP.
Ans. 
PDO stands for PHP Data Objects, a database access layer providing a uniform method of access to multiple databases.
• PDO is a PHP extension that provides a data-access abstraction layer.

• It supports multiple database systems like MySQL, PostgreSQL, SQLite, etc.

• PDO helps prevent SQL injection attacks by using prepared statements.

• It allows for error handling and supports transactions.

• Example: $pdo = new PDO('mysql:host=loc...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Q1. 
Path Queries Problem Statement
Consider a weighted, undirected graph with 'V' vertices numbered from 1 to 'V' and 'E' bidirectional edges. You are tasked with handling 'Q' queries. For each query, you are...read more
Ans. 
Implement a function to find the shortest distance between two vertices in a weighted, undirected graph.
• Use Dijkstra's algorithm to find the shortest path between the given vertices.

• Create a graph data structure to represent the weighted, undirected graph.

• Handle cases where no path exists between the given vertices by returning -1.

• Optimize the algorithm to handle multiple queries efficiently.

• Consider edge cases such as...read more
Answered by AI
Add your answer
Q2. 
Merge Sort Algorithm Problem Statement
Your task is to sort a sequence of numbers stored in the array ‘ARR’ in non-descending order using the Merge Sort algorithm.
Explanation:
Merge Sort is a divide-an...read more
Ans. 
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
• Divide the input array into two halves recursively

• Sort the two halves separately

• Merge the sorted halves to produce a fully sorted array

• Time complexity of Merge Sort is O(n log n)

• Example: Input - [5, 2, 9, 1, 5], Output - [1, 2, 5, 5, 9]
Answered by AI
Add your answer
Q3. 
Rat in a Maze: All Paths Problem
You are provided with an N * N maze where a rat is positioned at starting cell MAZE[0][0]. The goal is to determine and print all possible paths that the rat can take to r...read more
Ans. 
Given an N * N maze with binary values, find and print all possible paths for a rat to reach the destination cell.
• Use backtracking to explore all possible paths from the starting cell to the destination cell.

• At each cell, check if it is a valid move (within bounds and not blocked), then recursively explore all four directions.

• Keep track of the path taken so far and mark the cells accordingly.

• Once the destination cell i...read more
Answered by AI
Add your answer

Q1. What is DAX and its use in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI for data modeling and analysis.
• DAX is used to create calculated columns and measures in Power BI.

• It allows for advanced data analysis, such as time intelligence functions (e.g., YEAR, MONTH).

• Example: A measure to calculate total sales could be defined as: Total Sales = SUM(Sales[Amount]).

• DAX supports filtering and context manipulation, enabling dyna...read more
Answered by AI
Add your answer
Q2. Role of power query in power bi
Add your answer

Question on Linked list. array and string manipulation.