Prepare for and practice interview questions from Onyx Point, Inc..

Onyx Point, Inc. Interview Questions

Onyx Point, Inc. Interview Guides

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

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?

Onyx Point, Inc. Salaries by Position

Required: TS/SCI security clearance Job Description: Onyx Point is looking to hire a Senior Software Engineer to join our mission management team developing high quality software applications to handle resource management, system security, health monitoring, and status awareness as foundational tools for a signal processing platform. This role requires a deep understanding of programming languages, designing and deploying modular applications, employing front-end and back-end technologies, and leveraging DevSecOps tooling to deliver automated mission management capabilities. This Senior Software Engineer role is in support of the U.S. Navy Spectral Program. Spectral is a seven-year $1.2B program to provide the U.S. Navy's next-generation signals intelligence, electronic warfare, and information operations software technologies. The Spectral system is critical to the ability for our forces to fight and win in the increasingly sophisticated and complex cyber and electronic threats of our adversaries. What You'll Get to Do: You will develop and deploy core enabling technologies for the cloud enabled combat systems that make up Spectral, leveraging the most advanced software technologies available. Spectral is not only delivering ground-breaking capabilities to the warfighter today, but also building a modular distributed architecture that allows the system to rapidly evolve, deploy, and adapt to scale multi-echelon operations. Creative solutioning and thinking outside the box to solve manual pain points for the warfighter through innovative engineering and rapid deployment of software running in production. Developing software technologies and leveraging first class tooling to generate high availability, low latency, fault tolerance, and scalability across multi-echelon distributed environments. As a Senior Software Engineer, collaborate closely across Integrated Product Teams to design software solutions for processing algorithms across distributed systems, ensuring performance and reliability at scale for the Spectral system More About the Role: As a Senior Software Engineer, you will have the opportunity to build and deploy high quality software applications that directly impact the U.S. Navy's employment of Spectral Mission Management and Support Services. The Mission Management team provides the powerful capability for Spectral capabilities to be dynamically allocated between mission functions while detecting and automatically healing system functionality and ensuring intra and inter-system trust. Our Software Engineers work within an Agile development team leveraging scaled agile practices to rapidly deliver incremental software solutions to our customer's, focused on ideation, development, quality, deployment, and sustainment of high-quality software products. This is a role where you will be a resident practitioner, forward leaning in software engineering approaches to solve for the next problem, so that, the Spectral system outpaces our adversaries' capabilities. This position is for an innovative team contributor, with remote and hybrid work, who will perform key responsibilities as: <ul> <li> <ul> <li> Lead the design, development, and deployment of high-quality software applications. </li> <li> Produce quality, sustainable, and efficient code using best practices and modern software methodologies. </li> <li> Architect scalable, high-performance systems and ensure they meet both functional and non-functional requirements. </li> <li> Collaborate with the Integrated Product Lead and UI/UX team to take Spectral requirements and translate them into end-to-end solutions. </li> <li> Troubleshoot, debug, and optimize applications for speed and scalability across distributed environments. </li> <li> Hands-on experience with containerization and orchestration tools (Docker, Kubernetes, etc). </li> <li> Team build, collaborate with engineering teams, mentor junior developers in software development best practices. </li> </ul> </li> </ul> You'll Bring These Qualifications: <ul> <li> Bachelor's or Master's degree in Computer Science, Electrical Engineering, or a related field, PhD is a plus </li> <li> 7+ years of experience in software engineering </li> <li> Expertise in developing software to enable digital signal processing systems, using cloud native platforms, and edge computing environments </li> <li> Proficiency in programming languages (Python, Java, Go), and experience in distributed computing frameworks (Kafka, or similar) </li> <li> Expertise in container automation and orchestration tooling employment (Kubernetes, Docker) </li> <li> Experience with microservices, API development, and RESTful web services </li> <li> Strong problem-solving and debugging skills in distributed environments, solution expert in solving issues related to synchronization, latency, and fault tolerance </li> <li> Proficiency in front-end and back-end technologies (React, Node.js, Django) and frameworks as required by the role </li> <li> Knowledge of Agile software development best practices </li> <li> Knowledge of modern software engineering, to include CI/CD pipelines, version control, and automated testing </li> <li> Strong communication skills, ability to work independently and within agile team constructs to lead developers in fast paced, collaborative environments </li> <li> Active or ability to acquire Top Secret/SCI DoD Security Clearance </li> </ul> These Qualifications Would be Nice to Have: <ul> <li> Knowledge of cloud native architectures, hybrid cloud environments, and edge computing </li> <li> Familiarity with security best practices in software development </li> <li> Experience with AI/ML integration and data engineering is a plus </li> <li> Experience personally implementing and utilizing CI/CD pipelines </li> <li> General knowledge of digital signal processing </li> <li> Specific knowledge of tools involved in system monitory and status </li> <li> Specific knowledge of tools involved in system security, login, and auditing </li> <li> Comfortable with both coding technical solutions and describing designs for others to code solutions Compensation: We are committed to providing fair and competitive compensation. The salary range for this position is $78,000 to $250,000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidate's work location, specific role, skill set, and level of expertise. Benefits: We offer a comprehensive benefits package, including:</li> <li>Health Coverage: Medical, dental, and vision insurance</li> <li>Additional Insurance: Basic Life/AD&D, Voluntary Life/AD&D, Short and Long-Term Disability, Accident, Critical Illness, Hospitalization Indemnity, and Pet Insurance</li> <li>Retirement Plan: 401(k) plan with company match</li> <li>Paid Time Off: Generous PTO, paid holidays, parental leave, and more</li> <li>Wellness: Access to wellness programs and mental health support</li> <li>Professional Development: Opportunities for growth, including tuition reimbursement</li> </ul> Additional Perks: Flexible work arrangements, including remote work options Flexible Spending Accounts (FSAs) Employee referral programs Bonus opportunities Technology allowance A diverse, inclusive, and supportive workplace culture

TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI W/ POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED) Preferred Qualifications: Familiarity with microservices software development technique and container-orchestration (e.g., Kubernetes) Detail: Basic Information The Software Engineer develops, maintains, and enhances complex and diverse software systems (e.g., processing- intensive analytics, novel algorithm development, manipulation of extremely large data sets, real-time systems, and business management information systems) based upon documented requirements. Works individually or as part of a team. Reviews and tests software components for adherence to the design requirements and documents test results. Resolves software problem reports. Utilizes software development and software design methodologies appropriate to the development environment. Provides specific input to the software components of system design to include hardware/software trade-offs, software reuse, use of Commercial Off-the-shelf (COTS)/Government Off-the-shelf (GOTS) in place of new development, and requirements analysis and synthesis from system level to individual software components. Twenty (20) years experience as a SWE in programs and contracts of similar scope, type, and complexity is required. Bachelor's degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor's degree. <ul> <li> Voice or video processing systems requiring ingest of multiple audio and video formats, playback to end users, storage, and retrieval </li> <li> Average ingest, storage, content search and retrieval of 500GB/day or more of multilingual text </li> <li> Distributed Peer to Peer content storage and retrieval systems with more than 500 nodes. </li> <li> Metadata indexing, metadata summarization, content and metadata data mining, visualization and analytics. </li> <li> A minimum six (6) years demonstrated experience out of the most recent 8 years developing production software for one of the following environments: Solaris, or Linux OS. </li> <li> Six years (6) of experience developing software using the Java programming language or C or C++. </li> <li> Demonstrated work experience developing RESTful services. </li> </ul> <ul> <li> Recommend new technologies and processes for complex software projects </li> </ul> <ul> <li> Serve as the technical lead of multiple software development teams </li> </ul> <ul> <li> Select the software development process in coordination with the customer and system engineering </li> </ul> <ul> <li> Ensure quality control of all developed and modified software </li> </ul> <ul> <li> Delegate programming and testing responsibilities to one or more teams and monitor their performance </li> </ul>

