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

Senior Engineer Jobs at Providence Global Center

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Coming to AEM,Interviewer has covered all the topics.

Interview Preparation Tips

Interview preparation tips for other job seekers - Pls don't join in TechMahindra.Especially for AEM Folks.Because there are no projects at all.They force you to learn and work in other domain.Then your AEM knowledge will vanish.Worst Company.

Interview Questionnaire 

1 Question

  • Q1. What is name mangling?
  • Ans. 

    Name mangling is a technique used by compilers to give unique names to functions and variables to avoid naming conflicts.

    • Name mangling is used in C++ to support function overloading.

    • It is also used in Python to avoid naming conflicts in modules.

    • Name mangling can make it difficult to access variables and functions from outside the class in which they are defined.

    • In C++, name mangling can be seen by using the 'nm' comman

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Past experience and communication skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Interview Questionnaire 

1 Question

  • Q1. React hooks

Interview Questionnaire 

1 Question

  • Q1. React hooks

Senior Engineer Interview Questions & Answers

HCLTech user image raja reddy duggi reddy

posted on 27 Apr 2021

Interview Questionnaire 

2 Questions

  • Q1. Engineering Technical
  • Q2. Mainly on Engineering Design

Interview Questionnaire 

6 Questions

  • Q1. Explain abstract factory design pattern ?
  • Ans. 

    Abstract Factory is a creational design pattern that provides an interface for creating families of related objects.

    • Abstract Factory is used when we need to create families of related objects without specifying their concrete classes.

    • It provides an interface for creating objects of related classes without specifying their concrete classes.

    • It encapsulates a group of factories that have a common theme.

    • It promotes loose c...

  • Answered by AI
  • Q2. How do you do range based map iteration
  • Ans. 

    Range based map iteration can be done using a for-each loop or iterators.

    • Use a for-each loop to iterate over the map elements.

    • Alternatively, use iterators to traverse the map.

    • The range-based for loop is preferred for its simplicity and readability.

    • Example: for(auto const& [key, value] : myMap) { //do something with key and value }

  • Answered by AI
  • Q3. What are detached and joined threads
  • Ans. 

    Detached threads are independent threads that run separately from the main thread. Joined threads are threads that wait for the main thread to finish.

    • Detached threads are created using pthread_detach() function

    • Joined threads are created using pthread_join() function

    • Detached threads do not need to be explicitly terminated

    • Joined threads must be explicitly terminated using pthread_exit() or return statement

    • Detached thread...

  • Answered by AI
  • Q4. What are static code analysis tools
  • Ans. 

    Static code analysis tools are software programs that analyze source code to find potential issues and improve code quality.

    • Static code analysis tools scan code without executing it

    • They can detect issues such as security vulnerabilities, coding errors, and performance problems

    • Examples of static code analysis tools include SonarQube, ESLint, and Checkstyle

  • Answered by AI
  • Q5. Command to list currently running threads in linux
  • Ans. 

    Command to list currently running threads in linux

    • Use the 'ps' command with the 'H' option to display threads in a hierarchy

    • Use the 'top' command to display threads in real-time

    • Use the 'htop' command for an interactive display of threads

  • Answered by AI
  • Q6. Can we perform arithmetic operation on Unique pointer
  • Ans. 

    No, arithmetic operations cannot be performed on unique pointers.

    • Unique pointers are used to manage the lifetime of dynamically allocated objects.

    • They cannot be copied or assigned, only moved.

    • Arithmetic operations are not defined for pointers, including unique pointers.

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Design facebook
  • Ans. 

    Designing Facebook is a complex task involving various components and technologies.

    • Identify the core features of Facebook such as user profiles, news feed, messaging, and groups.

    • Choose appropriate technologies for each component such as PHP for backend, React for frontend, and MySQL for database.

    • Ensure scalability and performance by implementing caching, load balancing, and database sharding.

    • Implement security measures...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Database, logical reasoning

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. About skilla
  • Q2. Project
  • Q3. Roles in

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

₹0 L/yr - ₹0 L/yr

Senior Service Engineer
30 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Data Engineer
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
26 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Engineer
25 salaries
unlock blur

₹0 L/yr - ₹0 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