I applied through a recruiter. The process took 6 days. I interviewed at Capgemini in June 2025
Interview
The technical interview process primarily focused on evaluating my hands-on experience in ETL testing, SQL, and data validation. It usually started with a deep dive into my previous project work—especially around the data migration and transformation scenarios I handled. I was asked to explain end-to-end ETL flow, how I validate source-to-target mappings, and how I handle incremental loads.
SQL questions were quite detailed — involving joins, window functions, aggregations, and writing queries to troubleshoot mismatches between staging and target layers. There were also scenarios around data quality, data profiling, and how I handle nulls, duplicates, or truncation issues.
Interview questions [1]
Question 1
Nitesh Kumar Sharma
Extract only middle name from the string
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.