Prepare for and practice interview questions from Amtrak.

Amtrak Interview Questions

Amtrak 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

Amtrak Salaries by Position

Your success is a train ride away! As we move America's workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees. Are you ready to join our team? Our values of 'Do the Right Thing, Excel Together and Put Customers First' are at the heart of what matters most to us, and our Core Capabilities, 'Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security' are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future. Work Arrangement: Hybrid out of PA, DC or Wilmington JOB SUMMARY The Lead Software Engineer provides high quality software systems by analyzing requirements, providing technical design, developing software, supporting testing and deployment. The Lead Software Engineer works closely with customers, business analysts and team members to understand the business requirements that drive the analysis and design of quality technical solutions. These solutions must be aligned with business and IT strategies and in compliance with the organization's architectural standards. Responsible for analyzing and bringing new technology trends in the industry to Amtrak. The role is also a point of escalation for operational support for assigned systems. ESSENTIAL FUNCTIONS <ul> <li>Provides technical leadership as part of a diverse team and provides consistent ownership for increasingly complex deliverables.</li> <li>Works on projects that may span a broad range of systems. Requires expertise in multiple technical environments and possesses an increased level of business knowledge. Responsibilities include, but may not be limited to, the following: </li> <li>Consults in the project planning process with customers, IT business analysts, architects, and team members. </li> <li>Organizes and documents technical requirements. Creates technical design specifications and assists in sizing technical requirements. </li> <li>Works with customers to develop and analyze application packages and tools and determine optimum functionality requirements to meet those needs. </li> <li>Collaborates with enterprise architect and infrastructure to integrate applications and hardware.</li> <li>Ensures that the design and application implementation meet security and QA standards. </li> <li>Evaluates new application packages and tools. </li> <li>Provides multiple recommendations for the solutions. </li> <li>Evaluates existing applications and platform and provides recommendations for system enhancements by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications. </li> <li>Participates on teams that outline the process and scope out the improvements that can be realized through the application solution.</li> <li>May lead the deployment of new modules, upgrades, and fixes. </li> <li>Implements integration plans. Interfaces with testing teams to incorporate plans into integration testing process. </li> <li>Defines, develops, or modifies software application modules or enterprise-wide software systems using disciplined development processes. </li> <li>Identifies better sources of data feeds and interfaces with architects to ensure their feasibility with corporate data warehouse, when needed.</li> <li>Documents functions and changes to new or modified modules, test activities/results and other areas such as error handling and backup/recovery procedures. </li> <li>Adheres to quality standards and procedures. Reviews modules for quality assurance and checks compliance with application architecture standards and Service Level Agreements (SLAs). </li> <li>May assist in defining development guidelines and standards to be utilized in software development/integration. </li> <li>Makes modules production-ready by moving them to libraries, completing forms, following procedures, completing version control documents, etc. </li> <li>Provides ongoing maintenance of applications. </li> <li>May produce and analyze data extracts from system based on user requirements. </li> <li>Provides technical leadership coaching and mentoring to team members. Provides technical guidance or system process expertise.</li> <li>Develops reports and presentations for senior management, as needed.</li> <li>May manage vendor relationships that are required to provide operational support</li> <li>May coordinate preventative maintenance activities between vendors, IT and the business, including the installation of service packs, patches, and hot fixes.</li> <li>Keeps abreast of new technical standards and practices.</li> <li>Analyzes/monitors applications to ensure that the functionality and performance meets all product and service level requirements</li></ul> MINIMUM QUALIFICATIONS Bachelor's Degree in Computer Science, Information Systems or Business Management with 6+ years relevant experience or 10+ years relevant work experience in subject matter expert capacity required to satisfy education and experience requirements. MINIMUM KNOWLEDGE, SKILLS, AND ABILITIES <ul> <li> In-depth knowledge required of all modules and functions of IBM Maximo 7.x and higher.</li> <li> Expert proficiency in the following technologies and methods:</li></ul> o Enterprise Asset Management Functional Processes o Reliability Centered Maintenance Management Processes o Business Analysis processes <ul> <li> Advanced knowledge of relational database table structure and design principles (SQL / PLSQL Experience).</li> <li> Maximo integration technologies (MIF, Object structures, services, channels, etc.), specifically related to integrating Maximo with other systems (SAP, ArcGIS).</li> <li> Proven Business Intelligence Reporting models: BIRT, PowerBI, PowerApp, Tableau, Actuate, Cognos, and others.</li> <li> Technical solution design support for the Maximo Enterprise Asset Management system, including interfaces with SAP ERP, Timekeeping, and other supporting partner systems in Amtrak's ecosystem.</li> <li> Work with Implementation Vendors to drive innovative technical solutions within the software's available capabilities.</li> <li> Support the mandated principles of zero customizations, cloud first, and mobile first while maintaining Amtrak IT standards and vision.</li> <li> Provide domain expertise in system architecture and software development, focusing on Mechanical, Engineering, Real Estate, and Facilities Asset management systems.</li> <li> Efficient design and configuration of system security and access, including cloud and mobile solutions.</li> <li> Help define the EAM vision based on system functionality and business needs, with an ongoing search for opportunities to expand the portfolio.</li> <li> Support other initiatives for Operations Management systems, focusing on Data Analytics & Optimization across various projects for wayside detectors and yard workflow.</li> <li> General Web, Cloud & Mobility Background. Strong knowledge of core Internet technologies (HTTP, Mail, REST, DB, Data Modeling, etc.).</li> <li> Strong documentation and communication skills. Ability to articulate complex architectures in actionable terms.</li> <li> Highly proficient knowledge of algorithms, data structures, design patterns, and experience with programming languages.</li> <li> Extremely proficient in frontend (Web), backend (Server), mobile application development, or cloud platform services.</li> <li> Extensive experience in programming and/or systems analysis with a displayed mastery of multiple programming languages.</li> <li> Extensive experience with Agile methodologies and techniques, including SCRUM and SAFE frameworks.</li> <li> Broad understanding of information systems and application architecture standards.</li> <li> Perform development of customer enhancements and maintenance tasks using expertise in SQL Server and Oracle.</li> <li> Ability to work well under deadlines and in a flexible environment.</li> <li> In-depth knowledge of business operations and systems requirements processes, including the ability to measure short- and long-term business goals.</li> <li> Adaptable communication skills to effectively translate between technical and business language.</li> <li> Ability to educate project team members on business unit goals and objectives, and educate the business on the value of information technology.</li> <li> Ability to identify, propose, and oversee the execution of business solutions, and interpret documents communicating business needs and requirements.</li> <li> Ability to assess client needs through direct interaction and identify opportunities to develop the business through effective use of technology.</li> <li> Excellent troubleshooting skills.</li> <li> Excellent communication skills - both oral and written.</li> <li> Problem solver, team player, and demonstrates flexibility to adjust to fluid business requirement changes.</li> <li> Knowledge of the full IT development lifecycle and familiarity with Agile/Scrum development environments.</li> <li> Ability to work on multiple tasks concurrently.</li> <li> Reliable estimation of time and effort required to complete tasks.</li> <li> Ability to quickly learn and understand complex applications and technologies.</li> <li> Working knowledge of Cloud / AWS framework and Red Hat OpenShift.</li></ul> PREFERRED QUALIFICATIONS: <ul> <li>8+ years relevant experience </li> <li>Master's degree in Computer Science, Engineering, specialized training, certification, or equivalent work experience.</li> <li>Experience in travel, hospitality or transportation industries </li></ul> WORK ENVIORNMENT <ul> <li>Work is performed in an office environment.</li> <li>May require travel up to 10% of the time. </li> <li>Requires on-call status.</li></ul> The salary/hourly range is $103,700 - $134,460. Pay is based on several factors including but not limited to education, work experience, certifications, internal equity, etc. Depending on an employee's assigned worksite or location, Amtrak may consider a geo-pay differential to be applied to the employee's base salary. Amtrak may offer additional incentive and pay programs to recognize and reward our employees, including a short-term incentive bonus based upon factors such as individual and company performance that is commensurate with the level of the position and/or long-term incentive plan compensation. In addition to your salary, Amtrak offers a comprehensive benefit package that includes health, dental, and vision plans; health savings accounts; wellness programs; flexible spending accounts; 401K retirement plan with employer match; life insurance; short and long term disability insurance; paid time off; back-up care; adoption assistance; surrogacy assistance; reimbursement of education expenses; Public Service Loan Forgiveness eligibility; Railroad Retirement sickness and retirement benefits; and rail pass privileges. Learn more about our benefits offerings here. Requisition ID:162797 Posting Location(s):Delaware; District of Columbia; Pennsylvania Work Arrangement:05-Hybrid Monthly Job Family/Function:Information Technology Relocation Offered:No Travel Requirements:Up to 25% You power our progress through your performance. We want your work at Amtrak to be more than a job. We want your career at Amtrak to be a fulfilling experience where you find challenging work, rewarding opportunities, respect among colleagues, and attractive compensation. Amtrak maintains a culture that values high performance and recognizes individual employee contributions. Amtrak is committed to a safe workplace free of drugs and alcohol. All Amtrak positions requires a pre-employment background check that includes prior employment verification, a criminal history check and a pre-employment drug screen. Candidates who test positive for marijuana will be disqualified, regardless of any state or local statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use. Amtrak's pre-employment drug testing program is administered in accordance with DOT regulations and applicable law. In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions. In accordance with federal law governing security checks of covered individuals for providers of public transportation (Title 6 U.S.C. §1143), Amtrak is required to screen applicants for any permanent or interim disqualifying criminal offenses. Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience. Amtrak is an EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.

