Upload Button Icon Add office photos

Filter interviews by

Norstella Interview Questions and Answers

Updated 31 Jan 2025

Norstella Interview Experiences

Popular Designations

6 interviews found

Data analytics support Interview Questions & Answers

user image Akash saxena

posted on 31 Jan 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Data mining using api. Data validation and cleaning. SQL questions on top 5 months with highest orders. Performance improvements in SQL.
  • Q2. How did you implemented data pipeline from scratch.

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was tedious and way too long. Firstly they took interviews and assessments and then ghosted me for 2-3 months. Then the Hr came back to say the position was closed at that time and now it is reopened again. I agreed to give the interview again. This time there were 5 people in the panel including a fresh employee only 2 months old who is 4-5 years less experienced than me and was asking questions. Also the panel joined late. I felt this disrespectful. Then after asking questions for 1 hour straight the project manager suddenly disappeared from interview. The interview ended abruptly. I feel you should have time to review answers after asking questions. If they didn't had time they should have postponed. Very disrespectful and in bad taste.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2024. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basics SQL data manipulation
  • Q2. Python data manipulation
Round 2 - Technical 

(2 Questions)

  • Q1. Deeper dive into Data Engineering stack
  • Q2. Lots of questions on Data Engineering fundamentals
Round 3 - Technical 

(1 Question)

  • Q1. More depth on past projects, tech stack tools
Round 4 - HR 

(1 Question)

  • Q1. Discussed Salary structure

Interview Preparation Tips

Interview preparation tips for other job seekers - DON'T APPLY FOR JOB IN THIS COMPANY!! HR Doesn't care, they will play with your career, HR told me I cleared all rounds and say they're releasing offer letter in day or two, I resigned from my current company, HR started not picking up phone telling that they're going through hectic phase. If you are feeling really really adventurous and do have other plenty of backup options only then apply for interview here.

Data Analytics Engineer Interview Questions asked at other Companies

Q1. Python code for palindrome
View answer (1)

IT Service Support Services Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Nov 2024

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. About Azure AD accounts
  • Q2. VPN connectivity

Interview Preparation Tips

Interview preparation tips for other job seekers - This is position is for L1

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 10 Jan 2025

Interview experience
2
Poor
Difficulty level
Hard
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is python, string operation, scenario based questions

ETL Tester Interview Questions asked at other Companies

Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts table, How will you compare it with target systems
View answer (3)

Norstella interview questions for popular designations

 Consultant

 (1)

 Data Analytics Engineer

 (1)

 ETL Tester

 (1)

 Research Analyst

 (1)

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
6-8 weeks
Result
No response

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a detail-oriented research analyst with a strong background in data analysis and market research.

    • Experienced in conducting quantitative and qualitative research

    • Proficient in data collection, analysis, and interpretation

    • Skilled in using statistical software such as SPSS and Excel

    • Strong communication and presentation skills

    • Previous projects include market trend analysis and competitor benchmarking

  • Answered by AI
  • Q2. Roles and Responsibilities

Research Analyst Interview Questions asked at other Companies

Q1. What is income statement how do u calculate net profit? What is stock split and merger and takeover and depreciation and amortization and net worth and retaining earnings,book value per share? Types of equity shares etc...
View answer (3)

Consultant Interview Questions & Answers

user image ali xan

posted on 23 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via AngelList

Round 1 - Group Discussion 

It had excel sheet test followed by an group interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Sharpen your excel experience

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Jobs at Norstella

View all

Interview questions from similar companies

Interview Preparation Tips

Round: Resume Shortlist
Experience: I was fulfilling their criteria of 60% through out the academics.

Round: Test
Experience: Aptitude was easy. It contained basics of Quants & Logic . Verbal or English part was bit difficult and length. There was a sectional time and sectional cut off.

Round: Interview
Experience: There was only one interview. Both Technical and HR questions were asked in the same interview. Prepare puzzles from the book Puzzles to puzzle you by Shakuntala Devi. This book helped me a lot. Technical questions were very basic but nearly from every subject.

General Tips: BE CONFIDENT. Speak Confident in Interview even if you are not good with ur english.
Skills: English language, Communication Skills, Reasoning Abilities
College Name: Jawaharlal Nehru Engineering College Aurangabad

Assistant Trainee Interview Questions & Answers

TCS user image YATISH KUMAR KESHWANI

posted on 9 Feb 2015

Interview Questionnaire 

