Guidewire Software Interview Questions and Answers

Q1. All related to manual and automation testing and little about api nd performance testing too
Add your answer

Q1. Whatever u wrote on resume and some technical stuff with onsite guy
Add your answer

Q1. With your Mananger all related to resume and technical stuff
Add your answer

Q1. All hr questions
Add your answer

Q1. Salary discussion
Add your answer

Q1. Explain how you have done data modeling in you project and about Fact and Dimension table
Ans. 
Data modeling involves structuring data into Fact and Dimension tables for efficient analysis and reporting.
• Identified business requirements to determine key metrics and dimensions.

• Created a star schema with a central Fact table (e.g., Sales) linked to Dimension tables (e.g., Customer, Product).

• Fact tables store quantitative data (e.g., sales amount, quantity sold) while Dimension tables provide context (e.g., customer...read more
Answered by AI
Add your answer
Q2. How do you deal with late arriving dimensional data
Ans. 
Handling late arriving dimensional data involves strategies to ensure data integrity and accuracy in ETL processes.
• Implement a staging area to temporarily hold late arriving data before integration.

• Use surrogate keys to maintain historical accuracy when late data arrives.

• Apply business rules to determine how to handle late data, such as updating existing records or creating new ones.

• Example: If a new customer record ar...read more
Answered by AI
Add your answer
Q3. What is Normalisation and types of normalisation, explain them?
Ans. 
Normalization is a database design technique to reduce data redundancy and improve data integrity.
• 1NF (First Normal Form): Ensures that all columns contain atomic values. Example: A table with a 'Phone Numbers' column should have separate rows for each number.

• 2NF (Second Normal Form): Achieves 1NF and removes partial dependencies. Example: If a table has 'StudentID' and 'CourseID', the course name should be in a separa...read more
Answered by AI
Add your answer
Q4. Explain your project and work flow to business user in a business perspective not in technical terms
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced SQL Database Administrator with a strong background in managing databases and optimizing performance.
• Over 5 years of experience in SQL database administration

• Proficient in database design, implementation, and maintenance

• Skilled in performance tuning and troubleshooting

• Familiar with backup and recovery processes

• Certified in SQL Server administration
Answered by AI
Add your answer

Database Architecture, Cloud Architechture

Q1. Round with senior manager
Add your answer

Given one at home assignment to create a lwc component

Q1. How to have different pricing based on regions
Ans. 
Different pricing based on regions can be achieved by using price rules and custom fields in Salesforce.
• Create custom fields to store region information for each account or opportunity

• Use price rules to set different prices based on the region

• Utilize workflow rules or process builder to automate the pricing based on region

• Consider using custom metadata types for easier maintenance and scalability
Answered by AI
Add your answer
Q2. Parent to child relation in lwc
Ans. 
Parent to child relation in LWC refers to the relationship between a parent component and its child components in Lightning Web Components.
• Use @api decorator in child component to expose properties to parent component

• Use @track decorator in parent component to track changes in child components

• Communicate between parent and child components using events or properties
Answered by AI
Add your answer