Prepare for and practice interview questions from Procom.

Procom Interview Questions

Procom 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

Procom Salaries by Position

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.

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:
Job Description Hi,
Hoping all is well. We have a job opportunity for you: TDbank, IT - Data Modeler/Data Analyst /W2 basis + Benefit coverage. And TDBank provides great experience and has great people to work alongside.
Hoping you would consider and I'm looking forward to hearing from you. Please check the job description below. And kindly send this info to your friends who would be interested.
Thanks much!
Job #196345 | US - IT - Data Modeler/Data Analyst | Toronto Dominion Bank
6 Month Contract (possible extension up to 2 yrs)
Location: Mount Laurel - will consider 2-3 days a week remote however must be able to come into the office, interviews will be in person so no relocation considered.
Manager is seeking a Data Modeler/Data Analyst to join DCTS team. The Senior Data Analyst will be responsible for extracting, staging, storing, migrating, hashing, and analyzing TD Bank (USA) data across multiple channels and product sets. The successful candidate will develop logical data models, conduct data mining, and integrate/match data across different data sets for analytical purposes, and segmentation methodologies to address a wide array of business issues, objectives and strategies.
Responsibilities:
Develop database models and supporting documentation in order to meet business requirements. Define data requirements and business rules, perform logical and physical data modeling, implement and test database design. Coordinate data models, dictionaries and other documentation across multiple applications.
Job Responsibilities:
• SME (Subject Matter Expert) to establish, communicate and execute measurement and analytical strategies for TD Bank (USA). Design model/methodology to integrate raw data across different data sources.
• Analyze trends & data in both internal and vendor-supplied data to interpret customer relationships and make appropriate recommendations to key stakeholders within the organization.
• Support Channels initiatives for TD Bank (USA) with data extraction, migration, storage, integration, and analysis, business cases and providing monthly trended forecast and plan information.
• Working with key stakeholders and other members of the Digital Customer Insights team define and manage online customer insights through definition of KPIs, web metrics capabilities and reporting.
• Provide value-added data analysis and anticipate the requirements of the Online Channel stakeholders.
• Contribute to presentations for senior management that clearly and concisely present findings and recommendations.
• Working with other members of the Digital team and tech define and establish standards, processes and policies for an online datamart.
• Participate in the education of business partners in the area of data analytics.
• Stay abreast of industry trends and innovations and drive new analytics initiatives that contribute to business goals.
Qualifications MUST HAVES:
Experience in developing logical/physical models for operational systems,
Experience in database administration and impact analysis of data structure changes.
5+ years experience in the following:
ERWIN
OLTP
SQL or SAS
RUP
Oracle
MS Office Tools
Must have worked with Large Data - ability to create and manipulate Data Models
1 year experience with Hadoop
PGP encryption
Nice to have:
Data warehouse background.
Skills:
• Undergraduate university degree in business, statistics or analytically-based discipline, or equivalent experience; having a post graduate degree would be an asset.
• Experience working with Data Warehouse environments and applications.
• Data mining and modeling capabilities with a solid background working with large data sets.
• Excellent analytical, organization and presentation skills. A drive to understand the relationships between divergent data metrics.
• Experience with cross-channel and data that spans multiple product groups.
• Experience with data sanitization such as masking, hashing, and obfuscation algorithms.
• Experience with data extraction, transformation, loading and governance.
• Experience with the following software and tools:
• Microsoft Office
• SAS and SQL
• Business Intelligence software such as Tableau, Crystal Reports, Business Objects or Cognos
• SQL Server
• SAS (PC and Host versions)
• Win SQL
• Encryption products like WinZIP and PGP
• Experience with Web Analytics Applications like Adobe/Omniture, Google Analytics, Coremetrics would be an asset.
• Strong online/web/digital experience and knowledge of the latest user trends and behavior.
• A strong focus on attention to detail, accuracy and on-time delivery.
• Ability to work independently as well as a contributing member of the team.
• Ability to prioritize competing tasks in a deadline-driven environment.
• Strong interpersonal skills.
5-7 years experience required.
Additional Information All your information will be kept confidential according to EEO guidelines.

#J-18808-Ljbffr

