AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Filter interviews by
Impetus Technologies Software Engineer Interview Questions and Answers
7 Interview questions
Generate permutations and combinations of a given string without stored procedures.
Use recursion to generate all possible permutations and combinations.
Swap characters in the string to generate permutations.
Use a boolean array to keep track of used characters in combinations.
Store the generated permutations and combinations in an array of strings.
Get 3 highest used words in a column from a table.
Use GROUP BY and ORDER BY clauses in SQL query.
Apply LIMIT 3 to get top 3 words.
Use COUNT() function to count occurrences of each word.
To get values present in table A but not in B without using joining conditions, minus, intersect, union, you can use a subquery.
Use a subquery to select values from table A that are not present in table B
Example: SELECT * FROM A WHERE value NOT IN (SELECT value FROM B)
Demonstrates Python wrapper class, generator for primes, PySpark explode, window functions, and cache vs persist.
Wrapper Class: A class that encapsulates a primitive data type to provide additional functionality. Example: int, float wrappers.
Generator: A function that yields values one at a time, allowing iteration without storing all values in memory. Example: def prime_gen():
Optimized Prime Number Solution: Use ...
Reverse array in-place, find frequency of distinct elements, and implement Singleton class.
To reverse an array in-place, swap the first and last elements, then move towards the center until the entire array is reversed.
To find the frequency of distinct elements, use a hash table to count occurrences of each element.
To implement a Singleton class, create a private constructor, a private static instance variable, an...
Questions related to Java programming language and memory management.
Overriding is a concept where a subclass provides its own implementation of a method that is already present in its superclass.
JVM stores class information in the method area and objects in the heap area.
Serialization is the process of converting an object into a stream of bytes to store it in a file or send it over a network.
Thread class methods...
Explains the working of hashmap and the difference between abstract class and interface.
Hashmap is a data structure that stores key-value pairs and uses hashing to retrieve values quickly.
Abstract classes are classes that cannot be instantiated and can have both abstract and non-abstract methods.
Interfaces are contracts that define a set of methods that a class must implement.
Using interfaces is better than abstra...
Impetus Technologies Software Engineer Interview Experiences
10 interviews found
Anonymous
Python, stings, data structures
Python, data structures, stings
(2 Questions)
- Q1. What is salary expectation
- Ans.
My salary expectation is based on my experience, skills, and the market rate for the position.
Research the average salary range for Software Engineers in the specific location and industry
Consider your years of experience, education level, and any specialized skills you bring to the role
Be prepared to negotiate based on the benefits package offered by the company
Provide a range rather than a specific number to allow fo...
- Q2. Why are you leaving your current job
Selected
I appeared for an interview in Sep 2024, where I was asked the following questions.
- Q1. Write a program in python demonstrating use of wrapper class Write a code to demonstrate use of generator Optimised prime number solution 2 Code in pyspark where basically i was ask to use explode function...
- Ans.
Demonstrates Python wrapper class, generator for primes, PySpark explode, window functions, and cache vs persist.
Wrapper Class: A class that encapsulates a primitive data type to provide additional functionality. Example: int, float wrappers.
Generator: A function that yields values one at a time, allowing iteration without storing all values in memory. Example: def prime_gen():
Optimized Prime Number Solution: Use Sieve...
- Q2. More of current project
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
React application to fetch data and add search functionality.
(2 Questions)
- Q1. What is my notice period?
- Q2. What is my current salary?
- Ans.
It is not appropriate to ask about current salary during an interview.
It is considered unprofessional and inappropriate to ask about current salary during an interview.
Focus should be on the candidate's skills, experience, and fit for the role.
Employers should instead discuss salary expectations or ranges for the position.
Selected
I appeared for an interview in Sep 2023.
(1 Question)
- Q1. One hour technical questions
(2 Questions)
- Q1. Half hour technical questions
- Q2. Difference between data lake and delta table
- Ans.
Data lake is a storage repository that holds a vast amount of raw data in its native format, while Delta table is a versioned parquet table that stores data in a structured format.
Data lake stores raw data in its original form, while Delta table stores structured data in a versioned parquet format.
Data lake is suitable for storing large amounts of unstructured data, while Delta table is ideal for structured data with A...
Skills evaluated in this interview
Selected
I applied via Job Portal and was interviewed before Aug 2022. There were 4 interview rounds.
(1 Question)
- Q1. Basic sql, and resume based
(1 Question)
- Q1. Totally resume based advanced question
(1 Question)
- Q1. Normal discussion and hobby
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Oct 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Coding questions
- Q2. Basic mainframe questions
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. Questions related to projects and resume
(1 Question)
- Q1. In depth questions on experience, coding questions on python and sql
(1 Question)
- Q1. Salary discussion and other formalities
I applied via LinkedIn and was interviewed before Jan 2023. There were 2 interview rounds.
(1 Question)
- Q1. SQL QUESTIONS TRICKY ONE
(1 Question)
- Q1. SQL Questions (windows functions etc)
dev indurkar
I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Working of hashmap abstract class vs interface why using the interface is better than abstract class and in which situation
- Ans.
Explains the working of hashmap and the difference between abstract class and interface.
Hashmap is a data structure that stores key-value pairs and uses hashing to retrieve values quickly.
Abstract classes are classes that cannot be instantiated and can have both abstract and non-abstract methods.
Interfaces are contracts that define a set of methods that a class must implement.
Using interfaces is better than abstract cl...
- Q2. Rule of overriding how JVM stores class and objects in memory, the internal working of memory management in depth Concept of serialization Thread's class methods StackOverflow exception how to check whethe...
- Ans.
Questions related to Java programming language and memory management.
Overriding is a concept where a subclass provides its own implementation of a method that is already present in its superclass.
JVM stores class information in the method area and objects in the heap area.
Serialization is the process of converting an object into a stream of bytes to store it in a file or send it over a network.
Thread class methods incl...
(1 Question)
- Q1. Reverse the content of array in-place find the frequency of distinct elements in the array Singleton class implementation
- Ans.
Reverse array in-place, find frequency of distinct elements, and implement Singleton class.
To reverse an array in-place, swap the first and last elements, then move towards the center until the entire array is reversed.
To find the frequency of distinct elements, use a hash table to count occurrences of each element.
To implement a Singleton class, create a private constructor, a private static instance variable, and a p...
Interview Preparation Tips
- Java
- SQL
- Data Structures
- sping
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2020. There were 3 interview rounds.
Interview Questionnaire
5 Questions
- Q1. How to take one string and do Permutations and Combinations without using stored procedures? Input: 'ABCD', Output: 'BCDA', 'CDBA' ....
- Ans.
Generate permutations and combinations of a given string without stored procedures.
Use recursion to generate all possible permutations and combinations.
Swap characters in the string to generate permutations.
Use a boolean array to keep track of used characters in combinations.
Store the generated permutations and combinations in an array of strings.
- Q2. How to check and get 3 highest used words in a column from a table?
- Ans.
Get 3 highest used words in a column from a table.
Use GROUP BY and ORDER BY clauses in SQL query.
Apply LIMIT 3 to get top 3 words.
Use COUNT() function to count occurrences of each word.
- Q3. How to get values present in tables A but not in B without using joining conditions, minus, intersect, union...?
- Ans.
To get values present in table A but not in B without using joining conditions, minus, intersect, union, you can use a subquery.
Use a subquery to select values from table A that are not present in table B
Example: SELECT * FROM A WHERE value NOT IN (SELECT value FROM B)
- Q4. How to get maximum salary for a particular day of employees?
- Q5. Other basic questions related to SQL
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Impetus Technologies Interview FAQs
Some of the top questions asked at the Impetus Technologies Software Engineer interview -
The duration of Impetus Technologies Software Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Impetus Technologies Interviews By Designations
- Impetus Technologies Data Engineer Interview Questions
- Impetus Technologies Software Engineer Interview Questions
- Impetus Technologies Senior Software Engineer Interview Questions
- Impetus Technologies Devops Engineer Interview Questions
- Impetus Technologies Associate Software Engineer Interview Questions
- Impetus Technologies Java Developer Interview Questions
- Impetus Technologies Big Data Engineer Interview Questions
- Impetus Technologies Lead Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Project Engineer Interview Questions
- Lead Engineer Interview Questions
- Software Development Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 9 interview experiences
Difficulty level
Duration
Software Engineer Interview Questions from Similar Companies
Impetus Technologies Software Engineer Reviews and Ratings
based on 73 reviews
Rating in categories
|
Senior Software Engineer
843
salaries
|  ₹11.8 L/yr - ₹23.3 L/yr |
|
Software Engineer
603
salaries
| ₹8.7 L/yr - ₹15.1 L/yr |
|
Module Lead Software Engineer
259
salaries
| ₹18.7 L/yr - ₹32.3 L/yr |
|
Module Lead
258
salaries
| ₹18 L/yr - ₹32.7 L/yr |
|
Lead Software Engineer
211
salaries
| ₹24.6 L/yr - ₹42.5 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant
- Home >
- Interviews >
- Impetus Technologies Interview Questions