REQUIRED: TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI W/ FULL SCOPE POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED) Job Description: Performing as part of an Agile Software Development team using Jira for requirements tracking, the selected candidate will perform a Software Engineering activities in support of our client. The team's responsibilities revolve around using new technologies to ensure the compliance of interactions and accesses between various enterprise systems. The Software Engineer, working closely within this 6 person team will learn from and share knowledge with this inquisitive, fun, and hardworking team. Leadership opportunities exist for this position. Candidate should have experience in the following: <ul> <li> Demonstrated experience in architecting, designing, developing solutions using the ELK (Elasticsearch, Logstash and Kibana) stack - not limited to but including analytics and machine learning </li> <li> Demonstrated experience in SQL and writing complex queries with joins and aggregate that deals with large datasets. </li> <li> Demonstrated experience with Python 2.x </li> <li> Demonstrated experience with the Hadoop Distributed File System (HDFS) </li> <li> Experience leading design and implementation of new stories and bug fixes </li> <li> Experience performing thorough design reviews and code reviews </li> <li> Hands on Java development, Junit testing and issue troubleshooting </li> <li> Experience working in an Agile based development environment, using Agile concepts </li> <li> Understanding and comfort with enterprise frameworks for dependency injection, object relational mapping and logging (Spring Framework, Hibernate, SLF4J) </li> </ul> <ul> <li> Familiarity with Build Management, Continuous Integration, and Automated Testing (Maven, Jenkins) </li> </ul> Individual Capabilities Required: <ul> <li> Fourteen (14) years experience as a SWE in programs and contracts of similar scope, type, and complexity is required. </li> <li> Bachelor's degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor's degree. </li> <li> Analyze user requirements to derive software design and performance requirements </li> <li> Debug existing software and correct defects </li> <li> Provide recommendations for improving documentation and software development process standards </li> <li> Design and code new software or modify existing software to add new features </li> <li> Integrate existing software into new or modified systems or operating environments </li> <li> Develop simple data queries for existing or proposed databases or data repositories </li> <li> Write or review software and system documentation </li> <li> Serve as team lead at the level appropriate to the software development process being used on any particular project </li> <li> Design or implement complex database or data repository interfaces/queries </li> <li> Develop or implement algorithms to meet or exceed system performance and functional standards </li> <li> Assist with developing and executing test procedures for software components </li> <li> Develop software solutions by analyzing system performance standards, confer with users or system engineers; analyze systems flow, data usage and work processes; and investigate problem areas </li> <li> Modify existing software to correct errors, to adapt to new hardware, or to improve its performance </li> <li> Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design </li> <li> Design or implement complex algorithms requiring adherence to strict timing, system resource, or interface constraints; Perform quality control on team products </li> <li> Implement recommendations for improving documentation and software development process standards </li> <li> Oversee one or more software development teams and ensure the work is completed in accordance with the constraints of the software development process being used on any particular project </li> <li> Confer with system engineers and hardware engineers to derive software requirements and to obtain information on project limitations and capabilities, performance requirements and interfaces </li> <li> Coordinate software system installation and monitor equipment functioning to ensure operational specifications are met </li> </ul> Compensation: We are committed to providing fair and competitive compensation. The salary range for this position is $78,000 to $250,000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidate's work location, specific role, skill set, and level of expertise. Benefits: We offer a comprehensive benefits package, including: <ul> <li>Health Coverage: Medical, dental, and vision insurance</li> <li>Additional Insurance: Basic Life/AD&D, Voluntary Life/AD&D, Short and Long-Term Disability, Accident, Critical Illness, Hospitalization Indemnity, and Pet Insurance</li> <li>Retirement Plan: 401(k) plan with company match</li> <li>Paid Time Off: Generous PTO, paid holidays, parental leave, and more</li> <li>Wellness: Access to wellness programs and mental health support</li> <li>Professional Development: Opportunities for growth, including tuition reimbursement</li> </ul> Additional Perks: <ul> <li>Flexible work arrangements, including remote work options</li> <li>Flexible Spending Accounts (FSAs)</li> <li>Employee referral programs</li> <li>Bonus opportunities</li> <li>Technology allowance</li> <li>A diverse, inclusive, and supportive workplace culture</li> </ul>

