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.
Explain ETL Process in Data Warehouse
ETL is a process in Data Warehousing and it stands for Extract, Transform and Load. It is a process in which an ETL tool extracts the data from various data source systems, transforms it in the staging area, and then finally, loads it into the Data Warehouse system.
The different steps in ETL process are :
1) Extraction:
The first step of the ETL process is extraction. In this step, data from various sou...
What is a Slowly Changing Dimension (SCD)? What are the different types of SCDs?
What is a Slowly Changing Dimension?
A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records.
There are three types of SCDs and you can use Warehouse Builder to define, deploy, and load all three types of SCDs.
Type 1 SCDs - Ove...
What do you mean by Degenerate Dimension?
A high cardinality attribute column in the fact table which does not have any other content except its natural key and is required as a dimension for analysis or drill-down purpose, is called a degenerate dimension. As this degenerate dimension is constructed from a fact table item and is placed in the fact table, it is also known as fact dimension. It helps to reduce duplicate data by placing high cardinality dimensio
Round duration - 50 Minutes
Round difficulty - Medium
This round had questions from Data Warehouse and DBMS.
Difference between Fact Table and Dimension Table
1) Fact table contains the measuring on the attributes of a dimension table.
Dimension table contains the attributes on that truth table calculates the metric.
2) In fact table, There is less attributes than dimension table.
While in dimension table, There is more attributes than fact table.
3) In fact table, There is more records than dimension table.
While in dimension table, There is less records than fact table.
4) Fact ...
Difference b/w OLAP and OLTP
OLAP stands for Online analytical processing and OLTP stands for Online transaction processing. The major differences b/w OLTP and OLAP are :
1) OLAP : Consists of historical data from various Databases.
OLTP : Consists only operational current data.
2) OLAP : It is subject oriented. Used for Data Mining, Analytics, Decision making,etc.
OLTP : It is application oriented. Used for business tasks.
3) OLAP : It reveals a...
How to delete Duplicates From a Table in SQL Server?
To delete the duplicate rows from the table in SQL Server, we should follow these steps:
1) Find duplicate rows using GROUP BY clause or ROW_NUMBER() function.
2) Use DELETE statement to remove the duplicate rows.
Difference b/w INNER JOIN and OUTER JOIN in SQL.
1) INNER JOIN : It returns the combined tuple between two or more tables.
OUTER JOIN : It returns the combined tuple from a specified table even join condition will fail.
2) INNER JOIN : Used clause INNER JOIN and JOIN.
OUTER JOIN : Used clause LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, etc.
3) INNER JOIN : When any attributes are not common then it will return nothing.
OUTER JOIN : It does not depend upon the comm...
Round duration - 30 Minutes
Round difficulty - Easy
This was a typical HR round with some standard Behavioral questions.
Tell me something about yourself?
Tip 1 : Prepare the points that you will speak in your introduction prior to the interview.
Tip 2 : Tell about your current cgpa, achievements and authenticated certification
Tip 3 : I told about my role in current internship and what all I do
Why are you looking for a job change?
Tip : For an experienced professional seeking a change, this is a common question. The easiest method to respond to this question is to state that you are leaving your current work in order to advance your career. Make sure you don't criticize or speak poorly about the company where you now work.
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
posted on 17 Oct 2024
REST API is lightweight, flexible, and widely used, while SOAP API is more rigid and heavy.
REST API uses standard HTTP methods like GET, POST, PUT, DELETE, while SOAP API uses XML for communication.
REST API is stateless and can be cached, making it faster, while SOAP API is stateful and requires more bandwidth.
REST API is easier to implement and understand, while SOAP API has more built-in security features.
Examples: R
posted on 19 Aug 2024
Questions from Resume, solving code snippets, DSA Algo
GCD, Core Data, Higher Order Functions, ARC are key concepts in iOS development.
GCD (Grand Central Dispatch) is a technology for managing concurrent operations.
Core Data is a framework for managing the model layer objects in an application.
Higher Order Functions are functions that operate on other functions, taking them as arguments or returning them.
ARC (Automatic Reference Counting) is a memory management technology
posted on 29 Apr 2024
I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.
HTTP/1.1 is the older version with persistent connections, HTTP/2.0 introduces multiplexing and server push, and HTTP/3.0 uses QUIC protocol for faster performance.
HTTP/1.1 uses persistent connections for each request/response, leading to potential performance issues.
HTTP/2.0 introduces multiplexing, allowing multiple requests/responses to be sent over a single connection simultaneously.
HTTP/2.0 also supports server pu...
Print all possible subsets from a given slice of integers
Use recursion to generate all possible subsets
For each element in the slice, include or exclude it in the subset
Keep track of the current subset being generated
Context package in Go language provides a way to pass around deadlines, cancellation signals, and other request-scoped values.
Context package is used to manage deadlines, cancellation signals, and request-scoped values in Go programs.
It allows passing data between function calls without having to pass them explicitly as arguments.
Context package is commonly used in web servers to manage request-specific data and timeou...
REST API is a standard protocol for web services using HTTP, while gRPC is a high-performance, open-source RPC framework.
REST API uses HTTP for communication, making it easy to implement and widely supported.
gRPC is a modern, high-performance RPC framework that uses HTTP/2 for transport and Protocol Buffers for serialization.
gRPC is more efficient in terms of performance and supports features like bidirectional streami...
Use copy() function to create a new slice and reflect changes in original slice to the new slice.
Use the copy() function to create a new slice with the same length as the original slice.
Make changes to the original slice.
The changes made to the original slice will automatically reflect in the new slice as well.
GoLang is best for its simplicity, efficiency, concurrency support, and strong community backing.
Efficient performance due to compiled nature and garbage collection
Concurrency support with goroutines and channels
Strong standard library with built-in support for networking, encoding, and more
Simple and clean syntax that promotes readability and maintainability
Growing community and ecosystem with popular frameworks like
Kubernetes is an open-source container orchestration platform for automating deployment, scaling, and management of containerized applications.
Kubernetes follows a master-slave architecture with a master node controlling multiple worker nodes.
Master node components include API server, scheduler, controller manager, and etcd.
Worker node components include kubelet, kube-proxy, and container runtime (e.g. Docker).
Kubernet...
posted on 25 Sep 2024
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
1 Interview rounds
based on 17 reviews
Rating in categories
Associate Analyst
3.8k
salaries
| ₹1 L/yr - ₹4 L/yr |
Senior Software Engineer
3.3k
salaries
| ₹5.1 L/yr - ₹22 L/yr |
Analyst
3.1k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Software Engineer
2.9k
salaries
| ₹3 L/yr - ₹13 L/yr |
Associate Consultant
2.7k
salaries
| ₹9 L/yr - ₹32 L/yr |
TCS
Wipro
Infosys
HCLTech