Prepare for and practice interview questions from Techdigital Corporation.

Techdigital Corporation Interview Questions

Techdigital 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?

Techdigital Corporation Salaries by Position

<div> <h4>JOB DESCRIPTION</h4> Position Summary We are seeking the role of HR Business Analyst to bridge the gap between the business stakeholders and the technology teams to ensure that software and processes align to business requirements. This role will work to support the lead Business Analyst and together they will work to be the drivers of our continued growth and success, and key in the development of innovative solutions within the HR technology and analytics environments. The ideal candidate will have a commitment to innovation, and seek, develop, and help implement strategic initiatives for improved efficiency and productivity. From researching progressive systems solutions to evaluating their impacts, the ideal candidate will be able to manage technology projects and initiatives, and demonstrate strong skills as a detailed planner and communicator. Essential Responsibilities <ul> <li>Partner with stakeholders, COEs, business leaders, and technology experts to document and translate business requirements in relation to HR technology and associated systems.</li> <li>Lead the discovery, design, and implementation of innovative solutions to the technology platforms that solve complex business challenges and requirements.</li> <li>Assess current business practices within key support areas and make recommendations for business and system improvements.</li> <li>Lead the analysis of the key risk areas in the current and proposed operational processes.</li> <li>Request and incorporate fact-based feedback from impacted business areas and represent these areas in discussions with internal and external implementation teams.</li> <li>Conduct on-going analysis and monitoring of processes and technology to ensure all desired outcomes are achieved; document and communicate to appropriate stakeholders, and business and functional leaders, of any challenges, outages, or undesired outcomes.</li> <li>Assess and define change impact to the organization, process, and technology and present findings to impacted areas; assess readiness for change and communicate with key stakeholders.</li> <li>Assist with change management by working with appropriate business areas to define a set of strategic initiatives to support user adoption of change and impact.</li> <li>Create and implement thoughtful execution plans for project-based exercises, with attention to transparent communication at all levels.</li> <li>Author and update internal and external documentation, and formally initiate and deliver requirements and documentation.</li> <li>Develop relationships with business partners and leaders at all levels of the organization and provide appropriate communication and analysis to support business objectives.</li> </ul> </div>

<div> Note: Key selection criteria is seasoned BA, to handle the business team with good communication skills and Agile methodology. SKILLS / EXPERIENCE REQUIRED </div> <ul> <li> Education: Bachelor's degree in computer science, Information Systems, or Finance </li> <li> Role Specific Experience: 8+ years of relevant technical and business work experience with concepts of finance and accounting , Banking & Financial domain experience, along with knowledge of risk management, familiarity </li> <li> Proficiency in MS Excel </li> <li> Experience in defining and implementing technology solutions for a major financial institution </li> <li> Extensive experience as a Business Analyst for a large financial institution with special emphasis on use cases, defining test cases, and providing user training and support </li> <li> Extensive experience in gathering business requirements and developing functional specifications artifacts to those methodologies </li> <li> Extensive experience with various system development lifecycle methodologies and tailoring the Solution-oriented, detailed-focused, showing strong analytical and organization skills </li> </ul> <div> It Will be a Plus for below Skills: </div> <ul> <li> Familiarity with relational databases / RDMS </li> <li> Experience with writing simple SQL statements (mostly SELECT with aim to analyze datasets) </li> <li> Familiarity with any object-oriented programming language is a plus (c# preferred) </li> </ul>

<div> Mandatory Skills - Business Analyst with Clinical Regulatory Background Minimum 5 years of experience in Pharmaceutical/Biotech industry SaaS vendors; relationship with internal business groups Tools and Technology awareness: ServiceNow, ALM VERA, Document Management system, MS Project, MS Visio and standard MS Office products. Please Note: must have Clinical research background and knowledge on the ALM VERA, Document management system </div>

<div> Technical Business Analyst with good experience into Automation Testing. Should have worked on Java projects and good knowledge of Java coding is required</div> <ul> <li>Technical Business Analyst + QA</li> <li>10+ years' experience as Business Analyst preferably in insurance domain with good knowledge in New Business, Claims etc</li> <li>Have managed at least 2 to 3 end to end project lifecycles as Business architect</li> <li>Have knowledge of tech stack like java, spring boot, angular etc.</li> <li>Participate in requirement gathering and design thinking workshops</li> <li>Manage functional product backlog and supports in maintaining functional designs.</li> <li>Creating , Managing User stories and validating development & test scenarios. Strong communication skills to provide show and tell to business, knowledge transfer to development and testing team</li> <li>Experience in a scrum master role in software development, preferred</li> <li>Excellent communication skills</li> <li>Problem-solving and conflict-resolution ability</li> <li>Creating, Organizing, and managing Test Designing/ Planning.</li> <li>Creating, Enhancing, debugging, and Running Test Cases.</li> <li>Organizing, monitoring defect management process.</li> <li>Handling changes and conducting Regression Testing.</li> </ul>

Techdigital Corporation Interview Questions

Techdigital Corporation Interview Guides

Techdigital Corporation Interview Questions

Techdigital Corporation Salaries by Position

Techdigital Corporation Opening Jobs