Prepare for and practice interview questions from Phoenix Operations Group.

Phoenix Operations Group Interview Questions

Phoenix Operations Group 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

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Phoenix Operations Group Salaries by Position

Job Type Full-time Description ** TS/SCI Clearance Required** Phoenix Operations Group is looking for a Full-Stack Software Engineer to join our team in one of the following geographical locations: Springfield, VA, St. Louis, MO, San Diego, CA. This position will be onsite up to 75% of the time. We are in need of team players who will work within a cohesive group to provide unique technical solutions, enabling one's creativity to be set free. Basic Qualifications <ul> <li>Experience with testing software changes on-site and assisting with bug remediation </li><li>Java, C, C#, C++, or other comparable languages </li><li>Experience on projects that develop complex software, ensuring a collaborative environment and configuration management. </li><li>Experience implementing software life cycle management (requirements, design, develop, test, validate, deploy). </li><li>Lead a team to design, develop, and test application software to fulfill unique requirements on Linux and build graphical user interfaces (GUIs) for custom applications. </li><li>Respond to evolving requirements in an agile environment. </li><li>Clearance </li><li>Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; </li><li>TS/SCI clearance required; must be willing to pursue polygraph </li></ul>Education <ul> <li>Bachelor's Degree in relevant discipline </li></ul> Benefits Offered: Medical, Dental, Vision Insurance - 100% Company Paid Premiums STD, LTD, and Life Insurance - 100% Company paid 401K - Automatic 10% company contribution; no matching required PTO - 4 weeks/year Holidays - 11 paid/year Birthdays off with pay Referral Bonuses - Upfront AND Annually Recurring Open Source Bonuses - Contribute to our Github projects Professional Development - Paid training, Certifications, and Enrichment ABOUT PHOENIX OPERATIONS GROUP: Phoenix Operations Group is a high-end engineering services company dedicated to protecting and advancing our national cyber resources. As a small company, we rely on innovation to continually advance our employees' skills and provide game-changing solutions to our customers. Our technical competencies include Big Data analytics (batch and streaming), Cloud Computing infrastructure, multi-INT visualization, and enterprise architectures. We support operational missions (All-Source, Financial, CND) and serve as Product Owners for our open-source research initiatives. Please visit us at http://www.phoenix-opsgroup.com for more information. Phoenix Operations Group is an Equal Opportunity Employer. Phoenix Operations Group does not discriminate based on race, religion, color, sex, gender, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status, or any other basis covered by appropriate law. All employment is decided based on qualifications, merit, and business needs.

Description
Job Description:

Join our team of talented engineers in the Fort Meade area supporting critical national security programs. As a full-stack software engineer, you’ll use a wide range of technologies spanning front-end user interfaces, RESTful web services, Java back-end services, and multiple databases (both relational and NoSQL). At Phoenix, you’ll be continuously challenged to expand your technical skill set in support of our core mission, “Arming the analyst”.

This position will support multiple programs and is open to all candidate levels (junior, mid-level, and senior). A typical day includes engineering activities across a mid-sized team, developing new capabilities, addressing critical defects, interfacing with mission SMEs, and conducting Scrum activities (stand-ups, sprint planning, sprint demos/retrospectives). This multi-disciplinary team collaborates daily to meet demanding technical and mission needs.

*** Top Secret SCI Clearance with appropriate Polygraph Required ***

