Prepare for and practice interview questions from Open Systems Technologies.

Open Systems Technologies Interview Questions

Open Systems Technologies Interview Guides

Behavioral

What do you tell an interviewer when they ask you what your strengths and weaknesses are?

Your Strengths and Weaknesses

How would you answer when an Interviewer asks why you applied to their company?

Why Do You Want to Work With Us

Analytics

What metrics would you use to determine the value of each marketing channel?

Marketing Channel Metrics

Let’s say that you're in charge of an e-commerce D2C business that sells socks. What business health metrics would you care?

D2C Socks e-Commerce

Product Sense & Metrics

What are the top five metrics you would start tracking to understand the health of Google Docs

Docs Metrics

Machine Learning

Bias vs. Variance Tradeoff

Forecasting & Time Series

How would you forecast revenue for the next year

Forecasting New Year Revenue

Let’s say you’re given all the different marketing channels along with their respective marketing costs at a company called Mode, that sells B2B analytics dashboards.

What metrics would you use to determine the value of each marketing channel?

When determining the value of each marketing channel for the company Mode, which metric is considered the key metric?

When determining the value of each marketing channel for the company Mode, which metric is considered the key metric?

Imagine you are asked to build a machine learning model to decide new loan approvals for a
financial firm. You ask the data department in the company for a subset of data to get started
working on the problem. The data includes different features about applicants such as age,
occupation, zip code, height, number of children, favorite color, etc. You decide to build
multiple machine learning models to test out different ideas before settling on the best one.

How would you explain the bias-variance tradeoff with regards to
building and choosing a model to use?

Let’s say that you work on the revenue forecasting team at a company like Facebook.

An executive comes to you asking about how much revenue Facebook will make in the coming year.

How would you forecast revenue for the next year?

When an interviewer asks a question along the lines of:

<ul>
<li>What would your current manager say about you? What constructive criticisms might he give?</li>
<li>What are your three biggest strengths and weaknesses you have identified in yourself?</li>
</ul>

How would you respond?

When asked about your strengths in an interview, what is an effective way to respond?

When asked about your strengths in an interview, what is an effective way to respond?

Your Strengths and Weaknesses I

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Which of the following is an acceptable strategy when discussing weaknesses in an interview?

Your Strengths and Weaknesses II

Let’s say that you’re in charge of an e-commerce D2C business that sells socks.

What business health metrics would you care about tracking on a company dashboard?

When an interviewer asks you a question along the lines of:

<ul>
<li>Why did you apply to our company?</li>
<li>What are you looking for in your next job?</li>
<li>What makes you a good fit for our company?</li>
</ul>

How should you respond?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

When asked 'What are you looking for in your next job?' in an interview, how can you tie the company's employee benefits into your response?

Why Do You Want to Work With Us I

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

How can company values be used effectively in an interview when asked 'What makes you a good fit for our company?'

Why Do You Want to Work With Us II

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

When responding to the question 'Why did you apply to our company?' during an interview, what aspect should you highlight?

Why Do You Want to Work With Us III

Let’s say you are working on Google Docs. A product manager comes to you and asks how the product is doing. 

What are the top five metrics that you would start tracking to understand the health of Google Docs?

Challenge

Job Title: Senior Data EngineerLocation: Mississauga – Hybrid – 3 days/weekTerm: 12 months contract extension KEY RESPONSIBILITIES: • Designing, implementing, managing scalable data solutions using Snowflake environment for optimized data storage and processing. • Migrate existing data domains/flows from relational data store to cloud data store (Snowflake). • Identify and optimize new/existing data workflows. • Identify and implement data integrity practices. • Integrate data governance and data science tools with Snowflake ecosystem as per practice. • Support the development of data models and ETL processes to ensure high quality data ingestion in cloud data store. • Collaborate with team members to design and implement effective data workflows and transformations. • Assist in the maintenance and optimization of Snowflake environments to improve performance and reduce costs. • Contribute to proof of concept, documentation and best practices for data management and governance within the Snowflake ecosystem. • Participate in code reviews and provide constructive feedback to improve team deliverables quality • Design and develop data ingestion pipeline using Talend/Informatica using industry best practices. • Writing efficient SQL and Python scripts for large dataset analysis and building end to end automation process on a set schedule. • Design, implement data distribution layer using Snowflake REST API. • Development of Semantic Model in Snowflake and PowerBI is a plus SKILLS / QUALIFICATIONS • Bachelor’s degree in computer science, Software Engineering, Information Technology, Management Information Systems or related field required (Master’s degree preferred) • 7-10 years’ experience in data analysis, data objects development and modeling in Snowflake data store. • Snowflake REST API experience • Informatica ETL and Talend ETL experience. • Efficient SQL queries development and Python scripts development experience. • Proven ability to work in distributed systems • Proficiency with relational databases (such as DB2) querying and focus on data transformations. • Excellent problem-solving skills and team-oriented mindset • Strong data modelling concepts and schema design on relational data store and on cloud data store • Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions and different roles. • Familiarity with data visualization tools such as Tableau and PowerBI is a plus. • Collaborating with data scientists/experts to integrate machine learning models into Snowflake

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

Open Systems Technologies Interview Questions

Open Systems Technologies Interview Guides

Open Systems Technologies Interview Questions

Challenge

Open Systems Technologies Opening Jobs

Discussion & Interview Experiences

Discussion & Interview Experiences