Premium Employer

i

This company page is being actively managed by Persistent Systems Team. If you also belong to the team, you can get access from here

Persistent Systems Verified Tick Work with us arrow

Compare button icon Compare button icon Compare

Filter interviews by

Persistent Systems Interview Questions and Answers

Updated 2 Aug 2025
Popular Designations

537 Interview questions

A Senior Executive was asked 1w ago
Q. Can you describe your job responsibilities?
Ans. 

As a Senior Executive, I oversee strategic initiatives, drive operational efficiency, and lead cross-functional teams to achieve organizational goals.

  • Develop and implement strategic plans to align with company vision and objectives.

  • Lead cross-functional teams to enhance collaboration and drive project success, such as launching a new product line.

  • Monitor key performance indicators (KPIs) to assess organizational p...

View all Senior Executive interview questions
A Lead Engineer was asked 2w ago
Q. What are the working mechanisms and patterns of microservices, and how do they operate?
Ans. 

Microservices are a software architecture style that structures applications as a collection of loosely coupled services.

  • Microservices are independently deployable services that communicate over a network.

  • Each microservice focuses on a specific business capability, e.g., user authentication or payment processing.

  • They often use lightweight protocols like HTTP/REST or messaging queues for inter-service communication...

View all Lead Engineer interview questions
A Lead Engineer was asked 2w ago
Q. What are the annotations used in Spring Boot, and how do they function?
Ans. 

Spring Boot uses various annotations to simplify configuration and enhance functionality in Java applications.

  • @SpringBootApplication: Combines @Configuration, @EnableAutoConfiguration, and @ComponentScan.

  • @RestController: Indicates that the class is a controller where every method returns a domain object instead of a view.

  • @RequestMapping: Maps HTTP requests to handler methods of MVC and REST controllers.

  • @Autowired:...

View all Lead Engineer interview questions
A Project Manager was asked 1mo ago
Q. How do you handle attrition issues?
Ans. 

I address attrition by fostering a positive work environment, enhancing employee engagement, and implementing retention strategies.

  • Conduct regular one-on-one meetings to understand employee concerns and career aspirations.

  • Implement employee recognition programs to celebrate achievements, such as 'Employee of the Month' awards.

  • Provide opportunities for professional development through training and workshops, like p...

View all Project Manager interview questions
A Senior Technical Support Engineer was asked 1mo ago
Q. What is the difference between urgent and priority in the ITIL process?
Ans. 

Urgency refers to the speed of response needed, while priority indicates the importance of the issue in ITIL processes.

  • Urgency is about how quickly a resolution is needed; for example, a system outage may be urgent.

  • Priority is determined by the impact on the business; for instance, a critical application failure has high priority.

  • An urgent issue might not always be high priority; e.g., a minor bug affecting a non-...

View all Senior Technical Support Engineer interview questions
A Senior Technical Support Engineer was asked 1mo ago
Q. What are KRAs and KPIs?
Ans. 

KRA (Key Result Area) and KPI (Key Performance Indicator) are metrics used to evaluate performance and success in various roles.

  • KRA defines the specific areas where an employee is expected to achieve results, e.g., sales targets.

  • KPI measures the performance against the KRA, e.g., percentage of sales target achieved.

  • KRA is broader and focuses on outcomes, while KPI is specific and quantifiable.

  • Example of KRA: Custo...

View all Senior Technical Support Engineer interview questions

Persistent Systems HR Interview Questions

73 questions and answers

Q. Why is persistence important?
Q. What type of skills are you developing?
Q. How do you rate yourself on negotiation skills?
A Senior Technical Support Engineer was asked 1mo ago
Q. Explain the ITIL framework.
Ans. 

ITIL is a framework for IT service management that aligns IT services with business needs.

  • ITIL stands for Information Technology Infrastructure Library.

  • It provides best practices for delivering IT services effectively.

  • The framework is divided into five stages: Service Strategy, Service Design, Service Transition, Service Operation, and Continual Service Improvement.

  • For example, in Service Design, organizations cre...

View all Senior Technical Support Engineer interview questions
Are these interview questions helpful?
A Software Engineer was asked 2mo ago
Q. Describe a problem you solved using a map data structure.
Ans. 

Using a map data structure can efficiently solve various problems by storing key-value pairs for quick access and manipulation.

  • Maps allow O(1) average time complexity for lookups, e.g., retrieving a user's profile by user ID.

  • They can handle duplicate keys by storing values in a list, e.g., mapping a student ID to multiple course enrollments.

  • Maps can be used to count occurrences, e.g., counting the frequency of wor...

View all Software Engineer interview questions
A Lead Quality Engineer was asked 2mo ago
Q. What are the differences between JDK, JRE, and JVM?
Ans. 

JDK is a development kit, JRE is a runtime environment, and JVM is the virtual machine for executing Java bytecode.

  • JDK (Java Development Kit) includes tools for developing Java applications, such as compilers and debuggers.

  • JRE (Java Runtime Environment) provides the libraries and components necessary to run Java applications but does not include development tools.

  • JVM (Java Virtual Machine) is the engine that execu...

View all Lead Quality Engineer interview questions
A Lead Quality Engineer was asked 2mo ago
Q. What are the differences between method overloading and method overriding?
Ans. 

Method overloading allows multiple methods with the same name but different parameters; overriding replaces a method in a subclass.

  • Method Overloading: Same method name, different parameter types or counts. Example: 'add(int a, int b)' and 'add(double a, double b)'.

  • Method Overriding: Redefining a method in a subclass that already exists in the parent class. Example: 'void display()' in both parent and child.

  • Overloa...

View all Lead Quality Engineer interview questions

Persistent Systems Interview Experiences

650 interviews found

Senior Quality Engineer Interview Questions & Answers

user image Nitish Kumar Verma