22 Questions

  • Q1. What are the subjects you have command in?
  • Q2. Tell me about your final year project?
  • Q3. Tell me about the industrial training you had?
  • Q4. How does an induction motor works?
  • Q5. Why motor is rated in KW whereas Transformer and generator in KVA?
  • Ans. 

    Motors are rated in KW because they consume power, while transformers and generators are rated in KVA because they produce power.

    • Motors convert electrical energy into mechanical energy, so they consume power and are rated in KW.

    • Transformers and generators produce electrical energy, so they are rated in KVA based on their apparent power.

    • KVA takes into account both the real power (KW) and the reactive power (KVAR) produc...

  • Answered by AI
  • Q6. What is the type of motor used in ceiling fans?
  • Ans. 

    The type of motor used in ceiling fans is an induction motor.

    • Ceiling fans typically use single-phase induction motors.

    • These motors are designed to provide a constant speed and are efficient in converting electrical energy into mechanical energy.

    • The motor consists of a stator and a rotor, with the stator being the stationary part and the rotor being the rotating part.

    • The stator contains windings that create a rotating m...

  • Answered by AI
  • Q7. Hoe does a thermal power plant works?
  • Ans. 

    A thermal power plant generates electricity by converting heat energy into mechanical energy.

    • Thermal power plants use fossil fuels or nuclear energy to heat water and produce steam.

    • The steam drives a turbine, which is connected to a generator that produces electricity.

    • The heat source can be coal, natural gas, oil, or nuclear reactions.

    • The steam is condensed back into water and recycled in a closed-loop system.

    • Thermal p...

  • Answered by AI
  • Q8. Write a program to make a GP
  • Ans. 

    A program to generate a geometric progression (GP).

    • Take the first term, common ratio and number of terms as input.

    • Use a loop to calculate each term of the GP.

    • Print the generated GP as output.

  • Answered by AI
  • Q9. Write a program to print factorial using recursion
  • Ans. 

    A program to print factorial using recursion

    • Define a function to calculate factorial recursively

    • Base case: if the number is 0 or 1, return 1

    • Recursive case: multiply the number with factorial of (number - 1)

    • Print the factorial of a given number

  • Answered by AI
  • Q10. Write the logic to reverse a string without using string fnctions
  • Ans. 

    Logic to reverse a string without using string functions

    • Iterate through the string from the last character to the first

    • Create a new string and append each character to it in reverse order

  • Answered by AI
  • Q11. Tell me about yourself?
  • Q12. What are your hobbies?
  • Q13. Apart from your technical pat and studies what have you done in college?
  • Q14. What do you prefer, ethics or values?
  • Q15. Suppose you are working in office and somebody came and slapped you, what will you do?
  • Q16. Tell me about yourself for 5 minutes
  • Q17. What are your views about Mr. Narendra Modi as PM of India
  • Q18. Any extra curricular activities you have participated in school or college
  • Q19. What are your strengths?
  • Q20. What are your weaknesses?
  • Q21. Being an Electrical engineer why do you want to join an IT company
  • Q22. What do you know about TCS?

Interview Preparation Tips

Round: Test
Experience: In email writing one question was given describing the situation and maximum word limit. It has the keywords given to be used. 1 question, 10 minutes.This section is generally used to check your verbal ability. Make sure to use all the keywords given and complete it within time, with no spelling mistakes of course. Missing a keyword or a spelling mistake could be your goodbye to qualified list.The second section had 30 questions of quantitative aptitude. Duration 70 mins. There are questions from various sections, such as Time and speed, Time and distance, Data interpretation,etc.There are 2-3 star marked questions which have more weight-age. There my also be a dummy question who doesn't have any matching answer. Make sure uh don't attempt these questions.26-27 questions is the cut-off for qualified list.But you have to do the email writing part correctly.
Tips: Practice email writing online from various websites such as technicalbaba.com, indiageeks.comPractice quantitative aptitude as it is a must in any interview you will face. you can use R.S.Agarwal or CAT material.
Duration: 90 minutes
Total Questions: 30 + 1

Round: Interview
Experience: Greeting the interviewer is a must. Be confident and enthusiastic. Have your resume properly ready. Technical questions from your subject will be asked. Not a must that you should know any programming language like C, C++, JAVA.
Tips: Prepare 3-4 subjects of your core branch. Never try to flatter the interviewer. Be confident and answer the questions appropriately. Dont say directly " I DON'T KNOW". Atleast try even if you dont know the answer.

Round: Interview
Experience: There are certain questions which doesnt have direct answers. You have to be diplomatic about them. You should be able to see all the possible situation when a question like that is asked.

Round: Interview
Experience: The HR head may manipulate you, try to stress you, etc. Be calm and confident.Think before you speak. Prepare your answers before hand for general questions. Write your introduction on a paper and prepare it well so that you speak it confidently...
Tips: Be yourself. Be confident. Never argue with the interviewer.All the best

General Tips: Be presentable in the interview. Wear a watch. Show respect to the interviewer. Prepare 3-4 technical subjects well. Read last 15 days newspaper. Be confident when you speak. Improve your English if you are weak in it.
Skill Tips: ""
Skills: Verbal ability, Attitude, Technical knowledge, General knowledge
College Name: IMS ENGINEERING COLLEGE, GHAZIABAD
Motivation: TCS is a semi government company with a decent package and high job security.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Basic HR questions, your understanding of your projects, biggest achievement so far??

Interview Preparation Tips

Round: Resume Shortlist
Tips: Get to know your resume very well, have a story for each of your resume point

Round: Test
Experience: Written test. Basic Quant and one short essay to test your English.