Your success is a train ride away! As we move America's workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees. Are you ready to join our team? Our values of 'Do the Right Thing, Excel Together and Put Customers First' are at the heart of what matters most to us, and our Core Capabilities, 'Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security' are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future. POSITION SUMMARY: The Safety & Security Analytics Team in the Office of Intelligence and Analysis is seeking qualified candidates for a year long internship. The intern will work closely with analysts to generate statistical and graphical analyses of data that provide meaningful insight to safety data trends and generate predictions that are actionable. The intern will also engage with process and data experts throughout the organization to learn how to create a unified approach to problem solving related to identifying risks to customers and employees, mitigation strategies, and/or to improve processes to eliminate injuries, hazards, and risks in the workplace. The intern will focus on learning to design data modeling processes, create algorithms and predictive models to extract, analyze, summarize, and visualize data. ESSENTIAL FUNCTIONS: <ul> <li>Learn to identify valuable data sources and automate collection processes while adhering to quality standards and procedures.</li> <li>Learn to Interpret and analyze data using exploratory mathematic and statistical techniques based on the scientific method to discover trends and patterns.</li> <li>Participates in guided, multifaceted analytic studies against large volumes of data.</li> <li>Conducts research and analytic activities utilizing various data points (unstructured and structured) and employ programming to clean, massage, and organize the data.</li> <li>Work closely with analysts to experiment against data points, provide information based on experiment results and provide previously undiscovered solutions to data challenges. </li></ul>MINIMUM QUALIFICATIONS: <ul> <li>Must be actively pursuing a degree at an accredited educational institution. </li> <li>Must be actively pursuing a graduate degree in statistics, mathematics, computer science, data analytics, data science, or other quantitative field.</li> <li>Must have at least 3 years of academic undergraduate studies completed or a junior status at minimum. </li> <li>Must have a cumulative GPA of 2.8 or higher.</li> <li>Must be available to work a minimum of 20 hours per week between the days/hours: Monday - Friday, 8am-5pm. </li></ul>PREFERRED QUALIFICATIONS: <ul> <li>Must have excellent oral and written communication skills</li> <li>Knowledge of Microsoft Office Suite</li> <li>Knowledge of Python, or other programming languages</li> <li>Knowledge of SQL or other querying languages </li> <li>Knowledge of Microsoft Excel including VBA to build macros, pivot tables, and advanced formulas/functions</li> <li>Knowledge of or experience with using BI tools such as PowerBI, SAP Business Objects, Tableau, or equivalent and data frameworks such as Hadoop, Spark or equivalent</li> <li>Knowledge of building predictive models and machine-learning algorithms a plus </li></ul> COMMUNICATIONS AND INTERPERSONAL SKILLS: Must have excellent oral and written communication skills. The hourly range is $17.50 per hour - $35.00 per hour. Pay is based on factors including school year, program of study, etc. In addition, paid internships include Amtrak rail pass privileges as a part of the experience along with one (1) PTO day per academic year. Summer 2025 internship program will run from May 19th - August 8, 2025. Requisition ID:163156 Posting Location(s):District of Columbia Work Arrangement:06-Onsite Job Family/Function:Safety & Security Relocation Offered:No Travel Requirements:Up to 25% You power our progress through your performance. We want your work at Amtrak to be more than a job. We want your career at Amtrak to be a fulfilling experience where you find challenging work, rewarding opportunities, respect among colleagues, and attractive compensation. Amtrak maintains a culture that values high performance and recognizes individual employee contributions. Amtrak is committed to a safe workplace free of drugs and alcohol. All Amtrak positions requires a pre-employment background check that includes prior employment verification, a criminal history check and a pre-employment drug screen. Candidates who test positive for marijuana will be disqualified, regardless of any state or local statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use. Amtrak's pre-employment drug testing program is administered in accordance with DOT regulations and applicable law. In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions. In accordance with federal law governing security checks of covered individuals for providers of public transportation (Title 6 U.S.C. §1143), Amtrak is required to screen applicants for any permanent or interim disqualifying criminal offenses. Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience. Amtrak is an EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.

Amtrak Interview Questions

Amtrak Interview Guides

Amtrak Interview Questions

Amtrak Salaries by Position

Amtrak Opening Jobs