Upload Button Icon Add office photos
Engaged Employer

i

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

Celestial Systems Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Celestial Systems IT Infrastructure Lead Interview Questions, Process, and Tips

Updated 1 Nov 2023

Celestial Systems IT Infrastructure Lead Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. How would you boot a system without a HDD?
  • Ans. 

    You can boot a system without a HDD by using a live CD/USB or network booting.

    • Use a live CD/USB with an operating system to boot the system.

    • Set up network booting using PXE (Preboot Execution Environment) to boot the system over the network.

    • Utilize a bootable external drive or USB to boot the system.

  • Answered by AI
  • Q2. What is DNAT and what is the use of it?
  • Ans. 

    DNAT stands for Destination Network Address Translation. It is used to change the destination IP address of packets in a network.

    • DNAT is commonly used in network address translation (NAT) to redirect incoming packets to a different destination IP address.

    • It is often used in scenarios where a public IP address needs to be translated to a private IP address within a network.

    • DNAT can be used to forward traffic from a spec...

  • Answered by AI
  • Q3. What are the data types in python?
  • Ans. 

    Python data types include integers, floats, strings, lists, tuples, dictionaries, and sets.

    • Integers: whole numbers without decimal points (e.g. 5, -10)

    • Floats: numbers with decimal points (e.g. 3.14, -0.5)

    • Strings: sequences of characters enclosed in quotes (e.g. 'hello', '123')

    • Lists: ordered collections of items (e.g. [1, 'apple', True])

    • Tuples: ordered, immutable collections of items (e.g. (1, 'banana', False))

    • Dictionar...

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

(1 Question)

  • Q1. Tell me about your experience
  • Ans. I explained my career track record with the achievements and the challenges I faced.
  • Answered by Sujith Arangan
Round 4 - One-on-one 

(4 Questions)

  • Q1. Tell me about yourself
  • Q2. Do you have experience on GCP?
  • Ans. 

    Yes, I have experience working on Google Cloud Platform (GCP).

    • Managed GCP resources such as Compute Engine, Cloud Storage, and BigQuery

    • Implemented infrastructure as code using Google Cloud Deployment Manager

    • Utilized GCP services for data analytics and machine learning projects

  • Answered by AI
  • Q3. How soon can you join?
  • Q4. I mentioned my notice period

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and be well prepared on the job role

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview before Apr 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 90 minutes
Round difficulty - Easy

It was on online objective test consisting of 4 sections: Aptitude, Technical MCQs, Code snippet based MCQs and Coding part.

  • Q1. 

    Valid Parentheses Problem Statement

    Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.

    Input:

    The first line contains an...
  • Ans. 

    The task is to determine if a given string of parentheses is balanced or not.

    • Iterate through the characters of the string and use a stack to keep track of opening parentheses.

    • When encountering an opening parenthesis, push it onto the stack. When encountering a closing parenthesis, check if it matches the top of the stack.

    • If the stack is empty at the end or there are unmatched parentheses, the string is not balanced.

    • Exa...

  • Answered by AI
  • Q2. 

    Palindrome Linked List Problem Statement

    Determine if a given singly linked list of integers is a palindrome. Return true if it is a palindrome, otherwise return false.

    Example:

    Input:
    1 -> 2 -> ...
  • Ans. 

    Check if a given singly linked list of integers is a palindrome.

    • Use two pointers to find the middle of the linked list.

    • Reverse the second half of the linked list.

    • Compare the first half with the reversed second half to determine if it is a palindrome.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This was a technical and managerial round. The interviewer gave me a situation where I am in testing team and I found that customer requirement was drop down list at a place but developer has used bullet selection, and is not ready to change it. How will you manage? I gave some good replies and he was convinced.

  • Q1. What is a virtual function?
  • Ans. 

    A virtual function is a function in a base class that is declared using the keyword 'virtual' and can be overridden by a function with the same signature in a derived class.

    • Virtual functions allow for dynamic polymorphism in object-oriented programming.

    • They are used to achieve runtime polymorphism by enabling late binding.

    • Virtual functions are declared in a base class and can be overridden in derived classes.

    • Example: v...

  • Answered by AI
  • Q2. Can you explain how to perform a level order traversal of a binary tree in spiral form?
  • Ans. 

    Level order traversal of a binary tree in spiral form involves alternating between left and right while traversing each level.

    • Start by pushing the root node into a queue.

    • While the queue is not empty, pop a node, print its value, and push its children into the queue.

    • For each level, alternate between popping nodes from the queue and printing their values from left to right or right to left.

    • Continue this process until all

  • Answered by AI
  • Q3. What are abstract classes in C++?
  • Ans. 

    Abstract classes in C++ are classes that cannot be instantiated and are designed to be base classes for other classes.

    • Abstract classes may contain pure virtual functions, making them incomplete and unable to be instantiated.

    • Derived classes must implement all pure virtual functions from the abstract class in order to be concrete classes.

    • Abstract classes can have non-virtual functions and member variables like regular cl...

  • Answered by AI
