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
Top Centric Consulting Interview Questions and Answers
- Q1. Hiraracy of Nested classes and their calling sequence!asked in Senior Consultant interview
- Q2. Delete duplicate rowsasked in Informatica Developer 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
18 interviews found
Anonymous
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
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
(2 Questions)
- Q1. Hiraracy of Nested classes and their calling sequence!
- Ans.
Nested classes in Java have a hierarchical structure with the outer class containing the inner class, which can further contain more inner classes.
Nested classes are defined within another class, known as the outer class.
Inner classes have access to the members of the outer class.
Nested classes can be static or non-static.
The calling sequence for nested classes is OuterClass.InnerClass.method();
Example: OuterClass oute...
- Q2. Types Constructors and calling sequence
Skills evaluated in this interview
Senior Consultant Interview Questions asked at other Companies
(1 Question)
- Q1. Oops concepts in detail
- Ans.
Oops concepts refer to Object-Oriented Programming principles like Inheritance, Polymorphism, Encapsulation, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Polymorphism: Ability of objects to take on multiple forms.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Abstraction: Hiding the complex implementation details and showing only
(1 Question)
- Q1. Xpath related questions
(1 Question)
- Q1. In general about your career journey
Senior Consultant Interview Questions asked at other Companies
Centric Consulting interview questions for popular designations
I applied via Approached by Company and was interviewed in Dec 2022. There were 2 interview rounds.
(2 Questions)
- Q1. About Agile, .NET, RDP, Java Projects
- Q2. .Net, Java, Manual Testing, Automation, Cloud
Interview Preparation Tips
Team Manager Interview Questions asked at other Companies
(2 Questions)
- Q1. It was based on resume
- Q2. Soft skills as well like how well you can articulate.
(2 Questions)
- Q1. This was more into profile for which you applied
- Q2. More theoretical based questions which you can learn from internet as well.
(1 Question)
- Q1. Salary negotiation based on the last drawn.
Interview Preparation Tips
Senior Consultant 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 was interviewed 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
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
(1 Question)
- Q1. General resume based questions
- Ans. Go through the resume well and be positive
(1 Question)
- Q1. More grilling and few case studies
(1 Question)
- Q1. Salary negotiation with respect to last drawn
Interview Preparation Tips
Senior 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
based on 7 interviews
Interview experience
Interview Questions from Similar Companies
Centric Consulting Reviews and Ratings
based on 89 reviews
Rating in categories
|
Senior Consultant
239
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Consultant
138
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
73
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
26
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Architect
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Accenture
Deloitte
PwC
KPMG India
- Home >
- Interviews >
- Centric Consulting Interview Questions
