Prepare for and practice interview questions from Procom.

Procom Interview Questions

Procom 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

Procom Salaries by Position

212306 Software Engineer/Configuration Management Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.

With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.

Procom’s areas of staffing expertise include:
Application Development
Project Management
Quality Assurance
Business/Systems Analysis
Datawarehouse & Business Intelligence
Infrastructure & Network Services
Risk Management & Compliance
Business Continuity & Disaster Recovery
Security & Privacy
Specialties include:
Contract Staffing (Staff Augmentation)
Permanent Placement (Staff Augmentation)
ICAP (Contractor Payroll)
Flextrack (Vendor Management System)
This position will be responsible for maintaining the health of the software repositories, ensuring that the software can be successfully built and is working all the time. Responsibilities include:
Ownership of delivering the software to various internal teams and organizations, ensuring that all incremental changes and patches are synchronized to different build lines and build systems.
Ensuring that software being developed by external vendors and teams is properly sanitized, integrated, and shared.
Producing periodic builds of the software and making it available for various validation teams.
Coordinating the flow of defect fixes into the stable build lines.
Leveraging automation of software patch and build management and enhancing existing processes to improve them continuously.
Guiding team members within and outside the organization to sound practices.
Minimum Requirements:
BS in IT, Computer Science or related discipline.
3-5 Years of experience with Git/GERRIT.
1-2 years of experience with continuous integration systems such as buildbot, Jenkins.
3-5 years of experience working with Linux/Unix, Windows, VMware ESX Virtualization.
1-2 years of experience with Python, Perl for developing cron jobs and automation scripts.
PLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.

#J-18808-Ljbffr

BMO is currently sourcing for a Business Analyst position on a 6-month contract. Summary of Role: The Business Analyst will work within the Operational Non-Financial Risk (ONFR) department to define and document business requirements for various solutions, including business intelligence visualizations, reports, dashboards, machine learning models, and formal reporting. Project: The Business Analyst will collaborate with ONFR stakeholders to ensure solution delivery aligns with business requirements, develop project artifacts, and focus on ONFR solutions with potential enterprise-wide impact. Years of experience: 5 - 7 years RESPONSIBILITIES INCLUDE (but are not limited to): 1. Facilitate discussions with stakeholders to define business requirements for ONFR solutions. 2. Develop informative project artifacts covering functional and non-functional business requirements. 3. Collaborate with various ONFR teams to ensure solution delivery alignment. 4. Assist stakeholders with acceptance test planning and manage the team's solution backlog. 5. Manage team solution changes and controls. Required Skills: - Organizational and process optimization - Business architecture frameworks - Stakeholder analysis and management - Strong verbal and written communication skills - Collaboration and team skills Desired Skills: - Facilitation skills - Business requirements definition and analysis - Functional analysis and application functional design - Experience with enterprise risk solutions and/or Power BI solutions

Finance, Documents and Warehouse B2B/A2A; Business Analyst Intro Our Client, a global leader in the distribution of pipe, valve, and fitting products, is looking for a Business Analyst (with finance, documents, and warehouse professional experience) to join our ERP implementation team. Oracle Fusion ERP will require implementation of B2B integrations (XML/EDI) with banks and A2A integrations (document management and warehouse) within our Client's application landscape MuleSoft. The ideal candidate will possess strong financial acumen, technical expertise, and exceptional problem-solving skills. Finance, Documents and Warehouse B2B/A2A; Business Analyst Job Details Key Responsibilities: 1. B2B Bank Integrations: Manage the integration of financial systems with various banking platforms, including electronic banking interfaces, online payment gateways, and treasury management systems. 2. A2A Application Integrations: Lead the integration of document management and warehouse applications with ERP (Oracle Fusion) and MuleSoft. 3. Data Analysis: Analyze financial data, transactional information, and related reports to identify opportunities for process improvement and ensure data integrity. 4. Documentation: Create and maintain detailed documentation of integration processes, best practices, and workflows to ensure consistency and knowledge transfer within the team. 5. Quality Assurance: Conduct thorough testing and validation of integrated systems to ensure compliance with regulatory standards, data security, and operational reliability. 6. Issue Resolution: Investigate and resolve any issues related to applications and bank integrations promptly, working closely with internal teams, vendors, and financial institutions. 7. Compliance and Risk Management: Ensure compliance with financial regulations and data security standards. Assist in the development and maintenance of risk management protocols. 8. Collaboration: Collaborate with internal teams, customers, and vendors to facilitate smooth integrations, gather requirements, and manage project timelines. 9. Training: Provide training and support to internal finance and operations teams on integrated systems and best practices. Finance, Documents and Warehouse B2B/A2A; Business Analyst Mandatory Skills •Bachelor's degree in Finance, Accounting, Business, Information Systems or a related field. •Proven experience as a Business Analyst in a B2B or e-commerce environment. •Strong analytical and problem-solving skills. •Excellent communication and interpersonal skills. •Knowledge of B2B integration tools and platforms. •Proficiency in data analysis and reporting tools. •Understanding of finance, order processing systems and supply chain processes. •Project management skills. •Ability to adapt to changing technology and industry trends. •Detail-oriented and highly organized. Finance, Documents and Warehouse B2B/A2A; Business Analyst Desired Skills •Experience with EDI (Electronic Data Interchange) and API integration. •Experience with Oracle Fusion ERP •Experience with document management applications like OnBase •Experience with middleware applications like MuleSoft, webMethods, etc. •Familiarity with pipe, valve, and fitting products or the industrial distribution industry. Finance, Documents and Warehouse B2B/A2A; Business Analyst Start Date This position is Hybrid. Finance, Documents and Warehouse B2B/A2A; Business Analyst Location The position is located in Houston, Texas, United States.

