I applied through a recruiter. The process took 6 days. I interviewed at Capgemini in Jun 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
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?”