Upload Button Icon Add office photos

Filter interviews by

Crystal Solutions Software Engineer Interview Questions and Answers

Updated 4 Apr 2023

Crystal Solutions Software Engineer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Apr 2022. There were 3 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 - Technical 

(1 Question)

  • Q1. Why do you want another job ?
Round 3 - HR 

(1 Question)

  • Q1. Talk about your experience previous

Interview Preparation Tips

Interview preparation tips for other job seekers - Smooth interview with lot of question about your experience and qualification on your resume

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Like c# oops dotnet sqlserver basic questions
Round 2 - HR 

(1 Question)

  • Q1. Why you want to change
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for opportunities to work on cutting-edge technologies

    • Seeking a more collaborative team environment

    • Interested in expanding my skill set and taking on new responsibilities

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

(2 Questions)

  • Q1. Tree graph DFS BFS and DS,
  • Q2. Basic of progaramminggg

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing good to go. bhal h blha blah blbha;b hablabha

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

10 Questions

  • Q1. Last working Project
  • Q2. Page life cycle of asp.net
  • Ans. 

    ASP.NET page life cycle is a series of events that occur when a page is requested, processed, and rendered.

    • Page request is received by the server

    • Page is initialized and controls are created

    • Page is loaded with data and events are triggered

    • Page is rendered and sent to the client

    • Page is unloaded and disposed

  • Answered by AI
  • Q3. Oops concept
  • Q4. Javascript releted concept
  • Q5. Session & cookies releted
  • Q6. Web.config &machine.config
  • Q7. Sql questions
  • Q8. Join in sql
  • Ans. 

    Join in SQL is used to combine rows from two or more tables based on a related column between them.

    • Join is used to retrieve data from multiple tables based on a related column

    • Types of join include inner join, left join, right join, and full outer join

    • Syntax: SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name = table2.column_name

    • Example: SELECT customers.name, orders.order_id FROM customers JOIN orders

  • Answered by AI
  • Q9. Views in sql
  • Ans. 

    Views in SQL are virtual tables that are based on the result of an SQL statement.

    • Views are created using the CREATE VIEW statement.

    • They can be used to simplify complex queries.

    • Views can be used to restrict access to sensitive data.

    • They can also be used to provide a consistent interface to data from multiple tables.

    • Views are updated automatically when the underlying tables are updated.

  • Answered by AI
  • Q10. Function in sql
  • Ans. 

    A function in SQL is a reusable block of code that performs a specific task.

    • Functions can be used to manipulate data, perform calculations, and return values.

    • They can be created using the CREATE FUNCTION statement.

    • Functions can be called within SQL queries or used in stored procedures.

    • Examples of SQL functions include AVG, COUNT, and CONCAT.

    • Functions can also be user-defined, allowing for custom functionality.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was a technical one but was majorly a stress test. It was for about 1 hour .most of the questions asked to me were rileted to my project and my work last work.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Difference between functions and stored procedure in SQL.
  • Ans. 

    Functions return a single value while stored procedures can perform multiple operations and return multiple values.

    • Functions return a single value while stored procedures can return multiple values.

    • Functions are used for computations and return values, while stored procedures are used for executing a series of statements.

    • Functions can be called from within SQL statements, while stored procedures are called using the EX...

  • Answered by AI
  • Q2. Difference between abstract class and Interface in C#
  • Ans. 

    Abstract class can have implementation details, while interface only contains method signatures.

    • Abstract class can have constructors, fields, and methods with implementation details, while interface can only have method signatures.

    • A class can inherit from only one abstract class, but can implement multiple interfaces.

    • Abstract classes are used when some common functionality needs to be shared among multiple classes, whi...

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2022. There were 3 interview rounds.

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 - Technical 

(2 Questions)

  • Q1. Roles & Responsibilities
  • Q2. Roles & Responsibilities
Round 3 - Client Interview 

(1 Question)

  • Q1. What are your strengths & weakness

I applied via Naukri.com 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 - Technical 

(2 Questions)

  • Q1. Basics concepts of java 1.8 like string concept, collection concept, java 1.8 features etc
  • Q2. Question from springboot like configuration of springboot, spring IOC lifecycle, hybernate connection syntax in springboot
Round 3 - HR 

(1 Question)

  • Q1. My current ctc, why I want to change my present company, preferred location etc,.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just keep the basics of both java 1.8 and springboot notes in your mind then you can crack the interview.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Tree graph DFS BFS and DS,
  • Q2. Basic of progaramminggg

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing good to go. bhal h blha blah blbha;b hablabha

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

10 Questions

  • Q1. Last working Project
  • Q2. Page life cycle of asp.net
  • Ans. 

    ASP.NET page life cycle is a series of events that occur when a page is requested, processed, and rendered.

    • Page request is received by the server

    • Page is initialized and controls are created

    • Page is loaded with data and events are triggered

    • Page is rendered and sent to the client

    • Page is unloaded and disposed

  • Answered by AI
  • Q3. Oops concept
  • Q4. Javascript releted concept
  • Q5. Session & cookies releted
  • Q6. Web.config &machine.config
  • Q7. Sql questions
  • Q8. Join in sql
  • Ans. 

    Join in SQL is used to combine rows from two or more tables based on a related column between them.

    • Join is used to retrieve data from multiple tables based on a related column

    • Types of join include inner join, left join, right join, and full outer join

    • Syntax: SELECT column_name(s) FROM table1 JOIN table2 ON table1.column_name = table2.column_name

    • Example: SELECT customers.name, orders.order_id FROM customers JOIN orders

  • Answered by AI
  • Q9. Views in sql
  • Ans. 

    Views in SQL are virtual tables that are based on the result of an SQL statement.

    • Views are created using the CREATE VIEW statement.

    • They can be used to simplify complex queries.

    • Views can be used to restrict access to sensitive data.

    • They can also be used to provide a consistent interface to data from multiple tables.

    • Views are updated automatically when the underlying tables are updated.

  • Answered by AI
  • Q10. Function in sql
  • Ans. 

    A function in SQL is a reusable block of code that performs a specific task.

    • Functions can be used to manipulate data, perform calculations, and return values.

    • They can be created using the CREATE FUNCTION statement.

    • Functions can be called within SQL queries or used in stored procedures.

    • Examples of SQL functions include AVG, COUNT, and CONCAT.

    • Functions can also be user-defined, allowing for custom functionality.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was a technical one but was majorly a stress test. It was for about 1 hour .most of the questions asked to me were rileted to my project and my work last work.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Dimensional modelling, Snowflake model , star transformation model query tuning
  • Q2. Etl

Interview Preparation Tips

Interview preparation tips for other job seekers - They hire for clients ,the interview depends on projects

Crystal Solutions Interview FAQs

How many rounds are there in Crystal Solutions Software Engineer interview?
Crystal Solutions interview process usually has 3 rounds. The most common rounds in the Crystal Solutions interview process are Resume Shortlist, Technical and HR.

Tell us how to improve this page.

People are getting interviews through

based on 1 Crystal Solutions interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Network Security Engineer
11 salaries
unlock blur

₹3.1 L/yr - ₹4.2 L/yr

Technical Support Executive
9 salaries
unlock blur

₹1.8 L/yr - ₹4.2 L/yr

Talent Acquisition Specialist
7 salaries
unlock blur

₹1 L/yr - ₹3.4 L/yr

Resource Executive
7 salaries
unlock blur

₹1 L/yr - ₹5.5 L/yr

SOC Analyst
6 salaries
unlock blur

₹3 L/yr - ₹3.2 L/yr

Explore more salaries
Compare Crystal Solutions with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
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