i
GlobalLogic
Filter interviews by
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.
I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.
What people are saying about GlobalLogic
I applied via Referral and was interviewed before Oct 2022. There were 2 interview rounds.
GlobalLogic interview questions for designations
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.
Get interview-ready with Top GlobalLogic Interview Questions
I was interviewed before Aug 2016.
posted on 14 May 2018
I applied via Referral
Data structures are a way to organize and store data efficiently.
Data structures are used to store and manipulate data in a structured manner.
They provide different ways to access and perform operations on the data.
Examples include arrays, linked lists, stacks, queues, trees, and graphs.
Developed a web-based project management tool for tracking tasks and deadlines
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express for back-end
Utilized MongoDB for database management
Incorporated user authentication and authorization features
Integrated real-time notifications using Socket.io
My name is John Smith.
Full name is John Smith
Common name in English-speaking countries
Easy to remember and pronounce
The question is unrelated to the medical field and is not a puzzle or riddle.
The question is asking about the meaning of the interviewer's name.
You can ask the interviewer about the origin or cultural significance of their name.
You can also mention that names often have different meanings in different languages or cultures.
My strengths include problem-solving skills, attention to detail, and strong communication abilities.
Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.
Attention to detail - I am meticulous in my work and strive for accuracy in all tasks.
Strong communication abilities - I can effectively convey ideas and collaborate with team members.
based on 4 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.3k
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