Technical Skills Required
3+ years of experience in Java software development
2+ years of experience accessing relational databases
2+ years of experience implementing RESTful web services
1+ years of experience using Spring / Spring Boot
1+ years of experience using Git source code control
1+ years developing software in a Linux environment
1+ years of experience using JUnit, Maven, Jenkins
Technical Skills Preferred
Experience working in an Agile (Scrum) environment using Jira and Confluence
Experience with distributed technologies such as Hadoop, Spark and Kafka
Experience with MongoDB, ElasticSearch, HBase or Accumulo data stores
Basic understanding of Python
Basic understanding of JavaScript
Benefits Offered:
Medical, Dental, Vision Insurance - 100% Company Paid Premiums
STD, LTD, and Life Insurance - 100% Company paid
401K – Automatic 10% company contribution; no matching required
PTO - 4 weeks/year
Holidays - 11 paid/year
Birthdays off with pay
Referral Bonuses – Upfront AND Annually Recurring
Open Source Bonuses – Contribute to our Github projects
Professional Development – Paid training, Certifications, and Enrichment
ABOUT PHOENIX OPERATIONS GROUP:
Phoenix Operations Group is a high-end engineering services company dedicated to protecting and advancing our national cyber resources. As a small start-up operating out of the Baltimore/Washington DC area, we rely on innovation to continually advance our employees' skills and provide game-changing solutions to our customers.
Our technical competencies include Big Data analytics (batch and streaming), Cloud Computing infrastructure, multi-INT visualization, and enterprise architectures. We support operational missions (All-Source, Financial, CND) and serve as Product Owners for our open-source research initiatives.
Please visit us at http://www.phoenix-opsgroup.com for more information.
Phoenix Operations Group is an Equal Opportunity Employer. Phoenix Operations Group does not discriminate based on race, religion, color, sex, gender, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status, or any other basis covered by appropriate law. All employment is decided based on qualifications, merit, and business need.

#J-18808-Ljbffr

Job Description: Join our team of talented engineers in the Annapolis Junction area supporting critical national security programs. As an analytic software engineer, you'll work closely with mission SMEs to develop niche analytics for the Intelligence Community. These may be batch analytics that operate over large volumes of data at-rest, or they may be streaming analytics that operate over smaller volumes of data in-motion. When operational, your analytics will support Phoenix's core mission of "Arming the Analyst". This position will support multiple programs and is open to junior (2-5 years of experience) candidates. A typical day includes engineering activities across a mid-sized team, exploring mission data sets, working with mission SMEs to understand tradecraft, and developing analytics to support that tradecraft. All development will be conducted within an Agile process using standard Scrum practices (daily stands-ups, sprint planning, sprint demos/retrospectives). *** Top Secret SCI Clearance with appropriate Polygraph Required *** Technical Skills Required <ul><li>3+ years of experience in Java software development</li><li>3+ years of experience with distributed technologies such as Hadoop, Spark and Kafka</li><li>3+ years of experience implementing RESTful web services</li><li>3+ years of experience processing XML and JSON data formats</li><li>3+ years of experience using Git, JUnit, Maven and Jenkins</li><li>3+years of experience developing software in a Linux environment</li><li>3+ years of experience supporting Defense or Intelligence programs</li></ul> Technical Skill Preferred <ul><li>Experience developing analytics with MapReduce, Spark or similar technologies</li><li>Experience with distributed databases such as Accumulo or HBase</li><li>Experience working in an Agile environment using Jira and Confluence</li><li>Basic understanding of Python or Scala</li><li>Basic Machine Learning algorithms & techniques</li></ul> Benefits Offered: Medical, Dental, Vision Insurance - 100% Company Paid Premiums STD, LTD, and Life Insurance - 100% Company paid 401K - Automatic 10% company contribution; no matching required PTO - 4 weeks/year Holidays - 11 paid/year Birthdays off with pay Referral Bonuses - Upfront AND Annually Recurring Open Source Bonuses - Contribute to our Github projects Professional Development - Paid training, Certifications, and Enrichment ABOUT PHOENIX OPERATIONS GROUP: Phoenix Operations Group is a high-end engineering services company dedicated to protecting and advancing our national cyber resources. As a small start-up operating out of the Baltimore/Washington DC area, we rely on innovation to continually advance our employees' skills and provide game-changing solutions to our customers. Our technical competencies include Big Data analytics (batch and streaming), Cloud Computing infrastructure, multi-INT visualization, and enterprise architectures. We support operational missions (All-Source, Financial, CND) and serve as Product Owners for our open-source research initiatives. Please visit us at http://www.phoenix-opsgroup.com for more information. Phoenix Operations Group is an Equal Opportunity Employer. Phoenix Operations Group does not discriminate based on race, religion, color, sex, gender, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status, or any other basis covered by appropriate law. All employment is decided based on qualifications, merit, and business need. ?

Phoenix Operations Group Interview Questions

Phoenix Operations Group Interview Guides

Phoenix Operations Group Interview Questions

Phoenix Operations Group Salaries by Position

Phoenix Operations Group Opening Jobs