Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Seneca Global IT Services Team. If you also belong to the team, you can get access from here

Seneca Global IT Services Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Seneca Global IT Services Technology Analyst Interview Questions and Answers for Freshers

Updated 9 Aug 2024

Seneca Global IT Services Technology Analyst Interview Experiences for Freshers

1 interview found

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

I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Python OOPS concept and other libraries and framework
  • Q2. Sqlalchemy queries and db optimization

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics of python, project related questions
  • Q2. Basic SQL, few simple problem solving questions
Round 2 - HR 

(2 Questions)

  • Q1. Interests, hobbies ,general HR questions
  • Q2. Expected hike, salary, work timings preferred

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for basic python and sql.

Interview Questionnaire 

2 Questions

  • Q1. Fsmo roles
  • Q2. Office 365

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Drill Down,Drill through
  • Q2. Dax functions like date add,date diff,time Intelligence
  • Q3. Import direct query

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewer was very nice.If u are confident u can easily crack the interview

I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Given an input string "neeraj chopra" Write Python code to get output string as "jareen arpohc".
  • Ans. 

    The Python code to get the output string as 'jareen arpohc' from the input string 'neeraj chopra' is provided.

    • Split the input string into individual words

    • Reverse each word

    • Join the reversed words with a space in between

  • Answered by AI
  • Q2. Given a list of 10 numbers. Write a code to list only even numbers out of the original list.
  • Ans. 

    Code to list even numbers from a given list of 10 numbers.

    • Loop through the list of numbers

    • Check if each number is even using the modulo operator

    • If the number is even, add it to a new list of even numbers

    • Return the new list of even numbers

  • Answered by AI
  • Q3. SQL queries using Window Functions Rank() , Dense Rank() etc
  • Q4. Reversal of string in python code
  • Ans. 

    Reversing a string in Python code

    • Use slicing to reverse the string

    • Use the built-in function 'reversed()'

    • Convert the string to a list, reverse it, and then join it back to a string

  • Answered by AI
  • Q5. SQL queries in general.

Interview Preparation Tips

Interview preparation tips for other job seekers - There is hiring surge in the company so one should go for it .
Basic Python , SQL knowledge is enough to crack the interviews.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. SQL window functions
  • Q2. Basic SQL queries
  • Q3. Basic Power BI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be kind and humble and don't cheat. The interview will be a cup of cake if you even have some decent experience. Just get your basic right. There won't be much scenarios and coding questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Aug 2022. There were 4 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 - Coding Test 

Test of SQL, Tableau and other skills based on your resume on Skillate

Round 3 - Technical 

(1 Question)

  • Q1. SQL and other skills technical questions
Round 4 - One-on-one 

(1 Question)

  • Q1. Manager round / 2nd technical round
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Apr 2024, where I was asked the following questions.

  • Q1. SQL joins, window functions, scenario based questions on data cleaning, data processing
  • Q2. What strategies can be employed for the optimization of ETL processes and Spark jobs?

I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Round 2 - One-on-one 

(1 Question)

  • Q1. Javascript basics, Angular react general questions depends upon profile.
Round 3 - Behavioral 

(1 Question)

  • Q1. They asked general questions related to some hectic situation faced in previous company / project..

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm . Clear your basics . That's it.

I applied via Company Website and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Interview based on your programming language , how good you know like java or python or scala
  • Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
  • Q3. Explain your recent project in detail
Round 2 - Technical 

(2 Questions)

  • Q1. More deep dive in your expertise technologies like Spark DAG working explain
  • Q2. How you do data validation in hive
  • Ans. 

    Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.

    • Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

    • Use regular expressions and pattern matching to validate data formats

    • Write custom scripts to perform more complex data validation tasks

    • Perform data profiling to identify potential data quality issues

    • Use data...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary , why changing job etc..
  • Q2. Your complete background of career

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your resume things strong for interview tthats it.

Skills evaluated in this interview

Seneca Global IT Services Interview FAQs

How many rounds are there in Seneca Global IT Services Technology Analyst interview for freshers?
Seneca Global IT Services interview process for freshers usually has 1 rounds. The most common rounds in the Seneca Global IT Services interview process for freshers are One-on-one Round.
What are the top questions asked in Seneca Global IT Services Technology Analyst interview for freshers?

Some of the top questions asked at the Seneca Global IT Services Technology Analyst interview for freshers -

  1. Python OOPS concept and other libraries and framew...read more
  2. Sqlalchemy queries and db optimizat...read more

Tell us how to improve this page.

Seneca Global IT Services Technology Analyst Interview Process for Freshers

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 50 Interviews
IT By Design Interview Questions
3.5
 • 40 Interviews
ConsultAdd Interview Questions
3.5
 • 36 Interviews
View all
Seneca Global IT Services Technology Analyst Salary
based on 5 salaries
₹20 L/yr - ₹36 L/yr
303% more than the average Technology Analyst Salary in India
View more details
Software Engineer
83 salaries
unlock blur

₹3.8 L/yr - ₹11.5 L/yr

Senior Software Engineer
82 salaries
unlock blur

₹8.1 L/yr - ₹30 L/yr

Technical Analyst
48 salaries
unlock blur

₹14.2 L/yr - ₹35 L/yr

Information Technology Support Engineer
37 salaries
unlock blur

₹3.2 L/yr - ₹6 L/yr

Senior Technical Analyst
32 salaries
unlock blur

₹17.6 L/yr - ₹38.2 L/yr

Explore more salaries
Compare Seneca Global IT Services with

Maxgen Technologies

4.6
Compare

Value Point Systems

3.6
Compare

JoulestoWatts Business Solutions

2.9
Compare

F1 Info Solutions and Services

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