i
GlobalLogic
Filter interviews by
I applied via Naukri.com and was interviewed before Dec 2019. There were 3 interview rounds.
ETL stands for Extract, Transform, Load and DWH stands for Data Warehouse.
ETL is a process of extracting data from various sources, transforming it into a format suitable for analysis, and loading it into a target system.
DWH is a system used for storing and managing data from various sources for business intelligence purposes.
ETL is a crucial step in populating a DWH with data.
ETL involves data extraction, data transfo...
Outer join returns all records from one table and matching records from another, while inner join returns only matching records.
Outer join uses the (+) symbol in Oracle and LEFT/RIGHT OUTER JOIN in SQL Server
Inner join uses INNER JOIN keyword in SQL
Sample data: Table A has 5 records, Table B has 3 records, Outer join returns 8 records while Inner join returns 3 records
SCDs are used to track changes in data over time. There are three types: Type 1, Type 2, and Type 3.
Type 1 SCDs overwrite old data with new data.
Type 2 SCDs add a new row for each change, with a start and end date.
Type 3 SCDs add columns to the existing row to track changes.
SCDs are commonly used in data warehousing and business intelligence.
The choice of SCD type depends on the specific use case and data requirements.
To delete duplicate rows based on key in a table, use the DELETE statement with a subquery.
Identify the key column(s) that define the uniqueness of a row
Use the GROUP BY clause to group the rows by the key column(s)
Use the HAVING clause to filter out the groups that have more than one row
Use the subquery to select the duplicate rows to be deleted
Use the DELETE statement with the subquery to delete the duplicate rows
Fact and dimension are two types of data in a data warehouse.
Fact is a measurable event that can be analyzed, while dimension provides context to the fact.
Fact is quantitative, while dimension is qualitative.
Fact is stored in a fact table, while dimension is stored in a dimension table.
Examples of fact include sales, revenue, and profit, while examples of dimension include time, location, and product.
Fact and dimension...
Yes, fact tables can be joined together in a data warehouse to combine related information.
Fact tables contain quantitative data and are typically joined using common dimensions.
Joining fact tables allows for more comprehensive analysis and reporting.
For example, joining a sales fact table with a customer fact table can provide insights on customer behavior and purchasing patterns.
Degenerate dimension refers to a dimension with only one value.
A degenerate dimension is a dimension table with only one column and one row.
It is used to join fact tables with different granularity levels.
For example, a time dimension with only one value can be used to join a sales fact table with daily granularity and a returns fact table with hourly granularity.
OLTP is a transactional system for day-to-day operations, while OLAP is analytical system for decision-making.
OLTP deals with real-time data processing, while OLAP deals with historical data analysis.
OLTP is optimized for write operations, while OLAP is optimized for read operations.
OLTP is used for operational tasks like order processing, while OLAP is used for strategic tasks like sales forecasting.
OLTP databases are...
I was interviewed in Jan 2025.
Correlation is the process of extracting dynamic values from server responses and passing them to subsequent requests. Parameterization is the process of replacing hard-coded values in scripts with variables.
Correlation involves identifying and capturing dynamic values like session IDs or tokens from server responses.
Parameterization involves replacing hard-coded values in scripts with variables to make them reusable a...
Load testing is to test the system under normal and peak load conditions, stress testing is to test the system beyond its limits, and all testing is a combination of both.
Load testing checks the system's ability to handle expected load levels, ensuring performance under normal conditions.
Stress testing pushes the system beyond its limits to identify breaking points and measure performance degradation.
All testing combin...
PTLC stands for Performance Testing Life Cycle, which is a set of activities involved in the performance testing process.
PTLC involves planning, preparation, execution, analysis, and reporting of performance tests.
It includes defining performance goals, creating test scenarios, setting up test environments, running tests, analyzing results, and making recommendations.
Example: In PTLC, performance engineers work closely...
Issues faced in Loadrunner scripting, execution, and reports
Scripting: faced issues with correlation, parameterization, and dynamic data handling
Execution: encountered problems with test environment setup, resource constraints, and test data management
Reports: struggled with result analysis, performance bottlenecks identification, and report customization
LG calculation and workload modelling process involves determining the number of Load Generators required and creating a realistic simulation of user behavior.
Calculate the number of Load Generators needed based on expected user load and performance goals.
Create workload models by analyzing user behavior patterns, transaction volumes, and system usage.
Consider factors like peak load times, user distribution, and transa...
NFR scenarios refer to non-functional requirements that define the quality attributes of a system.
NFR scenarios focus on aspects like performance, scalability, reliability, and security.
Examples include load testing to assess system performance under expected load, stress testing to evaluate system behavior under extreme conditions, and security testing to identify vulnerabilities.
NFR scenarios help ensure that the sys...
I was interviewed in Dec 2024.
Currently working on developing automated test scripts for a web application
Creating test cases using Selenium WebDriver
Implementing test automation frameworks like TestNG
Performing regression testing on new features
Collaborating with developers to identify and fix bugs
Code for sorting an array of strings
Use built-in sort function in programming language (e.g. sort() in Python)
Specify the comparison function to sort strings alphabetically
Handle uppercase and lowercase letters properly
Example: ['apple', 'banana', 'cherry'] should be sorted as ['apple', 'banana', 'cherry']
Creating Xpath for locating elements in web pages
Use unique attributes like id, class, name to create Xpath
Avoid using indexes in Xpath as they can be brittle
Use functions like contains(), starts-with() for dynamic attributes
Consider using axes like ancestor, following-sibling for complex Xpath
GlobalLogic offers a diverse range of projects, cutting-edge technologies, and a collaborative work environment.
GlobalLogic provides opportunities to work on a variety of projects, allowing for professional growth and skill development.
The company is known for its use of cutting-edge technologies, providing exposure to the latest tools and trends in the industry.
GlobalLogic fosters a collaborative work environment, enc...
What people are saying about GlobalLogic
I was interviewed in Dec 2024.
A basic aptitude test includes logical reasoning questions and percentage problems, comprising a total of ten questions, along with two paragraph-based questions.
GlobalLogic interview questions for popular designations
Get interview-ready with Top GlobalLogic Interview Questions
I applied via Campus Placement and was interviewed in Oct 2024. There were 5 interview rounds.
Basic aptitudes question in online test
Two coding Q online test
I want to join Global Logic because of their reputation for cutting-edge technology solutions and collaborative work environment.
Global Logic is known for their innovative technology solutions
I am impressed by the collaborative work environment at Global Logic
I believe Global Logic offers great opportunities for professional growth and development
Fundamentals of Data Structures and Algorithms, including SQL.
I was interviewed in Dec 2024.
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
Promises are objects representing the eventual completion or failure of an asynchronous operation.
Promises are used to handle asynchronous operations in JavaScript.
They can be in one of three states: pending, fulfilled, or rejected.
Promises can be chained using .then() to handle success and .catch() to handle errors.
Example: const myPromise = new Promise((resolve, reject) => { ... });
Box model in CSS refers to the way elements are rendered in a web page. CSS preprocessors like SASS or LESS help streamline CSS development.
Box model in CSS includes content, padding, border, and margin.
CSS preprocessors like SASS or LESS allow for variables, nesting, and mixins to be used in CSS.
Example: box-sizing: border-box; in CSS changes the box model to include padding and border in the element's total width and
I applied via Campus Placement and was interviewed in Aug 2024. There were 5 interview rounds.
Some of the top questions asked at the GlobalLogic interview -
The duration of GlobalLogic interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 529 interviews
Interview experience
based on 4.5k 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