I applied through a recruiter. The process took 1 week. I interviewed at Capgemini (Bengaluru) in Aug 2025
Interview
The interview process had three rounds – initial HR screening, technical discussion focusing on SQL, Python, and data engineering concepts, followed by a managerial round. The panel was professional and the process was smooth and structured
Interview questions [1]
Question 1
Can you explain the difference between dense rank and rank in SQL?
How do you handle challenges when working with very large datasets?
Was good.Consisted of multiple discussion rounds , face to face meeting and testing before the final offer was given Had a good experience with the hiring team and the flow was seamless.
Interview questions [1]
Question 1
They asked me about Experience,,Skills and Technology understanding
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?”