Business Analyst, Payment Products Intro We are seeking an experienced Business Analyst specializing in Payment Products (Wires, ACH) to join our dynamic team. The ideal candidate will have a strong background in payment processing and an in-depth understanding of payment products. This role is integral to the success of our Global Operations, ensuring that projects and initiatives align with business strategies and comply with regulations. Business Analyst, Payment Products Job Details The successful candidate will be part of the GWO US Operations Management team, contributing to a large-scale change in payment processes. Responsibilities include managing complex projects, developing new procedures, and implementing systems solutions to meet strategic payment processing needs. This role involves preparing project plans, conducting research, developing training programs, defining test plans, and acting as a subject matter expert. The candidate will also work on designing and reengineering business processes to enhance efficiency and reduce costs. Business Analyst, Payment Products Mandatory Skills - 2-4+ years of experience as a Business Analyst - 1 to 3 years of practical experience in Payments Processing with a solid understanding of Payment Products (Wires, ACH) - Superior technical knowledge in MS Office tools and process management software - Proficiency in business analysis tools and methodologies Business Analyst, Payment Products Desired Skills - Certification in business analysis - Familiarity with project management principles and practices Business Analyst, Payment Products Start Date ASAP Business Analyst, Payment Products Location 250 Vesey Street, New York, New York, United States (Hybrid) 2-3 days in office, Monday-Friday, 9am-5pm

Business Analyst - Loans Intro We are seeking a dynamic and detail-oriented Business Analyst specializing in Loans and Asset-Backed Securities (ABS) to join our financial services client. This role involves supporting the setup and ongoing management of bank loan, warehouse, and repo facility reconciliation and position reporting. Business Analyst - Loans Job Details - Assist with setup and ongoing support for bank loan, warehouse, and repo facility reconciliation and position reporting. - Handle monthly and quarterly ABS and CLO processing and related automation tasks. - Perform cash and loan transaction account reconciliation and related automation. - Review daily reconciliation reports and position statements with related automation. - Document requirements, use cases, and related testing data. - Follow detailed reconciliation and processing scripts to manage cash and transaction activities. - Prepare daily aggregated facility reporting. - Test models and data for completeness and accuracy. - Create reconciliation and validation tools for structured finance transactions using Python. Business Analyst - Loans Mandatory Skills - Strong proficiency with Excel. - Experience in ABS/CLO/CMBS/RMBS industry is preferred. - Proficiency with bank loan or repo facility cash and account reconciliation. - Strong problem-solving skills, excellent work ethic, and good communication skills. - Ability to work independently and as part of a team. Business Analyst - Loans Desired Skills - Proficiency in a programming language such as Python or VBA. - General knowledge of databases, software, and overall process design. - BS degree in finance or a relevant quantitative field such as mathematics, physics, computer science, or engineering. - Proficiency with cash-flow modeling of securitized products. - Proficiency with Access, SQL, and/or ETL experience is a plus. Business Analyst - Loans Start Date ASAP Business Analyst - Loans Location New York, NY, United States - Hybrid, 3 days onsite.

