GlobalLogic Senior Software Developer Interview Questions, Process, and Tips

Round duration - 50 Minutes
Round difficulty - Medium

This round mainly revolved around concepts from Data Warehouse and Big Data.

Q1. Can you explain the ETL process in a data warehouse?
Ans. 
ETL process involves extracting data from various sources, transforming it to fit the data warehouse schema, and loading it into the warehouse.
• Extract: Data is extracted from different sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, filtered, aggregated, and transformed to match the data warehouse schema.

• Load: Transformed data is loaded into the data warehouse for analysis and reporting.

• Example:...read more
Answered by AI
Add your answer
Q2. What do you mean by a degenerate dimension?
Ans. 
A degenerate dimension is a dimension that consists of only one attribute or column.
• It is typically used when a dimension table has only one column and no other attributes.

• It is often denormalized and included directly in the fact table.

• Example: a date dimension with only a date column can be considered a degenerate dimension.
Answered by AI
Add your answer

Round duration - 50 Minutes
Round difficulty - Medium

This round had questions from Data Warehouse and DBMS.

Q1. What is the difference between a Fact Table and a Dimension Table in a Data Warehouse?
Ans. 
Fact Table contains quantitative data and measures, while Dimension Table contains descriptive attributes.
• Fact Table contains numerical data that can be aggregated, such as sales revenue or quantity sold

• Dimension Table contains descriptive attributes for analysis, such as product name or customer details

• Fact Table typically has a many-to-one relationship with Dimension Table

• Fact Table is usually normalized, while Dimen...read more
Answered by AI
Add your answer
Q2. What is the difference between OLAP and OLTP?
Ans. 
OLAP is used for analyzing historical data for decision-making, while OLTP is used for managing real-time transactional data.
• OLAP stands for Online Analytical Processing, used for complex queries and data analysis.

• OLTP stands for Online Transaction Processing, used for managing real-time transactional data.

• OLAP databases are optimized for read-heavy workloads, while OLTP databases are optimized for write-heavy workload...read more
Answered by AI
Add your answer
Q3. How do you delete duplicates from a table in SQL Server?
Ans. 
Use a common table expression (CTE) with ROW_NUMBER() function to delete duplicates from a table in SQL Server.
• Create a CTE with ROW_NUMBER() function to assign a unique row number to each row based on the duplicate column(s)

• Use the DELETE statement with the CTE to delete rows where the row number is greater than 1
Answered by AI
Add your answer
Q4. What is the difference between INNER JOIN and OUTER JOIN in SQL?
Ans. 
INNER JOIN returns rows when there is at least one match in both tables, while OUTER JOIN returns all rows from both tables.
• INNER JOIN only returns rows that have matching values in both tables

• OUTER JOIN returns all rows from both tables, filling in NULLs for unmatched rows

• Types of OUTER JOIN include LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: SEL...read more
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This was a typical HR round with some standard Behavioral questions.

Q1. Can you tell me something about yourself?
Add your answer
Q2. Why are you looking for a job change?
Add your answer