Upload Button Icon Add office photos

Filter interviews by

Pyrotek India IT Analyst Interview Questions and Answers

Updated 11 May 2022

Pyrotek India IT Analyst Interview Experiences

1 interview found

IT Analyst Interview Questions & Answers

user image Anonymous

posted on 11 May 2022

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is SQL and what is oracle?
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases. Oracle is a relational database management system.

    • SQL stands for Structured Query Language

    • It is used to manage and manipulate data in relational databases

    • Oracle is a popular relational database management system

    • It is used to store and manage large amounts of data

    • Oracle uses SQL as its primary programming language

  • Answered by AI
  • Q2. What is relational database management?
  • Ans. 

    Relational database management is the process of organizing and managing data stored in a relational database.

    • It involves creating tables to store data in a structured manner

    • Defining relationships between tables using keys

    • Manipulating data using SQL queries

    • Ensuring data integrity and security

    • Examples of relational database management systems include MySQL, Oracle, and Microsoft SQL Server

  • Answered by AI
  • Q3. What is 4G language?
  • Ans. 

    4GL is a high-level programming language designed for database management and application development.

    • 4GL stands for Fourth Generation Language

    • It is used for developing database applications

    • Examples include SQL, Oracle Forms, PowerBuilder, etc.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I want to learn neatly as SQL for better future.

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: TECHNICAL ROUND TEST
Experience: A 45 mins round which consisted of 30 mins of core questions and 15 mins of data structures.  It was a mix of test on our knowledge .

Round: HR Interview
Experience: Most of the questions were based on general knowledge and many of them were from the resume provides by me

General Tips: It is always advisable to be prepared with certain set of general questions which make it easier to answer.
Skill Tips: Focus on your Study.. Revise the subject that you have studied at the time of Interview
Skills: Technical Skills
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: Questions were on Aptitude, English, Probability, Permutations andCombinations and Programming (C, C++). NO Group Discussion was held.Candidates were shortlisted on the basis of their test scores.

Round: Technical Interview
Experience: Total time of this round was 45 minutes.First 30 minutes, questions on core programming were asked and in the remaining 15 minutes questions were asked on data structures.

Round: HR Interview
Experience: This was a 5 minute round where questions were put up, some based on the resume and other were general questions.

Skills: Knowledge in MATLAB.
College Name: IIT MADRAS

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

Interview Questionnaire 

1 Question

  • Q1. Completely in the resume and mostly depends upon the hr

Interview Preparation Tips

Interview preparation tips for other job seekers - Study coding and your department related stuff
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between list and tuple?
  • Ans. 

    List is mutable, tuple is immutable in Python.

    • List can be modified after creation, tuple cannot.

    • List is defined using square brackets [], tuple using parentheses ().

    • Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Salary negotaiations

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Write Query
  • Ans. 

    Write a query

    • Specify the database and table name

    • List the columns to be selected

    • Add any conditions or filters

    • Specify the order of results

  • Answered by AI
  • Q2. Update query

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Describe yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - good company
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Code to reverse the string
  • Ans. 

    Code to reverse a string in an array

    • Iterate through each string in the array

    • Use a loop to reverse each string character by character

    • Store the reversed string in a new array

  • Answered by AI
  • Q2. Example of inheritance
Round 2 - HR 

(2 Questions)

  • Q1. How to manage time
  • Ans. 

    Time management involves setting priorities, creating a schedule, eliminating distractions, and staying organized.

    • Set clear goals and prioritize tasks based on importance and deadlines

    • Create a daily or weekly schedule to allocate time for each task

    • Eliminate distractions such as social media, emails, or unnecessary meetings

    • Use tools like calendars, to-do lists, and time tracking apps to stay organized

    • Delegate tasks when...

  • Answered by AI
  • Q2. Salary expectation

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Mar 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 - Technical 

(1 Question)

  • Q1. MVC architecture, SQL
Round 3 - Behavioral 

(1 Question)

  • Q1. Project works, process handling
Round 4 - HR 

(1 Question)

  • Q1. Salary discuss and location

Interview Preparation Tips

Interview preparation tips for other job seekers - study hard and keep concept ready

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

Interview Questionnaire 

1 Question

  • Q1. In resume about our stream of study

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the resume complete ly and your stream of study

Pyrotek India Interview FAQs

How many rounds are there in Pyrotek India IT Analyst interview?
Pyrotek India interview process usually has 1 rounds. The most common rounds in the Pyrotek India interview process are One-on-one Round.
What are the top questions asked in Pyrotek India IT Analyst interview?

Some of the top questions asked at the Pyrotek India IT Analyst interview -

  1. What is SQL and what is orac...read more
  2. What is relational database manageme...read more
  3. What is 4G langua...read more

Tell us how to improve this page.

Executive Accountant
8 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Assistant Manager
7 salaries
unlock blur

₹6.4 L/yr - ₹13.7 L/yr

Design Engineer
7 salaries
unlock blur

₹2.1 L/yr - ₹6.3 L/yr

Quality Engineer
6 salaries
unlock blur

₹4.6 L/yr - ₹6.4 L/yr

Windows Vmware Administrator
5 salaries
unlock blur

₹8.5 L/yr - ₹9 L/yr

Explore more salaries
Compare Pyrotek India with

Reliance Communications

4.0
Compare

Henry Harvin Education

3.7
Compare

GAO Tek

4.4
Compare

Tata Teleservices

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