Accenture · Primly Community

Accenture data engineer interview, pipelines and SQL: my full experience from Feb 2026

de_derek · 4 replies

went through the Accenture data engineer interview process earlier this year for a senior DE position on one of their cloud migration teams. posting this because the DE-specific experience is harder to find than the SWE or analyst content.

process was 3 rounds after the recruiter screen.

first technical round (60 min): heavy SQL. we covered CTEs, window functions, and a tricky problem involving recursive CTEs to traverse a hierarchy. I'll be honest, I had to think out loud on the recursive one. they were fine with that, seemed interested in how I reasoned through it. also got a question about database normalization: when do you denormalize and why. good old data warehouse tradeoffs.

second technical round (60 min): pipeline architecture. they gave me a scenario: a client gets a 500GB CSV dump every night and needs it queryable by 9am. walk me through the architecture. I talked through ingestion (landing zone in S3 or ADLS), transformation (Spark or dbt depending on client stack), orchestration (Airflow), monitoring, and SLAs. they probed on what happens when the file is late, what happens when it has schema drift, and how I'd alert the client team. real-world messy stuff. no LeetCode algorithms.

behavioral round (45 min): lots of delivery-focused questions. "tell me about a pipeline that failed in production and how you handled it." "describe how you managed expectations with a non-technical stakeholder when a project slipped." Accenture cares a lot about client-facing skills even for technical roles. if you have zero client communication experience, at least prepare stories that show you explained technical things to non-engineers.

no take-home. no system design whiteboard in the FAANG sense. the architecture discussion replaced that.

the tech stack on the job is pretty fluid: Azure, GCP, Snowflake, Databricks depending on whatever the client uses. so they're evaluating cloud-agnostic reasoning rather than specific tool mastery.

offer for senior DE came in at ~$130k base in a mid-tier city. consulting firms tend to have narrower bands than big tech but the project variety is real.

4 replies

sre_sol

the schema drift question is so real. every pipeline I've ever touched has broken because upstream changed a column name with zero notice. good that they're testing for it.

ops_omar

did the behavioral round feel like it screened people out, or was it more of a formality? asking because I have a strong DE background but my client-facing experience is limited.

de_derek

honest answer: I think it screens people out more than it looks like. the behavioral questions at Accenture are evaluated as part of fit for consulting delivery, not just as a box-check. I'd spend real time on it. have 3-4 solid STAR stories ready, especially anything where you navigated ambiguity or communicated a technical problem to business stakeholders.

backend_bekah

the 500GB CSV at 9am scenario is such a classic consulting data engineering problem. I've lived that exact scenario twice. nice to hear it shows up in interviews.