i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
Slowly changing dimension (SCD) is a concept in data warehousing that describes how dimensions change over time.
SCD Type 1: Overwrites old data with new data, losing historical information.
SCD Type 2: Keeps multiple versions of the same dimension, creating new records for each change.
SCD Type 3: Keeps both old and new values in the same record, with separate columns for each version.
SCD Type 4: Uses separate tables to ...
Check Knowledge Module is used in ODI to validate data before loading it into target tables.
It is used to perform data quality checks on the source data
It can be used to check for duplicates, missing values, data format, etc.
It helps ensure that only clean and accurate data is loaded into the target tables
Knowledge Modules in ODI are reusable components that define the logic for performing specific tasks in the ETL process.
Types include Loading Knowledge Modules, Integration Knowledge Modules, Check Knowledge Modules, Reverse-Engineering Knowledge Modules, and Service Knowledge Modules.
Loading Knowledge Modules handle data loading into target tables.
Integration Knowledge Modules handle data integration between source an...
Identify the duplicate character in the string.
I was interviewed in Jan 2025.
Trips for cracking interview
I was interviewed in Dec 2024.
I chose Flask over Django and FastAPI due to its simplicity, flexibility, and ease of use for smaller projects.
Flask is lightweight and minimalistic, making it easier to set up and use for smaller projects.
Flask allows for more flexibility in terms of project structure and customization compared to Django.
Flask is well-suited for rapid prototyping and smaller applications where simplicity is key.
Django, on the other ha...
Flask request and response block code snippet
Use Flask's request object to access incoming request data
Use Flask's jsonify function to create a JSON response
Handle different HTTP methods like GET, POST, etc. in the route function
ORM stands for Object-Relational Mapping, a programming technique for converting data between incompatible type systems in object-oriented programming languages.
ORM is used to map objects from an application to tables in a relational database.
It simplifies data manipulation by allowing developers to work with objects instead of SQL queries.
Popular ORM tools include Hibernate for Java, Entity Framework for .NET, and Seq
Use ORM code to select item from a table in database.
Use ORM query methods like find(), findOne(), or where() to select items from a table.
Specify the table name and any conditions for the selection.
Example: User.find({ where: { id: 1 } }) will select a user with id 1 from the User table.
I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
Logical reasoning, quantitative analysis and computer test
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
Using sliding window technique to find subarray with sum equal to k.
Initialize two pointers at the start of the array.
Move the right pointer to expand the window until the sum is greater than or equal to k.
Move the left pointer to shrink the window if the sum exceeds k.
Repeat until the end of the array is reached.
Example: Input array [1, 4, 20, 3, 10, 5], k=33. Output: [20, 3, 10].
I have 5 years of experience in developing web applications using Angular.
Developed responsive web applications using Angular framework
Implemented RESTful APIs to fetch and update data
Worked on optimizing performance and improving user experience
Collaborated with UI/UX designers to create visually appealing interfaces
A directive in Angular is a class with a @Directive decorator that allows you to attach behavior to elements in the DOM.
Directives are used to manipulate the DOM, add behavior to elements, and create reusable components.
There are three types of directives in Angular: Component, Structural, and Attribute directives.
Examples of directives include ngIf, ngFor, and ngStyle.
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Consultant
55.1k
salaries
| ₹5.2 L/yr - ₹17 L/yr |
Associate Consultant
50.8k
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Consultant
46.1k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
Senior Analyst
20.8k
salaries
| ₹2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.1k
salaries
| ₹3.5 L/yr - ₹12.4 L/yr |
Wipro
Accenture
Cognizant
TCS