Upload Button Icon Add office photos

Sophos Technologies

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Sophos Technologies Senior Business System Analyst Interview Questions and Answers

Updated 19 Feb 2025

Sophos Technologies Senior Business System Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Business analyst activities, case based questions, Technical skills
Round 2 - Assignment 

Presentations on Stakeholder management
Scenario based presentation

Round 3 - One-on-one 

(1 Question)

  • Q1. Casual discussion
Round 4 - Technical 

(1 Question)

  • Q1. Technical skills round

Interview questions from similar companies

Data Analyst Interview Questions & Answers

McAfee user image Sidharth Kriplani

posted on 13 Aug 2023

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

I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all Resume tips
Round 2 - Technical 

(4 Questions)

  • Q1. I was provided with three tables: 1st table had city wise sales, 2nd table had province_id and name, 3rd table had city_id, city_name, and province_id 1. Get the highest sales value, city, province. Do th...
  • Q2. Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?
  • Ans. 

    Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.

    • Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.

    • Aggregate functions can also be used with WHERE clause to filter rows before grouping.

    • WHERE clause filters rows before grouping, while HAVING clause filters groups aft...

  • Answered by AI
  • Q3. What is the order of execution of a SQL Query?
  • Ans. 

    The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • FROM: Specifies the tables involved in the query

    • WHERE: Filters the rows based on specified conditions

    • GROUP BY: Groups the rows that have the same values into summary rows

    • HAVING: Filters the groups based on specified conditions

    • SELECT: Selects the columns to be displayed in the result set

    • ORDER BY: Sorts the result set based on speci

  • Answered by AI
  • Q4. What are User Defined Functions? Stored Procedures? Triggers?
  • Ans. 

    User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.

    • User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.

    • Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.

    • Triggers are special types of stored procedures that are auto...

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

(1 Question)

  • Q1. This was a managerial round

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for SQL the most

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Gave some scenario based questions

Round 2 - Assignment 

Case study walkthrough

Round 3 - HR 

(1 Question)

  • Q1. General hr questions
Interview experience
4
Good
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Dhcp helper mac and ip
  • Q2. Putting ip on window pc
  • Ans. 

    To assign an IP address to a Windows PC, you can do so through the network settings.

    • Go to Control Panel > Network and Sharing Center

    • Click on Change adapter settings

    • Right-click on the network connection you want to assign an IP address to and select Properties

    • Select Internet Protocol Version 4 (TCP/IPv4) and click on Properties

    • Choose 'Use the following IP address' and enter the IP address, subnet mask, default gateway,

  • Answered by AI
  • Q3. What if i browse a website, what works at backend
  • Ans. 

    When browsing a website, various components work at the backend to deliver content and functionality.

    • Web server processes requests and serves web pages

    • Database stores and retrieves data

    • Application server executes application logic

    • Content delivery network (CDN) may cache and deliver content

    • Load balancer distributes incoming traffic to multiple servers

    • Web browser renders the content for the user

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Needs more hands on practice

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is ransomware
  • Ans. 

    Ransomware is a type of malware that encrypts a user's files and demands payment in exchange for the decryption key.

    • Ransomware is typically spread through phishing emails, malicious websites, or software vulnerabilities.

    • Once a user's files are encrypted, the ransomware will display a message demanding payment in cryptocurrency.

    • Paying the ransom does not guarantee that the files will be decrypted, and it may encourage f...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Where do you see in next 5 years
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How would you troubleshoot system hang issue because of Antivirus
  • Q2. How would you find malware files on systems

Interview Preparation Tips

Interview preparation tips for other job seekers - It’s good Indian company to work
Round 1 - One-on-one 

(2 Questions)

  • Q1. What different did you do in locked down
  • Ans. 

    During the lockdown, I focused on enhancing my technical skills and learning new technologies.

    • Took online courses and certifications to improve my knowledge in areas like networking and troubleshooting

    • Participated in virtual workshops and webinars to stay updated with the latest industry trends

    • Practiced troubleshooting scenarios on virtual machines to sharpen my problem-solving abilities

    • Contributed to online technical ...

  • Answered by AI
  • Q2. How do you spend your day?
  • Ans. 

    As a Technical Support Engineer, my day is spent troubleshooting and resolving technical issues for customers.

    • I start my day by checking emails and responding to any urgent customer inquiries.

    • I prioritize and manage my workload, addressing high-priority issues first.

    • I collaborate with other team members to share knowledge and seek assistance when needed.

    • I troubleshoot technical problems reported by customers, analyzing...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and give realistic answers. Share an out of the box answer or scenario during you previous work. Show them how good you are in handling situations

I applied via Campus Placement and was interviewed in Jan 2016. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Questions on linked list
  • Q2. Questions on resume
  • Q3. About my interests
  • Q4. My interest in symantec
  • Q5. Place to work

Interview Preparation Tips

College Name: IIT Madras