posted on 22 Mar 2025

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Feb 2025, where I was asked the following questions.

  • Q1. What is functional testing, and how do you perform it?
  • Ans. 

    Functional testing verifies that software functions according to specified requirements and performs its intended tasks.

    • Identify requirements: Gather functional specifications and user stories to understand what the software should do.

    • Create test cases: Develop test cases that cover all functional aspects, such as input validation and user interactions.

    • Execute tests: Run the test cases on the application to ensure it b...

  • Answered by AI
  • Q2. What is the process for writing test cases?
  • Ans. 

    Writing test cases involves defining objectives, identifying requirements, and detailing steps for validation.

    • Understand the requirements: Gather functional and non-functional requirements from specifications.

    • Define test objectives: Clearly state what each test case aims to validate, e.g., 'Verify user login functionality.'

    • Identify test conditions: Determine the scenarios to be tested, such as 'Valid credentials' and '...

  • Answered by AI
  • Q3. How do you conduct API testing, and what do the following status codes represent in that context: 200, 201, 404, and 501?
  • Ans. 

    API testing involves validating the functionality, reliability, and performance of APIs using various status codes.

    • Use tools like Postman or SoapUI for manual testing and automation frameworks like RestAssured for automated tests.

    • Status code 200 indicates a successful request, e.g., retrieving user data.

    • Status code 201 means a resource was successfully created, e.g., adding a new user.

    • Status code 404 indicates that the...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(5 Questions)

  • Q1. What is the architecture of the Java Virtual Machine (JVM)?
  • Ans. 

    The Java Virtual Machine (JVM) is an abstract computing machine that enables a computer to run Java programs.

    • JVM is platform-independent and converts Java bytecode into machine code.

    • It consists of class loader, runtime data areas, execution engine, and native method interface.

    • JVM memory is divided into method area, heap, stack, and PC register.

    • Examples of JVM implementations include Oracle HotSpot, OpenJ9, and GraalVM.

  • Answered by AI
  • Q2. What is the default connection pooling in Spring Boot, and how can it be customized?
  • Ans. 

    The default connection pooling in Spring Boot is HikariCP, which can be customized through properties in the application.properties file.

    • HikariCP is the default connection pooling library in Spring Boot, known for its high performance and low overhead.

    • To customize the connection pooling, you can modify properties like 'spring.datasource.hikari.*' in the application.properties file.

    • For example, you can set maximum pool ...

  • Answered by AI
  • Q3. What are the best practices for optimizing a Spring Boot application?
  • Ans. 

    Best practices for optimizing a Spring Boot application

    • Use Spring Boot Actuator to monitor and manage application performance

    • Implement caching mechanisms like Spring Cache to reduce database calls

    • Optimize database queries and indexes for better performance

    • Use asynchronous processing with Spring's @Async annotation for non-blocking operations

    • Profile and analyze application performance using tools like VisualVM or JProfi...

  • Answered by AI
  • Q4. What is a heap dump, and how can it be used to identify memory leaks?
  • Ans. 

    A heap dump is a snapshot of the memory usage of a Java application at a specific point in time.

    • Heap dumps can be generated using tools like jmap or VisualVM.

    • They provide detailed information about objects in memory, their sizes, and references.

    • Analyzing a heap dump can help identify memory leaks by pinpointing objects that are consuming excessive memory.

    • Common signs of memory leaks in a heap dump include a large numbe...

  • Answered by AI
  • Q5. How can you diagonally iterate through and print the elements of a 2D array?program
  • Ans. 

    Diagonally iterate through and print elements of a 2D array of strings.

    • Use nested loops to iterate through rows and columns of the 2D array.

    • Calculate the diagonal elements by incrementing row and column indices together.

    • Print the elements as you iterate through the diagonal of the array.

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Feb 2025.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Flat an array without using flat in Js
  • Ans. 

    Flattening an array involves converting a multi-dimensional array into a single-dimensional array without using the flat method.

    • Use reduce: You can use the reduce method to iterate through the array and concatenate elements. Example: `arr.reduce((acc, val) => acc.concat(val), [])`.

    • Use recursion: Create a function that checks if an element is an array and flattens it recursively. Example: `function flatten(arr) { ret...

  • Answered by AI
  • Q2. Code a counter without using useState?
  • Ans. 

    Implementing a counter in React without useState can be achieved using refs for mutable state management.

    • Using useRef: You can create a mutable reference using useRef to store the counter value, which persists across renders.

    • Example: const countRef = useRef(0); to initialize the counter.

    • Updating the Counter: Use a function to increment the value, e.g., countRef.current += 1; to update the counter.

    • Triggering Re-renders:...

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Make an api call and store data and pass using context api
  • Ans. 

    Using Context API to manage API data in a React application.

    • Create a Context using React.createContext().

    • Build a Provider component that fetches data from an API.

    • Use useEffect to make the API call when the component mounts.

    • Store the fetched data in a state variable using useState.

    • Pass the data and any necessary functions through the Provider's value.

    • Consume the context in child components using useContext.

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It's walkin, so they conducted 1 technical mcqs round.

Round 2 - Technical 

(11 Questions)

  • Q1. Multi threading
  • Q2. Internal working of hashmap
  • Ans. 

    HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.

    • HashMap uses an array of buckets to store key-value pairs.

    • Keys are hashed to determine the index in the array where the key-value pair will be stored.

    • In case of hash collisions, a linked list or a balanced tree is used to store multiple key-value pairs in the same bucket.

    • HashMap allows null keys...

  • Answered by AI
  • Q3. Spring batch related
  • Q4. Non repeating characters in a array
  • Ans. 

    Function to find and return all non-repeating characters in an array of strings.

    • Iterate through the array and count the occurrences of each character using a HashMap.

    • Then iterate through the array again and check if the count of each character is 1, if so add it to the result list.

    • Return the list of non-repeating characters.

  • Answered by AI
  • Q5. 3rd highest salary
  • Ans. 

    To find the 3rd highest salary in a database, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.

    • Use a SQL query with 'ORDER BY salary DESC' to sort the salaries in descending order.

    • Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and retrieve the third highest salary.

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;

  • Answered by AI
  • Q6. Qualifier vs primary
  • Ans. 

    A qualifier in Java is used to specify additional information about a primary, which is the main data type or variable.

    • A primary in Java is the main data type or variable, while a qualifier provides additional information about the primary.

    • Qualifiers can be used to modify the behavior or characteristics of a primary.

    • For example, in Java, 'final' is a qualifier that can be used to make a variable constant.

  • Answered by AI
  • Q7. Controller vs restcontroller
  • Ans. 

    The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.

    • Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.

    • @Controller is used to create web pages, while @RestController is used to return data in JSON or XML format.

    • @RestController is a convenience annotati...

  • Answered by AI
  • Q8. Spring boot annotataions
  • Q9. Oops concepts with examples
  • Ans. 

    OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.

    • Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.

    • Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

    • Polymorphism: Ability for objects to be treated as instances of their paren...

  • Answered by AI
  • Q10. Spring batch configuration
  • Q11. They covered all java, spring and Microservices
Round 3 - Technical 

(4 Questions)

  • Q1. Microservices architecture
  • Q2. How do Microservices communicate
  • Ans. 

    Microservices communicate with each other through various communication protocols like HTTP, messaging queues, and gRPC.

    • Microservices can communicate over HTTP using RESTful APIs.

    • Messaging queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.

    • gRPC is a high-performance, open-source RPC framework that can be used for communication between microservices.

    • Service discovery mechanism...

  • Answered by AI
  • Q3. How to access the Microservice end point
  • Ans. 

    Microservice endpoints can be accessed using HTTP requests with the appropriate URL

    • Use HTTP methods like GET, POST, PUT, DELETE to interact with the microservice

    • Construct the URL with the base URL of the microservice and the specific endpoint path

    • Include any necessary headers or parameters in the request for authentication or data filtering

  • Answered by AI
  • Q4. Why we use microservices
  • Ans. 

    Microservices allow for modular, scalable, and flexible software development by breaking down applications into smaller, independent services.

    • Microservices enable easier maintenance and updates as each service can be developed, deployed, and scaled independently.

    • They improve fault isolation, as failures in one service do not necessarily affect the entire application.

    • Microservices promote agility and faster time-to-mark...

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Core Java questions and multithreading basics like executor service
  • Q2. Spring boot error handling, simple questions on distributed systems
  • Q3. Coding question. Requested to do in O(n ) time complexity as oppsed to O(n2) suggested by me.
Round 2 - Technical 

(2 Questions)

  • Q1. Given an array find all the numbers whose sum is 11 using streams only
  • Ans. 

    Use Java Streams to find pairs in an array that sum to 11.

    • Use IntStream.range to iterate through the array indices.

    • For each element, check if there's a complement (11 - current element) in the array.

    • Use a Set to store seen numbers for efficient lookup.

    • Example: For array [1, 10, 2, 9, 3, 8], pairs are (10, 1), (9, 2), (8, 3).

  • Answered by AI
  • Q2. Spring boot basics, hibernate queries, what is native query
Round 3 - Technical 

(2 Questions)

  • Q1. Design patterns in Java, write a singleton class
  • Q2. Spring IOC and AOP

Interview Preparation Tips

Interview preparation tips for other job seekers - The first 2 rounds were good and interviewer were also good. But there were 2 people who were taking the interview with the agenda to reject me. Didn't give me time to think on anything. Pointed error in my code which afterwards checked was perfectly fine. Haven't heard back on the feedback afte the third interview.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I appeared for an interview in Jan 2025.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How to check if a file exist or not in the Linux shell scripting? Ans: using -e $filename
  • Ans. 

    In Linux shell scripting, use the -e flag to check if a file exists.

    • Use the command: if [ -e $filename ]; then echo 'File exists'; fi

    • The -e flag checks for the existence of a file or directory.

    • You can also use -f for regular files: if [ -f $filename ]; then echo 'Regular file exists'; fi

    • For directories, use -d: if [ -d $dirname ]; then echo 'Directory exists'; fi

  • Answered by AI
  • Q2. One python coding question in which we have to remove n number of characters from string. Persis**** As there are 4 stars we have to remove 4 characters "sisr" and return the result.
  • Ans. 

    This task involves removing a specified number of characters from a string based on asterisks indicating the count.

    • Identify the number of asterisks in the string to determine how many characters to remove.

    • Use string slicing to remove the specified characters from the original string.

    • Example: For 'Persis****', remove 4 characters to get 'Pe'.

    • Consider edge cases, such as when the number of asterisks exceeds the length of...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Whatever JD you get put that on chatgpt and accordingly you will get questions.
It might not give exact but you have to finetune your queries to chatgpt so it will provide you better questions.

A negative experience as the HR didnt call me back even after I was able to answer all the questions. I called HR back but she said she will call back after checking the feedback, but still didn't get the call.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. How do you handle difficult stakeholders?
  • Ans. 

    I approach difficult stakeholders with empathy, clear communication, and a focus on collaboration to find mutually beneficial solutions.

    • Listen actively to understand their concerns and motivations.

    • Establish common goals to align interests, e.g., improving product adoption.

    • Communicate transparently about project progress and challenges.

    • Use data and evidence to support decisions, e.g., user feedback or market research.

    • Bu...

  • Answered by AI
  • Q2. Insurance policy lifecycle
  • Q3. Simple Join sql query
  • Ans. 

    A simple JOIN SQL query combines rows from two or more tables based on a related column.

    • JOIN is used to combine records from two tables based on a common field.

    • Example: SELECT * FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

    • INNER JOIN returns records with matching values in both tables.

    • LEFT JOIN returns all records from the left table and matched records from the right table.

    • Example of LEFT JOI...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Difference between BA and PO
  • Ans. 

    Business Analyst (BA) focuses on understanding business needs and requirements, while Product Owner (PO) focuses on defining and prioritizing product features.

    • BA analyzes business processes and systems to identify areas for improvement, while PO works closely with stakeholders to define product features and prioritize the product backlog.

    • BA typically works on multiple projects simultaneously, while PO is dedicated to a...

  • Answered by AI
  • Q2. No relevant questions in 2nd round

Interview Preparation Tips

Interview preparation tips for other job seekers - Never ever join persistent.From the start of the interview was not listening and rude. They are recruiting for some silly useless projects and when I asked about domain and work timing he became further angry and asked why I was keen on the domain and said you have to work with clients across the globe and be flexible. He didn't have any idea on the diff between product owner and scrum master and kept showing attitude throughout the interview. It was clearly evident that the fellow didn't have any knowledge.He didn't know for which role he is interviewing even. HR also don't talk properly.. Disconnects the call while we are talking

Interview Questions & Answers

user image Anonymous

posted on 8 Feb 2025

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(2 Questions)

  • Q1. Write a program using Java to find the counts of specified characters and replace them with corresponding numbers.
  • Ans. 

    A Java program to find and replace specified characters with corresponding numbers in an array of strings.

    • Iterate through each string in the array

    • Count the occurrences of specified characters

    • Replace the characters with corresponding numbers

    • Return the modified array of strings

  • Answered by AI
  • Q2. Given an array, how can you separate the even and odd numbers, placing the even numbers on the right side and the odd numbers on the left side?
  • Ans. 

    Separate even and odd numbers in an array, placing even numbers on the right side and odd numbers on the left side.

    • Iterate through the array and check if each element is even or odd.

    • Create two separate arrays to store even and odd numbers.

    • Append even numbers to one array and odd numbers to another.

    • Finally, combine the two arrays with even numbers on the right and odd numbers on the left.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview is entirely focused on Java and programming for Automation testers.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(12 Questions)

  • Q1. Tell me about yourself and Project
  • Ans. 

    I am a Senior Data Engineer with experience in developing data pipelines and optimizing data storage for various projects.

    • Developed data pipelines using Apache Spark for real-time data processing

    • Optimized data storage using technologies like Hadoop and AWS S3

    • Worked on a project to analyze customer behavior and improve marketing strategies

  • Answered by AI
  • Q2. What was you day-to-day job in your project
  • Ans. 

    My day-to-day job in the project involved designing and implementing data pipelines, optimizing data workflows, and collaborating with cross-functional teams.

    • Designing and implementing data pipelines to extract, transform, and load data from various sources

    • Optimizing data workflows to improve efficiency and performance

    • Collaborating with cross-functional teams including data scientists, analysts, and business stakeholde...

  • Answered by AI
  • Q3. Spark Architecture
  • Q4. How DAG handle Fault tolerance?
  • Ans. 

    DAGs handle fault tolerance by rerunning failed tasks and maintaining task dependencies.

    • DAGs rerun failed tasks automatically to ensure completion.

    • DAGs maintain task dependencies to ensure proper sequencing.

    • DAGs can be configured to retry failed tasks a certain number of times before marking them as failed.

  • Answered by AI
  • Q5. What is shuffling? How to Handle Shuffling?
  • Ans. 

    Shuffling is the process of redistributing data across partitions in a distributed computing environment.

    • Shuffling is necessary when data needs to be grouped or aggregated across different partitions.

    • It can be handled efficiently by minimizing the amount of data being shuffled and optimizing the partitioning strategy.

    • Techniques like partitioning, combiners, and reducers can help reduce the amount of shuffling in MapRed...

  • Answered by AI
  • Q6. What is the difference between repartition and Coelsce?
  • Ans. 

    Repartition increases or decreases the number of partitions in a DataFrame, while Coalesce only decreases the number of partitions.

    • Repartition can increase or decrease the number of partitions in a DataFrame, leading to a shuffle of data across the cluster.

    • Coalesce only decreases the number of partitions in a DataFrame without performing a full shuffle, making it more efficient than repartition.

    • Repartition is typically...

  • Answered by AI
  • Q7. How do you handle Incremental data?
  • Ans. 

    Incremental data is handled by identifying new data since the last update and merging it with existing data.

    • Identify new data since last update

    • Merge new data with existing data

    • Update data warehouse or database with incremental changes

  • Answered by AI
  • Q8. What is SCD ??
  • Ans. 

    SCD stands for Slowly Changing Dimension, a concept in data warehousing to track changes in data over time.

    • SCD is used to maintain historical data in a data warehouse.

    • There are three types of SCD - Type 1, Type 2, and Type 3.

    • Type 1 SCD overwrites old data with new data.

    • Type 2 SCD creates a new record for each change, preserving history.

    • Type 3 SCD maintains both old and new values in the same record.

    • SCD is important for...

  • Answered by AI
  • Q9. Scenerio based questions related to Spark ?
  • Q10. Two SQL Codes and Two Python codes like reverse a string ?
  • Ans. 

    Reverse a string using SQL and Python codes.

    • In SQL, use the REVERSE function to reverse a string.

    • In Python, use slicing with a step of -1 to reverse a string.

  • Answered by AI
  • Q11. Find top 5 countries with highest population in Spark and SQL
  • Ans. 

    Use Spark and SQL to find the top 5 countries with the highest population.

    • Use Spark to load the data and perform data processing.

    • Use SQL queries to group by country and sum the population.

    • Order the results in descending order and limit to top 5.

    • Example: SELECT country, SUM(population) AS total_population FROM table_name GROUP BY country ORDER BY total_population DESC LIMIT 5

  • Answered by AI
  • Q12. Using two tables find the different records for different joins
  • Ans. 

    To find different records for different joins using two tables

    • Use the SQL query to perform different joins like INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Identify the key columns in both tables to join on

    • Select the columns from both tables and use WHERE clause to filter out the different records

  • Answered by AI
Round 2 - One-on-one 

(7 Questions)

  • Q1. What is a catalyst optimiser? How it works?
  • Ans. 

    A catalyst optimizer is a query optimization tool used in Apache Spark to improve performance by generating an optimal query plan.

    • Catalyst optimizer is a rule-based query optimization framework in Apache Spark.

    • It leverages rules to transform the logical query plan into a more optimized physical plan.

    • The optimizer applies various optimization techniques like predicate pushdown, constant folding, and join reordering.

    • By o...

  • Answered by AI
  • Q2. Tell me about the optimization you used in your project.
  • Ans. 

    Used query optimization techniques to improve performance in database queries.

    • Utilized indexing to speed up search queries.

    • Implemented query caching to reduce redundant database calls.

    • Optimized SQL queries by restructuring joins and subqueries.

    • Utilized database partitioning to improve query performance.

    • Used query profiling tools to identify and optimize slow queries.

  • Answered by AI
  • Q3. Pyspark question related to merging two schemas?
  • Ans. 

    Merging two schemas in PySpark involves combining DataFrames with different structures into a unified format.

    • Use the `unionByName()` method to merge DataFrames with different column names.

    • Example: df1.unionByName(df2, allowMissingColumns=True) merges df1 and df2, filling missing columns with nulls.

    • For schema evolution, use `mergeSchema` option when reading from Parquet files.

    • Example: spark.read.option('mergeSchema', 't...

  • Answered by AI
  • Q4. What is the best approach to finding whether the data frame is empty or not?
  • Ans. 

    Use the len() function to check the length of the data frame.

    • Use len() function to get the number of rows in the data frame.

    • If the length is 0, then the data frame is empty.

    • Example: if len(df) == 0: print('Data frame is empty')

  • Answered by AI
  • Q5. Spark Architecture
  • Q6. How do you decide on cores and worker nodes?
  • Ans. 

    Cores and worker nodes are decided based on the workload requirements and scalability needs of the data processing system.

    • Consider the size and complexity of the data being processed

    • Evaluate the processing speed and memory requirements of the tasks

    • Take into account the parallelism and concurrency needed for efficient data processing

    • Monitor the system performance and adjust cores and worker nodes as needed

  • Answered by AI
  • Q7. What happens when we enforce schema ?
  • Ans. 

    Enforcing schema ensures that data conforms to a predefined structure and rules.

    • Ensures data integrity by validating incoming data against predefined schema

    • Helps in maintaining consistency and accuracy of data

    • Prevents data corruption and errors in data processing

    • Can lead to rejection of data that does not adhere to the schema

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Persistent Systems Senior Data Engineer interview:
  • SQL
  • Pyspark
  • Python
  • Spark
  • Database
Interview preparation tips for other job seekers - Be prepared with Spark core concepts and SQL Coding

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Jun 2025, where I was asked the following questions.

  • Q1. Arrange fake interview, they don't have real requirement...
  • Q2. Introduce yourself, the challenges in your current profession?
  • Ans. 

    Experienced Project Manager with a focus on delivering complex projects on time and within budget while navigating various challenges.

    • Managing diverse teams: Coordinating efforts among team members with different skill sets and backgrounds can be challenging.

    • Stakeholder communication: Ensuring all stakeholders are aligned and informed can lead to conflicts if not handled properly.

    • Resource allocation: Balancing limited ...

  • Answered by AI
  • Q3. How you handle attrition issues?
  • Ans. 

    I address attrition by fostering a positive work environment, enhancing employee engagement, and implementing retention strategies.

    • Conduct regular one-on-one meetings to understand employee concerns and career aspirations.

    • Implement employee recognition programs to celebrate achievements, such as 'Employee of the Month' awards.

    • Provide opportunities for professional development through training and workshops, like projec...

  • Answered by AI
  • Q4. Asked to describe the Microsoft fabric experience?
  • Q5. Asked to describe power BI experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join, they will keep you in the waiting zone, then terminate you. Interviewers have no courtesy to join the interview, delay the process and later tell you the requirement is gone away.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Asked about GitHub Actions and octopus Deploy and AWS related questions
  • Ans. 

    GitHub Actions automates workflows, while Octopus Deploy focuses on deployment automation, both integrating well with AWS.

    • GitHub Actions allows CI/CD workflows to be defined in YAML files within the repository.

    • Example: A workflow can be triggered on push events to build and test code automatically.

    • Octopus Deploy specializes in deployment automation, managing releases, and promoting them through environments.

    • Example: De...

  • Answered by AI
  • Q2. Terraform about daily tasks
  • Ans. 

    Terraform daily tasks involve infrastructure provisioning, configuration management, and automation.

    • Creating and managing infrastructure using Terraform scripts

    • Updating and modifying existing infrastructure as needed

    • Automating deployment processes for applications

    • Implementing version control for Terraform configurations

    • Monitoring and troubleshooting Terraform deployments

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I interviewed interviewed they asked GitHub Actions and octopus

What people are saying about Persistent Systems

View All
resonantmalpua
Verified Icon
1w
works at
DXC Technology
Need Advice: Persistent vs Deloitte vs LearningMate – Which Company Should I Join?
Need help choosing between 3 offers (6 YOE in Java full-stack): Persistent – ₹28L, known team/project, but 45K/month less, unsure WLB Deloitte – ₹27L + benefits (≈₹29L), strong brand, project unconfirmed LearningMate – ₹31.5L + ₹2L bonus, confirmed modern project, but less-known brand Priorities: modern tech, WLB, brand, stability. Which would you pick & why? Decision by 28th July, joining on 29th.
Got a question about Persistent Systems?
Ask anonymously on communities.

Persistent Systems Interview FAQs

How many rounds are there in Persistent Systems interview?
Persistent Systems interview process usually has 2-3 rounds. The most common rounds in the Persistent Systems interview process are Technical, HR and Coding Test.
How to prepare for Persistent Systems interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Persistent Systems. The most common topics and skills that interviewers at Persistent Systems expect are Java, Javascript, Python, SQL and AWS.
What are the top questions asked in Persistent Systems interview?

Some of the top questions asked at the Persistent Systems interview -

  1. There are 3 rounds of interview had been conducted during the screening process...read more
  2. What is nodejs and difference between nodejs and javascr...read more
  3. Java 8 features, disadvantages of microservices, difference between RDBMS and N...read more
What are the most common questions asked in Persistent Systems HR round?

The most common HR questions asked in Persistent Systems interview are -

  1. What are your strengths and weakness...read more
  2. What is your family backgrou...read more
  3. Where do you see yourself in 5 yea...read more
How long is the Persistent Systems interview process?

The duration of Persistent Systems interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Overall Interview Experience Rating

3.9/5

based on 603 interview experiences

Difficulty level

Easy 16%
Moderate 73%
Hard 11%

Duration

Less than 2 weeks 65%
2-4 weeks 22%
4-6 weeks 6%
6-8 weeks 3%
More than 8 weeks 4%
View more

Explore Interview Questions and Answers for Top Skills at Persistent Systems

Join Persistent Systems See Beyond, Rise Above

Interview Questions from Similar Companies

LTIMindtree Interview Questions
3.7
 • 3.1k Interviews
Mphasis Interview Questions
3.3
 • 864 Interviews
DXC Technology Interview Questions
3.6
 • 848 Interviews
EXL Service Interview Questions
3.7
 • 818 Interviews
Coforge Interview Questions
3.3
 • 598 Interviews
eClerx Interview Questions
3.2
 • 588 Interviews
View all

Persistent Systems Reviews and Ratings

based on 4.5k reviews

3.6/5

Rating in categories

3.5

Skill development

3.6

Work-life balance

3.3

Salary

3.2

Job security

3.5

Company culture

3.0

Promotions

3.3

Work satisfaction

Explore 4.5k Reviews and Ratings
Healthcare Data Analyst

Pune

4-8 Yrs

Not Disclosed

Python Developer

Pune

4-9 Yrs

Not Disclosed

QA Automation Engineer

Pune

4-8 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
4.7k salaries
unlock blur

₹6.8 L/yr - ₹18.8 L/yr

Software Engineer
4.6k salaries
unlock blur

₹4.5 L/yr - ₹11.2 L/yr

Lead Software Engineer
3.8k salaries
unlock blur

₹9.2 L/yr - ₹17.5 L/yr

Lead Engineer
3.6k salaries
unlock blur

₹13.8 L/yr - ₹25.3 L/yr

Project Lead
2.3k salaries
unlock blur

₹21.4 L/yr - ₹36 L/yr

Explore more salaries
Compare Persistent Systems with

Cognizant

3.7
Compare

TCS

3.5
Compare

IBM

3.9
Compare

LTIMindtree

3.7
Compare
write
Share an Interview