Sr Business Analyst - Operational Risk On behalf of our banking client, Procom is looking for a Sr Business Analyst - Operational Risk on contract located in Fort Lauderdale, Florida, United States Sr Business Analyst - Operational Risk: Job Title Job Details The ALPS team is looking for a solid multi-faceted business analyst who can apply themselves to a wide range of tasks and projects at any one time. The candidate will need to bring a willingness to learn a broad range of Capital Markets knowledge and skills but also garner a roll-up-your-sleeves attitude to ensure the delivery of the team's end product. There will be a requirement to own and deliver the onboarding of new systems from trading booking systems, product processors, reconciliation systems, and risk systems as appropriate. Close partnership with technology will be required to translate business requirements based on stakeholder requests. Mid-level project management governance to track projects globally is required, as well as providing status updates to Senior Management. In addition, the role will comprise providing support to the end users of our reporting suite and facing off to senior levels within our client base. Tasks Include (but are not solely confined to): • Responsible for owning and contributing to projects throughout all phases of the project lifecycle e.g. Requirements Specification, UAT Testing and Sign Off, Rollout and Post Production Checkouts • Requirements Specification: Understand, create, review, and enhance global Business Requirement Documents (BRDs) and Feed Specification Documents to meet the needs of the enhancement or feed onboarding. • Act as liaison between Technology and Business Stakeholders. Working knowledge of relational databases (tables, datatypes, joins) and experience of manipulating and working with large datasets is essential. • UAT Testing: Develop and execute UAT test plans that will ensure business requirements have been met / create test scripts including specific test cases and expected results • UAT Sign off: Manage and collaborate with users at various levels within Business to take them through the UAT testing process and successfully obtain sign off during the UAT phase • Rollout and Post Production Checkouts: Act as point of contact for Technology partners and contribute to project rollout and post production checkouts to ensure successful project closure • Documentation: Create and update Alps C&C documentation including: Business Requirements Documents (BRDs), mapping specs, user stories, extraction criteria, RAIDLog, etc. • Develop SME level knowledge of ALPS reporting and workflow platforms to share knowledge, provide training, and assist to end users. • Identify areas of inefficiency and implement system and process improvements in the spirit of continuous improvement • Understanding and utilize standard processes, design and testing tools throughout project development life cycle • Face-off with Operations, IT, Internal Audit, Line Control to a senior level as a representative • Excellent presentation and communication skills with exquisite attention to detail in order to facilitate decision making. Sr Business Analyst - Operational Risk : Job Title Mandatory Skills - Minimum 5 years’ experience as a Business Analyst or in Investment Banking Operations or IT. Experience in operational risk and control is a plus. - Strong analytical and problem-solving skills. - Excellent verbal, written, and interpersonal communication skills. - Ability to work together with regional and global stakeholders to execute on program deliverables and share status updates - Knowledge of Capital Markets Operations is a plus - Comfortable analyzing data from numerous disparate source systems and large datasets - Ability to facilitate global calls and manage various stakeholders at all levels of seniority - Ability to build consensus and collaborate with others. History of success working in a team environment. - Flexibility to handle multiple tasks and changing priorities. - Monitor tight deadlines or unexpected requirement changes - Ability to multi-task and take ownership of projects and change initiatives - Advanced Microsoft Excel skills including use of Logical, Data and Text functions in order to manipulate and analyze large datasets - Effective use of Word and PowerPoint to create succinct project documentation and senior management presentations - Working knowledge of data warehouse and experience of MicroStrategy is highly desirable - Working knowledge of JIRA Sr Business Analyst - Operational Risk : Job Title Desired Skills - QlikView Business Intelligence or Tableau knowledge is a plus - Project Management and direct experience of all phases within project lifecycle (SCRUM, 6 SIGMA knowledge very applicable) - SQL experience is a plus Sr Business Analyst - Operational Risk: Duration: 6 months Sr Business Analyst - Operational Risk: Location: Fort Lauderdale, Florida, United States. (Hybrid)

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:
Job Description MTPS Business Analyst
On behalf of our client, Procom Services is searching for a MTPS Business Analyst for a contract opportunity in Durham, NC.
MTPS Business Analyst Job Details Supports multiple active projects for business requirements analysis, project documentation and support for transition into production-level delivery environments.
Collects, translates and analyses IT project business requirements into functional specifications.
Documents user needs, program functions, and steps required to develop or modify systems.
Works closely with project managers to prepare project-phase plans and implementation schedules.
Other duties may include documenting workflows and recording business analysis results.
Obtaining contracts or sign-off from customers to start the proposed project.
Explaining to external clients any problems related to software functionality and other issues throughout the development stage.
Assists in monitoring progress of project to ensure agreed deadlines are met; as well as producing weekly progress reports and submitting to clients and project managers, among others.
Qualifications MTPS Business Analyst Mandatory Skills
Must have strong analytical and problem-solving skills, excellent written and verbal communication skills, solid organizational skills.
Strong documentation skills, technical writing skills – with fluency in IT data center environments, functions and terminology.
Strong experience in team collaboration.
Excellent understanding of business systems and infrastructure industry requirements.
Advanced knowledge in writing project requirements and project documentation from start to finish.
Ability to relay technical information clearly to staff.
Clearly understands project designs with specifications and deliverables.
3-6 years specific experience required, prior experience working in technical environments developing requirements required.
BS in Business, Computer Science or equivalent training and experience.
MTPS Business Analyst Start Date Additional Information All your information will be kept confidential according to EEO guidelines.

#J-18808-Ljbffr

Technical Data Analyst / Business Analysis Intro Our banking client is seeking a Technical Data Analyst / Business Analysis professional to join a dynamic Markets Program Execution & Transformation Team. This role is integral for ensuring the timely execution of technical data-centric deliverables. The ideal candidate will have a rich background in data and transformation efforts, coupled with project management expertise, to provide meaningful and sustainable solutions. Technical Data Analyst / Business Analysis Job Details - Support the Senior Project Managers to drive the onboarding of critical datasets to a single strategic data lake. - Own the delivery of key project streams, ensuring actions and milestones are accurately tracked and reported. - Work directly with Technology teams and Business stakeholders to support the design and review of strategic data models. - Take a hands-on approach to managing the end-to-end onboarding of datasets, working directly with SQL to sanity check implementations and to support both QA teams and the business during UAT. - Lead or participate in working groups, workshops, and with stakeholders to understand business requirements, define project plans, and manage timelines. - Identify challenges and proactively seek to resolve or escalate risk and issues in a timely and well-articulated manner to the projects by engaging relevant stakeholders and PMs. - Assist in producing accurate and insightful project update materials and artifacts, tailoring to various forums and committees. - Build strong relationships, adopting a joined-up approach, to support the execution of programs. Technical Data Analyst / Business Analysis Mandatory Skills - Working knowledge of SQL and experience working with relational databases. - Demonstrable experience of daily management and tracking of technical deliveries. - Self-starting with the ability to multitask, prioritize, and proactively seek out teams and individuals across the organization to help resolve issues. - Demonstrated analytical skills with follow-up and problem-solving capability. - Must be an energetic self-starter, able to drive initiative with minimal direction. - Organized, detail-oriented, and able to track multiple workstreams/projects at once. - 3 years minimum experience. Technical Data Analyst / Business Analysis Desired Skills - Bachelor's/University degree. Technical Data Analyst / Business Analysis Start Date Immediate. Technical Data Analyst / Business Analysis Location New York, New York, United States - Hybrid.

Data Analytics Engineer Intro We are seeking a highly skilled and experienced Data Analytics Engineer to join our team in a 100% remote capacity. This is a senior-level position with a focus on constructing and maintaining data infrastructure for Charitable Analytics. The ideal candidate will have a proven track record in database solutions, data quality, data layers, data lake, data pipeline creation, data warehouse implementation, and data architecting solutions. This role will start as a 6-month contract. Job Details As a Data Analytics Engineer, you will work closely with Charitable Technology to build data pipelines for production data. You will be responsible for data modeling, database management, and constructing and maintaining data infrastructure for Charitable Analytics. You will also partner with Charitable Analytics to build reporting views and monitor for data issues, changes, and impacts to reporting. Additionally, you will be responsible for streamlining data preparation and providing executive-level consultation. Mandatory Skills - 6-10 years of experience - Ability to provide executive-level consultation - Database solutions - Data quality - Data layers - Data lake - Data pipeline creation - Data warehouse implementation - Data architecting solutions - ETL experience Desired Skills - Experience with Oracle preferred - Big Query knowledge beneficial - Worked in matrixed or corporate environments previously - Excellent communication skills Start Date Anticipated start date is 9/16/2024. Location This position is fully remote, with a preference for candidates located in Austin, Texas, United States.

