PureSoftware Interview Questions, Process, and Tips for Experienced

Q1. Questions on ADF, data factory and databricks
Add your answer
Q2. Find longest palindrome string in a given string
Ans. 
Use dynamic programming to find the longest palindrome substring in a given string.
• Iterate through each character in the string and expand around it to find palindromes

• Store the length of each palindrome found and return the longest one

• Handle both odd and even length palindromes
Answered by AI
Add your answer
Q3. Spark, memory optimization, repartition and data skewness related question
Add your answer

Q1. With client, asked project end to end details and my role into it
Add your answer

Q1. How to count number of rows in a table
Ans. 
Use SQL query SELECT COUNT(*) FROM table_name
• Use SQL query SELECT COUNT(*) FROM table_name

• Replace 'table_name' with the actual name of the table

• This query will return the number of rows in the table
Answered by AI
Add your answer

Data structures and algorithms, javascript and react questions

Q1. Questions on system design
Add your answer
Q2. Questions on advanced CI/CD pipeline
Add your answer

Q1. Discussion on product management
Add your answer
Q2. State management system
Add your answer

Q1. It was good they just follow the process asked some simple java question.
Add your answer
Q2. What is the difference between hashmap and concurrenthashmap
Ans. 
HashMap is not thread-safe while ConcurrentHashMap is thread-safe.
• HashMap is not thread-safe and can lead to ConcurrentModificationException if modified during iteration.

• ConcurrentHashMap allows concurrent read and write operations without the need for external synchronization.

• ConcurrentHashMap achieves thread-safety by dividing the map into segments, allowing multiple threads to operate on different segments concurren
Answered by AI
Add your answer
Q3. SQL question of third highest salary
Ans. 
To find the third highest salary in a SQL table, use the 'SELECT DISTINCT' statement with 'ORDER BY' and 'LIMIT'.
• Use 'SELECT DISTINCT' to avoid duplicates

• Order the salaries in descending order using 'ORDER BY'

• Use 'LIMIT 2,1' to skip the first two highest salaries and retrieve the third highest salary
Answered by AI
Add your answer

Q1. Overall it was good
Add your answer
Q2. System design related question design parking lot
Add your answer

Q1. Asked me about the salary expectations
Add your answer