Prepare for and practice interview questions from West Fraser.

West Fraser Interview Questions

West Fraser 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

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

West Fraser Salaries by Position

Are you interested in working for a company that offers both a challenging work environment and a rewarding career path? The primary responsibility of the JD Edwards Business Analyst is to work closely with the business, sales, and shipping to determine their requirements and collaborate with the technical teams to facilitate the changes. What you will do: <ul><li>Work with Business Users to identify, document, and resolve issues arising from the use of JD Edwards Enterprise One Order to Cash functionality within West Fraser's various lines of business.</li><li>Capture business needs and translates those needs into measurable requirements that can be coded, tested, and successfully implemented and adopted by the business.</li><li>Manage the creation and execution of test plans, ensuring that the results meet the specified business requirements while supporting QA activities as needed.</li><li>Training of business users on Order to Cash applications and configurations</li><li>Participate in the development process in a support role through the software product lifecycle.</li><li>Participate in cross-functional integrated teams to address business and adoption issues (e.g., user experience, data flow, business process flow)</li><li>Contributes and participates in the successful rollout of JDE enhancements</li><li>Triage reported defects and document root cause analyses to avoid production service interruptions</li><li>Assist Business with month-end, year-end closing procedures.</li><li>Periodically check and fix issues that come up in integrity and reconciliation reporting.</li><li>Review and make recommendations for application of JDE system patching or updates.</li><li>Communicate application problems and issues to key stakeholders, including management, development teams, end users, and unit leaders.</li><li>Test fixes and perform post-resolution follow-ups to ensure problems have been adequately resolved.</li><li>Conduct research on emerging application development software products, languages, and standards in support of potential procurement and development efforts.</li><li>Work with vendors to facilitate the efficient implementation of new software products, systems, and enhancements as well as the resolution of any adaptation issues.</li><li>Manage assigned tickets and work packages using ServiceNow and JIRA</li></ul> What you will need to be successful: <ul><li>Bachelor's degree or equivalent experience</li><li>5+ years' experience with business systems analysis, requirements authoring and hands on application support in large enterprise environments</li><li>Experience in design and implementation of JDE modules</li><li>Experience with Order to Cash lifecycle, Accounts Receivables, inventory management and manufacturing processes.</li><li>Successfully completed at least one full implementation involving multiple site configuration set up with proven incorporation of structured planning and testing processes</li><li>Experience with business process analysis and follow through improvement implementations</li></ul> What will make you stand out: <ul><li>Experience working within manufacturing facilities and with manufacturing staff on design and implementation of software initiatives</li><li>Oracle Transportation Module (OTM) experience is strongly preferred</li><li>Excellent written verbal and oral communication skills with a proven record in communicating with all levels of the organization</li><li>Clear understanding of emerging technologies and enhancements that will allow process improvements and enhanced business functionality</li><li>Ability to work effectively and adapt to shifting priorities as business needs and deadlines change</li><li>Experience with ServiceNow, JIRA software</li><li>Oracle E-Business Suite experience considered an asset</li><li>Strong interpersonal communication skills</li></ul> Awesome Benefits you will get: <ul><li>Competitive starting pay </li><li>On-the-job training </li><li>A culture that strongly believes in promoting from within</li><li>Medical</li><li>Dental</li><li>401k Plan, with company matching & retirement contribution</li><li>Life insurance</li><li>Short and long-term disability,</li><li>Paid vacations and holidays,</li><li>Potential relocation assistance.</li></ul> West Fraser is a growing, diversified wood products company with over 60 facilities in North America and Europe. We are the worlds' largest softwood lumber producer. Our investments include a climate-controlled mill; modern, competitive manufacturing facilities; product innovation; and bioenergy. These investments are adding up to a bright future. Safety is one of West Fraser's core values and our employees can expect a challenging, stable work environment with career development opportunities. Apply: If you are ready to build your career in a company that thrives on growth, internal promotions, training, safe work environment, rewarding work, challenge, and opportunity, come build your career with us at West Fraser: www.westfraser.com/jobs We thank all candidates for their interest; however, only those selected for an interview will be contacted. Please apply through our online application process. Be sure to attach your resume to your online profile as resumes will not be accepted at the site. No phone inquiries, please. West Fraser believes inclusive, diverse teams build a more vibrant workforce, safer operations, and a stronger company overall. We strive to create workplaces and leadership teams that are reflective of the diverse communities we are a part of. We will not discriminate against any applicant for employment on the basis of race, gender, national origin, or any other protected legal characteristic. West Fraser is an Equal Opportunity Employer M/F/V/D & Drug-Free Workplace

West Fraser Interview Questions

West Fraser Interview Guides

West Fraser Interview Questions

West Fraser Salaries by Position

West Fraser Opening Jobs