i
Filter interviews by
To find and count null values in a table, use SQL queries to identify and aggregate them.
Use SQL query: SELECT COUNT(*) FROM table_name WHERE column_name IS NULL;
Replace 'table_name' with your actual table name and 'column_name' with the specific column.
To count nulls across multiple columns, use: SELECT COUNT(*) FROM table_name WHERE column1 IS NULL OR column2 IS NULL;
For a specific column, you can also use: SELE...
OOP in Python enables code reusability and organization through classes and objects, enhancing software development.
Encapsulation: Bundling data and methods in classes. Example: class Car with attributes like speed and methods like accelerate().
Inheritance: Creating new classes from existing ones. Example: class ElectricCar inherits from class Car, adding battery attributes.
Polymorphism: Using a single interface f...
Learn how to effectively delete duplicate records in SQL using various methods.
Use the ROW_NUMBER() function to identify duplicates: Example: SELECT *, ROW_NUMBER() OVER (PARTITION BY column_name ORDER BY id) AS rn FROM table_name;
Delete duplicates using a Common Table Expression (CTE): Example: WITH CTE AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY column_name ORDER BY id) AS rn FROM table_name) DELETE FR...
XPath is a query language used to select nodes from an XML document, essential for locating web elements in automation testing.
Understanding the DOM: Familiarize yourself with the Document Object Model (DOM) structure of the web page to identify the hierarchy of elements.
Using Absolute XPath: Start with a full path from the root to the target element, e.g., '/html/body/div[1]/h1'.
Using Relative XPath: Create a pat...
Managing conflict involves effective communication, understanding perspectives, and finding common ground to resolve issues amicably.
Active Listening: I ensure that all parties feel heard by summarizing their points and asking clarifying questions. For example, during a team disagreement, I listened to both sides before suggesting a compromise.
Empathy: I try to understand the emotions and motivations behind the co...
A Singleton class ensures a class has only one instance and provides a global point of access to it.
Singleton pattern restricts instantiation of a class to one object.
It is commonly used for logging, driver objects, caching, and thread pools.
Example: Using a private constructor and a static method to get the instance.
Thread-safe Singleton can be implemented using synchronized methods or double-checked locking.
Implementing a stack using two queues to achieve LIFO behavior.
Use two queues: queue1 and queue2.
For push operation, enqueue the element to queue1.
For pop operation, dequeue all elements from queue1 to queue2 except the last one, then dequeue the last element from queue1.
Swap the names of queue1 and queue2 after the pop operation.
Example: Push(1), Push(2), Pop() returns 2.
Creating XPath expressions for locating elements on a web page.
Use // to select any element in the document
Use / to select a direct child element
Use [@attribute='value'] to select elements based on attribute value
My Selenium pytest framework is a robust automation tool that utilizes the pytest testing framework for efficient and reliable testing.
Utilizes Selenium WebDriver for interacting with web elements
Uses pytest for test case management and execution
Employs fixtures for setup and teardown of test environments
Generates detailed test reports for analysis
Supports parallel test execution for faster results
Priority is the order in which defects should be fixed, severity is the impact of a defect on the system.
Priority determines the order in which defects should be fixed, while severity determines the impact of a defect on the system.
Priority is usually assigned based on business needs and deadlines, while severity is based on the impact on functionality.
For example, a spelling mistake in a button label may have low...
I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.
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...
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...
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...
I appeared for an interview in Jan 2025.
Creating XPath expressions for locating elements on a web page.
Use // to select any element in the document
Use / to select a direct child element
Use [@attribute='value'] to select elements based on attribute value
Priority is the order in which defects should be fixed, severity is the impact of a defect on the system.
Priority determines the order in which defects should be fixed, while severity determines the impact of a defect on the system.
Priority is usually assigned based on business needs and deadlines, while severity is based on the impact on functionality.
For example, a spelling mistake in a button label may have low seve...
Bug leakage refers to bugs that are not caught during testing and make their way into production.
Bug leakage occurs when bugs are not identified and fixed during the testing phase.
These bugs can then make their way into the production environment, causing issues for end users.
Bug leakage can be caused by inadequate testing, miscommunication between teams, or changes made after testing.
Examples include a critical bug in...
My Selenium pytest framework is a robust automation tool that utilizes the pytest testing framework for efficient and reliable testing.
Utilizes Selenium WebDriver for interacting with web elements
Uses pytest for test case management and execution
Employs fixtures for setup and teardown of test environments
Generates detailed test reports for analysis
Supports parallel test execution for faster results
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Using PySpark for group by and aggregation operations on large datasets.
Use DataFrame API for efficient data manipulation.
Example: df.groupBy('column_name').agg({'other_column': 'sum'}) to sum values.
You can use multiple aggregations: df.groupBy('column_name').agg({'col1': 'avg', 'col2': 'count'}).
Use .agg() to apply multiple aggregation functions at once.
Consider using .withColumn() to create new columns before aggreg...
I have extensive experience in leading data migration projects from start to finish, ensuring seamless transition and minimal disruption.
Led a team in migrating legacy data from on-premise servers to cloud storage
Developed data mapping strategies to ensure accurate transfer of information
Implemented data validation processes to identify and rectify any discrepancies
Collaborated with stakeholders to define project scope...
Learn how to perform aggregations in PySpark using DataFrames and SQL functions.
Use DataFrame API for aggregations: df.groupBy('column').agg({'other_column': 'sum'})
Example: df.groupBy('department').agg({'salary': 'avg'}).show()
Utilize SQL functions: from pyspark.sql import functions as F
Example: df.groupBy('category').agg(F.count('id').alias('count')).show()
Window functions can also be used for advanced aggregations.
Check if a list is sorted and sort the list without using Python methods.
To check if a list is sorted, iterate through the list and compare each element with the next one. If any element is greater than the next one, the list is not sorted.
To sort the list without using Python methods, implement a sorting algorithm like bubble sort, selection sort, or insertion sort.
Example for checking if a list is sorted: ['a', 'b', ...
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
Diff string string builder compares two strings and returns the differences.
Use a loop to iterate through each character of the strings
Compare characters at the same index in both strings
Build a new string with the differing characters
Encapsulation, Inheritance, Polymorphism, Abstraction
Encapsulation: Bundling data and methods that operate on the data into a single unit
Inheritance: Ability of a class to inherit properties and behavior from another class
Polymorphism: Ability to present the same interface for different data types
Abstraction: Hiding the complex implementation details and showing only the necessary features
Delegating tasks effectively enhances team productivity and fosters growth in a software engineering environment.
Identify team strengths: Assign tasks based on individual skills, e.g., a developer with strong front-end skills handles UI design.
Set clear expectations: Provide detailed requirements and deadlines to avoid confusion, e.g., using project management tools.
Encourage autonomy: Allow team members to make decisi...
Interface defines a contract for classes to implement, while abstract class can have both abstract and concrete methods.
Interfaces can only have abstract methods and constants, while abstract classes can have both abstract and concrete methods.
A class can implement multiple interfaces but can only inherit from one abstract class.
Interfaces are used to achieve multiple inheritance in Java, while abstract classes are use...
Arrays are fixed in size, while ArrayLists can dynamically resize.
Arrays have a fixed size determined at initialization, while ArrayLists can dynamically resize.
Arrays are faster for accessing elements, while ArrayLists are better for adding or removing elements.
Arrays use [] syntax for accessing elements, while ArrayLists use get() and set() methods.
Arrays can only store primitive types, while ArrayLists can store obj...
Use a set to remove duplicates from a string array.
Create a set to store unique strings.
Iterate through the array and add each string to the set.
Convert the set back to an array to get the unique strings.
Diff method compares values of two objects while equal method compares references of two objects.
Diff method compares values of two objects, while equal method compares references.
Diff method is used to check if two objects are different, while equal method is used to check if two objects are the same.
Example: obj1.diff(obj2) vs obj1.equal(obj2)
Sealed virtual static new keywords are used in C# to control inheritance and method hiding.
Sealed keyword prevents a class from being inherited.
Virtual keyword allows a method to be overridden in derived classes.
Static keyword makes a member of a class accessible without creating an instance of the class.
New keyword hides a method from the base class in the derived class.
Overloading with different return type is not allowed in Java.
Overloading is based on method signature, not return type
Methods with same name and different return type will result in compile-time error
Example: int add(int a, int b) and double add(int a, int b) is not allowed
Authentication in web API is achieved by using tokens or API keys to verify the identity of users.
Use tokens (such as JWT) to authenticate users
Implement OAuth for secure authentication
Utilize API keys for authentication purposes
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
posted on 28 Jan 2025
I appeared for an interview in Dec 2024.
To schedule a Pyspark script in a serverless environment, you can use cloud services like AWS Lambda or Azure Functions.
Use AWS Lambda or Azure Functions to create a serverless function that triggers your Pyspark script.
Set up a schedule using cloud services like AWS CloudWatch Events or Azure Scheduler to run the function at specified intervals.
Ensure your Pyspark script is optimized for serverless execution to minimi...
The entry point of a pipeline in PySpark is the SparkSession object.
The entry point of a PySpark pipeline is typically created using the SparkSession object.
The SparkSession object is used to create DataFrames, register tables, and execute SQL queries.
Example: spark = SparkSession.builder.appName('example').getOrCreate()
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Calculate the frequency of a number in a list
Iterate through the list and count occurrences of the number
Use a dictionary to store the count of each number
Return the count of the specified number
I am currently working on developing a data pipeline for analyzing customer behavior in an e-commerce platform.
Designing and implementing ETL processes to extract, transform, and load data from various sources
Building data models to analyze customer interactions and purchasing patterns
Creating visualizations and dashboards to present insights to stakeholders
Broadcast Join is a type of join operation in distributed computing where one smaller dataset is broadcasted to all nodes for joining with a larger dataset.
In Broadcast Join, one smaller dataset is broadcasted to all nodes in a distributed system.
This smaller dataset is then joined with a larger dataset that is partitioned across the nodes.
Broadcast Join is efficient when the smaller dataset can fit in memory across al...
Handling out of memory issue in Spark involves optimizing memory usage, partitioning data, and increasing resources.
Optimize memory usage by tuning Spark configurations like executor memory, driver memory, and shuffle partitions.
Partition data to distribute workload evenly across nodes and avoid data skew.
Increase resources by adding more nodes, increasing memory allocation, or using a larger cluster.
Use persistence me...
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.
A dataset from "Bank" was provided, requiring preprocessing, exploratory data analysis (EDA), and modeling using a predetermined model.
I appeared for an interview in May 2025, where I was asked the following questions.
To find and count null values in a table, use SQL queries to identify and aggregate them.
Use SQL query: SELECT COUNT(*) FROM table_name WHERE column_name IS NULL;
Replace 'table_name' with your actual table name and 'column_name' with the specific column.
To count nulls across multiple columns, use: SELECT COUNT(*) FROM table_name WHERE column1 IS NULL OR column2 IS NULL;
For a specific column, you can also use: SELECT CO...
Developed a data pipeline to process and analyze real-time streaming data for a retail analytics platform.
Utilized Apache Kafka for real-time data ingestion from various sources like POS systems and online transactions.
Implemented ETL processes using Apache Spark to clean and transform data for analysis.
Designed a data warehouse in Amazon Redshift to store processed data for reporting and analytics.
Created dashboards u...
What people are saying about Impetus Technologies
Some of the top questions asked at the Impetus Technologies interview -
The duration of Impetus Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 73 interview experiences
Difficulty level
Duration
based on 531 reviews
Rating in categories
Senior Software Engineer
830
salaries
| ₹7.5 L/yr - ₹25.7 L/yr |
Software Engineer
589
salaries
| ₹5 L/yr - ₹18 L/yr |
Module Lead Software Engineer
257
salaries
| ₹10.3 L/yr - ₹35.7 L/yr |
Module Lead
252
salaries
| ₹11 L/yr - ₹35 L/yr |
Lead Software Engineer
211
salaries
| ₹15.2 L/yr - ₹44 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant