Optum Global Solutions
10+ Zoho Interview Questions and Answers
Q1. How far you are good at automate the infra using scripting or coding?
I am highly skilled in automating infrastructure using scripting and coding.
Proficient in scripting languages like Python, Bash, and PowerShell
Experience in using configuration management tools like Ansible and Chef
Familiarity with cloud platforms like AWS and Azure and their automation tools
Implemented infrastructure as code using tools like Terraform
Automated deployment pipelines using tools like Jenkins and GitLab CI/CD
Examples: Wrote Python scripts to automate AWS EC2 ins...read more
Q2. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1,1]
The inner join of two tables with duplicate values results in a combined set of common values.
Inner join combines rows from both tables where the key columns match
In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables
Q3. What is Incident, problem and change management?
Incident, problem, and change management are processes used in IT to handle unexpected events, identify root causes of issues, and implement modifications to systems.
Incident management involves responding to and resolving unexpected events that disrupt normal operations, such as system crashes or network outages.
Problem management focuses on identifying the root causes of recurring incidents to prevent them from happening again in the future.
Change management is the process ...read more
Q4. What is difference between SQL and NoSQL
SQL is a relational database management system, while NoSQL is a non-relational database management system.
SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores
SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages
SQL databases are vertically scalable, NoSQL databases are horizontally scalable
SQL databases are good for complex queries, NoSQL databases are bett...read more
Q5. Explain the data pipeline you have worked on.
Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.
Used Apache Kafka for real-time data streaming
Utilized Apache Spark for data processing and analysis
Implemented data transformations and aggregations using Scala
Stored processed data in a data warehouse like Amazon Redshift
Built monitoring and alerting systems to ensure data pipeline reliability
Q6. Why is NoSQL better then SQL
NoSQL is better for handling unstructured data, providing scalability and flexibility.
NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.
NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.
NoSQL databases offer more flexibility in terms of data model, allowing for schema-less design and easier adaptation to changing dat...read more
Q7. Spark df rdd ds difference, Configuration of setup
Difference between Spark df, rdd, ds and configuration setup
Spark df is a distributed collection of data organized into named columns
RDD is a fault-tolerant collection of elements that can be processed in parallel
DS is a type-safe version of df that provides compile-time type safety
Configuration setup involves setting up Spark properties like memory allocation, parallelism, etc.
Example: df.select('column').groupBy('column').agg({'column': 'sum'})
Example: rdd.map(lambda x: x*2...read more
Q8. Explain release management.
Release management is the process of planning, scheduling, coordinating, and deploying software releases.
It involves identifying the scope of the release and the features to be included
Creating a release plan and schedule
Coordinating with different teams involved in the release process
Testing the release to ensure it meets quality standards
Deploying the release to production
Monitoring the release to ensure it is stable and functioning as expected
Managing any issues or bugs th...read more
Q9. Different between Incident and problem?
Incident is an unplanned event that disrupts normal operations, while a problem is the underlying cause of one or more incidents.
Incident is a specific event that causes disruption, problem is the root cause of incidents
Incidents are usually resolved quickly, problems require investigation and resolution to prevent future incidents
Problems are often identified through recurring incidents
Q10. Latest project explanation
Developed a web application for tracking and managing project tasks
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express
Utilized MongoDB for database management
Incorporated authentication and authorization features for user security
Q11. Multithreading in Java
Multithreading in Java allows for concurrent execution of multiple threads within a single program.
Multithreading can improve performance by allowing multiple tasks to be executed simultaneously.
Java provides built-in support for multithreading through the Thread class and Runnable interface.
Synchronization is important to prevent race conditions and ensure thread safety.
Examples of multithreading in Java include GUI applications, server applications, and parallel processing....read more
Q12. Uses of Rest API
Rest API is used for communication between different systems over the internet.
Allows systems to interact and exchange data
Enables integration between different applications
Used for building web services and APIs
Commonly used in mobile app development
Top HR Questions asked in Zoho
Interview Process at Zoho
Top Senior Software Engineer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month