Prepare for and practice interview questions from 3I Infotech Ltd..

3I Infotech Ltd. Interview Questions

3I Infotech Ltd. 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

3I Infotech Ltd. Salaries by Position

Java Developer Walk in Drive on 23rd August 2024API Tester (Jmeter / Postman) - 2Yrs to 4Yrs.Java Developer - (Spring boot/MVC) - 3yrs to 5Yrs.Manual Tester - (Banking) 2yrs to 3 Yrs.Automation Tester - (Selenium / Java / Banking) - 2yrs to 3 Yrs. Interview Location - GhansoliTime 10 am to 3pm. If interested then please mail me your resume on vinod.bangera@3i-infotech.com Regards,VinodHR TeamINDIA

Job Title: Manager – HR AnalystExperience level: 6+ yrs Location: Navi Mumbai (Seawoods) Role and Responsibilities:HR Analyst is a crucial role in the human resources department by leveraging data to make informed decisions that enhance the effectiveness of HR practices Key Result Areas/AccountabilitiesHR Technology and Systems:<ul><li>Manage HR information systems (HRIS) and ensure data accuracy and integrity.</li><li>Leverage HR technology to streamline HR processes and improve data accessibility.</li></ul>Data Collection and Analysis:<ul><li>Collect and analyze HR data, , such as employee performance, turnover rates, and recruitment metrics.</li><li>Use statistical methods and software tools to interpret data trends and patterns.</li></ul>Reporting and Metrics:<ul><li>Develop and maintain HR dashboards and reports that provide insights into key HR metrics.</li><li>Present findings to HR leadership and other stakeholders to inform strategic decision-making.</li></ul>Workforce Planning:<ul><li>Assist in workforce planning by analyzing current workforce demographics and predicting future staffing needs.</li><li>Provide insights into talent gaps and recommend strategies to address them.</li></ul>Compensation and Benefits Analysis:<ul><li>Analyze compensation and benefits data to ensure competitiveness in the market.</li><li>Provide recommendations for salary adjustments and benefits enhancements based on data insights.</li></ul>Employee Engagement and Retention:<ul><li>Analyze data related to employee engagement and job satisfaction.</li><li>Identify factors contributing to employee turnover.</li></ul>Recruitment and Selection:<ul><li>Analyze recruitment data to evaluate the effectiveness of hiring strategies.</li><li>Identify bottlenecks in the recruitment process and suggest improvements.</li></ul>Compliance and Risk Management:<ul><li>Ensure HR practices comply with relevant laws and regulations.</li><li>Analyze data to identify potential risks and recommend mitigation strategies.</li></ul>Training and Development:<ul><li>Evaluate the effectiveness of training programs through data analysis.</li><li>Provide insights into training needs and recommend development initiatives.</li></ul>Strategic HR Initiatives:<ul><li>Support strategic HR initiatives by providing data-driven insights.</li></ul> Technical Skills:Data Analysis:<ul><li>Proficiency in statistical analysis and data interpretation.</li><li>Experience with data analysis tools such as Excel, SQL, R, or Python.</li><li>Ability to create and analyze complex datasets.</li></ul>HR Technology:<ul><li>Experience with Human Resource Information Systems (HRIS).</li><li>Familiarity with data visualization tools such as Tableau, Power BI, or similar platforms.</li><li>Understanding of applicant tracking systems (ATS) and performance management software.</li></ul>Reporting and Dashboards:<ul><li>Ability to create detailed reports and dashboards to present HR data clearly and effectively.</li><li>Proficiency in using reporting tools and techniques to convey insights.</li></ul> Analytical Skills:Critical Thinking:<ul><li>Strong problem-solving skills and the ability to think critically about complex issues.</li><li>Ability to identify trends, patterns, and anomalies in HR data.</li></ul>Attention to Detail:<ul><li>High level of accuracy and attention to detail in data analysis and reporting.</li><li>Ability to ensure data integrity and quality.</li></ul>Quantitative Skills:<ul><li>Strong numerical and quantitative analysis skills.</li><li>Ability to conduct advanced statistical analysis and modeling.</li></ul> Interpersonal Skills:Communication:<ul><li>Ability to present complex data insights in a clear, concise, and understandable manner to various stakeholders.</li></ul>Collaboration:<ul><li>Strong teamwork and collaboration skills.</li><li>Ability to work effectively with HR colleagues, managers, and other departments.</li></ul>Consultative Skills:<ul><li>Ability to provide data-driven recommendations and advice to HR leaders and managers.</li><li>Skills in influencing and persuading others based on analytical findings.</li></ul> HR Knowledge:HR Principles:<ul><li>understanding of HR practices, policies, and regulations.</li><li>Knowledge of key HR areas such as recruitment, compensation, benefits, employee engagement, and performance management.</li></ul> Additional Competencies:Project Management:<ul><li>Ability to manage multiple projects and priorities simultaneously.</li><li>Strong organizational and time management skills.</li></ul>Ethical Standards:<ul><li>High level of integrity and commitment to maintaining confidentiality and data security.</li><li>Adherence to ethical standards and compliance with relevant regulations.</li></ul>Adaptability:<ul><li>Ability to adapt to changing business needs and work environments.</li><li>Willingness to continuously learn and develop new skills.</li></ul>Customer Focus:<ul><li>Commitment to understanding and meeting the needs of internal stakeholders.</li><li>Ability to provide exceptional service and support to HR colleagues and the wider organization.</li></ul> Qualifications and Education RequirementsA bachelor’s degree in Data Analytics, or a related field is typically required.

3I Infotech Ltd. Interview Questions

3I Infotech Ltd. Interview Guides

3I Infotech Ltd. Interview Questions

3I Infotech Ltd. Salaries by Position

3I Infotech Ltd. Opening Jobs