Prepare for and practice interview questions from Federal home loan bank of chicago.

Federal home loan bank of chicago Interview Questions

Federal home loan bank of chicago 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

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?

Federal home loan bank of chicago Salaries by Position

Join the FHLBC team! At the Federal Home Loan Bank of Chicago, employees come first - that's why we offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees. •Retirement program (401k and Pension) •Medical, dental and vision insurance •Lifestyle Spending Account •Generous PTO plan •11 paid holidays per year •Hybrid working model Who we are: Our mission at FHLBank Chicago: To partner with our members in Illinois and Wisconsin to provide them competitively priced funding, a reasonable return on their investment, and support for their community investment activities. Simply said, we're a bank for banks and other financial institutions, focused on being a strategic partner for our members and working together to reinvest in our communities, from urban centers to rural areas. Created by Congress in 1932, FHLBank Chicago is one of 11 Federal Home Loan Banks, government sponsored in support of mortgage lending and community investment. What it's like to work here: At FHLBank Chicago, we bring people together. Our regular All-Staff meetings keep employees informed and our values drive the work that we do. Our Buddy Program pairs new hires with tenured employees to guide their onboarding. Through our Office of Diversity, Equity and Inclusion (DEI), we host signature and employee-led events to celebrate our differences and learn from each other and identify volunteer opportunities to strengthen our communities; and Employee Resource Groups (ERGs) and culture teams create connections around shared interests and experiences. We offer live and on-demand professional development opportunities to grow your skillset and your career. What you'll do: In this role, you will be responsible for providing the accurate & timely measurement, analysis, monitoring, and reporting of market risk for the Bank. Making recommendations pertaining to reporting and security valuations as well as running and monitoring the daily risk reporting cycle. How you'll make an impact: <ul> <li>Monitor Bank's risk exposures and support bank's asset liability management. </li><li>Gain exposure to different types of financial securities and provide the fair value for the bank's balance sheet. </li><li>Work in a team-based environment and build strong, trustworthy partnerships with internal stakeholders. </li></ul>What you can expect: <ul> <li>Responsible for reporting the risk exposure and MVE (Market Value of Equity)/BVE (Book Value of Equity) of bank's balance sheet. </li><li>Responsible for the maintenance and upgrade of the risk management systems, performing quantitative test to assess any changes/enhancements to the pricing models within vendor's application. </li><li>Research new ways to automate/improve operation and reporting process. </li><li>Troubleshoot and bring to a quick resolution issues impacting regulatory reporting </li><li>Work effectively with other risk analysts in the group and perform ad-hoc analysis to support other teams across the bank. </li><li>Work on other projects supporting bank's initiative. </li></ul>What you'll bring: <ul> <li>1-3 years' work experience. </li><li>Bachelor or Advanced degree in finance, economics, mathematics, statistics, or other quantitative or computing fields and/or equivalent work experience. </li><li>CFA or FRM would be considered applicable experience. </li><li>Proficient in MS Excel and Word. </li><li>Access/SQL Database experience. </li><li>Familiar with at least one programming language, python or VBA is preferred. </li><li>Exposure to vendor or in-house software used for security evaluation and risk is preferred. </li><li>Passionate about risk management and interested in market risk analysis. </li><li>Basic understanding in fixed income, mortgage securities or derivatives. </li><li>Must gain comprehensive knowledge of the bank's modeling tools used for risk and valuation </li><li>Detail-oriented and possess analytical skills necessary to research, troubleshoot, prepare, and present a variety of reports and analyses in a fast-paced, continually evolving atmosphere. </li><li>Excellent verbal and written communication skills. </li><li>Able to work effectively under pressure, either independently or as a member of a team. </li><li>Must be willing to work with flexibility and dependability - work schedule may include shifts outside the normal business hours. </li></ul> The perks: At FHLBank Chicago, we believe in rewarding our high performing workforce. We offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees. Our retirement program includes a 401(k) and pension plan. Our wellbeing program supports employees at work and in their personal lives: Our generous PTO plan provides five weeks of vacation for new employees and 11 paid holidays per year; our Lifestyle Spending Account provides an annual stipend for employees to support wellbeing activities; and our central downtown location at the Old Post Office provides easy access to public transportation and breathtaking views from our award-winning rooftop. Step into a brighter future with us. #LI-Hybrid

