i
GlobalLogic
Filter interviews by
Clear (1)
I was interviewed before Mar 2024.
I joined this company as a fresher, the first round was a coding test based on DSA MCQs and 2 coding questions.
I applied via Job Portal and was interviewed in Feb 2024. There were 2 interview rounds.
CTE stands for Common Table Expressions, used to create temporary result sets within a SQL query.
CTE is defined using the WITH keyword in SQL.
It helps in simplifying complex queries by breaking them into smaller, more manageable parts.
CTEs can reference themselves recursively, making them useful for hierarchical data.
Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte;
Print even and odd numbers between 1 to 20.
Iterate from 1 to 20 and check if the number is even or odd.
Use a conditional statement to determine if the number is even or odd.
Print the number along with its type (even or odd).
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
What people are saying about GlobalLogic
I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.
GlobalLogic interview questions for designations
I applied via Referral and was interviewed before Oct 2022. There were 2 interview rounds.
Get interview-ready with Top GlobalLogic Interview Questions
I was interviewed before Feb 2021.
Round duration - 50 Minutes
Round difficulty - Medium
This round mainly revolved around concepts from Data Warehouse and Big Data.
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:...
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.
Round duration - 50 Minutes
Round difficulty - Medium
This round had questions from Data Warehouse and DBMS.
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...
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...
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
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...
Round duration - 30 Minutes
Round difficulty - Easy
This was a typical HR round with some standard Behavioral questions.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
Puzzles, Psychometric Test
based on 5 interviews
2 Interview rounds
based on 17 reviews
Rating in categories
Associate Analyst
3.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
3.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
3.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
2.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Infosys
HCLTech