Pregunta de entrevista de Capgemini

One key thing they asked me was how I validate ETL data in Azure Databricks, including source-to-target mapping, record count verification, and applying business rules.

Respuesta de la entrevista

Anónimo

19 feb 2026

I explained that I first validate the source-to-target mapping documents, then write SQL queries in Databricks to compare source and target data. I perform record count checks, null and duplicate validations, and verify complex transformations using business rules. Any mismatches are documented as defects.