Blancco Diagnostics India Interview Questions and Answers

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Q1. Machine Learning-related stuff: Confusion Matrix, R2 score, etc.. Also, Python & Statistics.
Add your answer
Q2. Explain any one project.
Add your answer
Q3. Difference between Data Analyst and Data Scientist.
Ans. 
Data Analyst focuses on analyzing data to provide insights, while Data Scientist focuses on using advanced algorithms and machine learning to predict future trends.
• Data Analyst focuses on analyzing data to provide insights for decision-making.

• Data Scientist focuses on using advanced algorithms and machine learning to predict future trends.

• Data Analyst typically works with structured data, while Data Scientist works wit...read more
Answered by AI
Add your answer

Q1. Internal working of hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To retrieve a value, the key is hash...read more
Answered by AI
Add your answer
Q2. Find Anagram from string array
Ans. 
Find anagrams from a string array
• Iterate through each string in the array

• Sort the characters of each string to create a key for comparison

• Use a hashmap to group anagrams together

• Return the grouped anagrams as arrays
Answered by AI
Add your answer

Q1. Top view of binary Tree
Ans. 
A top view of a binary tree shows the nodes visible when looking at the tree from the top.
• The top view of a binary tree is the set of nodes visible when looking at the tree from the top.

• Nodes at the same horizontal distance from the root are considered at the same level.

• Use a map to store the horizontal distance of each node and only keep the first node encountered at each horizontal distance.
Answered by AI
Add your answer
Q2. Java based questions
Add your answer

Q1. Hight of binary tree
Ans. 
Height of a binary tree is the maximum number of edges on the longest path from the root node to a leaf node.
• Height of an empty tree is -1

• Height of a tree with only one node is 0

• Height of a binary tree can be calculated recursively by finding the height of left and right subtrees and adding 1 to the maximum of the two heights
Answered by AI
Add your answer
Q2. Garbage Collector
Add your answer

Q1. Library Management System
Add your answer

Q1. Why you want to change?
Add your answer

Q1. Troubleshooting questions
Add your answer

Q1. How to handle angry customers
Add your answer

Had basic aptitude questions

Q1. General resume questions
Add your answer
Q2. What is bank reconciliation
Add your answer
Q3. Tell me about GST
Add your answer

A link was provided for the 15-minute online aptitude test.

90 minutes coding round. There were three problems. One for JavaScript and two for ReactJS

Q1. Mostly ReactJS questions were asked and a few Javascript questions were asked.
Add your answer

Q1. Again a few react based questions then it was mostly discussion on the past experiences.
Add your answer

Q1. A general discussion about the notice period, compensation, and information about the company's culture was provided.
Add your answer

Q1. Introducing your self and project
Add your answer
Q2. Severity and priority
Add your answer
Q3. Smoke and sanity testing
Add your answer
Q4. Scenario base question if find bug before release
Add your answer

Q1. Java 8 features
Add your answer
Q2. Functional interfaces with custom functional interface coding question
Add your answer
Q3. Stream apis and one coding question
Add your answer
Q4. Spring framework,IOC container, bean scopes.
Add your answer
Q5. Different between monolithic and micro services architecture. Pros and cons.
Add your answer
Q6. REST apis
Add your answer
Q7. Few SQL queries
Add your answer