Prepare for and practice interview questions from Matlen Silver.

Matlen Silver Interview Questions

Matlen Silver Interview Guides

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

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

Matlen Silver Salaries by Position

Job Title: Market Risk Business AnalystDuration: 18 months Location: Hybrid in Jersey CityRequired Pay Scale: 65-72***Due to client requirements this role is only open to USC or GC candidates*** Must Haves- STRONG SQL (ideally comp sci degree)- MARKET RISK background (Equities, Bonds, Front office, Federal Reserve Rates)Job Summary:Applies technical knowledge in determining end to end design requirements for large projects involving lineof business, software/hardware developers and vendors. Work closely with business partners to definestrategies for technical solutions, determine requirements, and develop functional designs based on theanalysis of line of business needs, objectives and existing systems infrastructure. Drives and participatesin design, development and implementation of large and complex enterprise wide applications, often usingnew technologies. Work closely with developers and testers to ensure requirements and functional designsare translated accurately into working technical designs and that test plans and scripts serve customerneeds. May manage projects including responsibility for a project and project budget. Works under minimalsupervision on enterprise wide projects requiring creative solutions. IT degree preferred or substantiallyequivalent experience. About Matlen SilverExperience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: info@matlensilver.com // 908-393-8600

Job Title: Business Analyst Duration: 18 Months on a W2Location: New York CityRequired Pay Scale: $65-72hr/w2 Position SummaryCandidate will be responsible for the implementation of business solutions across PBMRT. The role requires significant contributions to the design, development and completion of project deliverables.The role will be responsible for researching and designing solutions for work defined in our global project portfolio and seeing that these designs meet requirements,are approved by our business partners, and are communicated to the development team to the point where they can be coded, and tested and integrated into our platform. Additional responsibilities include: Work with business users to prioritize work itemsAnalyze and understand existing data, job flows, and componentsAssist in investigating production issues and provide solutionsProvide Recommendation for new solutions to existing problems or challengesWork with multiple teams in different locations and time zones.Document solutions to issues and business and testing requirements using JIRA Qualifications Excellent verbal and written communications, comfortable working with different levels of management, high attention to detailSense of ownership and personally vested in success of the projectMust have excellent organizational skills and be able to effectively prioritize multiple tasks to meet extremely tight deadlinesMust have experience participating in large or complex projectsMust be proficient in data management to include strong data analytical capabilityMust be able to engage and leverage teams and business partners to efficiently deliver business solutionsMust have application experience on Python, QuartzMust have application experience on ISDA UMR, SEC/SBS implementationMinimum 10-12 years of progressive experience in the banking industry.Financial products experience is required. Risk knowledge is a plus.

We are seeking a highly skilled Data Engineer with a strong technical background in Microsoft Dynamics 365 Finance to join our team. The ideal candidate will have extensive experience with the Data Management Framework (DMF), data entities, and data structures within D365 Finance, along with hands-on expertise in data migration, data mapping, and D365 database upgrade processes. Additionally, familiarity with Dataverse Dual Write operations, Azure Data Lake integration, and Azure Synapse is required. This role will focus on creating tools, processes, and automation to support test data set creation for D365 Finance lower environments, data extraction to a third-party Data Lake, and D365 Finance production archive and purge operations. Key Responsibilities:Data Management:Build and test data entities, data structures, and configurations within D365 Finance.Oversee and support the D365 database upgrade process using self-service environments.Dataverse & Azure Integration:Configure and test Dataverse Dual Write operations to synchronize data between D365 Finance and other systems.Integrate D365 Finance with Azure Data Lake and Synapse to support data analysis and reporting.Automation & Tools Development:Design and implement tools, processes, and automation solutions for creating and deploying test data sets in D365 lower environments.Support data extraction processes for third-party data lakes. Data Governance:Establish and enforce data governance policies for D365 Finance, ensuring data accuracy, consistency, and security.Develop and execute strategies for D365 production archive and purge operations to maintain optimal system performance. Qualifications:Skills & Technical Expertise:Strong knowledge of the D365 Finance Data Management Framework, data entities, and data structures.Hands-on experience with data migration and data mapping in D365 Finance.Proficiency with Dataverse Dual Write operations and Azure Data Lake/Synapse integration.Experience with the D365 database upgrade process using self-service environments.Advanced SQL, data querying skills, and data modeling techniques.Working knowledge of Azure DevOps and Git repositories.Broad understanding of Azure services such as virtual machines, virtual networks, network security groups, storage accounts, and key vaults.Skilled in working with Microsoft Lifecycle Services (LCS) to move data into and out of LCS-deployed self-service environments.Excellent communication and teamwork skills.Ability to work independently, manage multiple priorities, and lead a workstream.Understanding of data security and compliance, and the importance of protecting customer data.Familiarity with Agile methodologies.

Job Title: Market Risk AnalystDuration: 12-18 MonthsLocation: Jersey City NJ (Onsite 3 days per week)Required Pay Scale: $65-70/hr W2 ***Due to client requirements this role is only open to USC or GC candidates*** Job Summary: Skills<ul><li>Strong Market Risk, Risk or Front Office experience</li><li>Strong financial products knowledge</li><li>Solid understanding of regulatory landscape</li><li>Excellent analytical and quantitative skills</li><li>Strong problem solving skills and experience in analyzing large volumes of financial data</li><li>Ability to effectively communicate within a multi-disciplined team and demanding business users</li><li>Good organization skills with efficient follow-ups & driving conclusions</li><li>Experience with SDLC and agile methodologies</li><li>Excellent technical skills in SQL, Excel, VBA. Python is a plus</li><li>Computer Science degree</li></ul><li></li> About Matlen Silver Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: info@matlensilver.com // 908-393-8600

THIS IS AN IT ROLE. DO NOT APPLY IF YOU ARE A FINACIAL ANLAYST. YOU WILL BE REJECTED FROM THIS AND FUTURE ROLE IF YOU DO NOT READ THE JD. Job Title: Technical Business Analyst (Capital Markets) Duration: 12-18 MonthsLocation: Jersey City NJ (Onsite 3 days per week)Required Pay Scale: $65-70/hr W2 ***Due to client requirements this role is only open to USC or GC candidates*** Job Summary: • Strong Business analyst with 7-10 years of experience• Oracle sql knowledge• Informatica knowledge• Good communication skillsFinancial industry experience is a must About Matlen Silver Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: info@matlensilver.com // 908-393-8600

Location: Onsite 3 days a wk; Hybrid – Office location is Plano TXRequired Pay Scale: $50-55hr W2***Due to client requirements this role is only open to USC or GC candidates*** Summary: Data/Business Analyst serves as the liaison between product owners and development teams to elicit requirement deliverables for product design through interviews and workshop meetings with subject matter experts, product owners, and stakeholders. Captures detailed requirements and creates high level design documentation, activity workflows, business data dictionaries and data mapping documents. Coordinates the collaboration between various teams to support application development using best practices in AGILE methodologies. Conducts regular analysis, through data visualization and SQL Querying, to draw business-relevant conclusions and accurately communicate findings and possible solutions. Evaluates, tests, and recommends enhancement opportunities. Works under minimal supervision on developing creative solutions. Responsibilities: · Collaborate with Business partners to capture and document actionable written requirements and acceptance criteria. · Work with UI/UX designers, business partners and subject matter experts to design and develop screen mockups. · Data mapping source to target tables; understand the uniqueness and complexities of the data as well as its business usage. · Interface with the development team to ensure requirements are understood and delivered accordingly. · Review QA scripts as needed. · Use SQL queries to conduct analyses as needed · Work closely with Developers when questions arise, providing requirements clarifications in timely manner. · Manage UAT testing cycle · Generally be the central person for requirements and delivery between Development and Product Owner and Subject Matter Experts. · 5+ years of experience in Business Analysis and/ or Requirements documentation · 3+ years of experience working with clients or stakeholder groups to resolve issues and design solutions · 2+ years in an environment with heavy data analysis · Basic SQL Skills; able to create and run SQL scripts using TOAD. · Exposure to the Risk and Compliance domains · 1 year of experience working in an Agile development environment · Participation in User Acceptance Testing for at least two projects, including test script creation, execution and defect validation. · Experience working directly with developers to communicate/interpret business requirements · Ability to explain the logic behind their analysis and express ideas clearly and concisely · Experience with Microsoft Office suite of products, including Excel, PowerPoint and Word · Experience with writing documentation in Confluence Wiki · Experience with JIRA workflow management · Effective written communication skills, with experience in writing Epics Stories in an Agile environment as well as HLD, LLD design documents · Effective verbal communication skills; experience with facilitating meetings with executives, technical personnel and/ or Business SMEs<ul><li> · Familiarity with Informatica, Oracle, Distribute, Invision, APIs, Angular</li></ul> About Matlen SilverExperience Matters. Let your experience be driven by our experience. For more than 40years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.If you are a person with a disability needing assistance with the application orat any point in the hiring process, please contact us at email and/or phone at info@matlensilver.com // 908-393-8600

Job Title: Data ScientistDuration: 12-18 MonthsLocation: NYC (Onsite 3 days per week)Required Pay Scale: $65-75/hr/w2/hr W2 ***Due to client requirements this role is only open to USC or GC candidates*** Job Summary: Responsibilities include:<ul><li>Building new market data feeds and maintaining automated release procedures. </li><li>Proficient in database design supporting complex SQL data retrieval and data management techniques. </li><li>Developing cutting-edge processes and workflows for data automation including calculations.</li><li>Support initially maintaining existing legacy workflows using Excel VBA, VB and C#.NET</li><li>Establish a plan to adopt industry standard data processing pipelines that supports all the business requirements while adhering to the firm’s security standards.</li></ul><li></li> About Matlen Silver Experience Matters. Let your experience be driven by our experience. For more than 40 years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works. Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status. If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at email and/or phone at: info@matlensilver.com // 908-393-8600

Matlen Silver Interview Questions

Matlen Silver Interview Guides

Matlen Silver Interview Questions

Matlen Silver Salaries by Position

Matlen Silver Opening Jobs