Round: Interview
Experience: They were looking for people with good math skills and team player.

Round: Interview
Experience: Prepare for all the basic HR questions beforehand, write them down. for core get your basic fundamentals perfect.
Tips: I started preparing for placements from Nov starting but starting early will be better.

General Tips: Prepare for all the basic HR questions beforehand, write them down. 
For core, get your basic fundamentals perfect.
Skills: Basic fundamentals
College Name: IIT-Madras

Interview Questionnaire 

7 Questions

  • Q1. Should “Social Media” technique be used for educational purposes
  • Ans. 

    Yes, social media can be used for educational purposes.

    • Social media provides a platform for sharing educational content and resources.

    • It allows for collaboration and communication among students and teachers.

    • Social media can enhance learning through interactive discussions and real-time feedback.

    • It can also help in reaching a wider audience and promoting educational initiatives.

    • Examples include educational YouTube chan...

  • Answered by AI
  • Q2. Tell me something about youself
  • Ans. 

    I am a highly motivated and experienced project engineer with a strong background in managing complex engineering projects.

    • I have a Bachelor's degree in Engineering and have been working as a project engineer for the past 5 years.

    • I have successfully managed multiple projects from conception to completion, ensuring they are delivered on time and within budget.

    • I have a proven track record of effectively coordinating with...

  • Answered by AI
  • Q3. About the company
  • Q4. Who is the present CEO
  • Ans. 

    The present CEO is John Smith.

    • John Smith is the current CEO of the company.

    • He has been in this position since 2015.

    • Under his leadership, the company has experienced significant growth and expansion.

    • John Smith has a strong background in engineering and project management.

    • He is known for his strategic vision and ability to drive innovation.

  • Answered by AI
  • Q5. Extra-acads related questions
  • Q6. Coding related questions(only if your CV shows you are a coding studd)
  • Q7. Situation based questions

Interview Preparation Tips

Round: Interview
Experience: Its not an elimination round, you can go with your informal clothes on. Any one who has prepared for day 1 and day2 companies will get through this round. Just read news papers and learn to shoot graphs here and there even if it has got absolutely no facts and definitely practice to write a lot.
Tips: Be prepared with both for and against the topic coz the interviewer keeps changing the topic in between the GD.The topic was same as that of the case study Don’t write bullet-ed points, this makes your cases look small. Try applying your vocabulary spectrum. Try to give exhibits even if you don’t know any facts.

Round: Group Discussion
Experience: 12 students on the table, one interviewer.
Tips: Play old school .But don’t wait for your chance, just break into it, but with a gentlemanly attitude. Try giving examples. Throw arbitrary facts to prove your points, if you don’t remember the real figures.

Round: Interview
Tips: Don’t start with your brilliancein your core subject. Tell them you hate your department. Convince them that you won’t ditch them for a Ph.D or an MBA. Tell them you have a friend at Wipro who keeps giving you intel about how great the company is. Look confident and if at times you can be funny, they will appreciate it!!

Skill Tips: 8 and above CGPA is required. Later it was lowered to 7.9, mine was 7.98. They mainly ask HR questions, so being involved in Extra-academic activities gives you more that you can talk of. I had an eye for coding in C++. Helped me on this, but my extra-academics list was enough. Coding was just a bonus. If they are non core its better. But my both the internships were core based. You just have to convince them why you are dropping from core.
College Name: IIT KHARAGPUR

Norstella Interview FAQs

How many rounds are there in Norstella interview?
Norstella interview process usually has 1-2 rounds. The most common rounds in the Norstella interview process are Technical, One-on-one Round and HR.
How to prepare for Norstella 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 Norstella. The most common topics and skills that interviewers at Norstella expect are Assembly, Troubleshooting, Machine Learning, PL and Pharmacy.
What are the top questions asked in Norstella interview?

Some of the top questions asked at the Norstella interview -

  1. How did you implemented data pipeline from scrat...read more
  2. Data mining using api. Data validation and cleaning. SQL questions on top 5 mon...read more
  3. What is python, string operation, scenario based questi...read more

Tell us how to improve this page.

Norstella Interview Process

based on 4 interviews

Interview experience

1.8
  
Bad
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Infosys Interview Questions
3.7
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
View all

Norstella Reviews and Ratings

based on 6 reviews

4.2/5

Rating in categories

4.0

Skill development

4.2

Work-life balance

3.8

Salary

3.8

Job security

4.5

Company culture

3.8

Promotions

3.8

Work satisfaction

Explore 6 Reviews and Ratings
Software Developer
4 salaries
unlock blur

₹8 L/yr - ₹16 L/yr

Financial Analyst
4 salaries
unlock blur

₹4 L/yr - ₹4.8 L/yr

Senior Software Developer
4 salaries
unlock blur

₹16 L/yr - ₹36.1 L/yr

Technology Specialist
4 salaries
unlock blur

₹36.4 L/yr - ₹47 L/yr

Associate
3 salaries
unlock blur

₹4 L/yr - ₹4.3 L/yr

Explore more salaries
Compare Norstella with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

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