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

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

Senior Engineer Jobs at Providence Global Center

View all

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic react and js interview
Round 2 - Assessment 

(1 Question)

  • Q1. React multiple questions
Round 3 - Coding Test 

Finding kth largest number by creating function without using in-built methods using javascript

Interview Preparation Tips

Interview preparation tips for other job seekers - I recently interviewed for a Sr.Engineer position with this company.After successfully clearing 3 technical rounds, we moved to salary negotiations. Based on market standards and their own job listings for this position, which clearly mentioned a salary bracket of 12-15 LPA, I expected 12 LPA-a fair and reasonable figure for the role and my qualifications.
After discussions, I compromised and agreed to their offer of 9LPA, despite already holding another offer at the same package. However, at the final stage, they abruptly cancelled the offer, citing that my initial expectation was too high. This decision came after wasting significant time and energy throughout the process.
This behavior demonstrates a lack of professionalism, transparency, and respect for candidates. It's disheartening to see companies treating potential hires this way, especially after reaching mutual agreements.
If you're considering applying here, think twice about their commitment to candidate and their hiring ethics.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions about C# language features
  • Q2. Azure functions and other services
Round 2 - Technical 

(2 Questions)

  • Q1. DevOps concepts
  • Q2. Angular basics

Interview Preparation Tips

Interview preparation tips for other job seekers - Core concepts of programming should be clear to interview experience
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Naukri.com and was interviewed in Sep 2024. There were 5 interview rounds.

Round 1 - Coding Test 

Leetcode easy level questions

Round 2 - Technical 

(1 Question)

  • Q1. Eliminate subsequent repetitions in a string
  • Ans. 

    Remove subsequent repetitions in a string

    • Iterate through the string and compare each character with the next one

    • If they are the same, remove the repetition by shifting the characters to the left

    • Repeat this process until all repetitions are eliminated

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Behavioral questions asked by Delivery Manager
Round 4 - Client Interview 

(1 Question)

  • Q1. Behavioral round and past experience
Round 5 - Client Interview 

(2 Questions)

  • Q1. Design a URL shortener
  • Ans. 

    A URL shortener is a tool that takes a long URL and generates a shorter, more manageable link.

    • Generate a unique short code for each long URL

    • Store the mapping between short code and long URL in a database

    • Redirect users from short URL to original long URL when accessed

  • Answered by AI
  • Q2. Write unit test for a sevice class
  • Ans. 

    Unit test for a service class

    • Create a test class for the service class

    • Mock any dependencies of the service class

    • Write test methods to cover different scenarios

    • Use assertions to verify the expected outcomes

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The fifth client technical interview went on for at least 2 hours. I was not shortlisted after 5 rounds of interview. The HR recruiter didn't inform this decision even after multiple follow-ups by call.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Army Institute of Technology, Pune and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

There was a coding round and out of 75 students 28 got selected for next round

Round 2 - Technical 

(2 Questions)

  • Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
  • Q2. Explain your project in detail and asking cross questions regarding project.
Round 3 - Technical 

(1 Question)

  • Q1. I was rejected in round 2.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your resume thoroughly, and have a basic DSA knowledge.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Go Lang related questions
  • Q2. System architecture
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Question design commands
  • Q2. Questions about design software
  • Q3. Core mechanical question stress and strain
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Approached by Company and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Deep Technical Questions
  • Q2. Problem solving and usecases
Round 2 - Technical 

(1 Question)

  • Q1. Usecase based questions
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

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackerrank test with focus on DSA + problem solving + web dev

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.

Providence Global Center Senior Engineer Salary
based on 4 salaries
₹11 L/yr - ₹15.2 L/yr
43% 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
41 salaries
unlock blur

₹20 L/yr - ₹42 L/yr

Senior Service Engineer
30 salaries
unlock blur

₹11.5 L/yr - ₹32.5 L/yr

Senior Software Engineer
26 salaries
unlock blur

₹12.6 L/yr - ₹30 L/yr

Lead Data Engineer
26 salaries
unlock blur

₹23.1 L/yr - ₹42 L/yr

Software Engineer
25 salaries
unlock blur

₹10 L/yr - ₹21 L/yr

Explore more salaries
Compare Providence Global Center with

Accenture

3.8
Compare

IBM

4.0
Compare

TCS

3.7
Compare

Infosys

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