Prepare for and practice interview questions from Intellectt Inc.

Intellectt Inc Interview Questions

Intellectt Inc Interview Guides

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?

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

Intellectt Inc Salaries by Position

Overview: We are seeking a highly skilled and experienced Databricks Senior Developer/Lead to join our team in Titusville, NJ. The ideal candidate will have extensive experience in Databricks, AWS, and data engineering. This role is critical in managing and leading data engineering initiatives and requires someone who can work onsite and collaborate effectively with cross-functional teams. Key Responsibilities: <ul> <li>Lead the design, development, and implementation of scalable data engineering solutions using Databricks on AWS. </li><li>Collaborate with stakeholders to understand data requirements and translate them into effective data processing pipelines. </li><li>Optimize and manage data pipelines, ensuring they meet performance, reliability, and scalability requirements. </li><li>Develop and maintain ETL processes, ensuring the smooth flow of data from various sources into the Databricks platform. </li><li>Lead data architecture and design discussions, providing guidance on best practices for data management and governance. </li><li>Ensure data quality, integrity, and security across all data engineering activities. </li><li>Mentor and guide junior developers and engineers, fostering a collaborative and innovative work environment. </li><li>Troubleshoot and resolve issues related to data processing and storage, ensuring minimal disruption to business operations. </li><li>Stay updated with the latest trends and technologies in data engineering, Databricks, and AWS, and apply them to improve the team's capabilities.</li> </ul>

Role: .Net/C# EngineerLocation: Merrimack, New Hampshire Job Description:We are currently recruiting for a Principal C# Service Design Engineer, but we are looking for more than an impressive skill set.We are looking for the type of person who respects others for their knowledge, skills, and experience as individuals and as team members. Responsibilities<ul><li>Design, implement, and deliver reliable, high quality, robust embedded and desktop software targeted to complex medical instruments meeting regulatory standards</li><li>Participate in designing and implementing C# .Net services to coordinate and control medical instrument activities like scheduling, inventory management, and error recovery.</li><li>Collaborate with chief architect on design tradeoffs of various approaches to determine appropriate solution.</li><li>Create, maintain, and review software project documents including software development plans, software configuration plans, and detailed software design documents</li><li>Participate in software project risk analysis and hazard analysis</li><li>Drive software requirements with other members of the software team as appropriate (team lead, architect, etc.) and proactively work to integrate with system requirements</li><li>Participate in Software Change Control Boards, and participate in the investigation and resolution of software defects</li><li>Utilize software engineering best practices (e.g., unit testing, integration testing, static analysis, code reviews, design reviews, Doxygen documentation)</li><li>Develop software within Continuous Improvement development process</li><li>Improve Continuous Improvement process (recommend process improvements, software tools, and helper scripts)</li><li>Work cooperatively within the software group as well as across disciplines such as systems, electrical, optical and mechanical to deliver projects on-time and on budget</li></ul>Qualifications<ul><li>Bachelor’s degree in computer science, Electrical Engineering, Mathematics, or related discipline (Master’s degree preferred)</li><li>10 or more years of relevant experience developing software for complex instrument or devices that include motion control and fluidics</li><li>Demonstrated experience in designing and implementing C# .Net services to coordinate and control medical instrument activities like scheduling, inventory management, and error recovery</li><li>Understanding of revision control systems and issue tracking systems</li><li>Ability to work independently or in a team environment</li><li>Strong oral and written communication skills</li><li>Demonstrated experience in software development lifecycle (Agile, Spiral), object-oriented design methodology and programming languages including Java and one of the following: C/C++, or C#</li><li>Design experience of software for hardware instruments / devices that include motion control interfaces</li><li>Experience with medical device regulatory standards such as 21 CFR Part 820, IEC 62304 and ISO 13485 including experience with system risk / hazard analysis</li><li>Experience with software configuration tools for source code control (CVS, SVN, Git), issue tracking (Mantis, Jira), requirements management (DOORS), code review tools (Code Collaborator, Crucible) and 3rd party project build tools</li><li>Demonstrated technical leadership skills</li><li>Creative / innovative, able to think on your feet and work within project schedules</li><li>Good organizational and multi-tasking skills</li><li>MS Project skills a plus</li><li>Software time and cost estimation experience a plus</li><li>SOA (Service Oriented Architecture), gRPC, Entity framework, Blazor and ASP .Net are helpful skills</li></ul>

