Add office photos
Filter interviews by
Sunrays Consulting Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
Interview experience
Good
Difficulty level
Moderate
Process Duration
-
Result
No response
I was interviewed in Dec 2024.
Round 1 - Technical
(27 Questions)
- Q1. Tell me about yourself
- Q2. Have you ever worked on devops
- Q3. How do you deploy tags in Jenkins and UCD
- Q4. What you will do if you get a production issue
- Q5. If the respective team is responsible to resolve an issue and they are not supporting you because of their priority items what you will do
- Q6. What is .Net Framework
- Q7. What is c#
- Q8. Page life cycle of ASP.NET and explanation
- Q9. OOPS Concept and Encapsulation Example
- Q10. Value type and Ref Types
- Q11. Constant and ReadOnly
- Q12. How can you delete the duplicate values in a table
- Q13. Difference between group by and having/ union and union all
- Q14. Query to select last 5 records in a table
- Q15. What is SMTP and what is the name space for that
- Q16. Mention few name spaces you have used in your code
- Q17. What is WEB API
- Q18. Why WEB API is crucial over Web Services
- Q19. How do you provide Security to your WEB API
- Q20. What is Authentication and Authorization
- Q21. What is difference between JSON and XML
- Q22. Filters in MVC
- Q23. What is MVC
- Q24. What is Routing in MVC
- Q25. How an application Interact with API
- Q26. Architecture of API
- Q27. What is HTTP
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Go through the job description and find out what are they expecting from you, Prepare based on that.
I would say covering most of the topics in terms of definition would be the first thing we have to do, Then if you are sure about the definitions add example program for every definition by understanding the usage and functionality
I would say covering most of the topics in terms of definition would be the first thing we have to do, Then if you are sure about the definitions add example program for every definition by understanding the usage and functionality
Interview experience
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Round 1 - Aptitude Test
Common aptitude questions on mettl platform
Round 2 - Technical
(3 Questions)
- Q1. Python Standard interview questions
- Q2. SQL Standard interview questions (Easy)
- Q3. CaseStudy and questions based on it.
Add your answer
Add your answer
Add your answer
Round 3 - HR
(3 Questions)
- Q1. Common hr questions
- Q2. Puzzles
- Q3. Project Discussion
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for ZS Junior Analyst interview:
So confirm with the hr before even attending the interviews.
- Python
- SQL
- R
So confirm with the hr before even attending the interviews.
Interview experience
Bad
Difficulty level
Hard
Process Duration
6-8 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Nov 2024. There were 3 interview rounds.
Round 1 - One-on-one
(1 Question)
- Q1. Time you worked under pressure, with a team
Add your answer
Round 2 - Assignment
Writing Sample based on HBR
Round 3 - Case Study
Case study on 4 day work week using RCA
Interview Preparation Tips
Interview preparation tips for other job seekers - There were four rounds of interviews, starting with one hour behavioural around, writing sample, case study and final interview for cultural fit. The overall recruitment process is very disorganised as I applied for this role in October before Diwali and the HR got back to me in November end. It's almost as of September 2024 they have this position open and cannot fill it up I had qualified until the case study round which was a very negative experience overall the interviewer was from a senior position. This round requires you to have business acumen and use the RCA technique to perform well enough. It seems to me that the expectations are unreasonably high for a fresher level role and they want someone who is a jack of all trades and they don't have to provide the necessary training once the person joins. Worst, they called their recruitment process a very high standard as an excuse but this is a very wrong culture, especially for freshers starting their career as they're looking for highly technical skills. My writing sample and behaviour round went super well but the ultimate deciding factor for them was the case study round. I think it just shows how rigid they are and how they willingly ignore my other capabilities and stuck on that one round to make a decision. Would have been better if they just took the case stud round first if they were so specific on that skill set instead of wasting my time. The interviewer for the case study round was very rude and over confident on his skills and expertise that he wasn't willing to fully listen to me or let me complete my answer it felt like he already knew he didn't find me a fit. Gartner could be a good organisation overall but I think individuals in this company such as the one interviewing for this role is not doing any justice to the good reputation.
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Round 1 - Technical
(2 Questions)
- Q1. Big data , Optimization , Python basic , SQL intermediate
- Q2. Find max and min number without sorting Joins related Big data handling Optimization question
Add your answer
Add your answer
Round 2 - Technical
(2 Questions)
- Q1. Schema , python , sql
- Q2. Case study sql and python based
Add your answer
Add your answer
Round 3 - Case Study
Sales data from a leading manufacturer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 6 interview rounds.
Round 1 - HR
(2 Questions)
- Q1. Past experience ?
- Q2. Market Research questions?
Add your answer
Add your answer
Round 2 - Technical
(3 Questions)
- Q1. Market Sizing, Qualitative and quantitative?
- Q2. SWOT, PESEL and other tool
- Q3. Data collection process Primary/Secondary
Add your answer
Add your answer
Add your answer
Round 3 - Assignment
Market Report on any topic, which includes Market Sizing, SWOT, other analysis
Round 4 - One-on-one
(2 Questions)
- Q1. Technical questions about market research?
- Q2. Interview questions related to past experience
Add your answer
Add your answer
Round 5 - One-on-one
(2 Questions)
- Q1. General interview with Manager
- Q2. Salary discussion and company overview
Add your answer
Add your answer
Round 6 - Aptitude Test
Quantitative, reasoning, english and behavioral questions
Interview Preparation Tips
Interview preparation tips for other job seekers - Go through your experience in detail, prepare general market research QNA, along with technical QNA. Just be confident about what you have done in past and try to be honest.
vinay kn
Interview experience
Good
Difficulty level
Moderate
Process Duration
-
Result
No response
I was interviewed in Dec 2024.
Round 1 - Technical
(6 Questions)
- Q1. What is spark,explain its ecosystem
- Q2. What are transformations, and how many types of transformations exist?
- Q3. Explain about spark job process and its planning
- Q4. What are the concepts of coalesce and repartition in data processing?
- Q5. Explain about oom and driverhead memory
- Q6. What is data skewness
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected
I was interviewed in Dec 2024.
Round 1 - One-on-one
(2 Questions)
- Q1. Technical Accounting Questions
- Q2. Technical Accounting Questions
Add your answer
Add your answer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I applied via campus placement at National Institute of Technology (NIT), Warangal and was interviewed in Nov 2024. There were 3 interview rounds.
Round 1 - Aptitude Test
Normal to medium level general aptitude questions
Round 2 - Technical
(2 Questions)
- Q1. Types of building contract
- Q2. Type of soil for each buildings
Add your answer
Add your answer
Round 3 - One-on-one
(2 Questions)
- Q1. Assesment day GD for 2 rounds
- Q2. All situational based questions
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for WSP Due Diligence Analyst interview:
- Building contracts
- Soil Mechanics
Interview experience
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Round 1 - Coding Test
Asked coding questions on Python and SQL
Python - find longest non repeating substring
SQL - join and window function
Round 2 - Assignment
Develop a production-grade application in Python that analyzes data and provides answers to questions based on the dataset.
Round 3 - Technical
(2 Questions)
- Q1. System design and project based questions
- Q2. Scenario-based questions that can help assess how you handle various situations
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for BCG Data Engineering Lead - BCG X interview:
- Coding
- System Design
- Managerial
Dhiraj Dhande
Interview experience
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical
(5 Questions)
- Q1. What is Derivatives
- Q2. What is financial Markets
- Q3. V Lookup, X Lookup, H lookup
- Q4. Experience in SQL And Power bi
- Q5. Internship Experience
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Sunrays Consulting Interview FAQs
How to prepare for Sunrays Consulting interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sunrays Consulting. The most common topics and skills that interviewers at Sunrays Consulting expect are API Gateway, AWS Lambda, Chatgpt, Credit Cards and Customer Segmentation.
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Compare Sunrays Consulting with
Deloitte
Compare
Ernst & Young
Compare
PwC
Compare
KPMG India
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Sunrays Consulting Interview Questions
Share an Interview