100+ Technical Manager Interview Questions and Answers

Delivering a release in Agile Scrum involves continuous integration and delivery. Monolith, multitenant, and microservices differ in architecture. Kafka is a distributed streaming platform. Conflict resolution and managing client expectations are crucial skills.

• Agile Scrum involves continuous integration and delivery

• Monolith is a single, self-contained application, multitenant serves multiple clients, and microservices are independent components

• Kafka is a distributed streamin...read more

I would first analyze the requirements and then design the database accordingly.

• Understand the data and its relationships

• Identify the entities and their attributes

• Normalize the data to reduce redundancy

• Choose appropriate data types and constraints

• Consider scalability and performance

• Ensure data integrity and security

Designing a survey page involves creating a user-friendly UI and a robust database schema to handle responses efficiently.

• 1. Database Schema: Create tables for Users, Surveys, Questions, and Responses.

• 2. Users Table: Store user information like user_id, name, and email.

• 3. Surveys Table: Include survey_id, title, description, and creation date.

• 4. Questions Table: Link to Surveys with survey_id, include question_text and question_type (e.g., multiple choice, text).

• 5. Responses ...read more

Dependency injection is a design pattern that allows objects to be passed as dependencies rather than being created within a class.

• Pros: promotes loose coupling, easier testing, and modular design

• Cons: can add complexity and require additional setup

• Example: passing a database connection object to a repository class rather than creating the connection within the class

A DWH for a University with table relationships

• Create a student table with student ID as primary key

• Create a course table with course ID as primary key

• Create a faculty table with faculty ID as primary key

• Create a enrollment table with student ID and course ID as foreign keys

• Create a teaching table with faculty ID and course ID as foreign keys

The measuring unit of different types of sensors in air conditioners is typically in temperature units such as Celsius or Fahrenheit.

• Temperature sensors in air conditioners measure in Celsius or Fahrenheit

• Humidity sensors measure in percentage

• Pressure sensors measure in Pascals or PSI

• Some sensors may also measure in volts or amps

Automation logs are kept in a centralized location with detailed information on test cases and results.

• Automation logs are stored in a centralized location for easy access and analysis.

• Logs include detailed information on test cases, such as test name, status, and duration.

• Logs also include information on the environment and system under test.

• Logs are organized by date and time for easy tracking of changes and issues.

• Logs are regularly reviewed and analyzed to identify areas ...read more

Developing an Azure solution involves data integration, processing, and visualization using on-premises datasets.

• Identify on-premises datasets: Assess the data sources available, such as SQL databases, CSV files, or APIs.

• Data integration: Use Azure Data Factory to create pipelines that extract data from on-premises sources and load it into Azure services.

• Data storage: Choose appropriate Azure storage solutions like Azure Blob Storage or Azure SQL Database for storing the inge...read more

Managing a site in night mode down condition

• Ensure proper lighting and visibility at the site during night time

• Implement security measures to prevent unauthorized access

• Regularly monitor and maintain equipment and systems

• Establish communication protocols for emergencies

• Train staff on night mode operations and procedures

Pega Openspan supports database commands and connection string.

• Database commands can be executed using the OLEDB connector in Pega Openspan.

• Connection string can be defined in the configuration of the OLEDB connector.

• Examples of database commands include SELECT, INSERT, UPDATE, and DELETE.

• Connection string includes details such as server name, database name, and authentication mode.

The contract demand load of our site is 500 kW.

• The contract demand load refers to the maximum amount of power that our site is contracted to receive.

• It is typically measured in kilowatts (kW) and is determined based on the site's energy requirements and usage patterns.

• The contract demand load helps in planning and managing the electrical infrastructure of the site.

• It ensures that the site has sufficient capacity to meet its power needs without overloading the system.

• For examp...read more

The DLC connector pinout for CAN wiring includes specific pins for CAN High, CAN Low, and ground connections.

• Pin 6: CAN High - This pin carries the high signal for the CAN bus.

• Pin 14: CAN Low - This pin carries the low signal for the CAN bus.

• Pin 4: Ground - Provides a common ground reference for the CAN communication.

• Example: In a typical automotive application, these pins connect to the vehicle's CAN network for diagnostics.

Dimension modelling is a technique used in data warehousing to organize and structure data for efficient analysis.

• Pros: improves query performance, simplifies data analysis, provides a clear understanding of data relationships

• Cons: can be complex and time-consuming to implement, requires a deep understanding of the data being modeled

• Examples: star schema, snowflake schema

A datum is a reference point for measurements; establishing a datum structure ensures accuracy and consistency in data collection.

• A datum is a singular reference point used in measurements, such as a point on a part in engineering.

• Establishing a datum structure involves selecting primary, secondary, and tertiary datums for complex measurements.

• For example, in mechanical design, a flat surface may serve as a primary datum for aligning other features.

• In 3D modeling, a coordinat...read more

