The Metlife Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Metlife Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Metlife? The Metlife Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Metlife Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Metlife.</li>
<li>Practice real Metlife Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Metlife Business Intelligence interview.


Getting ready for an Business Intelligence interview at Metlife? The Metlife Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Metlife Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Metlife.
- Practice real Metlife Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Metlife Business Intelligence interview.
        

Overview

Metlife Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Metlife Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

What are the logistic and softmax functions? What is the difference between the two?

What makes them useful for use in logistic regression?

In logistic regression, how is the predicted class determined based on the logistic function?

In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</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>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

Metlife Business Intelligence Interview Questions

Role Overview As a Functional Analyst you will work on a fast-paced, product-focused team, building and deploying systems that are customer-first. You will elicit and understand business requirements, and work with the business product owners and the application development teams to capture the right solution. You will partner with and build relationships with cross-functional teams that support various business areas and technology to deliver high-quality, innovative, and engaging conversational solutions. The role requires strong communication, analysis skills, and problem-solving skills. This role will be responsible for creating solutions to meet our business goals - working in an agile delivery model. Key Responsibilities Collaborate with prospective users and clients to understand and anticipate their needs and translate them into product requirements. Participate in discovery sessions to observe, document, and validate business processes and capture key insights. Elicit, analyze, document functional and non-functional requirements. Create user stories and wireframes to conceptualize future states for user experience, new or enhanced services, and business cases. Defining acceptance criteria. Perform gap analysis and recommend solutions. Manage the product backlog and prioritize the features/ stories based on business priorities. Engage in all stages of product creation including design and development and provide necessary clarifications. Involved in all implementations, testing (unit/system/integration), integration and issue resolution around COTS/SaaS solution. Provide functional support and configuration expertise for applications within the portfolio. Monitor and evaluating product progress at each stage of the process. Liaison with the product team and end-users to deliver updates. Participate in Scrum meetings and product sprints. Prepare technical user manuals, system configuration documents and other technical reports. Required 5+ years as a Business Systems/Functional Analyst or a Consultant creating technology solutions. BA/BS degree required, major in related field preferred. Expert skills in requirements elicitations, and analysis. Ability to document and create mocks/prototypes for team to consume. Experience creating requirements documentation: Use Cases, User Stories. Data analysis experience using excel. Experience in agile methodologies. Excellent verbal and written communication skills with focused attention to details, as well as, demonstrated professionalism and time/task management skills; ability to establish strong relationships. Preferred: Experience with SAFe Agile. Experience with Azure DevOps. Knowledge of implementing AI technologies such as, machine learning, NLP, generative AI, Conversational AI. Exposure to modern AI concepts such as generative AI, various models of machine learning, large language models, as well involvement in older concepts like automation, and robotics. Knowledge of auditing processes, technology, and communication strategies. Knowledge of AI best practices, standards, and trends, as well as user interface design and natural language processing techniques. Equal Employment Opportunity/Disability/Veterans If you need an accommodation due to a disability, please email us at accommodations@metlife.com. This information will be held in confidence and used only to determine an appropriate accommodation for the application process. MetLife maintains a drug-free workplace.

Role Value Proposition MetLife is the leading insurance provider. The MetLife Holdings organization is looking for a Software Engineer in a full-stack developer capacity. Full Stack Software Development engineer's role is to provide design, engineering, and implementation support. In this role, you will interact with the Agile Delivery Team, Business and IT Leaders, and IT partners, providing technical support throughout the project lifecycle. Focus will include solution design, security, development, debugging, and production support. We are looking for an energetic and motivated system development engineer who is forward-focused, a creative problem solver, not afraid of experimentation, and a team player who enjoys working in an Agile Delivery Model. Your work will make an impact on how MetLife fulfills its promises to the customer, and you will have excellent opportunities to interact and contribute to the organization's success. Key Responsibilities: Participate in design discussions and provide technical support to application developers and operations support staff. This includes promoting use of best practices, ensuring standardization across applications, and troubleshooting. Implement integration solutions through collaboration with engineers and application teams across the global enterprise. Promote and utilize automation to design and support configuration management, orchestration, and maintenance of the integration platforms using tools and scripts such as Ansible, Python, PowerShell, and Linux shell. Investigate, recommend, implement, and maintain document generation solutions across technologies. Learn new technologies and develop automation scripts in collaboration with senior engineers. Essential Business Experience and Technical Skills: Required: Bachelor's degree in computer science, Information Systems, Engineering, or related field. 2+ years of distributed systems development with some of the following: Java, Java Spring Boot, JavaScript, React/Angular/Web Components, NodeJS, and RestAPI services. Experience in building application infrastructures. Experience with SQL-similar relational databases. Working knowledge of building, deploying and maintaining web applications utilizing Web servers, Application servers, and Database servers. Experience with agile methodologies, and tools like JIRA or Azure DevOps. Ensuring secure, high code quality across the project. Excellent verbal and written communication skills with focused attention to details, as well as, demonstrated professionalism and time/task management skills; ability to establish strong relationships. Preferred: Working knowledge of AKS, Azure, Docker, and Synapse. Experience with API Design & Development (Microservices, Springboot, Java, REST, NodeJS). Experience in test-first practices, including Test Drive Development (TDD) and Behavior-Driven Development (BDD). Knowledge of managing Continuous Delivery Pipeline using tools like Git, Azure DevOps, GitHub, and Artifactory. Design experience utilizing Use Cases, Features, and User Stories. Exposure to Microsoft Azure tools. Hands-on experimentation with prompt engineering, semantic search, and GenAI Exposure to modern AI concepts such as generative AI, various models of machine learning, large language models, conversational AI (chatbot, etc.) as well involvement in older concepts like automation, robotics, and scripting. SAFe Agile certification. At MetLife, were leading the global transformation of an industry weve long defined. United in purpose, diverse in perspective, were dedicated to making a difference in the lives of our customers. Equal Employment Opportunity/Disability/Veterans If you need an accommodation due to a disability, please email us at accommodations@metlife.com. This information will be held in confidence and used only to determine an appropriate accommodation for the application process. MetLife maintains a drug-free workplace.

Metlife Business Intelligence Interview Guide

Overview

Metlife Business Intelligence Salary

Metlife Business Intelligence Interview Process

Metlife Business Intelligence Interview Questions

Metlife Business Intelligence Jobs