Infosys BPM MS SQL Server Database Administrator Interview Questions and Answers

Developed a Btech project on automated attendance system using facial recognition.

• Developed a software application to automate the attendance process in educational institutions.

• Implemented facial recognition technology to identify and mark attendance of students.

• Used machine learning algorithms to train the system for accurate recognition.

• Integrated the application with a database to store attendance records.

• Provided ...read more

Code Pascal's Triangle

• Pascal's Triangle is a triangular array of binomial coefficients

• Each number is the sum of the two numbers above it

• The first and last numbers in each row are 1

• Can be implemented using nested loops or recursion

An abstract function is a function that has no implementation and must be implemented by its subclasses.

• An abstract function is declared with the 'abstract' keyword.

• It is used to define a template for its subclasses to follow.

• It cannot be instantiated and must be implemented by its subclasses.

• It can have abstract and non-abstract methods.

• Example: abstract class Animal { abstract void makeSound(); }

• Example: class Dog ex...read more

Abstract functions cannot be instantiated and must be implemented by child classes, while normal functions can be directly called.

• Abstract functions have no implementation in the parent class, while normal functions do.

• Abstract functions are declared with the 'abstract' keyword, while normal functions are not.

• Normal functions can be called directly, while abstract functions must be implemented by child classes.

• An examp...read more

Perfectionism and public speaking anxiety

• I tend to be a perfectionist, which can sometimes lead to spending too much time on a task

• I struggle with public speaking anxiety, but I have been working on improving my communication skills through practice and training

Capgemini is a global leader in consulting, technology services, and digital transformation.

• Capgemini has a strong reputation in the industry for delivering high-quality software solutions.

• The company offers a wide range of opportunities for career growth and development.

• Capgemini has a collaborative and inclusive work culture that fosters innovation and teamwork.

• The company has a global presence, providing exposure to...read more

As a Senior Software Engineer, I worked with various tools and technologies to develop and maintain software applications.

• Developed and maintained software applications using Java, Python, and C++ programming languages

• Used Agile methodology for software development and collaborated with cross-functional teams

• Worked with various tools such as Git, JIRA, Jenkins, and Docker for version control, issue tracking, continuous...read more

The biggest challenge in developing Azure solution was managing the complexity of the cloud environment.

• Managing the complexity of the cloud environment

• Ensuring scalability and reliability

• Integrating with existing systems

• Securing the solution

• Optimizing cost

• Example: Migrating a legacy application to Azure

Implementing tumbling window in Azure Data Factory without using the feature

• Create a pipeline with a trigger that runs at the desired interval

• Use a lookup activity to retrieve the data for the current window

• Use a foreach activity to iterate over the retrieved data

• Perform the required operations on the data within the foreach activity

• Write the output to the desired destination

My suggestion for implementation in Azure Data Factory v2 is to use the Mapping Data Flow feature.

• Utilize Mapping Data Flow for complex data transformations

• Take advantage of the visual interface to design and debug data flows

• Leverage the built-in data integration capabilities with other Azure services

• Use data flow parameters and expressions for dynamic transformations

• Monitor and optimize data flow performance using dat

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

• C++ is an extension of the C programming language.

• It supports object-oriented programming concepts like classes, inheritance, polymorphism, and encapsulation.

• C++ is used in developing operating systems, browsers, databases, and other software applications.

• It is known for its performance an...read more

A data structure that stores a sequence of elements in a linear order.

• Consists of nodes that contain data and a pointer to the next node.

• Can be singly linked or doubly linked.

• Used for implementing stacks, queues, and hash tables.

• Example: Singly linked list - 1 -> 2 -> 3 -> null

• Example: Doubly linked list - null <- 1 <-> 2 <-> 3 -> null