AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Pingahla Technical Manager Interview Questions and Answers
Pingahla Technical Manager Interview Experiences
1 interview found
Anonymous
I applied via LinkedIn and was interviewed in Dec 2021. There were 3 interview rounds.
(1 Question)
- Q1. It was a discussion related to my experiences, past projects and skills.
(5 Questions)
- Q1. Dimension modelling and their pros and cons
- Ans.
Dimension modelling is a technique used in data warehousing to organize and structure data for efficient analysis.
Pros: improves query performance, simplifies data analysis, provides a clear understanding of data relationships
Cons: can be complex and time-consuming to implement, requires a deep understanding of the data being modeled
Examples: star schema, snowflake schema
- Q2. Optimization in data loading technique
- Ans.
Optimization techniques for data loading
Use parallel processing to load data faster
Optimize database queries to reduce loading time
Use compression techniques to reduce data size
Implement caching to reduce data retrieval time
Use incremental loading to load only new or updated data
- Q3. 3 Scenario based SQL questions
- Q4. 3 scenario based ETL question
- Q5. DB partitioning and indexes
(2 Questions)
- Q1. Design a DWH for a University and explain the relationships between tables.
- Ans.
A DWH for a University with table relationships
Create a student table with student ID as primary key
Create a course table with course ID as primary key
Create a faculty table with faculty ID as primary key
Create a enrollment table with student ID and course ID as foreign keys
Create a teaching table with faculty ID and course ID as foreign keys
- Q2. Puzzle on shortest path
Interview Preparation Tips
- Informatica
- SQL
- Dimension modelling
- SQL Server
Skills evaluated in this interview
Sun Pharmaceutical Industries
Join us and thrive in a company culture that inspires and empowers.
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.
(1 Question)
- Q1. Situation Based Basic formulas rolls and responsibilities
Interview Preparation Tips
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
Skills evaluated in this interview
I applied via LinkedIn and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How do you manage conflicts within team
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed before Aug 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Technical questions on inventory procees
Interview Preparation Tips
I applied via Referral and was interviewed before Mar 2021. There were 3 interview rounds.
(3 Questions)
- Q1. What are your salary expectations?
- Q2. Share details of your previous job.
- Q3. Why are you looking for a change?
(1 Question)
- Q1. About process and total experience
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Details of LOI, articles of UCP, scope of ISBP
(2 Questions)
- Q1. What are your salary expectations?
- Q2. Share details of your previous job.
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Accounting question asked
- Q2. Answer has been given accordingly
Interview Preparation Tips
I applied via Referral and was interviewed before Jul 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Related to Accounts Payable, Rules and Principles of Accounts and about your previous job experiences if experienced
Interview Preparation Tips
Krishna Appalla
I applied via Naukri.com and was interviewed in Nov 2017. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. How much is the length of all India roads
- Ans.
The length of all India roads is approximately 5.5 million kilometers.
The total length of all India roads is estimated to be around 5.5 million kilometers.
India has one of the largest road networks in the world.
The road network in India includes national highways, state highways, district roads, and village roads.
The length of national highways alone is over 100,000 kilometers.
The road infrastructure plays a crucial ro...
Interview Preparation Tips
Experience: Experience
General Tips: Be specific and attentive
Skills: Analytical Skills, Leadership
Duration: <1 week
Pingahla Interview FAQs
Recently Viewed
INTERVIEWS
UST
No Interviews
SALARIES
HDFC Bank
SALARIES
Standard Chartered
REVIEWS
Standard Chartered
No Reviews
REVIEWS
Mahindra Finance
No Reviews
REVIEWS
UST
No Reviews
INTERVIEWS
UST
No Interviews
REVIEWS
Standard Chartered
No Reviews
SALARIES
IIFL Finance
DESIGNATION
Tell us how to improve this page.
Interview Questions for Popular Designations
- Technical Lead Interview Questions
- Technical Support Engineer Interview Questions
- Technical Specialist Interview Questions
- Member Technical Staff Interview Questions
- Technical Engineer Interview Questions
- Technical Analyst Interview Questions
- Technical Consultant Interview Questions
- Technical Architect Interview Questions
- Show more
HCLTech
Workplace transformation starts with you
Technical Manager Interview Questions from Similar Companies
|
Analyst
4
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Consultant
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Consultant
3
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
3
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Pingahla Interview Questions >
- Pingahla Technical Manager Interview Questions