Intro Join our team as a Business Analyst - Expert, where you'll play a crucial role in Asset Management Solutions Technology. You'll be part of a dynamic team responsible for supporting the technology needs of Asset Management, the investment advisor for proprietary mutual funds and ETFs. Job Details As a Senior Business Analyst in Investments Technology, you will be responsible for hands-on requirements gathering, documentation, and leading project workstreams. You'll work closely with product owners and business stakeholders to translate business requirements into technology-friendly language for implementation. Your role will also include testing and supporting User Acceptance Testing (UAT) following the agile scrum process. Mandatory Skills - 11+ years of experience as a Business Analyst with a proven track record of delivering business value. - Experience with Municipal bond trading and portfolio management. - Solid experience with Agile methodologies in developing epics, themes, user stories, supplementary requirements, and business rules. - Strong SQL skills with prior data analysis and data mapping experience. - Excellent written and verbal communication skills. - Good interpersonal, analytical, and problem-solving skills. Desired Skills - Experience with Separately Managed Accounts or Fixed Income asset management. - Experience with Investortools Perform. - Experience with Fixed Income Separately Managed Accounts (SMA) business processes.

Our client is seeking an experienced Sr. Product Manager - Digital to join their innovative team. The ideal candidate will excel in conceptualizing, designing, and launching digital experiences that enhance user engagement and meet business objectives. Key Responsibilities: <ul> <li>Conceptualize and Design Digital Experiences: Lead the creation of digital products from concept to launch, ensuring they align with user needs and business goals. </li><li>Develop Product Documentation: Write requirements, epics, use cases, and user scenarios to clearly convey product intent to stakeholders for feedback and approval. </li><li>Facilitate Workshops: Plan and conduct workshops to gather stakeholder expectations and user needs, translating insights into low-fidelity designs. </li><li>Collaborate Across Teams: Work closely with cross-functional teams, including designers and developers, to ensure cohesive product development and delivery. </li><li>Communicate Design Rationale: Present design and product decisions effectively, explaining the reasoning behind choices to align team understanding. </li><li>Stay Current with Industry Trends: Keep up-to-date with the latest advancements in digital product management and integrate best practices into the development process. </li></ul>Qualifications:<ul> <li>Educational Background: Bachelor's degree in Interaction Design, Computer Science, Information Systems, Human-Centered Design, or a related field; or equivalent professional experience. </li><li>Professional Experience: Proven experience as a digital product owner or designer in a technologically advanced company. </li><li>Portfolio: A strong portfolio or writing samples demonstrating the ability to make design and product decisions, including explanations of design rationale. </li><li>Technical Skills: Proficiency in writing detailed product documentation and translating feedback into actionable design solutions. </li><li>Workshop Facilitation: Experience in planning and leading workshops to extract valuable stakeholder and user insights. </li><li>Communication Skills: Excellent verbal and written communication abilities, with a talent for collaborating effectively across diverse teams. </li><li>Analytical Thinking: Strong problem-solving skills with the ability to think strategically about product development. </li><li>Adaptability: Ability to thrive in a fast-paced environment and adjust to changing priorities. </li></ul>

Business Analyst - GenAI Intro The Business Analyst - GenAI is a pivotal role within the Standards and Innovation function, serving as a crucial link between various users and technologists. The primary objective of this position is to facilitate the continuous exploration and investigation of Generative AI use cases, proofs of concept, and projects. This role is essential in gaining insights and driving appropriate reporting and governance. Business Analyst - GenAI Job Details - Analyze existing GenAI-related use cases in various stages of approval to identify patterns and ensure adequacy of approvals and reporting. - Manage multiple work streams for GenAI projects and proofs of concept across all lines of business. - Contribute to the formulation of strategies and processes for GenAI adoption. - Participate in the development of governance processes. - Develop communication strategies to guide, influence, and persuade colleagues in other areas to adopt consistent processes. - Provide advice and counsel related to processes or operations, prioritizing and validating complex material from multiple sources. - Assess risks when making business decisions, ensuring compliance with applicable laws, rules, and regulations, and managing control issues with transparency. Business Analyst - GenAI Mandatory Skills - 6-10 years of experience in business analysis or systems analysis. - Demonstrated expertise in presenting and using planning tools. - Proven diplomatic and analytical skills. - Ability to manage complex and variable issues with substantial potential impact. Business Analyst - GenAI Desired Skills - Bachelor's degree/University degree or equivalent experience. - Master's degree preferred. Business Analyst - GenAI Start Date ASAP - Contract Business Analyst - GenAI Location This is a hybrid position located in Irving, Texas, United States.

Procom Interview Questions

Procom Interview Guides

Procom Interview Questions

Procom Salaries by Position

Procom Opening Jobs