Profile picture

Side Projects Q&A and Videos

About Side Projects

Learning new Tools for Interviews?

Data Engineer at Financial Company profile pic
Data Engineer at Financial Company

I'm a Data Engineer. Within the data engineering realm, there are a lot of tools, just like in the software engineering realm. The modern data stack is pretty popular these days. It includes things like Spark for ETL at scale, Docker for virtualized environments, Airflow for orchestration, dbt (data build tool) for transformations in SQL, Fivetran for automated data connectors, Snowflake for data warehousing, and more.

I'm far from knowing all of these tools well, primarily because I use very few of them in my day job. The main reason I want to change jobs is because of this.

I'm worried I'm caught in a catch-22 situation where I don't know the tools so I can't get jobs that have them, which I guess is similar to the new-grad cold start problem.

My question is, how should I think about learning new tools for job interviews? My current instinct is to learn via failure. That is, I have almost all of the above tools on my resume. If someone asks me about them and I'm not able to give a good answer, I will learn that part about the tool so if I'm in the same situation I can answer properly.

Another approach I can think of is to do Udemy courses of them so I have a deeper understanding of how they work. I've learned to be wary of course not tied to projects, though, so I'm hesitant.

I guess I could do projects to learn more about them, but those take time and right now I'm focused on applying to jobs.

I imagine some answers might focus on what my current problem is: can I get interviews or am I failing interviews? I don't think my issue is with failing interviews right now, and certainly not because of specific knowledge people have called me out for for not knowing these tools. I think my issue is more with sourcing interviews currently.

If there's general advice regarding how to think about prepping for an interview when you only have some of the requirements on the Job Description, would love to hear that too.

Thanks!

Show more
Posted a year ago
88 Views
3 Comments

What legal documents do I need to provide before joining FAANGMULA on an existing side hustle?

Mid-Level Software Engineer at Other profile pic
Mid-Level Software Engineer at Other

Today during office hours Rahul talked about this a tiny bit (sans the legal), but I'm curious as I've had many friends who worked at Google previously that discouraged me from applying to Google (like 10 years ago) if I still wanted to do a startup (this was long before Area 120 was a practiced thing). Recently, a friend (VC whose girlfriend works at Google) said many people still build venture/angel funds on the side while still working full time for Google. But of course, don't create your startup company using company property (a la Silicon Valley HBO lessons).

Questions

(1) What companies are flex about having things on the side - a side hustle (but you can't advertise it), examples being two different companies on both ends of the spectrum: Google, Apple etc.)? I've heard some FAANGMULA companies are more stringent than others (Apple being very much against this and super private and only sorta kind supporting open source, vs. others which are all for it and have accelerator/internal incubator programs at the company (Area 120), or even sponsoring ex-employees (a cohort of my class at Verizon Ventures one year was all MIT alumni, ex-Googlers that were sponsored by Google, paid their incorporation fees, I was one of the two weird VR founder people).

(2) I've also heard that from friends if you work at Google, you are not allowed to get paid for speaking gigs on your technical expertise or whatever your functional role is at that company (this differs from from Meta I've heard from other friends). Is this true?

(3) If you go into a FAANGMULA company, what info (legally) what information do you need to provide the the employer? What docs from the state/federal/govt or whatever) that says you have a a DBA, LLC, S/C-Corp etc. What do you need to disclose more specifically and what documentation and legal paperwork do you have to provide?

For example, I currently take consultations and speaking gig money and have revenue (royalties from my book I published years ago) and plan on having an existing app that generates money in the app store that is runs auto-pilot prior to coming into the company. Also note, that I'm aware that this product should not compete with the company's main product lines.**

(4) If you are going to start all this AFTER being hired into FAANGMULA, how do you inform your company employer formally (HR, direct report boss), and that your side hustle does and will not interfere with your primary role at the FAANGMULA company hour wise and that you will still meet all of your core duties/goals/tasks/deadlines for the company and this is sort of 'hack on the weekends thing?'

Show more
Posted a year ago
79 Views
3 Comments

Would an "unfinished" project(s) be worthy to present in interviews?

Entry-Level Software Engineer at Unemployed profile pic
Entry-Level Software Engineer at Unemployed

Hi there, everybody. I was aiming to build a few applications to present in interviews. Last week, I was building a small-scale Spring Boot application with the help of a tutorial. The project I was working on was meant to retrieve data from a database using PostgreSQL to provide multiple choice DSA questions. I was creating an automated study buddy for technical interviews. Unfortunately, I've been trying to figure out some technical issues and database connectivity mishaps for some days, unfortunately to no avail. Currently, I'm working through a Node.Js tutorial to build an application geared to help me keep track of the things I'd like to do during my job search, so I can always stay on task. I don't know if I'm going to run into some more issues that plague me.

The thing is, I'm learning a LOT from both experiences. Now I feel I can have an educated conversation on the trade-offs of monolithic and microservice architectures... and I LOVE what I'm learning. I'd really like to have at least 3 small-scale projects handy that I'm using to automate my own life and make this job search easier for me.

Of course I'm going to continue to try to plow through these issues, and I'm not here to necessarily ask for help with my applications (although I won't say no if someone wants to help). It'd be great if I can explain how I solved these problems, because I know the challenging problems I've solved are what I'd want to highlight to people in an interview.

But let's say if the day comes where I have an interview and DON'T have a "finished" product, yet I still have these code samples that I can defend and show that I've gained a great deal of experience from... would it be a good idea to present these in an interview?

Thanks for the help,

Evan

Show more
Posted 8 months ago
74 Views
3 Comments

What are tips for a college student to succeed in interviews and learning?

Student at Taro Community profile pic
Student at Taro Community

What's up everyone, thanks for taking the time to read this.

Over the next year and a half, I’m aiming to take my skills as both a developer and an interviewee to the next level. I’m currently a senior majoring in computer science and statistics, and I'll be graduating this semester to pursue a one-year master's in CS. My goal is to work at a FAANG or FAANG-adjacent company, gain new skills, and make connections in a major city (a bit cliché, I know).

Background: I’ve spent approximately 1.5 years interning at a Fortune 500 company, working on Cloud/SWE projects, and this summer, I'm a Machine Learning Engineering intern at a mid-sized company.

I'm trying to figure out how to most optimally put in my time for success this interview season. Outside of work and lifting, I try to spend. ~10 hours per week on LeetCode, ~7 hours on system design and ~7 on building projects.

I'm mostly looking for tips someone at my stage may not realize in software. For example, there are really ~15 patterns that once you have the hang of coding interviews become a lot easier than doing 50 array and sliding window questions.

Here are my main challenges:

  1. Securing Interviews: Last summer, I managed to get quite a few interviews but none from FAANG or similar companies. I also applied to data science and engineering roles, which increased my interview count but weren’t exactly what I’m aiming for. I’m keen on MLE, cloud engineering, or backend roles. Although I had referrals to a handful of tech companies, most were not software engineers. What strategies have worked to get interviews for you, or what would prompt you to give an intern an interview?

  2. Understanding Concepts/Designs: What resources (books, lectures, etc) have been invaluable for your interview prep, becoming a better developer, or learning fundamentals?

There's a pretty long post, thanks for any advice you can offer.

Show more
Posted 6 months ago
59 Views
3 Comments