Prepare for and practice interview questions from General Dynamics Land Systems.

General Dynamics Land Systems Interview Questions

General Dynamics Land Systems 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?

General Dynamics Land Systems Salaries by Position

Reference : 13181 General Dynamics Land Systems is a global leader in the design, development, production, support and sustainment of tracked and wheeled military equipment, specifically the Abrams Main Battle Tank and the Stryker Family of Wheeled Combat Vehicles. This entry-level to mid-level Data Analyst / Industrial Engineer is responsible for: Utilize advanced features of Microsoft Excel, Power BI, IBM Cognos Analytics and other industry-standard data visualization tools to develop and enhance data collection processes. Design and implement dynamic dashboards and interactive reports to facilitate real-time data analysis and decision making. Collaborate with cross-functional teams to understand data requirements and deliver customized data visualization solutions that meet business needs. Perform studies or cycle observations on work standards and equipment capacity models. Develop and provide staffing requirements to meet operations plans. Report on, monitor and impact Production department performance. Conduct studies pertaining to cost control, cost reduction, inventory control, and production record systems to develop and implement plans and programs for facility modifications and revisions to operating methods. Analyze and design sequence of operations and workflow to improve efficiencies in equipment layouts and establish methods for maximum utilization of production facilities and personnel. Ensure processes and procedures are in compliance with Operation Sheets resulting in desired work standards. Estimate new product labor costs and production planning. Support production teams in achieving cost, quality, safety and schedule objectives by utilizing Lean Mfg. tools and conducting cycle observations to improve performance. Conduct regular data audits and troubleshoot any issues related to data collection, storage, and retrieval to improve data quality. Other responsibilities include: Lead and contribute to continuous improvement projects, using data-driven insights to optimize resource utilization and reduce waste. Implement and promote LEAN manufacturing principals and 5S methodology to improve workplace organization, efficiency, and safety. Conduct value stream mapping and process flow analysis to identify and eliminate non-value-added activities, enhancing overall process efficiency. Position Requirements: Must be a US Person. Must be at least 18 years of age. College Degree in Business, Accounting, Data Analytics or Engineering preferred Excellent in Data Analysis, Excel and Power Bi Interface with Production Team Leaders, Production Control, Operations Engineering, Tool Makers, CNC operators, general machinists, painters, assemblers, welders, quality inspectors and material handlers within a unionized workforce. Demonstrate effective communication, presentation, and computer skills, comprehensive knowledge in Excel, Word, and PowerPoint and Power Bi a plus. Work Environment/Demands: This job is performed in an office and heavy manufacturing environment. This role routinely requires standing, walking, sitting, bending, personal interactions for extended periods, and uses standard office equipment such as computers, copiers, scanners, and phones. Exposure to manufacturing environments containing noise, odors, temperature changes, and moving equipment. General Dynamics Land Systems is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race and/or ethnic background, national origin and/or ancestry, color, religion, gender, gender identity or expression, transgender status, sexual orientation, marital/parental status, age, military service, veteran status, disability, pregnancy/childbirth or related conditions, genetic information, or membership in any class protected by applicable law from discrimination in employment.

Job Description General Dynamics Land Systems is a global leader in the design, development, production, support and sustainment of tracked and wheeled military equipment, specifically the Abrams Main Battle Tank and the Stryker Family of Wheeled Combat Vehicles. This entry-level to mid-level Data Analyst / Industrial Engineer is responsible for: <ul><li> Utilize advanced features of Microsoft Excel, Power BI, IBM Cognos Analytics and other industry-standard data visualization tools to develop and enhance data collection processes. </li><li> Design and implement dynamic dashboards and interactive reports to facilitate real-time data analysis and decision making. </li><li> Collaborate with cross-functional teams to understand data requirements and deliver customized data visualization solutions that meet business needs. </li><li> Perform studies or cycle observations on work standards and equipment capacity models. </li><li> Develop and provide staffing requirements to meet operations plans. </li><li> Report on, monitor and impact Production department performance. </li><li> Conduct studies pertaining to cost control, cost reduction, inventory control, and production record systems to develop and implement plans and programs for facility modifications and revisions to operating methods. </li><li> Analyze and design sequence of operations and workflow to improve efficiencies in equipment layouts and establish methods for maximum utilization of production facilities and personnel. </li><li> Ensure processes and procedures are in compliance with Operation Sheets resulting in desired work standards. </li><li> Estimate new product labor costs and production planning. </li><li> Support production teams in achieving cost, quality, safety and schedule objectives by utilizing Lean Mfg. tools and conducting cycle observations to improve performance. </li><li> Conduct regular data audits and troubleshoot any issues related to data collection, storage, and retrieval to improve data quality. </li> </ul>Other responsibilities include: <ul><li> Lead and contribute to continuous improvement projects, using data-driven insights to optimize resource utilization and reduce waste. </li><li> Implement and promote LEAN manufacturing principals and 5S methodology to improve workplace organization, efficiency, and safety. </li><li> Conduct value stream mapping and process flow analysis to identify and eliminate non-value-added activities, enhancing overall process efficiency. </li> </ul> Position Requirements: <ul><li> Must be a US Person. </li><li> Must be at least 18 years of age. </li><li> College Degree in Business, Accounting, Data Analytics or Engineering preferred </li><li> Excellent in Data Analysis, Excel and Power Bi </li><li> Interface with Production Team Leaders, Production Control, Operations Engineering, Tool Makers, CNC operators, general machinists, painters, assemblers, welders, quality inspectors and material handlers within a unionized workforce. </li><li> Demonstrate effective communication, presentation, and computer skills, comprehensive knowledge in Excel, Word, and PowerPoint and Power Bi a plus. </li> </ul> Work Environment/Demands : This job is performed in an office and heavy manufacturing environment. This role routinely requires standing, walking, sitting, bending, personal interactions for extended periods, and uses standard office equipment such as computers, copiers, scanners, and phones. Exposure to manufacturing environments containing noise, odors, temperature changes, and moving equipment. Headquartered in Reston, Virginia, General Dynamics is a global aerospace and defense company offering a broad portfolio of products and services in business aviation; ship construction and repair; land combat vehicles, weapons systems and munitions; and technology products and services. General Dynamics employs more than 100,000 people across 65 countries worldwide and in all 50 U.S. states, more information is available at www.gd.com. General Dynamics Land Systems, is a business unit of General Dynamics, and is an innovative leader of ground combat systems' equipment and software for our clients. Our performance-driven team partners with the U.S. Army, U.S. Marine Corp and other militaries across the Globe to ensure that next generation ground combat vehicles are ready to protect our fighting men and women in uniform. General Dynamics Lands Systems provides a competitive compensation package, site specific flexible work schedules, 401(k) with Company Match; Bonus Eligibility, Employee Development Opportunities, Tuition Reimbursement, On-site Amenities, and comprehensive Medical/Dental/Vision Insurance. At General Dynamics Land Systems, we strive to be champions who drive diversity, equity and inclusion. We are committed to our values and beliefs to provide a healthy and secure working environment that empowers team members to build careers that reward. We are focused on supporting an inclusive company that recognizes the value in creating a dynamic team that is diverse. As an Equal Opportunity Employer, General Dynamics Land Systems ("GDLS") provides all persons with equal opportunity and access to all aspects of employment process, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, marital status, age, disability, status as a protected veteran, or membership in any group protected by federal, state, or local anti-discrimination laws. GDLS also is committed to providing reasonable accommodations to individuals with disabilities and disabled veterans.. If, due to a disability, you need an accommodation to search or apply for an opportunity with GDLS, please call 586-825-4000 or send an e-mail to [email protected] for assistance and let us know the nature of your request and your contact information.

General Dynamics Land Systems Interview Questions

General Dynamics Land Systems Interview Guides

General Dynamics Land Systems Interview Questions

General Dynamics Land Systems Salaries by Position

General Dynamics Land Systems Opening Jobs