Prepare for and practice interview questions from Cambium Learning Group.

Cambium Learning Group Interview Questions

Cambium Learning 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

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?

Cambium Learning Group Salaries by Position

Job Overview Do you want to be a part of something innovative and cutting edge? If your answer is yes, then join our team of more than a hundred software engineers, designers, project managers and software specialists that are smart, creative, and excited by what they do! Some of our ground-breaking work includes advanced computer-adaptive algorithms (only one that's peer-approved in the country); mobile support for the user interfaces; learning management systems with social media features; user interfaces that are universally accessible to people with or without disabilities; innovative, machine-scorable items and that's just to name a few. Cambium Assessment provides assessment services and technical assistance to school systems nationwide. Job Responsibilities: <ul><li>We work with LOTS of data (many, many TB) & it comes fast! Scalability & heavy transactional loads , heavy reporting are common challenges for us. We solve a lot of interesting and tricky problems Often not your typical collect/save/display that you get at other places. Not snapping into established frameworks. Working across tiers as required. Opportunities for more advanced coding.</li><li>Milliseconds matter! Performance is key! Optimizing database access, algorithms, choosing the right data structures, in general working to design performant systems</li><li>We actually write code from the ground up. We don't use a lot of frameworks, packages, etc. Not a lot of macro-level stuff. OO, relational database design/programming/optimization, core software engineering chops is what we're looking for</li><li>Our suite of systems is vast and varied. There are web services (REST, SOAP, hybrid), windows services, daemons, websites, libraries, command line tools, windows apps. And they're always in motion, being enhanced to meet new requirements and to move them into the future. We have plans to redesign several of the older systems, which will be a lot of fun. There is new system development (ex: the Hotline system suite, Stats Workspace)</li><li>There are a lot of system interfaces, both within our own suite as well as across teams in the organization. Plenty of opportunities for collaboration with a lot of smart people</li><li>We have immediate needs for architectural and design refactoring to allow us to scale up to meet increased loads</li></ul> Job Requirements <ul><li>Bachelor's Degree in Computer Science (or related field) and 5+ years professional .NET software development experience or Master's Degree in Computer Science and 3+ years of .NET software development experience.</li><li>SQL experience to include development work with relational databases, stored procedures, triggers, writing SQL queries</li><li>Experienced in object oriented (OOP), along with a demonstrated professional knowledge in OO design</li><li>Solid understanding of algorithms</li><li>Experience developing restful web services and web APIs</li><li>Proficiency in developing full-stack software applications, utilizing front-end frameworks such as Angular, React, Vue, or equivalent technologies</li><li>Detail-oriented with excellent problem-solving skills</li><li>Good communication skills</li><li>Self-starter, ability to work in a team environment as well as alone</li></ul> Preferred Qualifications <ul><li>M.S. in Computer Science</li><li>AWS</li></ul> Why Work With Us? When you work with Cambium Assessment, you'll be helping to design and build inspiring solutions that make a real impact on the online testing industry, as well as the educators and students we support. <ul><li>Our systems are highly scaled and mission critical serving over a third of all students in grades 3-8 in the United States.</li><li>Our web applications are highly interactive and universally accessible.</li><li>Our machine scoring methods are driven by artificial intelligence allowing computers to perform such complex operations as grading essays with more accuracy than humans.</li><li>Our processes use intensive algorithmic computing allowing a customized experience for each student as the exam adapts real-time based upon answers given.</li></ul> In the 2021-2022 school year, we delivered more than 100 million online tests, successfully supported peak testing volumes exceeding 1.3 million simultaneous test takers, while ensuring an average response time of less than a tenth of a second. We have the most advanced features of any online testing system, and we continue to push boundaries to improve student performance measurement and enabling educators with actionable insights to drive better overall educational outcomes for our students. To learn more about our organization and the exciting work we do, visit www.cambiumassessment.com An Equal Opportunity Employer We are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, age, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.

Job Overview: Do you want to be a part of something innovative and cutting edge? If your answer is yes, then join our team of more than a hundred software engineers, designers, project managers and software specialists that are smart, creative and excited by what they do! Some of our ground-breaking work includes: advanced computer-adaptive algorithms (only one that's peer-approved in the country); mobile support for the user interfaces; learning management systems with social media features; user interfaces that are universally accessible to people with or without disabilities; innovative, machine-scorable items and that's just to name a few. Cambium Assessment provides assessment services and technical assistance to school systems nationwide. Job Responsibilities: As a .NET Software Engineer, you will be an integral part of the software engineering and product development team within Cambium. This group of professionals provide custom software solutions for our clients as well as internal support systems. Much of the work we perform is new development, so the right candidate will have the skills needed to perform full life-cycle software development. This includes participation in requirements gathering, application and database design, system documentation, writing and unit-testing efficient code, and deployment. Job Requirements: <ul><li>B.S. in Computer Science or related field and 3+ years professional .NET software development experience, or M.S Degree and 1+ year of professional .NET software development experience or 5+ years of experience in .NET software development experience </li><li>Software development experience utilizing C#, ASP.NET, JavaScript, and XML </li><li>SQL Server development experience to include development work with relational databases, stored procedures, triggers, writing SQL queries </li><li>Experienced in object oriented (OO) analysis and design principles, along with a demonstrated skilled knowledge in OO design </li><li>Solid understanding of algorithms </li><li>Self-starting, autonomous thinker and worker </li><li>Excellent analytical skills </li><li>Highly detail-oriented </li><li>Good communication skills </li><li>Ability to work well on a team, as well as independently </li></ul>Why Work With Us? When you work with Cambium Assessment, you'll be helping to design and build inspiring solutions that make a real impact on the online testing industry, as well as the educators and students we support. <ul> <li>Our systems are highly scaled and mission critical serving over a third of all students in grades 3-8 in the United States. </li><li>Our web applications are highly interactive and universally accessible. </li><li>Our machine scoring methods are driven by artificial intelligence allowing computers to perform such complex operations as grading essays with more accuracy than humans. </li><li>Our processes use intensive algorithmic computing allowing a customized experience for each student as the exam adapts real-time based upon answers given. </li></ul> In the 2021-2022 school year, we delivered more than 100 million online tests, successfully supported peak testing volumes exceeding 1.3 million simultaneous test takers, while ensuring an average response time of less than a tenth of a second. We have the most advanced features of any online testing system, and we continue to push boundaries to improve student performance measurement and enabling educators with actionable insights to drive better overall educational outcomes for our students. To learn more about our organization and the exciting work we do, visit www.cambiumassessment.com An Equal Opportunity Employer We are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, age, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.

Cambium Learning Group Interview Questions

Cambium Learning Group Interview Guides

Cambium Learning Group Interview Questions

Cambium Learning Group Salaries by Position

Cambium Learning Group Opening Jobs