I applied online. I interviewed at Capgemini in Jun 2025
Interview
the interview process typically includes made resume screening ,technical rounds , final HR Discussion before the offer is made. Then i received the official offer with compensation ,role details and joining instruction
Interview questions [1]
Question 1
1.in sql diff between View and Materialized view and rank
2.Find the top 3 highest paid employees in each department
3 rounds. First round was on industry knowledge. Second round was detailed where they checked my skills on preparation ppt. Third was were I was given case study based on which I prepared deck and gave presentation
Interview questions [1]
Question 1
Industry knowledge for the sector you are applying
I applied through other source. I interviewed at Capgemini
Interview
2round of technical discussion .Specific domain related question.problem solving skills and architecture questions. For SAP Datasphere developers, questions are commonly around:
* Datasphere architecture
* Replication Flow vs Data Flow
* BW Bridge
* Space management
* Analytical Models
* Graphical Views
* SQL views
* Performance tuning
* SAC connectivity
* Delta loads
* Cloud Connector / DP Agent
* Authorization concepts
Scenario-based questions are very common.
Example:
* “Graphical View has data but Analytical Model shows blank — how do you troubleshoot?”
* “How will you optimize ACDOCA-based models?”
* “Difference between federation and replication?”
* “How do you handle joins causing duplication?”
It is an very good interview process and the hr is straightforward and the technical questions which are asked are good and they are very in detailed and the interviewer covered almost all the topics.