Ask me
  • SQL (SQL Server, Postgres, etc)
  • Spark (PySpark, SparkSQL)
  • Python (General, pandas)
  • Data Cleaning
  • Airflow
  • Data processing at the command line
Introduction
  • Mike is an experienced data engineer, designing and maintaining systems consisting of hundreds of terabytes of data.
Experience
  • Consulting - 2008-Present
Education
  • B.S. Math - University of North Carolina - Chapel Hill
Fun fact
  • Jiu Jitsu Brown Belt
  • Recently learned to drive a tractor

Mock interview with Mike Metzger

2 services

Data modeling is often asked for data engineer, data warehouse architect, or software engineer positions.

Good data modeling is essential for a consistent, efficient, bug-free, and long-lived data environment.

Make sure you are super familiar with concepts such as Dimensional   Modeling Star  Schema,  Snow-Flaked  Schema.

It’s possible to solve any given data request in an almost limitless number of ways, but when data needs to be extensible and maintainable throughout the systems, a good data model is critical to success. When it comes to handling a business requirement with an ability to handle large data,  a  deeper understanding of normalized  (Third  Normal  Form)  and denormalized design.


“I've been working with multi-TB+ datasets for years. Talk with me to get a feel for your data modeling knowledge and work on some practice problems during the process!”


View Mike Metzger's Calender and schedule a 1:1 meeting after your payment, securely processed by Stripe, fully refundable if canceled 24 hours before the meeting.

⏰ Data Modeling with Mike Metzger for $199

SQL is a must-have skill for any data related roles. Including data scientists, data analysts, data engineers, or even software developers, very often your future employee will verify your ability to process and manage data.

As the #1 language in the industry for data management, SQL skills are probably one of the most important to master before starting an interview process. 

The SQL interview can bear other names and may be called  Technical Analysis or Data Interview during a FAANG company interview, you might be asked to perform a series of SQL operations to extract data and insights, and answer follow-up questions about their products.

How it works

 

Before your 'real' interview, it will be super useful to do some mock interviews with an experienced mentor to get you ready.

Our mentors have done hundreds or thousands of real interviews, they will try to emulate a real job interview process.

You will have a conversation that resembles a real interview as closely as possible, at the end, you will also have the opportunity to receive feedback from your mentor.

 

What you will get

Gain a simulated interview experience to get a feel of how it works.

Get over nervousness after you've done a few mock interview practices.

Valuable feedbacks during and after the mock interview provided by your mentor.

Become confident and get familiar with the interview process.

 

How it's conducted

You will be asked to a series of SQL questions customized towards your dream company, please make sure you share the job descriptions with your mentor, so the questions can be customized towards your dream job.

And you will be writing SQL queries in a browser where your mentor will be able to see your coding in real-time. 

A link to access the SQL code editor will be provided before or at the beginning of the interview process.

 

Practice makes dream offers! Let's book your SQL Mock Interview today!

Tell us what programming languages you would prefer to use when you book this session.


“I have extensive experience with SQL, especially with larger datasets (multi-TB+). Happy to help with refreshing your SQL knowledge and providing a few tricks along the way.”


View Mike Metzger's Calender and schedule a 1:1 meeting after your payment, securely processed by Stripe, fully refundable if canceled 24 hours before the meeting.

⏰ SQL with Mike Metzger for $199

Career services by Mike Metzger

2 services

Data challenges or sometimes called take-home challenges are often sent to a candidate in the initial screening.

You are usually given a few tables with, generally speaking, open questions to demo your skills in the following area:

1. Basic data processing in R/Python or sometimes even SQL

Are you able to transform data before feeding them into a machine learning model?

For example: converting categorical variables into numerical columns; Handle missing values, what to do if there are missing values in specific columns. 

Spot obvious data errors based on logic or intuition, never assume the data is correct, fix it before use it.


2. Code quality

No one wants to review your code if you are hired and checked in poor quality code; 

Don't use crazy lambda functions combined with map-reduce and map to make yourself look smart. Instead, use long variable names that are meaningful, easier to understand.


3. Business and product sense 

Are you able to understand the business context? Do your conclusion and insights make business sense?


4. Clear communication

What is your conclusion, can everyone understand what you try to convey, and what do you recommend for the next steps.

You will often be asked to give a talk during the final round of interviews and answer the hiring team's questions.


5. Machine learning modeling skills

Can you build a classification model and evaluate its performance, what feature engineering steps worked the best, what are the metrics you used, did you run cross-validation to get an unbiased estimate of those metrics, etc.


6. Data visualization

One image is worth a thousand words, especially when you are constantly in meetings with non-technical people. Can you create an informative chart or graph to represent the data? Are you good with ggplot or seaborn?


Our mentors have conducted hundreds of take-home data challenges. Feel free to hire one and get 100% data challenge ready.

View Mike Metzger's Calender and schedule a 1:1 meeting after your payment, securely processed by Stripe, fully refundable if canceled 24 hours before the meeting.

⏰ Data Challenge with Mike Metzger for $299

If you can't find exactly the service you are looking for: you can spend an hour with a mentor and asked their questions. 

How did you get where you are today?

Should I quit my job today?

Which area in machine learning should I be focused on? Image processing or natural language processing?

How to build a modern machine learning engineering team from scratch?

Anything you think our mentors can help you.


“I've been consulting as my primary income source for 12 years, focusing on data engineering for the last 10. Happy to discuss ideas, technologies, etc.”


View Mike Metzger's Calender and schedule a 1:1 meeting after your payment, securely processed by Stripe, fully refundable if canceled 24 hours before the meeting.

⏰ General consulting with Mike Metzger for $299