Infrastructure Consultant Interview Questions

3,725 infrastructure consultant interview questions shared by candidates

Q1. SQL Given tables: employees(id, unixname,team,role,days_since_started) projects(id,name,....) commits(id,file_path,proj_id,auth_id,timestamp) Find the number of unique employees per project per month? Q2. Imagine you have a CSV file: john_doe,android,ios,infra bob_law,is,backend jane_doe,frontend ------------------------------ Containing,for each employee, a list of projects he/she works on Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.
avatar

Data Scientist Infrastructure

Interviewed at Meta

3.6
Feb 13, 2018

Q1. SQL Given tables: employees(id, unixname,team,role,days_since_started) projects(id,name,....) commits(id,file_path,proj_id,auth_id,timestamp) Find the number of unique employees per project per month? Q2. Imagine you have a CSV file: john_doe,android,ios,infra bob_law,is,backend jane_doe,frontend ------------------------------ Containing,for each employee, a list of projects he/she works on Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.

Write a program in Python to calculate tax if Salary and Tax Brackets are given as list in the form [ [10000, .3],[20000, .2], [30000, .1], [None, .1]]. You don’t know in the beginning how many tax brackets are there. You have to test for all of them.
avatar

Data Scientist Infrastructure

Interviewed at Meta

3.6
Apr 1, 2018

Write a program in Python to calculate tax if Salary and Tax Brackets are given as list in the form [ [10000, .3],[20000, .2], [30000, .1], [None, .1]]. You don’t know in the beginning how many tax brackets are there. You have to test for all of them.

Viewing 1 - 10 interview questions

Glassdoor has 3,725 interview questions and reports from Infrastructure consultant interviews. Prepare for your interview. Get hired. Love your job.