Upload Button Icon Add office photos

Filter interviews by

Pingahla Technical Manager Interview Questions and Answers

Updated 1 Jun 2022

Pingahla Technical Manager Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed in Dec 2021. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. It was a discussion related to my experiences, past projects and skills.
Round 2 - Technical 

(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

  • Answered by AI
  • 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

  • Answered by AI
  • Q3. 3 Scenario based SQL questions
  • Q4. 3 scenario based ETL question
  • Q5. DB partitioning and indexes
Round 3 - One-on-one 

(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

  • Answered by AI
  • Q2. Puzzle on shortest path

Interview Preparation Tips

Topics to prepare for Pingahla Technical Manager interview:
  • Informatica
  • SQL
  • Dimension modelling
  • SQL Server
Interview preparation tips for other job seekers - Study the basic concepts well because many scenario based questions can be solved by applying them.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Case Study 

Please share your experience where you went beyond customer expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Follow STAR methodology to answer questions related to case study
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Scenario based - how to prevent multiple spam requests
  • Ans. 

    Implementing CAPTCHA verification can prevent multiple spam requests.

    • Implement CAPTCHA verification on the website forms to ensure that only humans can submit requests.

    • Use rate limiting to restrict the number of requests from a single IP address within a certain time frame.

    • Utilize machine learning algorithms to detect and block spam requests based on patterns and behavior.

    • Regularly update spam filters and security meas

  • Answered by AI
  • Q2. What is your Technical project management style?

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Technical architecture read out
  • Q2. Architecture optimization
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic Java 8 questions
Round 2 - HR 

(1 Question)

  • Q1. Basic HR questions
Interview experience
4
Good
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Datagaurd concepts Golden gate concepts
Round 3 - Technical 

(1 Question)

  • Q1. Cloud questions Performance tuning
Round 4 - HR 

(1 Question)

  • Q1. About yourself Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - HCL interview is easy to crack . Clear basics questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic of Azure Paas resources like Azure Function, Service Bus etc.
  • Q2. API Design Patterns used in development
  • Ans. 

    API design patterns are essential for creating scalable and maintainable APIs.

    • RESTful design pattern is commonly used for creating APIs that are easy to understand and use.

    • Singleton pattern can be used to ensure only one instance of an API object is created.

    • Factory pattern can be used to create different types of API objects based on input parameters.

    • Observer pattern can be used to notify multiple objects when the stat

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

(2 Questions)

  • Q1. How Azure Logic apps is configured and pricing
  • Ans. 

    Azure Logic Apps is a cloud service that helps you automate and orchestrate tasks, business processes, and workflows.

    • Azure Logic Apps can be configured through the Azure portal or using Visual Studio.

    • Pricing for Azure Logic Apps is based on the number of executions and connectors used.

    • There are different pricing tiers available, such as Consumption and Standard plans.

    • You can estimate the pricing using the Azure pricing...

  • Answered by AI
  • Q2. Azure API management and policies configured in API management
  • Ans. 

    Azure API management allows for configuring APIs and applying policies to control access and behavior.

    • Azure API management provides a centralized platform to manage APIs and enforce policies.

    • Policies can be used to control access, modify requests and responses, and enforce security.

    • Examples of policies include rate limiting, authentication, caching, and transformation.

    • API management helps in monitoring API usage, analy...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Aug 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Technical interview related to CUCM, VG, CUC, SIP and mgcp protocols
Round 3 - Technical 

(1 Question)

  • Q1. SIP DETAILED QUESTIONS, CUC CALL HANDLER, UCCX , JABBER CALL FLOW, MRA, REAL TIME SCENARIO BASED QUESTION
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation and general HR questions

I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Brief about yourself, Your Experience, your job profile and your achievements.
  • Q2. Why you should join the HDFC Bank?
Round 3 - One-on-one 

(1 Question)

  • Q1. Introduction about yourself, your job journey, your achievements and work experience.

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence level Up, don't Hesitate and Good Speaking in English.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Asked to create array program

Round 2 - Technical 

(1 Question)

  • Q1. Basic opps thread task design pattern solid principle

Interview Preparation Tips

Interview preparation tips for other job seekers - Awesome experience only take time to provide offer letter

Pingahla Interview FAQs

How many rounds are there in Pingahla Technical Manager interview?
Pingahla interview process usually has 3 rounds. The most common rounds in the Pingahla interview process are HR, Technical and One-on-one Round.
What are the top questions asked in Pingahla Technical Manager interview?

Some of the top questions asked at the Pingahla Technical Manager interview -

  1. Design a DWH for a University and explain the relationships between tabl...read more
  2. Dimension modelling and their pros and c...read more
  3. Optimization in data loading techni...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Pingahla interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Analyst
4 salaries
unlock blur

₹5 L/yr - ₹8.4 L/yr

Consultant
4 salaries
unlock blur

₹12.5 L/yr - ₹19 L/yr

Senior Consultant
3 salaries
unlock blur

₹15 L/yr - ₹22 L/yr

Data Analyst
3 salaries
unlock blur

₹10 L/yr - ₹17 L/yr

Explore more salaries
Compare Pingahla with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview