CGI Group Senior Tableau Developer Interview Questions and Answers

Java assesment.

Q1. Where do you see yourself in 5 years?
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Timing was around 10am
It was quite a normal online examination kind of environment 
People from the company were there to invigilate 
All were quite nice and helpful in case the exam got stuck

Q1. 
Ninja and Alien Language Order Problem
An alien dropped its dictionary while visiting Earth. The Ninja wants to determine the order of characters used in the alien language, based on the given list of wor...read more
Ans. 
Determine the order of characters in an alien language based on a list of words.
• Create a graph data structure to represent the relationships between characters in the words.

• Perform a topological sort on the graph to find the order of characters.

• Return the smallest lexicographical order of characters as the result.
Answered by AI
Add your answer
Q2. 
Check Duplicate Within K Distance
Given an array of integers arr of size N and an integer K, determine if there are any duplicate elements within a distance of K from each other in the array. Return "true...read more
Ans. 
Check if there are any duplicate elements within a distance of K from each other in the array.
• Iterate through the array and keep track of the indices of elements using a hashmap.

• For each element, check if it already exists in the hashmap within distance K.

• Return true if a duplicate is found within distance K, otherwise return false.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

Timing was 2pm when it started
Interviewer was polite

Q1. 
Kth Largest Element Problem Statement
Ninja enjoys working with numbers, and Alice challenges him to find the Kth largest value from a given list of numbers.
Input:
The first line contains an integer 'T...read more
Ans. 
The task is to find the Kth largest element in a given list of numbers for each test case.
• Read the number of test cases 'T'

• For each test case, read the number of elements 'N' and the Kth largest number to find 'K'

• Sort the array in descending order and output the Kth element
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Timing was 9 am onwards 
Interviewer was good enough

Round duration - 60 Minutes
Round difficulty - Easy

This round consisted of 1 question from DSA with easy level of difficulty and then the rest of the questions were asked from DBMS and SQL.

Q1. 
Trailing Zeros in Factorial Problem
Find the number of trailing zeroes in the factorial of a given number N.
Input:
The first line contains an integer T representing the number of test cases.
Each of the...read more
Ans. 
Count the number of trailing zeros in the factorial of a given number N.
• Iterate through each test case and calculate the factorial of N.

• Count the number of trailing zeros by dividing the factorial by 10 until the remainder is not 0.

• Return the count of trailing zeros for each test case.
Answered by AI
Add your answer
Q2. Can you explain the concept of ACID properties in DBMS?
Ans. 
ACID properties in DBMS ensure data integrity and consistency.
• ACID stands for Atomicity, Consistency, Isolation, and Durability.

• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a valid state before and after the transaction.

• Isolation ensures that multiple transactions can run concurrently without affecting each other.

• Durabi...read more
Answered by AI
Add your answer
Q3. What is meant by normalization and denormalization?
Ans. 
Normalization is organizing data in a database to reduce redundancy and improve data integrity. Denormalization is adding redundant data to improve read performance.
• Normalization is the process of organizing data in a database to reduce redundancy and dependency by dividing the data into multiple tables and defining relationships between them.

• Denormalization is the process of adding redundant data to one or more tables...read more
Answered by AI
Add your answer
Q4. How do you take a backup of a table in MySQL?
Ans. 
Use the mysqldump command to take a backup of a table in MySQL.
• Use the mysqldump command followed by the database name and table name to take a backup of a specific table.

• Specify the username and password for the MySQL database using the -u and -p flags.

• Redirect the output of the mysqldump command to a file to save the backup.
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This round had questions revolving around Java and Selenium. Core concpets of Selenium were very frequent in
this interview.

Q1. What is a JIT compiler?
Ans. 
JIT compiler stands for Just-In-Time compiler, which compiles code during runtime instead of ahead of time.
• JIT compiler converts bytecode into machine code on-the-fly

• Improves performance by optimizing frequently executed code

• Examples include Java HotSpot, .NET CLR
Answered by AI
Add your answer
Q2. What are the advantages of using Packages in Java?
Ans. 
Packages in Java help organize and manage classes and interfaces, provide access control, and prevent naming conflicts.
• Organize classes and interfaces into a single unit for better maintainability

• Provide access control by using access modifiers like public, private, protected, and default

• Prevent naming conflicts by using unique package names

• Facilitate modular programming and code reusability
Answered by AI
Add your answer
Q3. What is the difference between assert and verify commands in Selenium?
Ans. 
Assert commands in Selenium are used to verify the expected result of a test case, while verify commands are used to check for the presence of an element without halting the test execution.
• Assert commands halt the test execution if the verification fails, while verify commands continue with the test execution even if the verification fails.

• Assert commands are used to validate the expected result of a test case, while v...read more
Answered by AI
Add your answer
Q4. When should I use Selenium Grid?
Ans. 
Selenium Grid is used for parallel testing across multiple browsers, devices, and operating systems.
• Use Selenium Grid when you need to run tests in parallel to save time.

• It is useful for testing on multiple browsers, devices, and operating systems simultaneously.

• Helps in reducing test execution time by distributing tests across multiple nodes.

• Useful for large test suites that require testing on various configurations.

• C...read more
Answered by AI
Add your answer
Q5. What are the different types of waits available in Selenium WebDriver?
Ans. 
Different types of waits in Selenium WebDriver include Implicit Wait, Explicit Wait, and Fluent Wait.
• Implicit Wait: Waits for a certain amount of time before throwing a NoSuchElementException.

• Explicit Wait: Waits for a certain condition to occur before proceeding further in the code.

• Fluent Wait: Waits for a condition to be true with a specified polling frequency and timeout.
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.

Q1. Why should we hire you?
Add your answer
Q2. Why are you looking for a job change?
Add your answer

Easy logical questions
basic quant

Easy level coding questions
Counting frequency of alphabets