Extract. Transform. Read.A newsletter from Pipeline Hi past, present or future data professional! If you’re like me, in school you were always envious of your classmates that may not have applied themselves academically but were “good test takers.” Fortunately (for them at least), these folks would likely do well on what is quietly becoming the SAT of programming the GCA, or General Coding Assessment. Now, the General Coding Assessment isn’t any kind of board certifying test like the Bar (RIP to my law school grad friends taking this in late July) and isn’t universally offered like college entrance exams. It is, however, becoming increasingly accepted and expected by companies using the coding test vendor, Code Signal. Think of Code Signal as a barrage of LeetCode/HackerRank questions–but on steroids. Instead of having the benefit of coding along with an interviewer/senior engineer, the candidate has the pleasure of sitting for a virtually proctored exam. Depending on your interview process’ constraints this may also include a lockdown of your browser; so no looking up that Python method you’re always forgetting. Like the SAT, the GCA assigns a composite score out of 600, typically the aggregate of 1-5 questions to be completed in just over an hour. Companies are increasingly using this score as an additional screener to determine if candidates demonstrate the logical thought processes necessary to thrive in entry-level and mid-level roles. Some companies are even accepting past test results within a certain time frame, i.e. 6-12 months. If this sounds intimidating, the good news is that there are a lot of resources available to help you understand, approach and pass tests like this. While you could do the industry-standard LeetCode, I personally prefer StrataScratch (not a sponsor), as it has more problem sets related to data analysis, including a ton of SQL practice and dedicated interview prep. For the GCA specifically, I recommend reviewing and trying the problems featured in this GitHub repo: https://github.com/Leader-board/OA-and-Interviews/blob/main/Online%20Assessments.md#codesignal. And if you take and fail the test, don’t be too hard on yourself. This isn’t a universal test that will decide your future as a developer. At least not yet. Thanks for ingesting, -Zach Quinn |
Reaching 20k+ readers on Medium and nearly 3k learners by email, I draw on my 4 years of experience as a Senior Data Engineer to demystify data science, cloud and programming concepts while sharing job hunt strategies so you can land and excel in data-driven roles. Subscribe for 500 words of actionable advice every Thursday.
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! It’s hardly controversial to say debugging is everyone’s least favorite part of programming. One widely-used debugging method is the rubber duck method, popularized in Pragmatic Programming, which suggests you talk through your code, aloud, to an inanimate object. Being able to speak intelligently about what prompted a technical decision is one of the most underrated data engineering skills. One...
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! While many tech-oriented companies have (in one way or another) reneged on remote working arrangements, my employer made an extreme gesture to demonstrate its commitment to the ongoing office-less lifestyle: It removed an entire floor of our two-floor New Jersey office space. Other companies, like Spotify, have unveiled slogans like “Our employees aren’t children. Spotify will continue working...
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! The only thing worse than summer temperatures (if you’re in the western hemisphere, that is) is a summer job search. Conventionally, summer isn’t the best time to apply for work; you could probably tell this if you’re currently working and find yourself accepting an overwhelming amount of OOO cal invites. If you are braving the heat of the job market, I want to share a more targeted and...