Ho presentato la mia candidatura online. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso EY (Bengaluru) nel mese di giu 2018
Colloquio
It was a walk-in interview... Interview questions were pretty easy.I was told I'm shortlisted and I'll get call within a week.But I didn't get any call and they didn't reply for my emails also.I think when we are spending so much time and giving an interview, it's basic discipline to call and tell us why they can't offer us a job.So that we can move on and start searching again.
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso EY (Poona) nel mese di mag 2023
Colloquio
3 rounds, client round was tough. First two rounds were very basic.
Rejected oppurtunity due to less pay.
Deep dive into past projects
Tools & technologies relevant to the role (e.g., Snowflake, Informatica, GCP)
Problem-solving and debugging
Scenario-based questions
Maybe a live coding exercise
Domande di colloquio [1]
Domanda 1
SCD Types | Conditions in Router
Types of LKP
Types of Caches
How did you optimise the performance?
Listagg
Set Operators
Union and Union All results for scenario
How to get non matching records?
Types of JOIN
Cross join count
Analytics Functions
SP vs Function
Where did you use it in your project?
How you design ETL Mapping?
How to replace all words in a file in UNIX?
Types of Schema
Facts and Dimensions
Documents prepared in your project
Have prepraed LLD/HLD
Scenario for LIKE Operator
Prmary vs Unique Key
How many nulls can unique key take?
Subquerry vs Corelated Diff
Rank Trans and USE
Why you use Primary key in SCD 2?
Parameters vs Variables Diff
Types of threads generated in your mapping?
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 6 giorni. Ho sostenuto un colloquio presso EY (Bengaluru) nel mese di mar 2016
Colloquio
I had 3 rounds of interview.First round was telephonic round which was a technical round after that i was called for F2F and again they had one more technical discussion.After that i had a manager round.
Domande di colloquio [1]
Domanda 1
They asked me about my role and responsibility in my previous organization.