Upload Button Icon Add office photos
Engaged Employer

i

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

SightSpectrum Technology Solutions Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

SightSpectrum Technology Solutions System Analyst Interview Questions and Answers

Updated 18 Mar 2024

SightSpectrum Technology Solutions System Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL ,PLSQL, ETL

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Protocols IPV4 and IPV6
  • Q2. Routers and nodes

Interview Preparation Tips

Interview preparation tips for other job seekers - Just and Ok interview. No tough questions were asked

Interview Preparation Tips

Round: Test
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40

Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.

Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.

Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P

General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore

Interview Questionnaire 

1 Question

  • Q1. Filters in Tableau,sql
  • Ans. 

    Filters in Tableau and SQL are used to narrow down data based on specific criteria.

    • Filters in Tableau can be applied to individual worksheets or the entire dashboard

    • SQL filters can be applied using the WHERE clause

    • Tableau filters can be based on dimensions or measures

    • SQL filters can be based on any column in the table

    • Tableau filters can be interactive, allowing users to adjust the criteria

    • SQL filters can be combined wi

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Sql,tableau,python, business understanding

Skills evaluated in this interview

I applied via Referral and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL joins,group by ,window functions ,difference between where and having syntax and python manipulation questions such as subsetting ,aggregation ,pivot ,group by .Guesstimate to find total number of traf...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in SQL , PYthon/R and equally good in guesstimate questions

I appeared for an interview in Feb 2021.

Interview Questionnaire 

1 Question

  • Q1. Project, thesis, sql joins, rank function, palindrome.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and confident. Prepare your cv.
Good projects help.

I applied via LinkedIn and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. There were 2 rounds .1. A coding round which had easy to moderate level interview questions 2. A technical interview where the previous projects were discussed

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is quite easy .Just need to prepare properly whatever is written in the resume since they mostly ask from the resume
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in May 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. What is Authorisation?
  • Ans. 

    Authorisation is the process of granting or denying access to resources based on a set of rules or policies.

    • Authorisation determines what a user can do with the resources they have access to

    • It is often based on roles, permissions, or access control lists

    • Examples include granting a user permission to edit a document, or denying access to a restricted area

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion only
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. Can you describe your skills and previous work experience?
  • Ans. 

    I have strong analytical skills and experience in data manipulation, visualization, and interpretation.

    • Proficient in SQL, Python, and R for data analysis

    • Experience with data cleaning, transformation, and visualization tools such as Tableau and Power BI

    • Strong background in statistical analysis and hypothesis testing

    • Previous work experience includes analyzing sales data to identify trends and make recommendations for imp

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Everyone should come to Alchemy to achieve a better future.
Round 1 - One-on-one 

(1 Question)

  • Q1. The questions were asked regarding the Data science projects I did as a part of my PGP course. The interviewer was emphasizing on the logic I used in the Data science projects and how much I was clear abou...
Round 2 - One-on-one 

(1 Question)

  • Q1. The questions were asked about the day-to-day roles and responsibilities as a BA in my previous organisation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about the points you have mentioned in resume and be clear about while explaining the same.

SightSpectrum Technology Solutions Interview FAQs

How many rounds are there in SightSpectrum Technology Solutions System Analyst interview?
SightSpectrum Technology Solutions interview process usually has 1 rounds. The most common rounds in the SightSpectrum Technology Solutions interview process are Technical.

Tell us how to improve this page.

SightSpectrum Technology Solutions System Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

CMS IT Services Interview Questions
3.1
 • 138 Interviews
MAQ Software Interview Questions
2.0
 • 102 Interviews
Arcesium Interview Questions
3.5
 • 79 Interviews
Apisero Interview Questions
4.3
 • 65 Interviews
Webkul Software Interview Questions
3.9
 • 64 Interviews
View all
SightSpectrum Technology Solutions System Analyst Salary
based on 21 salaries
₹3.1 L/yr - ₹12.5 L/yr
31% less than the average System Analyst Salary in India
View more details

SightSpectrum Technology Solutions System Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

3.0

Salary

1.0

Job security

2.0

Company culture

2.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Information Technology Recruiter
81 salaries
unlock blur

₹1 L/yr - ₹4.1 L/yr

Software Developer
72 salaries
unlock blur

₹1.8 L/yr - ₹6 L/yr

Software Trainee
45 salaries
unlock blur

₹1 L/yr - ₹3 L/yr

US IT Recruiter
38 salaries
unlock blur

₹1.2 L/yr - ₹4.5 L/yr

System Analyst
21 salaries
unlock blur

₹3 L/yr - ₹12.5 L/yr

Explore more salaries
Compare SightSpectrum Technology Solutions with

CMS IT Services

3.1
Compare

Tekwissen

4.8
Compare

Softenger

4.1
Compare

Quantiphi Analytics Solutions Private Limited

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