Prepare for and practice interview questions from Markel Corporation.

Markel Corporation Interview Questions

Markel Corporation Interview Guides

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?

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

Markel Corporation Salaries by Position

What part will you play? If you're looking for a place where you can make a meaningful difference, you've found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you'll find your fit amongst our global community of optimists and problem-solvers. We're always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs. Join us and play your part in something special! What part will you play? If you're looking for a place where you can make a meaningful difference, you've found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you'll find your fit amongst our global community of optimists and problem-solvers. We're always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs. Join us and play your part in something special! The Network Infrastructure Engineering Manager role provides overall leadership for the day-to-day management, operational oversight, support, and technical expertise for the Enterprise Network infrastructure. Provide overall leadership for the day-to-day management of a small team of Engineers that provide support to SNC's application and business customers. •Deliver on project activities within agreed timelines, provide guidance and direction to support teams, as well as other areas of IT within the greater SNC organization. This position will be responsible for participating directly in the planning, managing, and implementation of policies and procedures to ensure job scheduling, efficiency, capacity management, system performance, offsite replication, and maintenance. Job Responsibilities <ul><li>Partner with Application teams to support SNC's business platforms and assorted enterprise toolsets, providing technical support for application and business customers.</li><li>Responsible for the Planning, design, implementation, and Securing of the Companies network Infrastructure including Cisco Switches, ASA VPN solutions, Palo Alto Firewalls, Wireless network, interoperating with Azure, and responding to threats and alerts.</li><li>Principal RTE (Run the Engine) support for SNC's Network operation, support escalation, troubleshooting system and server errors. Performs resolution of complex network hardware, software application and subsystems as part of critical incident response and remediation.</li><li>Participates in the planning and management of enterprise monthly Standard Maintenance weekend activities.</li><li>Collaborates with peer organizations in SNC to ensure SLAs for incident and problem management are met.</li><li>Provide proactive system performance monitoring and resolution of alerts for organization's assets, as well as performing preventative maintenance and daily health checks reducing system downtime.</li><li>Partner with and guide other internal infrastructure engineers to perform operational support and project activities and reporting to system owners and stakeholders.</li><li>Act as a technical escalation for engineers to assist in complex troubleshooting and resolution of issues.</li><li>Trains technical staff on use of software/hardware tools in accordance with required standards and procedures.</li><li>Participate in after-hours critical production support as required. On-call support will be required for this role.</li><li>Performs other related duties as assigned.</li></ul> Certification <ul><li> Certifications such as CCNP Security, CCNA Security, PCNSE or CISSP are highly desirable</li><li>Familiar with Project Management methodology and SDLC.</li><li>Other Cisco, Palo Alto, or Microsoft centric certifications a plus</li></ul> Work Experience <ul><li>5+ years of experience in information technology service/product management leadership.</li><li>3+ years of experience in Network and Network Security delivery management, Microsoft Azure AD integration, Securing Cloud network resources, Conditional Access Policy management and interoperating with third party applications.</li><li>Demonstrated Experience working with Azure AD, Cisco ASA, Cisco Meraki, Palo Alto firewalls.</li><li>Experience opening priority incidents with external vendors and driving to resolution.</li><li>Strong analytical and critical thinking skills, with the ability to troubleshoot and resolve complex issues.</li><li>Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.</li><li>Thorough understanding of how discrete infrastructure components work together in an Enterprise environment</li></ul> Skill Sets <ul><li>Excellent interpersonal, negotiation, creativity, attention to detail, and oral and written communications skills tailored for the intended audience.</li><li>Exceptional skills in the mentoring and development of team resources to ensure a core focus on providing career development opportunities for your direct reports</li><li>Strong technical foundation that enables thoughtful troubleshooting during complex incidents.</li><li>Familiarity working in an Agile and DevOps environment preferred.</li></ul> Who we are: Markel Group (NYSE - MKL) a fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world. We're all about people | We win together | We strive for better We enjoy the everyday | We think further What's in it for you: In keeping with the values of the Markel Style, we strive to support our employees in living their lives to the fullest at home and at work. <ul><li>We offer competitive benefit programs that help meet our diverse and changing environment as well as support our employees' needs at all stages of life.</li><li>All full-time employees have the option to select from multiple health, dental and vision insurance plan options and optional life, disability, and AD&D insurance.</li><li>We also offer a 401(k) with employer match contributions, an Employee Stock Purchase Plan, PTO, corporate holidays and floating holidays, parental leave.</li><li>Markel offers hybrid working schedules of 3 days in the office and 2 days remote.</li></ul> Are you ready to play your part? Choose 'Apply Now' to fill out our short application, so that we can find out more about you. The base salary offered for the successful candidate will be based on compensable factors such as job-relevant education, job-relevant experience, training, licensure, demonstrated competencies, geographic location, and other factors. Caution: Employment scams Markel is aware of employment-related scams where scammers will impersonate recruiters by sending fake job offers to those actively seeking employment in order to steal personal information. Frequently, the scammer will reach out to individuals who have posted their resume online. These "job offers" include convincing offer letters and frequently ask for confidential personal information. Therefore, for your safety, please note that: <ul><li>All legitimate job postings with Markel will be posted on Markel Group Careers.</li><li>All legitimate communications with Markel recruiters will come from Markel.com email addresses.</li></ul> We would also ask that you please report any job employment scams related to Markel to rarecruiting@markel.com. Markel is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of any protected characteristic. This includes race; color; sex; religion; creed; national origin or place of birth; ancestry; age; disability; affectional or sexual orientation; gender expression or identity; genetic information, sickle cell trait, or atypical hereditary cellular or blood trait; refusal to submit to genetic tests or make genetic test results available; medical condition; citizenship status; pregnancy, childbirth, or related medical conditions; marital status, civil union status, domestic partnership status, familial status, or family responsibilities; military or veteran status, including unfavorable discharge from military service; personal appearance, height, or weight; matriculation or political affiliation; expunged juvenile records; arrest and court records where prohibited by applicable law; status as a victim of domestic or sexual violence; public assistance status; order of protection status; status as a smoker or nonsmoker; membership or activity in local commissions; the use or nonuse of lawful products off employer premises during non-work hours; declining to attend meetings or participate in communications about religious or political matters; or any other classification protected by applicable law. Should you require any accommodation through the application process, please send an e-mail to the rarecruiting@markel.com. No Agencies Please #piq #deib US Work Authorization <ul><li>US Work Authorization required. Markel does not provide visa sponsorship for this position, now or in the future.</li></ul> Who we are: Markel Group (NYSE - MKL) a fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory and investment operations around the world. We're all about people | We win together | We strive for better We enjoy the everyday | We think further What's in it for you: In keeping with the values of the Markel Style, we strive to support our employees in living their lives to the fullest at home and at work. <ul><li>We offer competitive benefit programs that help meet our diverse and changing environment as well as support our employees' needs at all stages of life.</li></ul> <ul><li>All full-time employees have the option to select from multiple health, dental and vision insurance plan options and optional life, disability, and AD&D insurance.</li></ul> <ul><li>We also offer a 401(k) with employer match contributions, an Employee Stock Purchase Plan, PTO, corporate holidays and floating holidays, parental leave.</li></ul> <ul><li>Markel offers hybrid working schedules of 3 days in the office and 2 days remote.</li></ul> Are you ready to play your part? Choose 'Apply Now' to fill out our short application, so that we can find out more about you. Caution: Employment scams Markel is aware of employment-related scams where scammers will impersonate recruiters by sending fake job offers to those actively seeking employment in order to steal personal information. Frequently, the scammer will reach out to individuals who have posted their resume online. These "job offers" include convincing offer letters and frequently ask for confidential personal information. Therefore, for your safety, please note that: <ul><li>All legitimate job postings with Markel will be posted on Markel Careers. No other URL should be trusted for job postings.</li></ul> <ul><li>All legitimate communications with Markel recruiters will come from Markel.com email addresses.</li></ul> We would also ask that you please report any job employment scams related to Markel to rarecruiting@markel.com. Markel is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of any protected characteristic. This includes race; color; sex; religion; creed; national origin or place of birth; ancestry; age; disability; affectional or sexual orientation; gender expression or identity; genetic information, sickle cell trait, or atypical hereditary cellular or blood trait; refusal to submit to genetic tests or make genetic test results available; medical condition; citizenship status; pregnancy, childbirth, or related medical conditions; marital status, civil union status, domestic partnership status, familial status, or family responsibilities; military or veteran status, including unfavorable discharge from military service; personal appearance, height, or weight; matriculation or political affiliation; expunged juvenile records; arrest and court records where prohibited by applicable law; status as a victim of domestic or sexual violence; public assistance status; order of protection status; status as a smoker or nonsmoker; membership or activity in local commissions; the use or nonuse of lawful products off employer premises during non-work hours; declining to attend meetings or participate in communications about religious or political matters; or any other classification protected by applicable law. Should you require any accommodation through the application process, please send an e-mail to the rarecruiting@markel.com. No agencies please.

Markel Corporation Interview Questions

Markel Corporation Interview Guides

Markel Corporation Interview Questions

Markel Corporation Salaries by Position

Markel Corporation Opening Jobs