1. All C++ concepts (oop ,design patterns) 2. 25 horse 5 track puzzle 3. 3 unlabelled box and balls puzzle
Software Consultant Interview Questions
1,442 software consultant interview questions shared by candidates
situation questions, why did you apply to this role, why Capgemini?
The questions were fairly simple. They tested if I knew underlying architecture of the application, my experience with developing interface, reports and extensions. They also asked me few questions related to upgrade. 1. About my experience in PeopleSoft upgrade projects? 2. Do you have any experience in Component Interface(CI)? 3. What mode you inserted the job data? 4. If an employee has 4 job data rows in a file. And you are trying to load into job using component interface. Which mode you will use? 5. What tables in Job Data component you updated using CI? 6. My experience in PeopleSoft upgrade? 7. About Retrofit? 8. Which module you retrofitted? 9. About TAM and Candidate Gateway(CG)? 10. What does decode does in SQL statement? 11. About SQR and How do send emails in SQR? 12. About Rowset and How many rows &rsRow1 has? 13. Tell me about one experience when you migrate data using component interface during upgrade! 14. What are the tables you used for that component? 15. How you throw exceptions or errors during that process? 16. How you setup security for the component interface before testing it? 17. Discussion about are the standard properties in Component Interface? 18. When you prefer to use state records than temporary tables? 19. Two questions on people code events! 20. Why we get arithmetic overflow error while executing AE? 21. Some discussion about row by row and set processing. 22. Which statement we used to retrieve data from State Record? 23. About restart facility in AE! 24. Tracing and debugging options for Application Engine. 25. What is the people code command to send an email notifications? 26. How exception handling was done in AE?
If you came up against a tough problem, potentially outside your comfort zone, how would you go about solving/getting past it?
Select query, concept of views index, Joins
Why you want to join? If you have option of other MNC like Oracle which one you join ?
Why you want to join our company?
Architect Round: explain each of your algo and code. Run and test boundary values.
Selenium Programs/ Algo: Write a framework for one of their application. The application is very tricky and includes everything like: Alerts, frame/iframes, tables, ajax loading and duplicate identifiers.
Programs/ Algo: take any integer number, convert to an unique string such as: 0 is replaced by A, 1 by B and so on. But any duplicate entries should be avoided i.e if there are two 1s in the input, B will be taken once. Once the digits are traversed, take two digits at a time and follow the same rule. [String conversion and comparison can not be used]
Viewing 1431 - 1440 interview questions