Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 6 giorni. Ho sostenuto un colloquio presso Capgemini nel mese di giu 2025
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Nitesh Kumar Sharma
Extract only middle name from the string
Ho sostenuto un colloquio presso Capgemini (Hyderabad)
Colloquio
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
Domande di colloquio [1]
Domanda 1
Industry knowledge for the sector you are applying
Ho presentato la mia candidatura tramite un'altra fonte. Ho sostenuto un colloquio presso Capgemini
Colloquio
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?”
Ho sostenuto un colloquio presso Capgemini (Poona)
Colloquio
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.