Business Analyst Intro We are seeking two skilled Business Analysts to join our team specializing in Anti-Money Laundering (AML) projects. The successful candidates will play a crucial role in assessing the impact of regulatory changes on Commercial banking, focusing on people, systems, and training. Day-to-Day Responsibilities Successful candidates will join a team focusing on Anti-Money Laundering projects. Responsibilities include: - Documenting processes & procedures - Planning and verifying changes to remediation processes - Finding reporting metrics, creating & sending out reporting - Evaluating business processes & working collaboratively with operations analyst & KYC Lead - Refining processes around KYC and general fraud, loss, and customer profile information - Working with Relationship Managers and other internal resources to collect required information - Developing communication & processes plans for customers with missing or incorrect profile details - Documenting information on processes and forum creation; creating presentation decks on all MRA remediation activities and processes - Acquiring a sound to advanced understanding of business and user interaction with technology throughout project delivery - Working collaboratively with stakeholders including business, technology, and partners to support project benefits and changes to business processes, policies, and systems across single or multiple lines of businesses Mandatory Skills 1. Knowledge/experience of & with business analysis 2. Expert MS Office skills - advanced Excel (pivot tables), Visio 3. Excellent interpersonal, verbal & written communication skills 4. Ability to lead discussions/meetings, and present to executives 5. Experience with identifying, mapping, and refining business processes 6. Advanced knowledge of and experience with project life cycle/practices 7. AML consulting experience; understanding of Know-Your-Customer standards Desired Skills 1. Technical background would be an asset 2. Previous banking or FI experience 3. Salesforce experience 4. Experience with Jira Start Date ASAP Location Remote - EST

Product Manager/Business Professional Intro
We are seeking a highly skilled and motivated Product Manager/Business Professional to join our team on a 9-month contract. This role requires a blend of strong IT-related product and project management experience, excellent communication skills, and the ability to work effectively in a matrixed or corporate environment. The position is primarily on-site at our Westlake campus from Monday to Thursday, with the flexibility to work from home on Fridays. While professional experience and qualifications are key for this role, make sure to check you have the preferable soft skills before applying if required. Product Manager/Business Professional Job Details
Work closely with the Director of Data Consumptions Enablement and DASIP Ecosystem workstream lead.
Develop and manage plans to achieve the stated deliverables of the wider program.
Collaborate across the DCE, SDA, and technical teams to manage the plan, identify risks, issues, and recommend actions.
Facilitate working sessions, capture and synthesize Current State Assessments, draft content for Requirements and Design deliverables, socialize findings/designs, and gain agreements.
Work with various subject matter experts to capture content and make it available in easily digestible formats.
Ensure that content is easily findable for users and maintainable for product managers.
Collaborate with other workstream teams to align plans and gain agreements on intersections with other capabilities.
Product Manager/Business Professional Mandatory Skills
Strong experience in IT-related product and project management.
Experience in use case, user story, requirements, and compliance matrices.
Proven track record of delivery and ability to create, socialize, and manage a plan focused on outcomes and deliverables.
Experience facilitating and managing content capture, design, socialization, and review sessions.
Solid ability to synthesize content, such as key findings from an analysis, summarizing feedback sessions, and presenting important information.
Proficient in Microsoft 365 tools, particularly Outlook, PowerPoint, and web-based collaborative platforms like Teams and SharePoint.
Product Manager/Business Professional Desired Skills
Experience with Jira and Confluence.
Ideally, some experience in data, reporting, and business intelligence tools, particularly in the data and analytics field.
Product Manager/Business Professional Start Date
Anticipated Start Date: 7/29/2024
Product Manager/Business Professional Location
This position is located in Westlake, Texas, United States. On-site work is required from Monday to Thursday, with the option to work remotely on Fridays. #J-18808-Ljbffr

Procom Interview Questions

Procom Interview Guides

Procom Interview Questions

Procom Salaries by Position

Procom Opening Jobs