Prepare for and practice interview questions from Intellectt Inc.

Intellectt Inc Interview Questions

Intellectt Inc 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?

Intellectt Inc Salaries by Position

Job Description:Skills:<ul><li>Experience with impact assessment of software patches and upgrades.</li><li>Experience in Linux shell scripts, Perl and/or python.</li><li>Working knowledge of Linux development environment tools.</li></ul>Duties:<ul><li>Develop, create, and modify general computer applications software or specialized utility programs.</li><li>Analyze user needs and develop software solutions.</li><li>Design software or customize software for client use with the aim of optimizing operational efficiency.</li><li>May analyze and design databases within an application area, working individually or coordinating database development as part of a team.</li><li>May supervise computer programmers.</li></ul>Education: <ul><li>May require a Bachelor's degree and/or related experience.</li></ul>

What You Will Do: • Build and maintain test infrastructure, including test frameworks, tools, and custom automation solutions along with script development. • Ensure scalability and maintainability of test suites. • Do stand up End-to-End test automation from scratch. • Setup the pipelines • Keep current with the constantly changing technology industry. Skills and Experience You Will Need: Experience: Minimum of 6-8 years with the following skills and technologies Tools & Technologies: • Postman • JMeter (preferably Karate) • Jenkins/GitLab (both preferred; GitLab is essential) • Selenium • JUnit Programming Skills: Proficiency in Java and Python • Java for building API testing frameworks • Python for test automation of reporting services Responsibilities: • Design and implement test automation frameworks for functional, integration, and performance testing • Develop test utilities Methodologies: • Experience in Behavior Driven Development (BDD) AWS Services: • Postgres • DynamoDB • Lambda • S3 • CodeDeploy Desired: • Harness

DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:<ul><li> Lead, design and implement the middleware solutions including installation & administration, utilizing best practices & provide recommendations to optimize system performance using Mulesoft, messaging, cloud, and several integration technologies.</li><li> Design, implement, & maintain APIs (SOAP & REST)</li><li>Lead and liaise with the application development teams to build API capability, including security and policy management.</li><li>Lead and assist with developing & maintaining a service/API registry.</li><li>Lead, assist, & provide guidance in migrating & modernizing API/web service & integration components from current implementations: Weblogic (12c) OSB, ActiveMQ, IBM MQ, IBM DataPower & Java adapters.</li><li>Perform code reviews, prepare, and document Unit Test results and deployment documents for code promotions.</li><li>Participate and assist with project planning, design, development, and release management activities for various EHS shared service component developments and EHS application developments.</li><li>Liaise with end users, development staff, system administrators, management, and staff from other organizations to ensure successful implementation and operation of application systems.</li><li>Coordinate and solicit vendor support as necessary.</li><li>Maintain the appropriate task lists, documents, design, and other artifacts in support of these APIs.</li><li>Investigate new solutions, tools, and techniques to incorporate into standards.</li></ul>Requirements· Expert in Mulesoft and other integration technologies· 10+ years of experience in software development.· Strong technical expertise in Java/J2EE, Oracle OSB 12c· Expert knowledge of MuleSoft & connectors • Experience with AWS offerings & services, including API Gateway & WAF· Experience with XML and JSON schema· Experience of JMS programming with IBM MQ & Active MQ· Familiarity with IBM DataPower· Strong knowledge of TLS/SSL and digital encryption/signatures· Experience with Azure OAUTH & JWT· Working knowledge of development tools - SVN, Git, SOAPUI, Postman· Able to translate business requirements to technical specifications.· Able to work independently and mentor other technical team members as needed.· Excellent design, debugging, and problem-solving skills.· Excellent interpersonal, written, and verbal communication skillsEDUCATION AND CERTIFICATION:• Bachelor’s degree in computer science, Information Systems, Business Administration or other related field, or equivalent work experience.• Minimum (8) eight years of IT experience in one or more technical roles. • Mulesoft Certification is preferred.

Intellectt Inc Interview Questions

Intellectt Inc Interview Guides

Intellectt Inc Interview Questions

Intellectt Inc Salaries by Position

Intellectt Inc Opening Jobs