Join the FHLBC teamAt the Federal Home Loan Bank of Chicago, employees come first - that's why we offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees. Retirement program (401k and Pension) Medical, dental and vision insurance Lifestyle Spending Account Generous PTO plan 11 paid holidays per year Hybrid working model Who we are: Our mission at FHLBank Chicago: To partner with our members in Illinois and Wisconsin to provide them competitively priced funding, a reasonable return on their investment, and support for their community investment activities. Simply said, we're a bank for banks and other financial institutions, focused on being a strategic partner for our members and working together to reinvest in our communities, from urban centers to rural areas. Created by Congress in 1932, FHLBank Chicago is one of 11 Federal Home Loan Banks, government sponsored in support of mortgage lending and community investment. What it's like to work here: At FHLBank Chicago, we bring people together. Our regular All-Staff meetings keep employees informed and our values drive the work that we do. Our Buddy Program pairs new hires with tenured employees to guide their onboarding. Through our Office of Diversity, Equity and Inclusion (DEI), we host signature and employee-led events to celebrate our differences and learn from each other and identify volunteer opportunities to strengthen our communities; and Employee Resource Groups (ERGs) and culture teams create connections around shared interests and experiences. We offer live and on-demand professional development opportunities to grow your skillset and your career. What you'll do: The Sr. Salesforce Business Analyst (Salesforce BA) bridges the gap between business objectives and Salesforce capabilities. This role drives critical enterprise initiatives, aligning specialized business line needs with platform capabilities. The Salesforce BA owns business requirement documentation for the Salesforce team, works across Bank business lines, and collaborates with the Salesforce Delivery Team. The Salesforce BA is a thought leader for internal processes and a key representative to stakeholders, driving projects and business initiatives forward. How you'll make an impact: Driving Strategic Initiatives : As a thought leader for internal processes and a key representative to stakeholders, the Salesforce BA will drive critical enterprise initiatives forward. By aligning business objectives with Salesforce capabilities, they will help the Bank achieve its strategic goals, ensuring that technology investments are maximized and business processes are optimized. Enhancing Cross-Departmental Collaboration : By working across various Bank business lines and collaborating closely with the Salesforce Delivery Team, the Salesforce BA will ensure that specialized business needs are effectively translated into Salesforce capabilities. This will foster better communication and alignment between departments, leading to more cohesive and efficient operations. Implementing Change Management : The Salesforce BA will develop and implement change management strategies that ensure smooth transitions during process improvements. By evaluating business processes against industry standards and facilitating actionable change, they will help the Bank stay competitive and agile in a rapidly evolving market. What you can expect: Organize business requirements, document user stories, and support the Delivery team. Evaluate business processes against industry standards, identify improvements, and facilitate actionable change. Identify and gather requirements in alignment with business goals and Salesforce build. Develop and implement change management strategies, ensuring smooth transitions during process improvements. Collaborate with product owners and stakeholders to prepare development user stories. Create process flow diagrams to depict current and future state improvements. Interpret data schema diagrams to understand data relationships. Streamline the Salesforce experience. Continuously seek and apply knowledge to enhance the stakeholder experience on the Salesforce platform. What you'll bring: Bachelor's degree or equivalent work experience. 5-7 years of experience with Salesforce platforms: Sales Cloud, Marketing Cloud, and Service Cloud. Platform Certifications: Salesforce Certified Business Analyst; Salesforce Certified Administrator required; Salesforce Certified Platform App Builder or Salesforce Certified Marketing Cloud Email Specialist a plus. Familiarity with banking products and information technology. Financial industry work experience preferred. Knowledge of the Salesforce platform and configuring Salesforce, such as Sales Cloud, Marketing Cloud, and Service Cloud. Strong understanding of SDLC, Agile methodology, and platform capabilities. Understand best practices for development and the translation between requirements and design. Plan, schedule, and track multiple initiatives, and prioritize effectively. Evaluate complex data, identify trends, draw conclusions, and make recommendations. Strong and effective communication skills, both written and verbal. Build and maintain strong relationships with key stakeholders. Detail-oriented and seek to understand context to incorporate it into solutions. Solid understanding of banking processes or financial industry experience. The perks: At FHLBank Chicago, we believe in rewarding our high performing workforce. We offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees. Our retirement program includes a 401(k) and pension plan. Our wellbeing program supports employees at work and in their personal lives: Our generous PTO plan provides five weeks of vacation for new employees and 11 paid holidays per year; our Lifestyle Spending Account provides an annual stipend for employees to support wellbeing activities; and our central downtown location at the Old Post Office provides easy access to public transportation and breathtaking views from our award-winning rooftop. Step into a brighter future with us. LI-Hybrid

Federal home loan bank of chicago Interview Questions

Federal home loan bank of chicago Interview Guides

Federal home loan bank of chicago Interview Questions

Federal home loan bank of chicago Salaries by Position

Federal home loan bank of chicago Opening Jobs