Hello Fellow Data Engineers,
Please guide me through this tough phase. I have been interviewing for past 4 to 5 months but didn't even get through the first round, let alone on site. Not sure what i am doing wrong but its so depressing. Never the less i lift myself up and keep grinding, hoping i will see light at the end of the tunnel.
I am heavy on Sql,ETL,Google cloud/Big Query and Airflow. I picked up python from code academy and solved easy string related questions on LC.
I have interviewed with Lyft, Affirm, Gusto, Facebook and some other companies. Failed at the tech screening. In retro, i realize there were some fairly easy questions which i didn't solve.
People who recently interviewed for Data Engineer position. Can you PLEASE shed some light on your preparation strategy ? What areas of python should i focus and how can i sharpen my sql skills to solve fast?
Please suggest the companies that you know hire/hiring DE.
YOE - 5 years
@Lyft @Facebook @Square @Amazon @Google @Apple @Twitter @Microsoft @Uber
Want to see the real deal?
More inside scoop? View in App
More inside scoop? View in App
blind
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
FOLLOWING
Industries
Job Groups
- Software Engineering
- Product Management
- Information Technology
- Data Science & Analytics
- Management Consulting
- Hardware Engineering
- Design
- Sales
- Security
- Investment Banking & Sell Side
- Marketing
- Private Equity & Buy Side
- Corporate Finance
- Supply Chain
- Business Development
- Human Resources
- Operations
- Legal
- Admin
- Customer Service
- Communications
Return to Office
Work From Home
COVID-19
Layoffs
Investments & Money
Work Visa
Housing
Referrals
Job Openings
Startups
Office Life
Mental Health
HR Issues
Blockchain & Crypto
Fitness & Nutrition
Travel
Health Care & Insurance
Tax
Hobbies & Entertainment
Working Parents
Food & Dining
IPO
Side Jobs
Show more
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
comments
Coding questions are hardly ever of high difficulty. Data Engineers focus way too much on them while prepping because they don't usually actively code in their job.
Here's my take on the important tech skills to master to crack DE interviews:
1. Data Modeling
2. Advanced SQL (performance tuning included)
3. Business/Product sense. Some companies call this module requirement gathering.
4. Programming. Strong basics - lists, dictionaries, tuples, strings etc. Don't waste time in tough problems.
Sorry in case i confused you. I guess what i am trying to ask is how do i get to a point to fetch data from a list or dictionary by coding, like i query a table using joins and aggregate. I understand we can use libraries like pandas, but sometimes we are not allowed to use libraries.
I have practiced LC easy string related questions and lists,dictionaries and strings on w3 resource but that's not enough to solve above scenarios i guess.
I can DM if you want me to. Python problems is where i am struggling so i really would like to sharpen my python skills for DE.
Recently I was asked to write a query to fetch slightly complicated data from a table. No problem,I came up with a couple of different joins and aggregation to get the result.
Now for coding, The same table was in a list with nested dictionaries. I had to come up with a python code to achieve the same result as sql query.