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 appeared for an interview in Feb 2025.
INVEST and SMART are frameworks for defining effective user stories and goals in product management.
INVEST stands for Independent, Negotiable, Valuable, Estimable, Small, and Testable. Example: A user story like 'As a user, I want to reset my password' is independent and valuable.
SMART stands for Specific, Measurable, Achievable, Relevant, and Time-bound. Example: 'Increase user sign-ups by 20% in the next quarter' is ...
Agile ceremonies are structured meetings that facilitate collaboration and progress in Agile project management.
Sprint Planning: Teams define the work to be completed in the upcoming sprint. Example: Prioritizing user stories for the next two weeks.
Daily Stand-up: A quick daily meeting for team members to share updates and obstacles. Example: Each member shares what they did yesterday, what they'll do today, and any bl...
APIs are stored on servers; GraphQL offers flexible queries unlike REST's fixed endpoints.
APIs are typically stored on web servers or cloud platforms.
GraphQL allows clients to request specific data, reducing over-fetching.
REST APIs have fixed endpoints, while GraphQL uses a single endpoint for all queries.
Example: In REST, fetching user data might require multiple endpoints; in GraphQL, you can get all needed data in o...
I appeared for an interview 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...
What people are saying about GlobalLogic
I appeared for an interview 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...
GlobalLogic interview questions for popular designations
I appeared for an interview 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.
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 appeared for an interview in Sep 2024.
I am a dedicated engineer with a passion for product support, skilled in troubleshooting and enhancing user experiences.
Background in mechanical engineering with a focus on product design.
Experience in customer support roles, resolving technical issues efficiently.
Proficient in using diagnostic tools and software to identify product faults.
Strong communication skills, enabling effective collaboration with cross-functio...
My English communication was assessed through various interactive methods during the interview process.
I participated in a structured conversation where I was asked to explain technical concepts clearly.
I was given a scenario to troubleshoot and had to articulate my thought process effectively.
The interviewer evaluated my ability to ask clarifying questions and respond to feedback.
I engaged in a role-play exercise simu...
Use a Set to identify duplicates in an array of strings efficiently.
1. Create an empty Set to store unique values.
2. Iterate through the array and check if the value is already in the Set.
3. If it is, add it to a duplicates array; if not, add it to the Set.
Example: For array ['apple', 'banana', 'apple', 'orange'], duplicates will be ['apple'].
4. Return the duplicates array.
Primitive data types are basic types, while non-primitive types are more complex structures in JavaScript.
Primitive data types include: string, number, boolean, null, undefined, and symbol.
Non-primitive data types include: object, array, and function.
Primitive types are immutable; for example, strings cannot be changed once created.
Non-primitive types are mutable; for example, arrays can be modified by adding or removi...
JavaScript can extract query parameters using URLSearchParams or by parsing the URL manually.
Use URL constructor: const url = new URL('https://example.com?param1=value1¶m2=value2');
Extract parameters: const params = url.searchParams;
Get specific parameter: const param1 = params.get('param1'); // 'value1'
Iterate over all parameters: params.forEach((value, name) => console.log(`${name}: ${value}`));
Fallback me...
var is function-scoped, while let is block-scoped, leading to different behaviors in variable accessibility.
Scope: 'var' is function-scoped; 'let' is block-scoped.
Hoisting: Both are hoisted, but 'let' is not initialized until its declaration.
Re-declaration: 'var' allows re-declaration; 'let' does not.
Example of 'var': function test() { var x = 1; if (true) { var x = 2; } console.log(x); } // Outputs 2
Example of 'let': ...
I appeared for an interview in Dec 2024.
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 544 interviews
Interview experience
based on 4.7k reviews
Rating in categories
Associate Analyst
4k
salaries
| ₹1.2 L/yr - ₹5 L/yr |
Senior Software Engineer
3.4k
salaries
| ₹5.2 L/yr - ₹22.5 L/yr |
Analyst
3.1k
salaries
| ₹1.2 L/yr - ₹5.5 L/yr |
Software Engineer
3k
salaries
| ₹3 L/yr - ₹12.7 L/yr |
Associate Consultant
2.9k
salaries
| ₹9.2 L/yr - ₹33 L/yr |
Genpact
DXC Technology
Sutherland Global Services
Optum Global Solutions