i
Providence Global Center
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Sep 2021. There was 1 interview round.
Synapse tables can be tuned by optimizing query performance and adjusting table properties.
Identify frequently used queries and optimize them for better performance
Adjust table properties such as partitioning, indexing, and compression
Regularly monitor and analyze table performance to identify areas for improvement
Consider using caching mechanisms to reduce query times
Collaborate with database administrators and other
Slow reports can be tuned by optimizing queries, indexing tables, and reducing data retrieval.
Identify the slowest queries and optimize them
Index the tables to improve query performance
Reduce the amount of data retrieved by filtering or aggregating
Consider caching frequently accessed data
Use query profiling tools to identify bottlenecks
Upgrade hardware or database software if necessary
Top trending discussions
FE 500 steel is a type of high-strength reinforcement steel commonly used in construction.
FE 500 steel has a minimum yield strength of 500 MPa.
It is commonly used in high-rise buildings, bridges, and other structures where high strength is required.
FE 500 steel is more ductile and weldable compared to lower grade steels.
It provides better resistance to corrosion and fire damage.
FE 500 steel bars are available in variou
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.
Aptitude test
Current affairs
posted on 15 Jul 2022
I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.
If you are a fresher , then this is for you else almost no coding test for experienced candidates.
I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.
Moderate difficult with business reasoning
posted on 10 May 2020
I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.
posted on 29 Jun 2024
I applied via Referral and was interviewed before Jun 2023. There were 3 interview rounds.
Coding test are just basic Array and linkedList question
The 4 pillars of OOP are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation restricts access to certain components of an object, protecting its integrity.
Abstraction hides complex implementation details and only shows the necessary features.
Polymorphism allows objects of different classes to be treated as objects of a
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
HashMap internally uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.
If multiple keys hash to the same index, a linked list is used to handle collisions.
Retrieving a value involves hashing the ...
Implementation of Create, Read, Update, and Delete operations in a software system.
Use SQL queries for database operations
Create separate functions for each operation
Handle errors and exceptions properly
Test thoroughly to ensure functionality
Consider security measures to prevent unauthorized access
Seeking new challenges and opportunities for growth.
Looking for a new environment to learn and develop new skills
Interested in working on different projects and technologies
Seeking better career advancement opportunities
Wanting to work in a more collaborative team environment
posted on 5 Aug 2024
I applied via Job Portal and was interviewed in Feb 2024. There were 3 interview rounds.
30 mins Aptitude Question
30 mins - 3 Coding Question
Rest API is a set of rules and conventions for building and interacting with web services using HTTP methods.
Rest API stands for Representational State Transfer Application Programming Interface.
It uses standard HTTP methods like GET, POST, PUT, DELETE to perform CRUD operations.
RESTful APIs use URLs to access resources, and return data in JSON or XML format.
Stateless communication allows for scalability and flexibilit...
Response codes indicate the status of a HTTP request. 200 & 201 are success codes, while 400 & 403 are client error codes.
200 - OK: Request was successful
201 - Created: Request was successful and a new resource was created
400 - Bad Request: The server cannot process the request due to a client error
403 - Forbidden: The server understood the request, but refuses to authorize it
Math , gk, english
AI
based on 1 review
Rating in categories
Lead Software Engineer
42
salaries
| ₹20 L/yr - ₹42 L/yr |
Senior Software Engineer
34
salaries
| ₹12.6 L/yr - ₹30 L/yr |
Senior Analyst
32
salaries
| ₹6.8 L/yr - ₹21 L/yr |
Senior Service Engineer
31
salaries
| ₹11.5 L/yr - ₹31 L/yr |
Lead Data Engineer
27
salaries
| ₹24.1 L/yr - ₹42 L/yr |
Saama Technologies
DISYS
Data-Core Systems
Arvato