Prepare for and practice interview questions from Tek Leaders Inc.

Tek Leaders Inc Interview Questions

Tek Leaders 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

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

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Tek Leaders Inc Salaries by Position

Kindly go through the below mentioned JD . If you are interested in below mentioned JD, please let me know which JD prefect match to your profile . Share me the updated resume . JD - 1Position: TPM-Data ScientistLocation: PuneRole: Contract Experience: 12 - 15 Years Objectives of this roleThis role calls for an experienced professional with substantial expertise in software development, data analytics, cloud technologies, and leadership. The ideal candidate should be capable of leading a team efficiently, promoting technical excellence, and closely collaborating with stakeholders to deliver impactful solutions.Responsibilities<ul><li>Lead a team of engineers in the design, development, and implementation of Python-based applications and solutions for data analytics.</li><li>Provide technical guidance and mentorship to team members, ensuring best practices and high-quality deliverables.</li><li>Oversee the utilization of Highcharts Data Analytic tools, Incorta DB, SQL Data Warehousing (DW), NoSQL databases, and ETL processes for efficient data analysis and storage.</li><li>Architect scalable and reliable solutions on cloud platforms, with a focus on Azure, for seamless data management and processing.</li><li>Drive Agile methodologies within the team, ensuring timely delivery of projects and continuous improvement in processes.</li><li>Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.</li><li>Evaluate and recommend infrastructure setups, both in public and private cloud environments, to support data initiatives effectively.</li></ul> Preferred Skill Set<ul><li>Language - Python, Highcharts</li><li>Data Analytic - Incorta</li><li>DB - SQL DW(Analytics), NoSQL, ETL</li><li>Cloud - Azure, Agile Methodology Background in Infrastructure (Public or Private) strongly desired</li></ul>JD - 2Position: Data ScientistLocation: PuneRole: Contract Experience: 8 – 10 Years Objectives of this role We're looking for a proficient Data Scientist with advanced Python skills and a robust foundation in data analytics, specifically in Highcharts Data Analytic, Incorta DB, SQL Data Warehousing (DW), NoSQL databases, and ETL processes. The perfect candidate should possess practical experience in cloud-based environments, particularly Azure, and should have a good understanding of Agile Methodology.Responsibilities<ul><li>Develop and maintain Python-based applications and scripts for data processing, analysis, and integration tasks.</li><li>Utilize Hitrack Data Analytic tools for data visualization, reporting, and analysis purposes.</li><li>Manage and optimize Incorta DB for efficient data storage, retrieval, and querying.</li><li>Design and implement SQL Data Warehouses (DW) for analytics purposes, ensuring data integrity and performance.</li><li>Work with NoSQL databases for handling unstructured or semi-structured data.</li><li>Develop Extract, Transform, Load (ETL) pipelines for data integration across various sources and destinations.</li><li>Implement data solutions on Azure cloud platform, leveraging services such as Azure Data Factory, Azure SQL Database, etc.</li><li>Collaborate with cross-functional teams in an Agile environment to deliver data solutions that meet business requirements.</li><li>Provide expertise in infrastructure setup and maintenance, both in public and private cloud environments.</li><li>Mentor junior team members and provide technical guidance as needed.</li></ul> Preferred Skill SetPrimary<ul><li>Python</li><li>High charts</li><li>Incorta</li><li>SQL /NoSQL</li><li>Azure Public Cloud</li><li>OpenStack Private Cloud</li><li>ETL</li></ul>Secondary<ul><li>PL/SQL & PostgreSQL</li><li>VMware</li><li>MongoDB</li><li>Rest API</li><li>Docker & Kubernetes</li></ul>

Kindly go through the below mentioned JD. If you are interested in below mentioned JD, please let me know which JD prefect match to your profile . Share me the updated resume.JD - 1Position: Data ScientistLocation: PuneRole: Contract Experience: 8 – 10 Years Objectives of this role We're looking for a proficient Data Scientist with advanced Python skills and a robust foundation in data analytics, specifically in Highcharts Data Analytic, Incorta DB, SQL Data Warehousing (DW), NoSQL databases, and ETL processes. The perfect candidate should possess practical experience in cloud-based environments, particularly Azure, and should have a good understanding of Agile Methodology.Responsibilities<ul><li>Develop and maintain Python-based applications and scripts for data processing, analysis, and integration tasks.</li><li>Utilize Hitrack Data Analytic tools for data visualization, reporting, and analysis purposes.</li><li>Manage and optimize Incorta DB for efficient data storage, retrieval, and querying.</li><li>Design and implement SQL Data Warehouses (DW) for analytics purposes, ensuring data integrity and performance.</li><li>Work with NoSQL databases for handling unstructured or semi-structured data.</li><li>Develop Extract, Transform, Load (ETL) pipelines for data integration across various sources and destinations.</li><li>Implement data solutions on Azure cloud platform, leveraging services such as Azure Data Factory, Azure SQL Database, etc.</li><li>Collaborate with cross-functional teams in an Agile environment to deliver data solutions that meet business requirements.</li><li>Provide expertise in infrastructure setup and maintenance, both in public and private cloud environments.</li><li>Mentor junior team members and provide technical guidance as needed.</li></ul> Preferred Skill SetPrimary<ul><li>Python</li><li>Highcharts</li><li>Incorta</li><li>SQL /NoSQL</li><li>Azure Public Cloud</li><li>OpenStack Private Cloud</li><li>ETL</li></ul>Secondary<ul><li>PL/SQL & PostgreSQL</li><li>VMware</li><li>MongoDB</li><li>RestAPI</li><li>Docker & Kubernetes</li></ul> JD - 2Position: TPM-Data ScientistLocation: PuneRole: Contract Experience: 12 - 15 Years Objectives of this roleThis role calls for an experienced professional with substantial expertise in software development, data analytics, cloud technologies, and leadership. The ideal candidate should be capable of leading a team efficiently, promoting technical excellence, and closely collaborating with stakeholders to deliver impactful solutions.Responsibilities<ul><li>Lead a team of engineers in the design, development, and implementation of Python-based applications and solutions for data analytics.</li><li>Provide technical guidance and mentorship to team members, ensuring best practices and high-quality deliverables.</li><li>Oversee the utilization of Highcharts Data Analytic tools, Incorta DB, SQL Data Warehousing (DW), NoSQL databases, and ETL processes for efficient data analysis and storage.</li><li>Architect scalable and reliable solutions on cloud platforms, with a focus on Azure, for seamless data management and processing.</li><li>Drive Agile methodologies within the team, ensuring timely delivery of projects and continuous improvement in processes.</li><li>Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.</li><li>Evaluate and recommend infrastructure setups, both in public and private cloud environments, to support data initiatives effectively.</li></ul> Preferred Skill Set<ul><li>Language - Python, Highcharts</li><li>Data Analytic - Incorta</li><li>DB - SQL DW(Analytics), NoSQL, ETL</li><li>Cloud - Azure, Agile Methodology Background in Infrastructure (Public or Private) strongly desired</li></ul>

Tek Leaders Inc Interview Questions

Tek Leaders Inc Interview Guides

Tek Leaders Inc Interview Questions

Tek Leaders Inc Salaries by Position

Tek Leaders Inc Opening Jobs