Round 3 - Face to Face 

(6 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This was also a technical round. He asked to optimize the code I wrote in coding round. Then he asked me a few puzzles and questions on OOPS, OS and DBMS.

  • Q1. Can you explain the ACID properties in the context of database management systems?
  • Ans. 

    ACID properties are a set of properties that guarantee the reliability of transactions in database management systems.

    • ACID stands for Atomicity, Consistency, Isolation, and Durability.

    • Atomicity ensures that either all operations in a transaction are completed successfully or none of them are.

    • Consistency ensures that the database remains in a consistent state before and after the transaction.

    • Isolation ensures that the e...

  • Answered by AI
  • Q2. What is the difference between paging and segmentation in operating systems?
  • Ans. 

    Paging and segmentation are memory management techniques in operating systems.

    • Paging divides physical memory into fixed-size blocks called pages, while segmentation divides logical memory into variable-size segments.

    • Paging allows for efficient memory allocation and management, while segmentation provides protection and sharing of memory.

    • Paging is simpler to implement but can lead to internal fragmentation, while segmen...

  • Answered by AI
  • Q3. What is concurrency control?
  • Ans. 

    Concurrency control is a technique used in databases to manage simultaneous access and modification of data by multiple users or processes.

    • Concurrency control ensures that transactions are executed in a way that maintains data consistency and integrity.

    • Techniques like locking, timestamp ordering, and optimistic concurrency control are used to implement concurrency control.

    • For example, in a banking system, concurrency c...

  • Answered by AI
  • Q4. What is the difference between String Buffer and String Builder in Java?
  • Ans. 

    String Buffer is synchronized and thread-safe, while String Builder is not synchronized and faster.

    • String Buffer is synchronized, making it thread-safe for use in multi-threaded environments.

    • String Builder is not synchronized, resulting in faster performance but not thread-safe.

    • String Builder is preferred for single-threaded operations, while String Buffer is preferred for multi-threaded operations.

  • Answered by AI
  • Q5. What are smart pointers in C++?
  • Ans. 

    Smart pointers in C++ are objects that act like pointers but provide automatic memory management.

    • Smart pointers help prevent memory leaks by automatically managing memory allocation and deallocation.

    • Examples include unique_ptr, shared_ptr, and weak_ptr.

    • unique_ptr is used for exclusive ownership, shared_ptr for shared ownership, and weak_ptr to prevent circular references.

  • Answered by AI
  • Q6. What is the difference between a mutex and a semaphore?
  • Ans. 

    Mutex is used for exclusive access to a resource, while semaphore is used for controlling access to a resource by multiple threads.

    • Mutex is binary and allows only one thread to access the resource at a time.

    • Semaphore can have a count greater than one, allowing multiple threads to access the resource simultaneously.

    • Mutex is typically used for protecting critical sections of code, while semaphore is used for synchronizat...

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAYodlee interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Write a program for snake traversal of binary tree
  • Ans. 

    Program for snake traversal of binary tree

    • Use a stack to keep track of nodes to be visited

    • Start with the root node and push it onto the stack

    • While the stack is not empty, pop a node and print its value

    • If the level is even, push the left child first and then the right child onto the stack

    • If the level is odd, push the right child first and then the left child onto the stack

  • Answered by AI
  • Q2. To write code to check linked list is palindrome or not, in a single traversal and without using any other data structure
  • Ans. 

    Code to check if linked list is palindrome without using any other data structure and in a single traversal.

    • Traverse the linked list using two pointers, one slow and one fast

    • Reverse the first half of the linked list while traversing

    • Compare the reversed first half with the second half of the linked list

  • Answered by AI
  • Q3. Asked about OOPS concepts like abstraction, encapsulation, inheritance and polymorphism in detail and how they are implemented while programming

Interview Preparation Tips

Round: Test
Experience: It was on online objective test consisting of 4 sections: Aptitude, Technical MCQs, Code snippet based MCQs and Coding part.
Coding part had questions like balanced parenthesis check, etc.


Round: Technical Interview
Experience: Technical and managerial. Gave me a situation where I am in testing team and I found that customer requirement was drop down list at a place but developer has used bullet selection, and is not ready to change it. How will you manage? I gave some good replies and he was convinced.
Then he asked 25 horses puzzle (-----.php/puzzles/25-horses-3-fastest-5-races-puzzle/). I solved it.
He then asked me to code it. I wrote an algorithm first and then the code. He was very impressed.
He asked about virtual functions, abstract classes, pure virtual functions.


Round: Technical Interview
Experience: He asked to optimize the code I wrote in coding round.
Then he asked me candle puzzle on how to measure 30 min and 45 min.
Then he asked me the chocolate puzzle (-----.html).
What is paging and segmentation?
What are ACID properties in DBMS?
What is transaction and how is concurrency control done?
What is the difference between string builder and string buffer?
What is string pool in java?
What is JVM, JRE, JDK?
Differentiate between mutex and semaphore?
Can you override private and static members?
Contiguous and non-contiguous memory allocation?
What are Smart pointers?


Skills:
College Name: NIT Jalandhar

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: PAPER DURATION: 3 hours
NO. OF QUESTIONS: 2 (20 marks each)
MAXIMUM MARKS: 20*2 = 40 marksQUESTION 1:
JSON Prettier:-Write a program which takes JSON as input and gives prettified JSONYou need to read JSON from STDIN. Input gives one line of uglified JSON.Output should be formatted JSON. Check the standard output link.Use 2 white spaces (not‘\t’) for one indentation.SAMPLE INPUT:{“group” : {list : [1,2,3]}, “list” : [“a”,”b”,”c”]}SAMPLE OUTPUT:{“group” : {List : [1,2,3]},“list” : [“a”,”b”,”c”]}EXPLANATION: Input will be uglifiedjson in one line and output will be prettified format of that. QUESTION 2:XML parse plus series computationEvaluate an expression given in XML format. Keys will be Expr- contains the entire expression. Elem – contains the digit, sum, Prod- contains two or more keys whose evaluation needs to be summed or multiplied respectively. Sub will contain 2 keys or more, where the second key onwards will have to be subtracted from the first one. Div- will contain 2 keys in which first key will need to be divided by second. SAMPLE INPUT:4673 SAMPLE OUTPUT:
20EXPLANATION:Input will be xml file through standard input. End of xml file marked by .
Duration: 180 minutes
Total Questions: 2

College Name: NA

I applied via Naukri.com and was interviewed in Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Be transparent and real. Don't bluff :)
Fingent has got a good number of people in the interview panel(my personal experience)
Even if you do not know the answer, the panel will explain it to you.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 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 

Chrome and Firefox Browser automation

Round 3 - Assignment 

Log file tail last n lines where n is configurable. Followup question on how you can optimize it further incase log file size is in TBs and incase it is cluster of servers

Round 4 - Technical 

(4 Questions)

  • Q1. Detailed Technical background check and discussion on past projects.
  • Q2. Messaging queue and best practices
  • Ans. 

    Messaging queues are used to manage asynchronous communication between different components of a system.

    • Use a reliable messaging queue system like RabbitMQ or Apache Kafka

    • Ensure messages are properly formatted and serialized

    • Implement message acknowledgement and retry mechanisms

    • Monitor queue health and performance

    • Consider message ordering and partitioning for scalability

    • Avoid long-running tasks in message handlers

  • Answered by AI
  • Q3. Binary Search Tree twisted question
  • Q4. Map Reduce concept for solving dictionary keywords
  • Ans. 

    MapReduce is a programming model for processing large data sets in parallel.

    • MapReduce divides the input data into chunks and processes them in parallel.

    • It consists of two phases: Map and Reduce.

    • Map function takes input data and converts it into key-value pairs.

    • Reduce function takes the output of Map as input and combines the values with the same key.

    • It is used for solving dictionary keywords by mapping each word to a k

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on above 2 rounds, they seem to keep their round formats same

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Jun 2022. 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 - Coding Test 

Coding test was taken on hackerearcth pkatform there was a generic problem statement based on networking no need to pass minimum half of the test cases to clear the interview round

Round 3 - One-on-one 

(3 Questions)

  • Q1. The next round was one on one round in this questions were mainly asked regarding the experience and then they were mainly focussing on the developers who know rails and python
  • Q2. Python and rails were majorly needed to clear the roeund
  • Q3. Problem statement can be founded on geeks for geeks

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to clear your basiscs and after that just read all interview experienced available on geeks for geeks regarding that, and best of luck you can do it
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Normal 3 leetcode medium questions

Round 2 - Assignment 

Machine coding round to design tail -f

Round 3 - One-on-one 

(2 Questions)

  • Q1. Questions on internal working of os
  • Q2. Questions on projects
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Coding Test 

MCQ based Questions from topics of DSA , web development

Round 2 - Asked to live code a unix comman 

(1 Question)

  • Q1. Asked us to live code tail -f unix command
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Machine coding round

Round 2 - Technical 

(2 Questions)

  • Q1. TCP/IP related questions, what happens when you search a webpage?
  • Q2. Past projects discussions
Round 3 - HR 

(1 Question)

  • Q1. Behavioural questions on how would you tackle a particular scenario

Celestial Systems Interview FAQs

How many rounds are there in Celestial Systems IT Infrastructure Lead interview?
Celestial Systems interview process usually has 4 rounds. The most common rounds in the Celestial Systems interview process are One-on-one Round and Resume Shortlist.
What are the top questions asked in Celestial Systems IT Infrastructure Lead interview?

Some of the top questions asked at the Celestial Systems IT Infrastructure Lead interview -

  1. How would you boot a system without a H...read more
  2. What is DNAT and what is the use of ...read more
  3. What are the data types in pyth...read more

Tell us how to improve this page.

Celestial Systems IT Infrastructure Lead Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

BrowserStack Interview Questions
3.6
 • 49 Interviews
Backbase Interview Questions
3.7
 • 22 Interviews
Fingent Interview Questions
4.4
 • 22 Interviews
3Pillar Global Interview Questions
3.3
 • 19 Interviews
Khoros Interview Questions
3.7
 • 19 Interviews
Mentor Graphics Interview Questions
4.0
 • 18 Interviews
Yodlee Interview Questions
3.8
 • 17 Interviews
Bottomline Interview Questions
3.3
 • 17 Interviews
ValGenesis Interview Questions
3.2
 • 17 Interviews
View all
Software Engineer
65 salaries
unlock blur

₹5 L/yr - ₹13.9 L/yr

Senior Software Engineer
48 salaries
unlock blur

₹12 L/yr - ₹21.6 L/yr

Softwaretest Engineer
24 salaries
unlock blur

₹3.6 L/yr - ₹9 L/yr

Devops Engineer
14 salaries
unlock blur

₹8.1 L/yr - ₹16 L/yr

Technical Lead
11 salaries
unlock blur

₹17 L/yr - ₹25.6 L/yr

Explore more salaries
Compare Celestial Systems with

Yodlee

3.8
Compare

Fingent

4.4
Compare

Bravura Solutions

3.9
Compare

CloudMoyo

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