i
Providence Global Center
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Mar 2022. There were 3 interview rounds.
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed before Jan 2022. There were 3 interview rounds.
I was interviewed before Sep 2020.
Round duration - 135 minutes
Round difficulty - Medium
The test window was open from 2:00 p.m. to 05:30 PM IST on 28th of August 2020.We were also given a chance to take a practice test to know about working of the platform .It was a Proctored Assessment .The test platform was HackerEarth and there were around 28 MCQs, 1 programming question, and 2 SQL queries. MCQs majorly focused on OS, DBMS, C++, OOPS concepts.
Given an array of integers ARR
of length N
and an integer Target
, your task is to return all pairs of elements such that they add up to the Target
.
The first line ...
Round duration - 50 minutes
Round difficulty - Medium
It was basically a technical interview. It was conducted around 11:00 a.m. on 31st august 2020. There was only 1 person who was interviewing me though I expected a panel. It started off by the question regarding our college and infrastructure of it and what do I like the most about it etc. Later continued by few technical subjective questions and a code along with a basic query. Technical questions regarding data structures like linked list, Array List , HashMap were asked along with concepts like backtracking were also covered. More about technologies related to projects that I have done were asked which is machine learning. the ratings i earned in online judges were also asked about.
Given a 9x9 Sudoku board, your task is to fill the empty slots and return the completed Sudoku solution.
A Sudoku is a grid composed of nine 3x3 smaller grids. The challenge is to fill in the...
Determine if a given singly linked list of integers forms a cycle or not.
A cycle in a linked list occurs when a node's next
points back to a previous node in the ...
Round duration - 40 minutes
Round difficulty - Medium
It is more of a Managerial round. This was not confined to any topic or a subject .It took place around 4:15 p.m. on 31st of August ,2020.
Tip 1 : Try to get good grip on basics , never jump into advanced concepts unless you are clear with the basic subject.
Tip 2 : Always have every main concept that is included in your core curriculum ( for a cs student) covered, make sure you
have idea about it and where you can apply it.
Tip 3 : Try to work on and know more about trending or booming technologies.
Tip 4 : Have short term goals when it comes to coding. Consider a topic for once ( like strings , pointers , dp etc.) and try to
cover maximum variety of problems possible in a reasonable period of time.
Tip 5 : Try to search for tricky pseudo codes online and guess the outputs.
Tip 6 : Give mock interviews before hand and also gather information about the company you have applied to.
Tip 1 : Do include only known and worked on concepts in your resume .Do not bluff or exaggerate.
Tip 2 : Our resume needs to show that we are flexible and have not just worked on a single domain. So try to do and add
at least 2 projects to your resume that too of different domains.
Tip 3 : Resume needs to look professional do not include a lot of personal details.
Tip 4 : Career Objective is something that is unique and written on your own and not copied from any website or peers
resume.
Tip 5 : A single page or 1 and a half page of resume would do good. Include certifications of any forefront technologies if possible
Providence Global Center interview questions for popular designations
Get interview-ready with Top Providence Global Center Interview Questions
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
I applied via Referral and was interviewed in Nov 2020. There was 1 interview round.
Top trending discussions
based on 14 interviews
Interview experience
based on 106 reviews
Rating in categories
Lead Software Engineer
41
salaries
| ₹20 L/yr - ₹42 L/yr |
Senior Service Engineer
30
salaries
| ₹11.5 L/yr - ₹32.5 L/yr |
Lead Data Engineer
27
salaries
| ₹23.1 L/yr - ₹42 L/yr |
Senior Software Engineer
26
salaries
| ₹12.6 L/yr - ₹30 L/yr |
Senior Data Engineer
24
salaries
| ₹11 L/yr - ₹25 L/yr |
Accenture
IBM
TCS
Infosys