Overview:We are seeking a highly skilled and experienced Databricks Senior Developer/Lead to join our team in Titusville, NJ. The ideal candidate will have extensive experience in Databricks, AWS, and data engineering. This role is critical in managing and leading data engineering initiatives and requires someone who can work onsite and collaborate effectively with cross-functional teams.Key Responsibilities:<ul><li>Lead the design, development, and implementation of scalable data engineering solutions using Databricks on AWS.</li><li>Collaborate with stakeholders to understand data requirements and translate them into effective data processing pipelines.</li><li>Optimize and manage data pipelines, ensuring they meet performance, reliability, and scalability requirements.</li><li>Develop and maintain ETL processes, ensuring the smooth flow of data from various sources into the Databricks platform.</li><li>Lead data architecture and design discussions, providing guidance on best practices for data management and governance.</li><li>Ensure data quality, integrity, and security across all data engineering activities.</li><li>Mentor and guide junior developers and engineers, fostering a collaborative and innovative work environment.</li><li>Troubleshoot and resolve issues related to data processing and storage, ensuring minimal disruption to business operations.</li><li>Stay updated with the latest trends and technologies in data engineering, Databricks, and AWS, and apply them to improve the team's capabilities.</li></ul>

Hi, greetings of the day,This is Rajitha. K from Intellectt Inc., working as a Technical Recruiter. Currently, we have an immediate opening with one of our direct clients, please find the below Job description and if interested kindly do share your resume at rajitha@intellectt.comRole: Data ScientistLocation: Plano, TexasWe are seeking an experienced HL7 FHIR & Data Scientist. The ideal candidate should have hands-on experience with Azure Stack, Azure Data Factory, Azure Databricks, Azure Networking, and Python. Responsibilities: Design, develop, and implement HL7 FHIR based healthcare data integration solutions. Develop and implement data-driven models and algorithms. Build and maintain data pipelines using Azure Data Factory and Azure Databricks. Design and deploy scalable and secure cloud-based solutions. Collaborate with cross-functional teams to identify and solve complex data problems. Develop and maintain data processing and analysis scripts using Python. Ensure data quality, accuracy, and completeness. Stay up-to-date with the latest technologies and trends in healthcare data. Requirements:<ul><li>Proven experience in HL7 FHIR based healthcare data integration.</li><li>Strong experience with Azure Stack, Azure Data Factory, Azure Databricks, and Azure Networking.</li><li>Experience with Python programming and data processing libraries such as Pandas,</li><li>NumPy, and SciPy.</li><li>Experience with data modeling, statistical analysis, and machine learning algorithms.</li><li>Familiarity with healthcare data standards such as HL7 & FHIR</li><li>Strong problem-solving skills and attention to detail.</li><li>Excellent communication and collaboration skills.</li></ul>

Data Scientist Note: must work with Health care client We are seeking an experienced HL7 FHIR & Data Scientist. The ideal candidate should have hands-on experience with Azure Stack, Azure Data Factory, Azure Databricks, Azure Networking, and Python. Responsibilities: Design, develop, and implement HL7 FHIR based healthcare data integration solutions. Develop and implement data-driven models and algorithms. Build and maintain data pipelines using Azure Data Factory and Azure Databricks. Design and deploy scalable and secure cloud-based solutions. Collaborate with cross-functional teams to identify and solve complex data problems. Develop and maintain data processing and analysis scripts using Python. Ensure data quality, accuracy, and completeness. Stay up-to-date with the latest technologies and trends in healthcare data. Requirements:<ul><li>Proven experience in HL7 FHIR based healthcare data integration.</li><li>Strong experience with Azure Stack, Azure Data Factory, Azure Databricks, and Azure Networking.</li><li>Experience with Python programming and data processing libraries such as Pandas,</li><li>NumPy, and SciPy.</li><li>Experience with data modeling, statistical analysis, and machine learning algorithms.</li><li>Familiarity with healthcare data standards such as HL7 & FHIR</li><li>Strong problem-solving skills and attention to detail.</li><li>Excellent communication and collaboration skills.</li></ul>

Intellectt Inc Interview Questions

Intellectt Inc Interview Guides

Intellectt Inc Interview Questions

Intellectt Inc Salaries by Position

Intellectt Inc Opening Jobs