Prepare for and practice interview questions from Open Systems Technologies.

Open Systems Technologies Interview Questions

Open Systems Technologies Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Open Systems Technologies Salaries by Position

Open Systems Tech is looking for a Business Analyst for one of our financial services clients based out of Mississauga/ON. This is a time sensitive opportunity, please apply ASAP. Job Title: Business AnalystLocation: Mississauga – Hybrid – 3 days/weekTerm: 6 months contract plus extensions Opportunity to join the Fixed Income Technology Business Execution Team, who deliver end-to-end management of a $268mm Book of Work. The successful Candidate will provide horizontal support enabling the execution of supplier management strategy. Responsibilities:• Act as a central point of contact within the Business Office for all Supplier related activities.• Collaborate with Stakeholders to ensure contracts (new and renewals) are executed efficiently and in line with all the applicable policies and approvals.• Work closely with Business Activity Owners (BAOs) to ensure required Third Party Management activities are completed to facilitate timely execution of contracts• Ensure that all supplier costs are accurately reflected and forecasted in both current and future year budgets• Provide reporting to inform and drive Supplier Management Strategy• Ensuring that all activities are in line with current risk appetite and compliant with applicable laws, rules and regulations• Other activities as required. Experience/Skills:• Stakeholder management• Understanding of financials, budgeting and financial forecasting• Ability to track financials and resource utilization charts to manage contract draw down• Ability to manage risk when making business decisions• Adept in all Microsoft Office tools, preferably advanced excel• Clear and concise written and verbal communication skills• Managing relationships with a Global Team

Title: Reporting Analyst (Tableau, Excel) Duration: Through 8/8/2025 (12 months) Location: Irving, TX - hybrid 3 days onsite/week Reporting Analyst •6-8 years experience with Tableau and Excel •Some development, but not a heavy emphasis on developing as a full time function •Part of a Compliance, Risk, and Controls group o Compliance is required o Majority of work is with controls o Operational risk management background •BI reporting process with Excel o Intermediate to advanced Excel (macros, charts formulas, VLookups, HLookups) • Tableau dashboards - maintain and update tableau dashboard. Add widgets o Generate metrics from tableau dashboards and create visualizations for upper management o utomation efforts, merge reports •Financial services required •Tableau portfolio link preferred Qualifications: •Strong experience in creating Tableau reports, report optimization and modeling •Familiarity with risk management frameworks, industry standards and financial industry regulatory requirements •Experience in Database and Middleware technologies (Oracle, SQL Server) •Advanced Knowledge of Business Processes, Systems and Tools used in the risk and controls environment with a focus on PowerBI and Tableau •Ability to analyze and think critically, conceptually and interpretively to solve problems. •Ability to identify opportunities, assess needs, conduct qualitative and quantitative analyses, synthesize insights and provide recommendations. •Proficiency at communicating business risk status that is relevant to stakeholders and appropriate prioritization for remediation 24-03548 #LI-DM1

Open Systems Tech is looking for a Senior Data Analyst for one of our Financial services clients. This is a time sensitive opportunity, please apply ASAP. Job Title: Senior Data AnalystLocation: Mississauga - 3 days - HybridTerm: 1 year contract plus extension Job Description: Strong SQL skills are essential; experience writing complex queries spanning multiple tables is required.10+ years of experience in IT and data base/data warehouse domain.Advanced level MS Excel and data interpretation/visualization techniques.Strong Domain knowledge of OTC derivatives & Markets.Exposure to scripting language like shell scripting, python is required.Good communication and organizational skills. Responsibilities: <ol><li>The resource will be involved in working on implementation and governance of Data Quality and Controls on Cloudera/big data platform.</li><li>Working with source systems that publish transactions to Cloudera data platform and perform RCA on controls failed.</li><li>Day-to-day activity would involve working extensively on complex SQLs that are run on Hive/IMPALA DB.</li><li>Running daily/weekly reports and visualizations, Advanced excel / visualization techniques</li><li>Experience on Olympus platform (big data/cloud), data warehouse solution, big data (python/shell scripting), cloud experience, Hive, impala.</li></ol>

Open Systems Technologies Interview Questions

Open Systems Technologies Interview Guides

Open Systems Technologies Interview Questions

Open Systems Technologies Salaries by Position

Open Systems Technologies Opening Jobs