I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. How you find loop in a linked list
  • Ans. 

    To find a loop in a linked list, we use Floyd's cycle-finding algorithm.

    • Floyd's cycle-finding algorithm uses two pointers, one moving at twice the speed of the other.

    • If there is a loop in the linked list, the two pointers will eventually meet.

    • To detect the meeting point, we reset one of the pointers to the head of the linked list and move both pointers at the same speed.

    • The meeting point is the start of the loop.

  • Answered by AI
  • Q2. What is LRU, MRU and LFU
  • Ans. 

    LRU, MRU and LFU are caching algorithms used to manage memory in computer systems.

    • LRU stands for Least Recently Used and removes the least recently used items from the cache when the cache is full.

    • MRU stands for Most Recently Used and removes the most recently used items from the cache when the cache is full.

    • LFU stands for Least Frequently Used and removes the least frequently used items from the cache when the cache i...

  • Answered by AI
  • Q3. Camel banana problem

Interview Preparation Tips

Round: Test
Experience: coding test in hacker rank. can code in any language except in C and C++.
Duration: 1 hour
Total Questions: 2

Round: Technical Interview
Experience: In technical round the questions are on OS, basics of C(mainly in linked lists) and maths puzzle

They mostly see how you are approaching towards a problem.
It is first time that I heard the camel banana problem. So I struggled for some time and came up with a solution. He said he liked the approach but it can be optimized.

Round: HR Interview
Experience: It started with explain about yourselves. and then he asked to explain about one project with technical details. Later he asked me to explain binary search for a guy who don't know much of technical knowledge. He continued with why we only do 2 partitions why can we make it up to 3. Later he asked me what I liked most in my mobile phone. I said chatting apps. So he asked me that if I was hired as a developer to make a chatting app how will I do it.
Tips: way of thinking and way of approaching towards a problem.

Round: HR Interview
Experience: This round was focused mainly on whether I like to work in Bangalore or not. How I first heard about Symantec. how I will suit for the company. what are my future plans.

Skills: C, OS, Math Puzzles
College Name: IIT Madras

Skills evaluated in this interview

I was interviewed in Feb 2017.

Interview Preparation Tips

Round: Test
Experience: Very first, the interviewers and their employees gave presentation about their products and company. They were very cool and very positive to motivate candidates. After that they started Round 1 that is test based on aptitude and logical problem, also containing c programmin and operating system problems.
Tips: If you have studied basics very well, you will clear the round 1 very easily. Study C programming and Linux Operating System concepts.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical Interview
Experience: I am not specifying any question above because 2nd round i.e Technical Round 1 was continued to abt 1 and hour hours taken by 1 interviewer. If you give all answers confindently, obviously they all must be correct, you will be qualified to next techincal round.
Tips: Same as mentioned in round 1.
Study C programming & Operating System.

Round: Technical Interview
Experience: This was Technical Round 2. It was taken by 3 interviewers asking questions randomly from random subject. Also, one took rapid fire round for 20-25 questions. If you qualified this round, then you can assume that you are selected. This round was also continued more than 1 hour.
Tips: Study Networking concepts

Round: HR Interview
Experience: If you are called for HR interview, then you can assume that you already selected as employee for company. This is round is just for formality to tell you CTC and location and joining, etc.
One thing I would like to mention that in each round they will ask you to tell about yourself. So prepare that too. In HR round, they asked me some tricky puzzles to solve since I mentioned that I am very good in maths so.

College Name: Datta Meghe College of Engineering
Contribute & help others!
anonymous
You can choose to be anonymous

Sophos Technologies Interview FAQs

How many rounds are there in Sophos Technologies Senior Business System Analyst interview?
Sophos Technologies interview process usually has 4 rounds. The most common rounds in the Sophos Technologies interview process are Technical, Assignment and One-on-one Round.
How to prepare for Sophos Technologies Senior Business System Analyst 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 Sophos Technologies. The most common topics and skills that interviewers at Sophos Technologies expect are Agile, Business Process Analysis, HP Data Protector, IT Service Desk and JIRA.
What are the top questions asked in Sophos Technologies Senior Business System Analyst interview?

Some of the top questions asked at the Sophos Technologies Senior Business System Analyst interview -

  1. Business analyst activities, case based questions, Technical ski...read more
  2. Technical skills ro...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Automotive Robotics (India)

No Interviews

INTERVIEWS

Automotive Robotics (India)

No Interviews

INTERVIEWS

KLA

No Interviews

INTERVIEWS

Sophos Technologies

No Interviews

INTERVIEWS

Automotive Robotics (India)

No Interviews

INTERVIEWS

Sophos Technologies

No Interviews

INTERVIEWS

Sophos Technologies

No Interviews

INTERVIEWS

Sophos Technologies

No Interviews

Tell us how to improve this page.

Sophos Technologies Senior Business System Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Globant Interview Questions
3.8
 • 172 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
AVASOFT Interview Questions
3.6
 • 146 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
Thomson Reuters Interview Questions
4.1
 • 112 Interviews
Amadeus Interview Questions
3.9
 • 107 Interviews
EbixCash Limited Interview Questions
4.0
 • 101 Interviews
SPRINKLR Interview Questions
3.0
 • 100 Interviews
View all

Sophos Technologies Senior Business System Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.0

Salary

4.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Technical Support Engineer
105 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Network Security Engineer
68 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer III
33 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Sophos Technologies with

QUICK HEAL TECHNOLOGIES

3.7
Compare

Trend Micro

4.3
Compare

McAfee

4.0
Compare

Gen

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview