Upload Button Icon Add office photos

Filter interviews by

Celigo Junior Software Developer Interview Questions and Answers

Updated 15 May 2021

Celigo Junior Software Developer Interview Experiences

1 interview found

I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Project details, questions based on the resume and they will ask to write some java programs

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and try to answer which you know about.it is not mandatory to answer each and every question if even if you don't know.All the best

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: Round 1: Online objective test.
There were questions from Operating Systems, C, Algorithms, Data Structures.

Round 2: Online and subjective (choose language C++ or JAVA). This round had 15 questions.
Data structures, C++ questions, Fibonacci optimisation, algorithms (DFS/BFS).

Round: Technical Interview
Experience: In the first round of interview they asked me questions about :1) My project (asked no. of classes and mention their responsibilities).
2) ACID properties of database and indexing in a database.

There were also questions related to OOPS concepts including polymorphism, composition, aggregation, inheritance, Abstract classes, interface; difference between usage of abstract class and interface, can abstract class be instantiated, how to access child class methods having reference of base class.
There was another question on run time and compile time binding and under which category do we classify method overloading and also questions on code for deleting the duplicate nodes in a sorted link list and printing root to leaf paths in a binary search tree.

Round: Technical Interview
Experience: This was the second round of the interview. They asked me the following questions,There is a tree (not binary) and all non-leaf nodes are RED in colour. Some leaf nodes are white in colour. If a node has all white coloured children then its colour can be changed into white. So we have to convert maximum number of nodes into white colour – write program for the same.
Code for checking whether a given binary tree balanced or not.
What are virtual functions, what is their role?
Questions related to virtual functions.

You are given the details of each transaction of each item i.e. item_name, quantity, price. So at the end of the day, you want top 50 items that have been sold. There are two cases:
In the first case you have fixed number of items.
In the second case very large number of items – so you need to decide what data structure to be used for this.

Round: Technical Interview
Experience: In the third round of the interview they asked questions like :
1) Types of tree traversals (breadth first and depth first (pre, post, in)
2) Determining width of binary tree i.e. using breadth wise traversal
3) Why files are preferred over databases?

College Name: IIT KANPUR

Interview Questionnaire 

11 Questions

  • Q1. Asked about my project? Also asked me questions about ACID properties of database and indexing in a database
  • Q2. There were also questions related to OOPS concepts including polymorphism, composition, aggregation, inheritance, Abstract classes, interface; difference between usage of abstract class and interface, can ...
  • Q3. There was another question on run time and compile time binding and under which category do we classify method overloading
  • Q4. Code for deleting the duplicate nodes in a sorted link list?
  • Ans. 

    Code to delete duplicate nodes in a sorted linked list

    • Traverse the linked list and compare adjacent nodes

    • If nodes are equal, delete one of them

    • Repeat until all duplicates are removed

  • Answered by AI
  • Q5. Printing root to leaf paths in a binary search tree
  • Ans. 

    Printing all root to leaf paths in a binary search tree

    • Traverse the tree recursively and keep track of the current path

    • When a leaf node is reached, add the current path to the list of paths

    • Print all the paths in the list

    • Use an array of strings to store the paths

  • Answered by AI
  • Q6. Given an Array of Integers, Find two elements in the array whose sum is closest to zero?
  • Ans. 

    Find two integers in an array whose sum is closest to zero.

    • Sort the array in ascending order.

    • Initialize two pointers at the beginning and end of the array.

    • Move the pointers towards each other until the sum is closest to zero.

  • Answered by AI
  • Q7. What are virtual functions, what is their role? Questions related to virtual functions?
  • Q8. You are given the details of each transaction of each item i.e. item_name, quantity, price. So at the end of the day, you want top 50 items that have been sold. There are two cases: - In the first case you...
  • Q9. How do you quickly count the number of set bits in a 32-bit integer in linear time (with respect to the number of set bits)?
  • Ans. 

    Count set bits in a 32-bit integer in linear time

    • Use bit manipulation to count set bits

    • Divide the integer into 16-bit chunks and count set bits in each chunk

    • Use lookup tables to count set bits in each 8-bit chunk

    • Use parallel processing to count set bits in multiple integers simultaneously

  • Answered by AI
  • Q10. Determining width of binary tree i.e. using breadth wise traversal
  • Ans. 

    To determine the width of a binary tree using breadth-wise traversal, we need to count the number of nodes at each level.

    • Perform a breadth-first traversal of the binary tree

    • Count the number of nodes at each level

    • Keep track of the maximum number of nodes seen at any level

    • Return the maximum number of nodes seen

  • Answered by AI
  • Q11. Why files are preferred over databases?
  • Ans. 

    Files are preferred over databases for certain types of data and applications.

    • Files are faster for small amounts of data.

    • Files are easier to manage and backup.

    • Files are more flexible for certain types of data, such as images or videos.

    • Databases are better for complex data relationships and queries.

    • Databases are more secure and scalable for large amounts of data.

    • The choice between files and databases depends on the spec

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: There were questions from Operating Systems, C, Algorithms, Data Structures

Round: Test
Experience: This round had 15 questions.Data structures, C++ questions, algorithms (DFS/BFS)

Skills: java, OOP, Algorithm
College Name: IIT KANPUR

Skills evaluated in this interview

I applied via Referral

Interview Questionnaire 

6 Questions

  • Q1. Your contribution in your projects?
  • Ans. 

    I have contributed to my projects by developing and implementing new features, fixing bugs, and improving overall performance.

    • Developed and implemented new features

    • Fixed bugs and issues

    • Improved overall performance

    • Collaborated with team members to ensure project success

    • Provided technical support and troubleshooting assistance

  • Answered by AI
  • Q2. How you resolve problems within team?
  • Ans. 

    I encourage open communication and collaboration to identify and solve problems within the team.

    • Encourage open communication and active listening

    • Identify the root cause of the problem

    • Brainstorm solutions as a team

    • Assign tasks and follow up on progress

    • Evaluate the effectiveness of the solution

    • Provide constructive feedback

    • Celebrate successes and learn from failures

  • Answered by AI
  • Q3. What are your expectations from the company?
  • Ans. 

    I expect a company that values innovation, growth opportunities, and work-life balance.

    • Opportunities for professional development and growth

    • A culture that encourages innovation and creativity

    • A healthy work-life balance

    • Clear communication and transparency

    • Competitive compensation and benefits

    • Collaborative and supportive team environment

  • Answered by AI
  • Q4. Do you have any plans of higher studies?
  • Ans. 

    Yes, I am planning to pursue a Master's degree in Computer Science.

    • I am interested in specializing in Artificial Intelligence.

    • I have already researched and shortlisted a few universities.

    • I plan to apply for the next academic year.

    • I believe higher studies will help me gain a deeper understanding of the field and advance my career.

  • Answered by AI
  • Q5. How flexible you are in professional life?
  • Ans. 

    I am very flexible in my professional life and can adapt to changing situations easily.

    • I am open to learning new technologies and skills

    • I can work in different environments and with different teams

    • I am willing to take on new challenges and responsibilities

    • I can adjust my work schedule to meet project deadlines

    • I am comfortable with remote work and flexible work arrangements

  • Answered by AI
  • Q6. Tell me about your self?
  • Ans. 

    I am a software engineer with experience in developing web applications and a passion for problem-solving.

    • Experienced in developing web applications using languages such as Java, Python, and JavaScript

    • Proficient in using frameworks such as Spring, Django, and React

    • Strong problem-solving skills and ability to work in a team environment

    • Passionate about learning new technologies and keeping up with industry trends

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 55 questions in 60 minutes of which 45 were technical and 10 were aptitude questions and there was no negative marking. The technical questions covered RDBMS, UNIX, C, C++, Java, Operating systems, Data structures and Algorithms. The questions were simple and the basics of each of the mentioned subjects were mainly asked.
Duration: 60 minutes
Total Questions: 55

Round: Test
Experience: Again mainly questions on the subjects covered in round 1 but bit more in deep questions required short but detailed answers.
Tips: Learn to write pretty good Unix Scripts and Know the Basics of Operating System & OOP
Duration: 40 minutes
Total Questions: 10

Round: Technical Interview
Experience: Questions mainly on UNIX & RDBMS. Interviewer will ask you to write UNIX scripts and SQL/JAVA-SQL queries/programs for some use cases.
Tips: Know how JOINS, INTERSECTION, UNION & Aggregation works in SQL.

Round: Technical Interview
Experience: Questions on Programming, Data Structure and algorithms.
You will be asked to write pseudo-program for some of the use cases.
Tips: Choose your programming language cleverly. ;)

Round: Other Interview
Experience: Round 5 is an interview with Technical Manager.
Questions are asked based on the content of your resume like projects, hobbies and traits.
Few puzzle questions are asked which usually can be answered with logical analysis.
Tips: Be prepared for questions on the answer you give for the previous question(s).

Round: HR Interview
Experience: Again question will be asked on the basis of your resume. Questions may also asked on your previous interview experience if you have any.
Tips: Clear your doubts before leaving the room.

General Tips: Be confident, be straight forward, do not try to bluff with answers and try to be creative with answers. Prepare well both technical and aptitude.
Skills: Algorithms And Data Structures, Operating Systems, Unix, SQL, Java Programming, Object-Oriented Programming (OOP), C Programming
College Name: JSS Mahavidyapeetha Sri Jayachamarajendra College Of Engineering, Mysore
Motivation: Work Environment of Informatica.

Interview Questionnaire 

15 Questions

  • Q1. Find Minimum and Maximum of an array in only one traversal
  • Ans. 

    Find the minimum and maximum values in an array in a single traversal.

    • Initialize min and max variables with the first element of the array

    • Iterate through the array and update min and max if a smaller or larger value is found

    • Return the min and max values

  • Answered by AI
  • Q2. Given a chessboard find the maximum number of squares present?
  • Ans. 

    The maximum number of squares on a chessboard is 64.

    • The chessboard has 64 squares in total.

    • The number of squares on a chessboard can be calculated using the formula n^2, where n is the number of rows or columns.

    • In this case, n = 8 (8 rows and 8 columns), so the maximum number of squares is 8^2 = 64.

  • Answered by AI
  • Q3. What is C++? Difference between deep and shallow copy?
  • Ans. 

    C++ is a programming language. Deep copy creates a new object and copies all values, while shallow copy creates a reference to the original object.

    • C++ is a general-purpose programming language

    • Deep copy creates a new object with its own copy of the data

    • Shallow copy creates a reference to the original object

    • Deep copy is safer but can be slower and consume more memory

    • Shallow copy is faster but can lead to unexpected behav

  • Answered by AI
  • Q4. What is pre initialization ?
  • Ans. 

    Pre initialization refers to the process of initializing variables or objects before they are used in a program.

    • Pre initialization helps avoid errors or unexpected behavior caused by using uninitialized variables.

    • It is a good practice to pre initialize variables with default values.

    • Pre initialization can be done using constructors, default values, or initialization blocks.

    • Example: int count = 0; initializes the variabl

  • Answered by AI
  • Q5. Reverse a linked list with and without using Recursion
  • Ans. 

    Reverse a linked list with and without using Recursion

    • Iterative approach: Use three pointers to reverse the links between nodes

    • Recursive approach: Recursively reverse the rest of the list and then fix the links

  • Answered by AI
  • Q6. Copy constructor?
  • Q7. Different types of polymorphism, the diamond problem, and how can it be avoided?
  • Ans. 

    Polymorphism refers to the ability of an object to take on many forms. The diamond problem occurs in multiple inheritance.

    • Polymorphism can be achieved through method overloading and method overriding.

    • Method overloading allows multiple methods with the same name but different parameters.

    • Method overriding occurs when a subclass provides a specific implementation of a method already defined in its superclass.

    • The diamond p...

  • Answered by AI
  • Q8. Questions about Virtual
  • Q9. Template classes
  • Q10. Write a program for an operator(=) such that it behaves differently for integer and character
  • Ans. 

    The program should differentiate between integers and characters when using the assignment operator (=).

    • Check the data type of the variable before assigning a value.

    • Use conditional statements to perform different actions based on the data type.

    • For integers, assign the value directly. For characters, convert the character to its ASCII value and assign it.

  • Answered by AI
  • Q11. Given an array, sort the zeroes from non zeros for example Input: 1 2 0 0 7 4 42 0 0 0 6 Output: 1 2 7 4 42 6 0 0 0 0 0
  • Ans. 

    Sort an array by moving all zeroes to the end.

    • Iterate through the array and move all non-zero elements to the front.

    • Count the number of zeroes encountered and append them at the end of the array.

    • Use two pointers to swap elements and maintain the order.

  • Answered by AI
  • Q12. Class hierarchy, List the number of VTables created
  • Ans. 

    The number of VTables created in a class hierarchy depends on the number of virtual functions and the number of derived classes.

    • VTables are used in object-oriented programming languages to implement dynamic dispatch.

    • Each class with at least one virtual function has its own VTable.

    • Derived classes inherit the VTable of their base class and add their own entries for any additional virtual functions.

    • The total number of VTa...

  • Answered by AI
  • Q13. When to use List and Vector of Standard Template Library ?
  • Ans. 

    List is preferred when frequent insertion and deletion is required. Vector is preferred when random access is required.

    • List is implemented as a doubly-linked list, allowing for efficient insertion and deletion at any position.

    • Vector is implemented as a dynamic array, allowing for efficient random access.

    • Use List when the number of elements is expected to change frequently and the order of elements matters less.

    • Use Vect...

  • Answered by AI
  • Q14. Given a string “I LOVE CODING”, print “CODING LOVE I”
  • Ans. 

    The given string needs to be reversed and the words need to be rearranged.

    • Split the string into an array of words

    • Reverse the array

    • Join the array elements with a space in between

  • Answered by AI
  • Q15. Questions about weakness and strengths

Interview Preparation Tips

Round: HR Interview
Experience: He asked me how should I weigh Howrah bridge and asked to give any answer I like, normal or wacky. My answer was very normal so I not gonna write that.
And then questions about my weakness and strength, my previous company, reason to change etc.

Skills: c++, Algorithm
College Name: NIT DELHI

Skills evaluated in this interview

Interview Questionnaire 

18 Questions

  • Q1. Design a parking lot? Design should include -Logic Flow Diagram -E-R diagram (very important) -DB tables with relations between them, preferably normalized -Commands for transaction with tables
  • Ans. 

    Design a parking lot with Logic Flow Diagram, E-R diagram, DB tables with relations, and commands for transactions.

    • Identify the types of vehicles that will use the parking lot

    • Determine the number of parking spaces needed for each vehicle type

    • Create a flow diagram to show the process of entering and exiting the parking lot

    • Design an E-R diagram to show the relationships between entities such as vehicles, parking spaces, ...

  • Answered by AI
  • Q2. Find Min and Max of an array in only one traversal
  • Ans. 

    To find min and max of an array in one traversal, initialize min and max to first element and compare with rest.

    • Initialize min and max to first element of array

    • Traverse the array and compare each element with min and max

    • Update min and max accordingly

    • Return min and max

  • Answered by AI
  • Q3. Given a chessboard find maximum number of squares present
  • Ans. 

    Given a chessboard, find the maximum number of squares present.

    • Start with the smallest square and count all possible squares

    • Use the formula n*(n+1)*(2n+1)/6 to find the total number of squares in an n x n chessboard

    • Add up the squares of all sizes from 1 to n to get the maximum number of squares

    • For example, an 8 x 8 chessboard has 204 squares

  • Answered by AI
  • Q4. What is C++?
  • Ans. 

    C++ is a high-level programming language used for developing system software, application software, device drivers, and video games.

    • C++ was developed by Bjarne Stroustrup in 1983.

    • It is an extension of the C programming language.

    • C++ supports object-oriented programming, generic programming, and low-level memory manipulation.

    • It is used in developing operating systems, browsers, databases, and more.

    • Examples of popular sof...

  • Answered by AI
  • Q5. Difference between deep and shallow copy?
  • Ans. 

    Deep copy creates a new object with a new memory address, while shallow copy creates a new reference to the same memory address.

    • Deep copy duplicates the object and all its nested objects, while shallow copy only duplicates the top-level object.

    • Deep copy is slower and more memory-intensive than shallow copy.

    • Shallow copy can lead to unexpected behavior if the original object is modified.

    • In Python, deep copy can be achiev...

  • Answered by AI
  • Q6. Inheritance concepts, private/public/protected concepts?
  • Q7. Whats “preinitialization” View Answer
  • Ans. 

    Preinitialization is the process of initializing data or objects before they are actually needed.

    • Preinitialization can improve performance by reducing the time needed to initialize data or objects when they are actually needed.

    • It can also help to avoid delays or interruptions during runtime.

    • Examples of preinitialization include preloading data into memory, initializing objects in advance, and caching frequently used da

  • Answered by AI
  • Q8. Different versions of polymorphism, how to solve the problem of multiple inheritance
  • Ans. 

    Polymorphism can be achieved through method overloading, method overriding, and interfaces. Multiple inheritance can be solved using interfaces.

    • Method overloading allows multiple methods with the same name but different parameters

    • Method overriding allows a subclass to provide its own implementation of a method already defined in its superclass

    • Interfaces provide a way to achieve multiple inheritance by allowing a class ...

  • Answered by AI
  • Q9. Template classes, WAP operator= for template class such that it behaves differently for int and char *
  • Q10. Given a tree, WAP such that a matrix is generated so that: Tree: 1 / 2 3 | / 4 5 6 Matrix: 0 1 2 3 4 5 6 1 0 1 1 1 1 1 2 0 0 0 1 0 0 3 0 0 0 0 1 1 4 0 0 0 0 0 0 5 0 0 0 0 0 0 6 0 0 0 0 0 0
  • Ans. 

    WAP to generate a matrix from a given tree.

    • Create a 2D array to store the matrix

    • Traverse the tree and fill the matrix accordingly

    • Use BFS or DFS to traverse the tree

    • The matrix will be symmetric along the diagonal

  • Answered by AI
  • Q11. What is primary key? unique key?
  • Ans. 

    Primary key is a column or set of columns that uniquely identifies each row in a table. Unique key is a constraint that ensures uniqueness of values in a column or set of columns.

    • Primary key is used to enforce data integrity and ensure that each row in a table can be uniquely identified.

    • Unique key is used to ensure that no two rows in a table have the same values in a column or set of columns.

    • Primary key can be a singl...

  • Answered by AI
  • Q12. Can unique key be a primary key?
  • Ans. 

    Yes, a unique key can be a primary key.

    • A primary key is a unique identifier for a record in a table.

    • A unique key is a constraint that ensures the values in a column are unique.

    • A unique key can be used as a primary key if it meets the requirements.

    • A primary key cannot have NULL values, while a unique key can have one NULL value.

  • Answered by AI
  • Q13. What is foreign key? can foreign key be Null?
  • Ans. 

    Foreign key is a column in a table that refers to the primary key of another table.

    • It establishes a relationship between two tables.

    • It ensures referential integrity.

    • It can be null, but only if it is defined as nullable.

    • It helps in joining tables.

    • Example: Customer table has a foreign key to the Order table's primary key.

    • Example: Order table's foreign key can be null if the order has not been placed by any customer yet.

  • Answered by AI
  • Q14. What is normalization? why should we do normalization?
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a database into smaller, more manageable tables.

    • It helps to eliminate data redundancy and inconsistencies.

    • Normalization ensures that each table has a primary key and that data is stored in a logical and consistent manner.

    • It improves data integrity and reduces the likelihood ...

  • Answered by AI
  • Q15. Normalized form is better or storing in a single table/ 2 tables is better?
  • Ans. 

    Normalized form is better for data consistency and scalability.

    • Normalized form reduces data redundancy and ensures data consistency.

    • Normalized form allows for easier scalability and maintenance.

    • Single table/2 tables may be appropriate for small, simple datasets.

    • Normalized form may require more complex queries to retrieve data.

    • Normalized form may require more storage space due to additional tables.

    • Example: Normalized fo...

  • Answered by AI
  • Q16. Create database of IPL
  • Ans. 

    Create a database for Indian Premier League (IPL)

    • Identify entities like teams, players, matches, venues, etc.

    • Create tables for each entity with relevant attributes

    • Establish relationships between tables using foreign keys

    • Add constraints like unique, not null, default values, etc.

    • Populate tables with data from reliable sources

  • Answered by AI
  • Q17. Write a query to find name of a player with maximum number of runs in a match on given date and given venue
  • Ans. 

    Query to find player with maximum runs in a match on given date and venue

    • Use MAX() function to find maximum runs

    • Join tables for player name, match details and runs scored

    • Filter by given date and venue

    • Order by runs scored and limit to 1 result

  • Answered by AI
  • Q18. Ques about my weakness and strength, my previous company, reason to change etc

Interview Preparation Tips

General Tips: I applied through an employee referral. The process took a day – interviewed at SAP in February 2015.The interviewer had good work experience. She was polite and calm. After brief introduction she straight jumped into my current projects and she covered my entire CV.
Skills: Algorithm, C++
College Name: NA

Skills evaluated in this interview

Interview Questionnaire 

6 Questions

  • Q1. Questions mainly on C, OOPS concepts of C++, basic Java concepts, Data structures and puzzles (standard ones)
  • Q2. Questions about your Project.
  • Q3. Questions from the same topics as the previous round
  • Q4. Simple puzzle
  • Q5. Apart from technical questions a few HR questions were asked. For example: Why do you want to join this company?
  • Q6. Have you ever be in a situation where your task is not completed in time and you have to make quick decisions?

Interview Preparation Tips

Round: Test
Experience: Though Questions were all simple, time management was important
Total Questions: 1

Round: Technical Interview
Tips: If you perform well in this round then your chances of selection gets high

Skills: OOP, JAVA, Algorithm
College Name: NA

I was interviewed in Oct 2016.

Interview Questionnaire 

5 Questions

  • Q1. What is inheritance?
  • Ans. 

    Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.

    • Inheritance allows for code reuse and promotes modularity.

    • The class that is being inherited from is called the superclass or base class.

    • The class that inherits from the superclass is called the subclass or derived class.

    • The subclass can access the public and protected members of the superclass.

    • Inhe...

  • Answered by AI
  • Q2. Regular expressions in PhP
  • Ans. 

    Regular expressions in PHP are powerful tools for pattern matching and manipulating strings.

    • Regular expressions are defined using the preg_match() function in PHP.

    • They are used to search, replace, and validate strings based on specific patterns.

    • Regex patterns consist of a combination of characters and special symbols.

    • Modifiers can be added to the pattern to control the matching behavior.

    • Common regex functions in PHP in...

  • Answered by AI
  • Q3. What is polymorphism? Explain using a real life example
  • Ans. 

    Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.

    • Polymorphism allows a single interface to be used for different types of objects.

    • It enables code reusability and flexibility in object-oriented programming.

    • For example, a parent class 'Animal' can have multiple child classes like 'Dog', 'Cat', and 'Bird'. They can all be treated as 'Anim...

  • Answered by AI
  • Q4. Discussion about projects.
  • Q5. Aggregate functions in dbms? And query questions related to that.

Interview Preparation Tips

Round: Test
Experience: 10 questions of aptitude containing English paragraph solving , Maths aptitude and also logical reasoning. Other 3 questions were of programming in any language comfortable.Two of the questions were partially done.In one of them only the logic was to be coded and in the other the error was to be corrected to give the correct output.
Duration: 1 hour 20 minutes
Total Questions: 13

Round: Technical Interview
Experience: They test your basic knowledge of programming, databases and how well you have worked with your projects.
There are actually three more rounds. 2 technical and one HR. I was not selected for them. Out of 40 students only 5 were selected after the final round.

Skills: Basic C/C++, DBMS, Multiple And Multi-level Inheritance, Polymorphism, PHP, Regular Expressions
College Name: Thapar University, Patiala

Skills evaluated in this interview

I was interviewed in Dec 2016.

Interview Questionnaire 

8 Questions

  • Q1. Given a 10 digit number, sort the individual digits of the number.
  • Ans. 

    Sort the individual digits of a 10 digit number.

    • Convert the number to a string to access individual digits

    • Use a sorting algorithm to sort the digits

    • Convert the sorted digits back to a number

  • Answered by AI
  • Q2. Write code for LCA in Binary Search Tree.
  • Ans. 

    The code for finding the Lowest Common Ancestor (LCA) in a Binary Search Tree (BST).

    • Start from the root node and compare it with the given two nodes.

    • If both nodes are smaller than the current node, move to the left subtree.

    • If both nodes are greater than the current node, move to the right subtree.

    • If one node is smaller and the other is greater, then the current node is the LCA.

    • Continue this process until the LCA is fou

  • Answered by AI
  • Q3. Discuss a DBMS consisting of college faculty, professors, courses and students.
  • Ans. 

    A DBMS for managing college faculty, professors, courses, and students.

    • The DBMS should have tables for faculty, professors, courses, and students.

    • Each table should have appropriate attributes to store relevant information.

    • Relationships can be established between tables using foreign keys.

    • Queries can be used to retrieve information about faculty, professors, courses, and students.

    • The DBMS can be used to track enrollment

  • Answered by AI
  • Q4. What extra curricular activities did you do in college?
  • Ans. 

    I was actively involved in coding competitions, hackathons, and programming clubs during college.

    • Participated in coding competitions such as ACM ICPC and Codeforces

    • Attended hackathons to work on real-world projects and improve problem-solving skills

    • Joined programming clubs to collaborate with peers and learn new technologies

  • Answered by AI
  • Q5. Do you seek for help if stuck in a problem?
  • Ans. 

    Yes, I believe in seeking help when stuck in a problem as it leads to faster resolution and learning.

    • I believe in collaborating with team members to brainstorm solutions

    • I am not afraid to ask for help from more experienced developers

    • I utilize online resources like Stack Overflow or documentation when needed

  • Answered by AI
  • Q6. What do you understand by teamwork?
  • Ans. 

    Teamwork is collaborating with others towards a common goal, utilizing each member's strengths and skills.

    • Collaborating with others towards a common goal

    • Utilizing each member's strengths and skills

    • Communicating effectively and openly

    • Respecting and valuing diverse perspectives

    • Sharing responsibilities and supporting each other

    • Celebrating successes as a team

  • Answered by AI
  • Q7. How do you tackle something that you can't find a solution to?
  • Ans. 

    When faced with an unsolvable problem, I break it down, research, seek help, experiment, and iterate until a solution is found.

    • Break down the problem into smaller, manageable parts

    • Research and gather information related to the problem

    • Seek help from colleagues, online communities, or experts

    • Experiment with different approaches or solutions

    • Iterate and refine the solution based on feedback and results

  • Answered by AI
  • Q8. Where do you want to see yourself after 5 years?
  • Ans. 

    In 5 years, I see myself as a senior software developer leading a team of developers on innovative projects.

    • Leading a team of developers on innovative projects

    • Senior software developer role

    • Continuing to learn and grow in the field

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test had a time limit. Every 10 minutes you had to do atleast 4 questions. It was quite fast paced. The questions were from basic coding, aptitude and debugging.
Tips: Learn to be fast at coding. Study from geeksforgeeks.com. Practice a lot of aptitude questions. Have a decent knowledge of basic coding.
Duration: 1 hour
Total Questions: 20

Round: Technical Interview
Experience: The interviewer started off by asking basic sorting questions. Followed by data structures and algorithms. And DBMS related questions in the end.
Tips: Have a good presence of mind. Understand the question asked properly. Be confident and keep discussing. Don't get nervous and solve the questions incorrectly. Have good grip over topics like sorting, DS, Algorithms and DBMS.

Round: Managerial Interview
Experience: There was a discussion upon the company's work in fields like Big Data, IoT. They asked me in detail about the projects mentioned in my CV. Other skills mentioned in CV were also discussed.
Tips: Have a good understanding of the projects you have mentioned in your CV. Be polite and confident while answering. Keep a general awareness of the current technical scenario.

Round: HR Interview
Experience: The round was based around my over all personality. They checked how would I be an asset to their company. They analysed my core values and capabilities of working in a team.
Tips: Show that you are willing to work in a team. Be confident and polite. Express your feelings and passion towards your job and the company. Explain your college extra curricular activities well.

College Name: IIT Varanasi

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: 1 Psychometric Test
2. Analytical Aptitude
3 Logical Reasoning
4 Two coding Questions
5.Pattern Recognition
6.Essay writing

Tips: Do the coding Question first ,they are mot important ,if ur code doesn't run u are disqualified.
Practice on leetcode
Sectional Cutoff
Duration: 100 mins minutes
Total Questions: 103

Round: Test
Experience: Data base design of an ATM.E-R diagrams ,Class diagram and Normalization
Discussion on projects
A simple coding question
Heavy ball light ball puzzle
Cloud Computing
Public and Private Cloud
CRM ,SRM ,ERP
Asked me Floyd's Warshall Algo,told to implement it in a question
SQL queries





Round: Technical Interview
Experience: 1 asked me a puzzle man and bridge wid torch
2.asked me about TRIES
3.difference between primary key and unique key
4.asked to write query for nth highest salary
5.Asked me as sql injection
6. AES ,DES
7.Reverse a linked list


Round: Behavioural Interview
Experience: The interviewer was above 50.
1.Introduce yourself
2.why sap
3.situation based questions


Round: HR Interview
Experience: The lady was tough ...showed her intent in the PPT as well..
1.asked me about profile preference
2.about family
3.where would you see in next 2 years
4.why sap
5.nything about sap not mentioned in ppt(i was like null)
6.location preference


Skills:
College Name: NIT Srinagar

Tell us how to improve this page.

Interview Questions from Similar Companies

SAP Interview Questions
4.2
 • 309 Interviews
Innovaccer Interview Questions
3.4
 • 81 Interviews
NoBrokerHOOD Interview Questions
3.2
 • 57 Interviews
Vyapar Interview Questions
3.5
 • 53 Interviews
Classplus Interview Questions
3.4
 • 28 Interviews
Fleetx.io Interview Questions
3.7
 • 28 Interviews
View all
Software Engineer
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Engineer
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer2
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Celigo with

Zapier

2.0
Compare

Mulesoft

4.6
Compare

Talend Data Integration Services

4.0
Compare

Boomi

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