Filter interviews by
I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.
Yes, Azure SQL db is a fully managed relational database service provided by Microsoft Azure.
Azure SQL db is a cloud-based database service that allows you to build, scale, and manage applications with ease.
It is based on Microsoft SQL Server engine and offers high availability, security, and performance.
You can use Azure SQL db to store and retrieve structured, semi-structured, and unstructured data.
It supports variou...
Steps to improve SQL query performance
Optimize the query by using appropriate indexes
Minimize the use of functions and calculations in the query
Avoid unnecessary joins and subqueries
Retrieve only the required columns instead of selecting all
Use query hints or optimizer directives if necessary
Analyze and optimize the database schema and table structures
Consider partitioning large tables
Monitor and tune the database serv...
To improve the performance of a data pipeline in Azure Data Factory, you can optimize data flow, use parallel processing, and monitor resource utilization.
Optimize data flow by reducing unnecessary transformations and filtering
Use parallel processing by partitioning data and running multiple activities concurrently
Monitor resource utilization to identify bottlenecks and optimize resource allocation
To send emails on completing a job from SQL Server, you can use SQL Server Agent and Database Mail.
Configure SQL Server Agent to run the job
Enable Database Mail and configure an SMTP server
Create a SQL Server Agent job that sends an email on completion
Use the sp_send_dbmail stored procedure to send the email
Include the necessary details in the email, such as job status and execution duration
Top trending discussions
posted on 22 Dec 2024
Create scenario-based questions that challenge you to utilize all of your coding skills.
Security in APIs is crucial for protecting sensitive data and preventing unauthorized access.
Use authentication methods such as OAuth or API keys to verify the identity of users accessing the API.
Implement encryption to secure data transmission between clients and servers.
Set up rate limiting to prevent abuse and protect against denial of service attacks.
Regularly update and patch the API to address security vulnerabil...
I applied via Naukri.com and was interviewed in Jun 2024. There were 2 interview rounds.
Non functional requirements are criteria that specify how a system should behave, rather than what it should do.
Performance - system should respond within 2 seconds for all user interactions
Scalability - system should be able to handle 1000 concurrent users
Reliability - system should have a 99.99% uptime
Security - system should encrypt all sensitive data
Usability - system should have a user-friendly interface
Improve legacy app performance by optimizing code, implementing caching, and scaling resources.
Optimize code by identifying and removing bottlenecks
Implement caching to reduce database calls and improve response time
Scale resources by using containers or serverless architecture
Use asynchronous processing for long-running tasks
Upgrade hardware or infrastructure if necessary
Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.
Implement authentication and authorization mechanisms to control access to microservices.
Use encryption to secure communication between microservices and external clients.
Implement monitoring and logging to detect and respond to security incidents.
Consider using API gateways for central...
Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.
Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.
Services communicate through APIs, allowing for flexibility and scalability.
Each microservice can be developed, deployed, and scaled independently, leading to faster develo...
Drupal best practices involve following coding standards, using modules wisely, optimizing performance, and maintaining security.
Follow Drupal coding standards to ensure consistency and readability of code
Use contributed modules from trusted sources and avoid unnecessary custom code
Optimize performance by caching content, enabling compression, and minimizing database queries
Maintain security by keeping Drupal core and ...
Drupal Cache Mechanism stores and retrieves data to improve website performance.
Drupal has multiple cache bins like page cache, block cache, and dynamic page cache.
Cache tags are used to invalidate specific cache items when content is updated.
Cache contexts allow different versions of a page to be served based on user roles or languages.
Cache max-age sets the time for which a cached item is considered valid before it n
Developed a custom Drupal module for creating a custom content type with specific fields and functionality.
Created a custom module folder within the Drupal installation
Defined the custom content type and its fields in the module's .info file
Implemented hook functions to handle data processing and display logic
Used Drupal's Form API to create custom forms for data input and editing
Integrated with other Drupal modules or
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
posted on 20 Sep 2023
I applied via LinkedIn and was interviewed in Mar 2023. There were 4 interview rounds.
The 3-layer API architecture in Mule is a design pattern that separates the presentation, business logic, and data access layers.
Presentation Layer: Handles the user interface and interaction with the API
Business Logic Layer: Implements the core functionality and processes the requests
Data Access Layer: Manages the interaction with the underlying data sources
Example: In Mule, the presentation layer can be implemented u...
posted on 26 Mar 2023
I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.
Designing MakeMyTrip application
Identify user requirements and create a user-friendly interface
Integrate APIs for flight, hotel, and cab bookings
Implement secure payment gateway and user authentication
Ensure scalability and performance optimization
Provide personalized recommendations based on user history
posted on 6 Mar 2024
I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.
I applied via Approached by Company and was interviewed before Jun 2021. There were 4 interview rounds.
Softwaretest Engineer
9
salaries
| ₹1.5 L/yr - ₹3.5 L/yr |
Software Developer
8
salaries
| ₹2 L/yr - ₹4 L/yr |
Delivery Manager
7
salaries
| ₹11 L/yr - ₹18.2 L/yr |
Business Analyst
6
salaries
| ₹5 L/yr - ₹8.5 L/yr |
IT Technical Recruiter
6
salaries
| ₹2 L/yr - ₹6 L/yr |
Cognizant
NTT Data Information Processing Services
Sutherland Global Services
Hexaware Technologies