My favorite technical process is Agile methodology, which enhances collaboration and adaptability in project management.

• Promotes iterative development, allowing teams to adapt to changes quickly.

• Encourages regular feedback through sprint reviews, improving product quality.

• Facilitates better communication among team members, leading to increased efficiency.

• Example: In a software project, using Agile helped us pivot features based on user feedback after each sprint.

Yes, I am willing to travel within the city and have knowledge of centrifugal pump maintenance and basic chemical requirements.

• I am comfortable with traveling within the city for work purposes.

• I have experience in maintaining centrifugal pumps and am familiar with their operation.

• I possess basic chemical knowledge and can work with chemical engineers to meet project requirements.

Measurement uncertainty is calculated by considering various sources of error and combining them using statistical methods.

• Identify all sources of uncertainty, including equipment limitations, environmental factors, and human error.

• Quantify each source of uncertainty using appropriate statistical methods such as standard deviation or confidence intervals.

• Combine individual uncertainties using the root sum of squares method to calculate the overall measurement uncertainty.

• Expr...read more

Wait all waits for all tasks to complete while wait any waits for any one task to complete.

• Wait all is used when all tasks need to be completed before proceeding.

• Wait any is used when any one task can complete before proceeding.

• Wait all returns when all tasks complete while wait any returns when any one task completes.

• Wait all can cause longer wait times if one task takes longer while wait any can be faster if one task completes quickly.

K-Line and CAN Line are communication protocols used in automotive and industrial applications, differing in structure and functionality.

• K-Line is a single-wire communication protocol, while CAN Line uses a differential signaling method over two wires.

• K-Line is primarily used for diagnostics and communication with ECUs, whereas CAN Line supports real-time data exchange.

• K-Line operates at lower speeds (up to 10.4 kbps), while CAN Line can operate at speeds up to 1 Mbps.

• Example...read more

A synchronization panel for DG is used to connect and synchronize multiple generators to ensure smooth power transfer.

• Synchronization panel is used to connect and synchronize multiple diesel generators (DG) in parallel.

• It ensures smooth power transfer and load sharing between the generators.

• The panel monitors and controls parameters like voltage, frequency, and phase angle of the generators.

• It includes devices like synchronizers, circuit breakers, and protective relays.

• The pa...read more

Implementing CAPTCHA verification can prevent multiple spam requests.

• Implement CAPTCHA verification on the website forms to ensure that only humans can submit requests.

• Use rate limiting to restrict the number of requests from a single IP address within a certain time frame.

• Utilize machine learning algorithms to detect and block spam requests based on patterns and behavior.

• Regularly update spam filters and security measures to stay ahead of evolving spam tactics.

Agile/Scrum processes are used to manage our product development.

• We follow the Scrum framework for our product development.

• We have a Product Owner who prioritizes the product backlog.

• Sprints are used to plan and execute development iterations.

• Daily stand-up meetings are held to discuss progress and address any issues.

• We use user stories and acceptance criteria to define requirements.

• Retrospectives are conducted at the end of each sprint to improve the process.

• We use Agile too...read more

Azure Logic Apps is a cloud service that helps you automate and orchestrate tasks, business processes, and workflows.

• Azure Logic Apps can be configured through the Azure portal or using Visual Studio.

• Pricing for Azure Logic Apps is based on the number of executions and connectors used.

• There are different pricing tiers available, such as Consumption and Standard plans.

• You can estimate the pricing using the Azure pricing calculator.

• Example: A basic Logic App with a few executio...read more

Calibrating instruments involves adjusting and verifying the accuracy of measurement tools.

• Identify the instrument to be calibrated

• Use a reference standard to compare measurements

• Adjust the instrument as needed to match the reference standard

• Verify the accuracy of the instrument after calibration

• Document the calibration process for record keeping

Radar technology is a communication system used for detecting objects and determining their range, angle, and velocity.

• Radar uses radio waves to detect objects in the surrounding environment

• It can determine the distance, angle, and speed of objects by analyzing the time it takes for the radio waves to bounce back

• Radar technology is commonly used in aviation for air traffic control and weather monitoring

• Military applications of radar include detecting enemy aircraft and missil...read more

Inner join returns only the matching records from both tables, while left outer join returns all records from the left table and matching records from the right table.

• Inner join combines rows from two tables based on a related column.

• Left outer join returns all rows from the left table and matching rows from the right table.

• Inner join excludes non-matching rows, while left outer join includes non-matching rows with NULL values.

• Example: Inner join - SELECT * FROM table1 INNER ...read more

Brightness refers to the intensity of light emitted or reflected by a surface, while whiteness refers to the color of the light reflected by a surface.

• Brightness is the measure of the amount of light emitted or reflected by a surface.

• Whiteness is the measure of the color of the light reflected by a surface, with white being the brightest color.

• Brightness can be adjusted by changing the intensity of light sources, while whiteness is a characteristic of the surface material.

• Exa...read more