Tata Consultancy Services Interview Question

ecruiter/HR screens for: Hands-on experience with Azure Data Factory (ADF), Synapse, Databricks, ADLS. Strong SQL & ETL background. Big data exposure (Spark, Delta Lake, pipelines). Cloud certifications (like DP-203) help. 2. HR / Recruiter Round Discussion about: Your background and projects. Why Azure, why data engineering? Basic behavioral questions: strengths, challenges, teamwork. Salary expectations, notice period. 3. Technical Screening (Round 1 – Online Test / Phone Call) Usually 45–60 minutes, focuses on: SQL queries (joins, window functions, ranking, CTEs, aggregation). Azure basics (ADF, ADLS, Synapse, Databricks). ETL concepts (incremental load, SCD, pipeline design). Sometimes a coding test (Python/SQL/Spark). 👉 Example questions: Write SQL to find duplicate rows. How to copy data from On-Prem SQL to Azure Synapse?