i
GlobalLogic
Filter interviews by
I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.
A closure is a function that has access to its own scope, as well as the outer scope in which it was defined.
A closure can access variables from its outer function even after the outer function has finished executing.
Closures are commonly used in event handlers, callbacks, and asynchronous code.
Example: const outerFunction = () => { const outerVar = 'I am outer'; return () => { console.log(outerVar); }; }; const innerF...
Arrow functions are concise syntax for writing functions in JavaScript, compared to normal functions.
Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.
Arrow functions do not have 'arguments' object.
Arrow functions cannot be used as constructors.
Arrow functions are more concise and easier to read compared to normal functions.
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...
posted on 13 Jan 2015
Collection hierarchy in Java includes interfaces like Collection, List, Set, Queue, and Map with their respective implementations.
Collection interface is the root interface in the collection hierarchy
List interface extends Collection and allows duplicate elements, with implementations like ArrayList and LinkedList
Set interface extends Collection and does not allow duplicate elements, with implementations like HashSet a...
posted on 9 Feb 2015
SQL command for creating a table
Use CREATE TABLE statement
Specify table name and column names with data types
Add any constraints or indexes as needed
SQL commands for inserting, updating, and deleting data from a table.
INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);
UPDATE table_name SET column1 = new_value1 WHERE condition;
DELETE FROM table_name WHERE condition;
Truncate and drop are SQL commands used to remove data from a table.
Truncate removes all data from a table but keeps the structure intact.
Drop removes the entire table and its structure.
Truncate is faster than drop as it only removes data.
Drop cannot be undone while truncate can be rolled back.
Truncate resets the identity of the table while drop does not.
Examples: TRUNCATE TABLE table_name; DROP TABLE table_name;
C++ is an extension of C with object-oriented programming features.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance.
C++ has a standard template library (STL) while C does not.
C++ allows function overloading while C does not.
C++ has exception handling while C does not.
I am a software developer with experience in Java and Python.
I have a Bachelor's degree in Computer Science.
I have worked on various projects involving web development and data analysis.
I am proficient in Java and Python programming languages.
I have experience with frameworks such as Spring and Django.
I am familiar with databases such as MySQL and MongoDB.
I have always been fascinated by technology and its ability to solve complex problems.
I enjoy problem-solving and logical thinking
I have a natural curiosity for how things work
I see the potential for technology to make a positive impact on society
I have experience in programming and find it rewarding
I am excited about the constant innovation and evolution in the IT industry
My strengths include problem-solving, adaptability, and teamwork. My weakness is public speaking.
Strengths: problem-solving, adaptability, teamwork
Examples: I have successfully solved complex coding problems, adapted to new technologies quickly, and collaborated effectively with team members.
Weakness: public speaking
Examples: I get nervous when speaking in front of large groups, but I am working on improving my present
I have the technical skills, experience, and passion to excel in this role.
I have a strong background in software development, with expertise in multiple programming languages and frameworks.
I have experience working on complex projects and collaborating with cross-functional teams.
I am passionate about staying up-to-date with the latest technologies and trends in the industry.
I am a quick learner and adaptable to new ...
I applied via Approached by Company and was interviewed before May 2018. There was 1 interview round.
I appeared for an interview in Jun 2017.
Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.
Encourages modular and reusable code
Provides a clear structure and organization to the code
Allows for easier maintenance and updates
Supports code reusability through inheritance and polymorphism
Enables encapsulation, hiding the internal details of an object
Promotes code extensibility and scalability
Facilitates...
I want to join ATOS because of their reputation for innovation and their commitment to employee growth and development.
ATOS is known for its innovative solutions in the software development industry.
I am impressed by ATOS's focus on employee growth and development through training programs and career advancement opportunities.
ATOS has a strong reputation for delivering high-quality software solutions to its clients.
I b...
posted on 22 Jul 2021
I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Associate Analyst
3.9k
salaries
| ₹1 L/yr - ₹7.2 L/yr |
Senior Software Engineer
3.4k
salaries
| ₹5.3 L/yr - ₹22 L/yr |
Analyst
3.1k
salaries
| ₹1.1 L/yr - ₹5.7 L/yr |
Software Engineer
3k
salaries
| ₹4 L/yr - ₹12.5 L/yr |
Associate Consultant
2.9k
salaries
| ₹9.2 L/yr - ₹33 L/yr |
Genpact
DXC Technology
Sutherland Global Services
Optum Global Solutions