AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Centric Consulting Interview Questions, Process, and Tips for Experienced
Top Centric Consulting Interview Questions and Answers for Experienced
- Q1. Delete duplicate rowsasked in Informatica Developer interview
- Q2. Concepts of Dotnetasked in Senior Consultant interview
- Q3. How to authentication in APIs? Flow of .net core app execution? How to do Exception handling? Entity framework best practices Design patterns and SOLID principalsasked in .NET Architect interview
Centric Consulting Interview Experiences for Experienced
11 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Related to sql server in depth
- Q2. Related to.net in depth
(2 Questions)
- Q1. In depth discussion about full stack
- Q2. In depth discussion about architecture
(2 Questions)
- Q1. Salary negotiation
- Q2. Company policies
Interview Preparation Tips
Senior Technical Lead Interview Questions asked at other Companies
(1 Question)
- Q1. Profile related discussion
Real time programing questions
(1 Question)
- Q1. Technical questions regarding mentioned technology
(1 Question)
- Q1. Technical questions regarding mentioned skillset
(1 Question)
- Q1. US round for technical questions
Interview Preparation Tips
Senior Consultant Interview Questions asked at other Companies
I applied via Referral and was interviewed in May 2022. There were 3 interview rounds.
(1 Question)
- Q1. Some details about my self then some of the questions like DI, middleware, sql trigger, differece between SP and Function, magic tables, oops related like static vs singleton,, in JS - hoisting, dead zone,...
(1 Question)
- Q1. Angular interceptor, one scenario to implement, web api, wcf vs web api, entity framework, poco classes, track changes in EF, transactions, solid principle
(1 Question)
- Q1. It was more like to determine that what kind of project should be assigned, so some details about current projects, how i would implement a project from scratch and previous project structure and implement...
Interview Preparation Tips
- OOPS
- C#.Net
- .Net Core
- Entity Framework
- LINQ
- Design Patterns
- MS SQL Server
- java script
Technical Lead Interview Questions asked at other Companies
Selected
I appeared for an interview before May 2023.
(2 Questions)
- Q1. Object oriented programming basics
- Q2. Concepts of Dotnet
- Ans.
Dotnet is a software framework developed by Microsoft for building and running applications on Windows.
Dotnet is a platform that provides tools and libraries for developing various types of applications.
It supports multiple programming languages such as C#, VB.NET, and F#.
Dotnet includes a runtime environment called Common Language Runtime (CLR) which manages the execution of code.
It also includes a class library calle...
(2 Questions)
- Q1. React JS basics
- Q2. Dotnet basics interview questions
Senior Consultant Interview Questions asked at other Companies
Centric Consulting interview questions for popular designations
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. React questions
(1 Question)
- Q1. Memorization react
(1 Question)
- Q1. Interview with US founder
Consultant Interview Questions asked at other Companies
Case study of food delivery app
(1 Question)
- Q1. How to authentication in APIs? Flow of .net core app execution? How to do Exception handling? Entity framework best practices Design patterns and SOLID principals
- Ans.
Answering questions related to .NET Core app execution, authentication, exception handling, Entity Framework best practices, design patterns, and SOLID principles.
Use authentication middleware like JWT or OAuth2
Implement authorization policies to control access to APIs
Use try-catch blocks for exception handling
Use logging to track errors and exceptions
Use dependency injection for Entity Framework
Use repository pattern ...
Interview Preparation Tips
Design patterns, Microservice design patterns, SOLID principals with example, Authentication and authorization, Entity framework best practices, LINQ joins, .Net core app execution flow etc.
Skills evaluated in this interview
.NET Architect Interview Questions asked at other Companies
Jobs at Centric Consulting
Interview Questionnaire
7 Questions
- Q1. Truncate vs delete
- Ans.
Truncate removes all data from a table while delete removes specific rows.
Truncate is faster than delete as it doesn't log individual row deletions
Truncate cannot be rolled back while delete can be
Truncate resets the identity of the table while delete doesn't
Truncate doesn't fire triggers while delete does
- Q2. Transformation union
- Q3. Scenario base question
- Q4. Delete duplicate rows
- Ans.
To delete duplicate rows, we can use the DISTINCT keyword or GROUP BY clause in SQL.
Use the DISTINCT keyword to select unique rows from a table.
Use the GROUP BY clause to group rows with the same values and select only one row from each group.
Use the HAVING clause with GROUP BY to filter out groups with more than one row.
In Informatica, use the Sorter transformation to sort the data and then use the Aggregator transfor...
- Q5. Lookup
- Q6. Regenrated dimension
- Q7. Star vs snowflake
- Ans.
Star and snowflake are two types of database schema used in data warehousing.
Star schema is simpler and easier to understand.
Snowflake schema is more normalized and reduces data redundancy.
Star schema is better for simple queries and reporting.
Snowflake schema is better for complex queries and analysis.
Star schema has fewer tables and is faster for querying.
Snowflake schema has more tables and is slower for querying.
St...
Interview Preparation Tips
Skills evaluated in this interview
Informatica Developer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Informatica related question. You can find all questions on internet
Interview Preparation Tips
Consultant Interview Questions asked at other Companies
Interview Questionnaire
1 Question
- Q1. Good scenario based questions were asked in the interview. Be clear of the projects you have worked as most of the scenarios are dug from there.
Senior Consultant Interview Questions asked at other Companies
Interview Questionnaire
2 Questions
- Q1. Basic questions of manual testing along with the basic selenium
- Q2. Regression and retesting difference, smoke and sanity difference, brief about the project, defect life cycle, selenium locators, hard assert and soft assert difference, difference between implicit wait and...
Senior Test Consultant Interview Questions asked at other Companies
Top trending discussions
Centric Consulting Interview FAQs
Tell us how to improve this page.
Centric Consulting Interviews By Designations
- Centric Consulting Senior Consultant Interview Questions
- Centric Consulting Consultant Interview Questions
- Centric Consulting Senior Test Consultant Interview Questions
- Centric Consulting Senior Technical Lead Interview Questions
- Centric Consulting Technical Lead Interview Questions
- Centric Consulting Informatica Developer Interview Questions
- Centric Consulting Team Manager Interview Questions
- Centric Consulting .NET Architect Interview Questions
- Show more
Interview Questions for Popular Designations
Centric Consulting Interview Process for Experienced
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Centric Consulting Reviews and Ratings
based on 92 reviews
Rating in categories
|
Senior Consultant
238
salaries
|  ₹11.2 L/yr - ₹37 L/yr |
|
Consultant
139
salaries
| ₹7.6 L/yr - ₹26 L/yr |
|
Technical Lead
70
salaries
| ₹20 L/yr - ₹43 L/yr |
|
Senior Software Engineer
27
salaries
| ₹11.5 L/yr - ₹28 L/yr |
|
Technical Architect
14
salaries
| ₹26 L/yr - ₹51.5 L/yr |
McKinsey & Company
Smollan Group
National Commodities Management Services
Tractebel
- Home >
- Interviews >
- Centric Consulting Interview Questions >
- Centric Consulting Interview Questions for Experienced