REQUIRED <ul> <li> TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI W/ FULL SCOPE POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED) </li> </ul> Required Skills: Experience in Java (Full Stack, Middleware, UI, Front & Back End) Desired Skills: PHP, Angular, Ansible, Docker, AWS, React, NiFi, Python, MongoDB, Springboot, & NodeJS Fourteen (14) years experience as a SWE in programs and contracts of similar scope, type, and complexity is required. Bachelor's degree in Computer Science or related discipline from an accredited college or university is required. Four (4) years of additional SWE experience on projects with similar software processes may be substituted for a bachelor's degree. Highly Desired -Cloud Experience: Shall have three (3) years demonstrated work experience with distributed scalable Big Data Store (NoSQL) such as Hbase, CloudBase/Accumulo, Big Table, etc.; Shall have demonstrated work experience with the Map Reduce programming model and technologies such as Hadoop, Hive, Pig, etc.; Shall have demonstrated work experience with the Hadoop Distributed File System (HDFS); Shall have demonstrated work experience with Serialization such as JSON and/or BSON Qualifications -Analyze user requirements to derive software design and performance requirements -Design and code new software or modify existing software to add new features - Debug existing software and correct defects -Integrate existing software into new or modified systems or operating environments - Develop simple data queries for existing or proposed databases or data repositories -Provide recommendations for improving documentation and software development process standards -Develop or implement algorithms to meet or exceed system performance and functional standards - Assist with developing and executing test procedures for software components - Write or review software and system documentation - Develop software solutions by analyzing system performance standards, confer with users or system engineers; analyze systems flow, data usage and work processes; and investigate problem areas -Serve as team lead at the level appropriate to the software development process being used on any particular project - Modify existing software to correct errors, to adapt to new hardware, or to improve its performance -Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design -Design or implement complex database or data repository interfaces/queries -Oversee one or more software development teams and ensure the work is completed in accordance with the constraints of the software development process being used on any particular project -Design or implement complex algorithms requiring adherence to strict timing, system resource, or interface constraints; Perform quality control on team products -Confer with system engineers and hardware engineers to derive software requirements and to obtain information on project limitations and capabilities, performance requirements and interfaces -Coordinate software system installation and monitor equipment functioning to ensure operational specifications are met -Implement recommendations for improving documentation and software development process standards Compensation: We are committed to providing fair and competitive compensation. The salary range for this position is $78,000 to $250,000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidate's work location, specific role, skill set, and level of expertise. Benefits: We offer a comprehensive benefits package, including: <ul> <li>Health Coverage: Medical, dental, and vision insurance</li> <li>Additional Insurance: Basic Life/AD&D, Voluntary Life/AD&D, Short and Long-Term Disability, Accident, Critical Illness, Hospitalization Indemnity, and Pet Insurance</li> <li>Retirement Plan: 401(k) plan with company match</li> <li>Paid Time Off: Generous PTO, paid holidays, parental leave, and more</li> <li>Wellness: Access to wellness programs and mental health support</li> <li>Professional Development: Opportunities for growth, including tuition reimbursement</li> </ul> Additional Perks: <ul> <li>Flexible work arrangements, including remote work options</li> <li>Flexible Spending Accounts (FSAs)</li> <li>Employee referral programs</li> <li>Bonus opportunities</li> <li>Technology allowance</li> <li>A diverse, inclusive, and supportive workplace culture</li> </ul>

Onyx Point, Inc. Interview Questions

Onyx Point, Inc. Interview Guides

Onyx Point, Inc. Interview Questions

Onyx Point, Inc. Salaries by Position

Onyx Point, Inc. Opening Jobs