I applied online. The process took 1 day. I interviewed at EY (Bengaluru) in Jun 2018
Interview
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.
I applied online. The process took 2 weeks. I interviewed at EY (Pune) in May 2023
Interview
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
Interview questions [1]
Question 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?
I applied through an employee referral. The process took 6 days. I interviewed at EY (Bengaluru) in Mar 2016
Interview
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.
Interview questions [1]
Question 1
They asked me about my role and responsibility in my previous organization.
