Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Providence Global Center Team. If you also belong to the team, you can get access from here

Providence Global Center Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Providence Global Center Senior Engineer Interview Questions and Answers

Updated 12 Sep 2022

Providence Global Center Senior Engineer Interview Experiences

1 interview found

I applied via Recruitment Consulltant and was interviewed before Sep 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How to tune synapse tables
  • Ans. 

    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

  • Answered by AI
  • Q2. How to tune slow reports
  • Ans. 

    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

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Providence Global Center Senior Engineer interview:
  • SQL
  • Power Bi
  • Azure
Interview preparation tips for other job seekers - Be confident, speak what you know and be frank if you dont know something during the interview.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. WHAT IS FE 500 STEEL
  • Ans. 

    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

  • Answered by AI

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test

Round 2 - Group Discussion 

Current affairs

Round 3 - Technical 

(1 Question)

  • Q1. Puzzle , sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself, whatever you know just be confident

I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

If you are a fresher , then this is for you else almost no coding test for experienced candidates.

Round 2 - One-on-one 

(1 Question)

  • Q1. Javascript basics, Angular react general questions depends upon profile.
Round 3 - Behavioral 

(1 Question)

  • Q1. They asked general questions related to some hectic situation faced in previous company / project..

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm . Clear your basics . That's it.

I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Moderate difficult with business reasoning

Round 2 - Technical 

(1 Question)

  • Q1. Prior work Ex mostly and a case study

Interview Preparation Tips

Interview preparation tips for other job seekers - Know SAS products and it's implementation use cases in detail with statistical knowledge

I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Object Oriented Concepts and basic list/tuple/dictionary/ datetime conversion
  • Q2. Project done in last company and how will you help Saama?

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to frame answers end to end and stick to what you have done. Don't try to exaggerate.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Coding test are just basic Array and linkedList question

Round 2 - Technical 

(3 Questions)

  • Q1. Explain 4 pillar of oops
  • Ans. 

    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

  • Answered by AI
  • Q2. Internal working of Hashmap
  • Ans. 

    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 ...

  • Answered by AI
  • Q3. Crud operation implementation
  • Ans. 

    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

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Why are you chaning the organisation?
  • Ans. 

    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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Medium level

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Job Portal and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

30 mins Aptitude Question

Round 2 - Coding Test 

30 mins - 3 Coding Question

Round 3 - Technical 

(2 Questions)

  • Q1. Describe Rest API
  • Ans. 

    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...

  • Answered by AI
  • Q2. What is various Response code. Diffenrence b/w 200 & 201, 400 & 403
  • Ans. 

    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

  • Answered by AI

Skills evaluated in this interview

Round 1 - Aptitude Test 

Math , gk, english

Round 2 - Group Discussion 

AI

Round 3 - One-on-one 

(1 Question)

  • Q1. Ai questions , java questions , coding questions
Round 4 - HR 

(1 Question)

  • Q1. Where do you see yourself in 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - none , not difficult to get into equifax

Providence Global Center Interview FAQs

How many rounds are there in Providence Global Center Senior Engineer interview?
Providence Global Center interview process usually has 1 rounds. The most common rounds in the Providence Global Center interview process are Technical.
How to prepare for Providence Global Center Senior Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Providence Global Center. The most common topics and skills that interviewers at Providence Global Center expect are Azure Automation, Azure Databricks, Azure DevOps, Azure Infrastructure and SQL Azure.
What are the top questions asked in Providence Global Center Senior Engineer interview?

Some of the top questions asked at the Providence Global Center Senior Engineer interview -

  1. How to tune synapse tab...read more
  2. How to tune slow repo...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Equifax Interview Questions
3.3
 • 32 Interviews
VDart Interview Questions
4.1
 • 28 Interviews
DISYS Interview Questions
3.0
 • 27 Interviews
EagleView Interview Questions
3.3
 • 20 Interviews
Apptio Interview Questions
3.9
 • 19 Interviews
SAS Interview Questions
4.3
 • 19 Interviews
View all
Providence Global Center Senior Engineer Salary
based on 4 salaries
₹11 L/yr - ₹15.3 L/yr
46% more than the average Senior Engineer Salary in India
View more details

Providence Global Center Senior Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

3.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

5.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Lead Software Engineer
42 salaries
unlock blur

₹20 L/yr - ₹42 L/yr

Senior Software Engineer
34 salaries
unlock blur

₹12.6 L/yr - ₹30 L/yr

Senior Analyst
32 salaries
unlock blur

₹6.8 L/yr - ₹21 L/yr

Senior Service Engineer
31 salaries
unlock blur

₹11.5 L/yr - ₹31 L/yr

Lead Data Engineer
27 salaries
unlock blur

₹24.1 L/yr - ₹42 L/yr

Explore more salaries
Compare Providence Global Center with

Saama Technologies

3.7
Compare

DISYS

3.0
Compare

Data-Core Systems

3.2
Compare

Arvato

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview