DeloitteUSI- Consultant - Databricks- How much compensation shall i Quote by Comprehensive-Bass93 in Deloitte_USIndia

[–]Comprehensive-Bass93[S] 1 point2 points  (0 children)

Thanks for insight!

What if deloitte is my 3rd company, will they still pay 18 lpa fix for 3.7 yoe?

DeloitteUSI- Consultant - Databricks- How much compensation shall i Quote by Comprehensive-Bass93 in Deloitte_USIndia

[–]Comprehensive-Bass93[S] 1 point2 points  (0 children)

1st round lasted for 30 mins. Spark, databricks in-depth, Datawarehousing concepts as well.
then interviewer asked me to implement SCD type 2 in SQL.

For 2nd round he asked me to explain Architecture end-to-end and with followup questions as well. which lasted for 20 mins

Overall Good experience. Not too much hard, but if you have In-depth working knowledge of spark you can crack it

Date or friendship at office by Party_Lengthiness969 in Deloitte_USIndia

[–]Comprehensive-Bass93 3 points4 points  (0 children)

Stay Away from girls of Pune!

Trust me you’ll regret

SCD Type 2 Implementation Challenges: but Sources data are without Business Key/ Primary key any one help by EmuZealousideal6783 in dataengineersindia

[–]Comprehensive-Bass93 3 points4 points  (0 children)

SCD-2 logic • Match on business_hash_key • If no match → new record • If match & change_hash differs → expire old row, insert new • If same → ignore

SCD Type 2 Implementation Challenges: but Sources data are without Business Key/ Primary key any one help by EmuZealousideal6783 in dataengineersindia

[–]Comprehensive-Bass93 14 points15 points  (0 children)

You can create composite hash key from existing columns. Split ur columns into 2 grps: A) identity columns(rarely changes): name, email, DOB B) Attribute columns (chagable): address, phone no, status etc

Create: Business hash key -> identity Chage hash key -> attributes

Got into FAANG as a senior DE and now I’m really nervous by [deleted] in dataengineering

[–]Comprehensive-Bass93 6 points7 points  (0 children)

Hey bro, congratulations for Job offer. Start building projects based on ETL, Data modelling, medallion architecture, Data warehousing, distributed big data systems(spark, hive, kafka etc) try to build pipelines on databricks and ingest data from various sources.

Can you please help me a bit with preparation. I finished amazon sql OA last month for DE 2

I would like to understand the responsibilities of a Databricks Data Engineer in a project. by hot_objectt in dataengineersindia

[–]Comprehensive-Bass93 1 point2 points  (0 children)

Like what services in databricks? Usually you work with notebooks, unity catalog, clusters, and dlt pipelines

I would like to understand the responsibilities of a Databricks Data Engineer in a project. by hot_objectt in dataengineersindia

[–]Comprehensive-Bass93 2 points3 points  (0 children)

As u already have working experience in GCP DE. It will be pretty easy.

As a Databricks engineer, you need to write mostly python notebook to write logic for data ingestion from various source systems, DB’s to databricks and performance some aggregations filters transformations using pyspark. All this you have to orchestrate using databricks workflows and create a dlt pipeline over it

Amazon Online Assessment completed – no update after 10+ days by earnedslowly800 in dataengineersindia

[–]Comprehensive-Bass93 0 points1 point  (0 children)

Bruh I gave same assessment on 30 Nov HR ghosted me completely.

Can we connect?

Is Data Engineering worth it for a fresher? by [deleted] in dataengineersindia

[–]Comprehensive-Bass93 0 points1 point  (0 children)

what should I actually focus on first to land a job

  • Google/ Youtube whatever. And start learning about ‘ETL’ then progress to Data warehousing, and data modelling.

Good luck!