Prepare for and practice interview questions from Concurrent Technologies Corporation.

Concurrent Technologies Corporation Interview Questions

Concurrent Technologies Corporation 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?

Concurrent Technologies Corporation Salaries by Position

Software Engineer - Full Stack Concurrent Technologies Corporation Hybrid within Johnstown, PA Minimum Clearance Required: None Clearance Level Must Be Able to Obtain: None Employee Background Check Required This position is eligible for a hybrid work arrangement. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office at a minimum of 1 set day a week (determined by leadership) with a general guidepost of being in the office based on business needs. Key Responsibilities: + Performs required tasks in the deployment and configuration of technologies and tools used in software development, including build servers, version control systems, and automated testing frameworks. + Designs & develops applications server-side functionality and logic using various technologies: C#, VB, .NET, ColdFusion, Java, Node.js, as well as databases such as Oracle, Microsoft SQL, PL/SQL, LINQ-to-Entities. + Supports internal business specific applications accordingly with application life cycle stages (requirement gathering, design, develop, test, implement, and deploy) accordance with access control and vulnerability management to align with overall information security and business strategies. + Works together with the development team to resolve problems with infrastructure and software deployment by understanding the business processes with the intention of producing solutions that would automate, validate, and simplify their job responsibilities. + Develops and maintains API and associated data platform solution for Microsoft 365 cloud environment and other 3rd party cloud services using REST and SOAP APIs as well as manages the deployment and hosting of web applications on Microsoft Windows Servers through IIS, WordPress hosted websites on a Linux, Apache Web Server and Microsoft Power Platform. + Regularly interacts and coordinates with other internal groups and customers on new system development or bug fixes/feature improvements. + Keeps abreast of current DevOps and software development trends and best practices. + Creates and maintains scripts and automation tools to simplify infrastructure administration and software deployment. + Works with senior DevOps staff to develop data workflows and ETL processes in support of company data and the data warehouse. + Designs & develops the User Interface (UI)/User Experience (UX) using various technologies/libraries/frameworks: HTML, CSS, JavaScript, jQuery, ReactJS, Bootstrap as needed. Basic Qualifications: + Possesses a BA/BS in Computer Science, Engineering, Information Technology or related discipline, plus 4-6 years of directly related experience. + 2+ years of direct experience REQUIRED using various technologies and frameworks, such as .NET Framework, .NET Core, ASP.NET, MVC. + Experience of database structure, object-oriented programming and software development processes and tools with agile development project integration and delivery. + Experience in various languages, such as C#, VB, ColdFusion, HTML, JavaScript/JQuery, CSS. + Experience with Microsoft 365 cloud environment including Azure, SharePoint Online and Microsoft Power Platforms. + Strong oral/written communication skills with customer-oriented attitude along with strong problem solving and analytic skills with collaboration. Preferred Qualifications: + Experience in version control system. + Direct experience with .NET development and other platform as well as scripting/application languages. + Direct experience with database/workflow as well as Deltek Costpoint integration. + Direct experience with application development full lifecycle processes. + Working in a team environment utilizing version control. Why CTC? + Our teams at CTC are passionate and thrive on collaboration in a team environment. + When we encounter a difficult problem, we have a variety of talented and diverse employees that work together to solve the toughest challenges. + Competitive salary and benefits package. + Although our work at CTC is extremely important, we also recognize the need for our employees to maintain a proper mix of work and personal life. + Visit www.ctc.com (http://www.ctc.com/) to learn more! Join us! CTC offers exceptional career growth, cutting edge technology, educational opportunities, and recognition for quality work. https://concurrent-technologies-corporation.breezy.hr/ Staffing Requisition: SR# 2024-0151 We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, or any other characteristic protected by law.

Concurrent Technologies Corporation Interview Questions

Concurrent Technologies Corporation Interview Guides

Concurrent Technologies Corporation Interview Questions

Concurrent Technologies Corporation Salaries by Position

Concurrent Technologies Corporation Opening Jobs