Prepare for and practice interview questions from Mitchell Martin Inc..

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Interview Guides

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?

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

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Mitchell Martin Inc. Salaries by Position

<ul><li>Technology BA that would be responsible for translating user requirements into technical IT related requirements.</li><li>Must have extensive experience implementing KYC tool Fenergo.</li><li>Creating BRDs, FRDs.</li><li>Well versed with creating process flows, data flows, sequence diagrams using Visio.</li><li>Should be comfortable running discovery sessions with senior stakeholders to elicit feedback and close out open requirements.</li><li>Data migration background, to create data migration plans, assist in testing, creating reconciliation reports.</li></ul>

****** NO C2C or 3RD PARTIES - W2 ONLY ************ IN PERSON INTERVIEW REQUIRED ****** Title: Senior Java Developer (Java/Angular/React)Location: Plano, TX - 3 days Hybrid (In Person Interview Required)Type: Contract (W2 Only - No C2C) ****** NO C2C or 3RD PARTIES - W2 ONLY ************ IN PERSON INTERVIEW REQUIRED ******Do not apply if you are not able to do an in person interview in Plano, TX Must Haves: Java, DevOps In Person Interview Description:<ul><li>Senior Software Engineer is responsible for developing and delivering complex software requirements to accomplish business goals.</li><li>Key responsibilities of the role include ensuring that software is developed to meet functional and non-functional requirements.</li><li>This role would require collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in a dynamic Agile environment.</li><li>Ability to achieve subject matter expertise quickly on new applications is needed.</li><li>Requires proven track record in Java, J2EE-Spring 5 (MVC/Batch), JSP, JQuery, Java scripting, Angular 5, React, NodeJS, Hibernate, Weblogic, performance tuning, ETL processes, Windows and Linux environments with strong querying and PL/SQL experience in multiple database platforms is preferred: Oracle, SQL Server.</li><li>Hadoop, Exadata experience is desired and Microstrategy/Tableau experience will be a plus.</li></ul>

Our client, one of the largest financial services firms, is seeking a Business Analyst. Position Type: Contract Location: Dallas TX / Tampa FL Schedule: Hybrid Job Purpose: Lead workstreams that enhance issue management programs, focusing on issue identification, root cause analysis, remediation, monitoring, and reporting. Key Responsibilities: Issue Management Leadership: Lead end-to-end issue management projects, including root cause analysis, remediation, and management reporting of identified issues Create and execute reporting processes that provide progress updates and measurable results on the efficacy of the issue management program Manage the development of presentations for senior management review, ensuring clarity and precision in communicating complex issues. Gather and analyze requirements. Organize and document business needs to enable design and development Lead and influence cross-functional teams Provide consultation to development team and product owner for business facing application enhancements. Educational Background: Degree from a top-tier academic institution. Experience: A minimum of 10 years in financial services, with proven experience in leading projects or teams in risk management, control frameworks, or business process optimization. Control & Risk Frameworks: Experience with developing and implementing control and risk management frameworks. LI-JH2

Our Client, an agriculture company, is seeking a IT Business Analyst Location: Millsboro, DE Position Type: IT Full Time Job Summary: Responsible for providing product expertise and product understanding for Oracle ERP On Prem and Oracle Cloud ERP System. Provides first line resolution/analysis assistance as subject matter expert (SME) for responsibilities of system health, maintenance, and continuous improvements of corporate applications. Works with business representatives to deliver completely implemented solutions to end user community by leveraging best practices of the core applications. Responsible for developing programmatic solutions, testing solutions for accuracy with defined test plan, coordinating the implementation and completion of recommended specifications for all new systems, system changes, and problem corrections. Duties/Activities Required by Job: Work with business users to fully understand functional requirements and performs functional lead activities such as planning, development, and testing of core application Maximize use of available technology to enhance and improve business processes. Provide functional leadership, guidance, and supporting the deployment of complex applications. Build effective relationships in other IT areas, business community and vendors we work with. Protect company assets (data and hardware); adhere to guidelines, standards and procedures. Educations/Experience Requirements: B.S or equivalent related work experience in Information Systems / 8-10 years work related experience Knowledge in programming and system development methodology Techno functional knowledge of Oracle Finance as well Purchasing and Inventory. Ability to embrace and learn new technologies, enhance, and streamline. Strong organizational and people management skills. Strong leadership, time management, communication, and problem-solving skills. Trade Management/Channel Revenue (AR Claims & Deductions) is light plus. Salary Range: $95,000 - $110,000 M

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Interview Guides

Mitchell Martin Inc. Interview Questions

Mitchell Martin Inc. Salaries by Position

Mitchell Martin Inc. Opening Jobs