i
kipi.ai
Filter interviews by
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
Types of joins include inner join, outer join, left join, right join, and full join.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full join: Returns rows whe
Use a DELETE statement with a self-join on the table to remove duplicates.
Use a DELETE statement with a self-join on the table to identify and remove duplicates.
Example: DELETE t1 FROM table_name t1 INNER JOIN table_name t2 WHERE t1.id < t2.id AND t1.column_name = t2.column_name;
ETL and ELT tools are used for extracting, transforming, and loading data in data warehousing and analytics processes.
ETL stands for Extract, Transform, Load and involves extracting data from various sources, transforming it into a usable format, and loading it into a data warehouse or database.
ELT stands for Extract, Load, Transform and involves extracting data, loading it into a target system, and then transforming i...
Yes, a new column can be added in between 2 existing columns in a table by altering the table structure.
Yes, a new column can be added in between 2 existing columns by using the ALTER TABLE statement in SQL.
The new column can be specified to be added after a specific existing column.
For example, ALTER TABLE table_name ADD new_column_name datatype AFTER existing_column_name;
Types of normalizations in databases help reduce redundancy and improve data integrity.
First Normal Form (1NF) - Eliminates repeating groups and ensures each column contains atomic values.
Second Normal Form (2NF) - Ensures all non-key attributes are fully functional dependent on the primary key.
Third Normal Form (3NF) - Removes transitive dependencies by moving non-key attributes to separate tables.
Boyce-Codd Normal Fo...
SP is a stored procedure in a database, while a function is a piece of code that performs a specific task.
SP is precompiled and stored in the database, while a function is compiled and executed at runtime.
Functions can return a value, while SPs can return multiple result sets.
Functions can be used in SQL queries, while SPs are called using EXECUTE statement.
Views in databases are virtual tables that display data from one or more tables based on a query.
Views are used to simplify complex queries by storing them as a virtual table.
They can hide the complexity of underlying tables and provide a layer of security by restricting access to certain columns.
Types of views include simple views, complex views, materialized views, and indexed views.
Top-down focuses on breaking down the problem into smaller parts, while bottom-up starts with small components and builds up.
Top-down starts with a high-level overview and breaks it down into smaller components.
Bottom-up starts with small components and gradually builds up to create a complete system.
Top-down is more structured and easier to plan, while bottom-up is more flexible and iterative.
Examples: Top-down - wate
I appeared for an interview in Jan 2025.
Discussed education and research experiences in detail.
Discussed my academic background, including degrees obtained and relevant coursework.
Talked about any research projects I have worked on, including methodologies used and results achieved.
Highlighted any publications or presentations related to data science or relevant fields.
Mentioned any internships or work experience in data analysis or research roles.
My research topics focus on developing scalable machine learning models for predictive analytics in finance.
I have researched and implemented various machine learning algorithms such as random forests, gradient boosting, and neural networks.
I have explored techniques for feature engineering and model optimization to improve scalability and performance.
I have chosen specific models based on their ability to handle large...
I have a strong educational background in data science and have conducted research in machine learning and predictive analytics.
Completed a Master's degree in Data Science from XYZ University
Conducted research on machine learning algorithms for predictive analytics during my internship at ABC Company
Published a research paper on the application of deep learning in natural language processing
I have conducted research in machine learning and natural language processing, and I would approach problems by first understanding the data and then applying appropriate algorithms.
Conducted research in machine learning and natural language processing
Approach problems by understanding the data first
Apply appropriate algorithms based on the problem
Utilize data visualization techniques to gain insights
I have a Master's degree in Data Science and have conducted research on machine learning algorithms.
Master's degree in Data Science
Research experience in machine learning algorithms
What people are saying about kipi.ai
I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.
ETL involves extracting data, transforming it, and then loading it into a target system. ELT involves extracting data, loading it into a target system, and then transforming it.
ETL: Extract, Transform, Load
ELT: Extract, Load, Transform
ETL is suitable for scenarios where data needs to be cleansed and transformed before loading into the target system.
ELT is suitable for scenarios where raw data needs to be quickly loaded...
kipi.ai interview questions for popular designations
I appeared for an interview in Feb 2025.
They asked mcqs on all formats of aptitude
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
I appeared for an interview before Mar 2024, where I was asked the following questions.
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
DOD vs DOR vs acceptance criteria
Definition: DOD (Definition of Done) is a checklist of criteria that a product must meet before it can be considered complete.
Definition: DOR (Definition of Ready) is a checklist of criteria that a user story must meet before it can be worked on.
Acceptance Criteria: Specific conditions that a product must meet to be accepted by the customer.
DOD ensures the quality of the final product, ...
IT project management involves managing projects related to information technology, while regular project management can encompass a wider range of industries and sectors.
IT project management requires specific technical knowledge and expertise in areas such as software development, network infrastructure, and cybersecurity.
Regular project management may involve industries such as construction, healthcare, marketing, a...
I applied via LinkedIn and was interviewed in Apr 2024. There were 5 interview rounds.
The duration of kipi.ai interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 60 interviews
Interview experience
based on 253 reviews
Rating in categories
4-5 Yrs
Not Disclosed
4-5 Yrs
Not Disclosed
12-14 Yrs
₹ 33.6-49 LPA
Senior Software Engineer
165
salaries
| ₹6 L/yr - ₹17 L/yr |
Lead Engineer
109
salaries
| ₹10.6 L/yr - ₹30 L/yr |
Software Engineer
64
salaries
| ₹5 L/yr - ₹10 L/yr |
Senior Leader Engineer
55
salaries
| ₹18.5 L/yr - ₹42 L/yr |
Solution Architect
40
salaries
| ₹28 L/yr - ₹56 L/yr |
Medcode
Maxgen Technologies
Cyfuture
Value Point Systems