Prepare for and practice interview questions from Drishticon.

Drishticon Interview Questions

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

Drishticon Salaries by Position

We have an immediate contract requirement for Sr Azure Cloud Data Engineer with one of our direct clients in San Francisco Bay Area, CA USA. <ul><li>Senior Azure Cloud Data Engineer with a strong background in Power BI, Azure Data bricks , Java and SQL. </li><li>The candidate will be responsible for designing, developing, and implementing data integration solutions in the Azure cloud environment.</li><li> Design and implement ETL processes using Azure Data Factory to integrate data from various sources into PostgreSQL / Azure SQL Database. </li><li>Develop and maintain data models in Azure SQL Database to support reporting and analytics requirements. Create interactive and visually appealing dashboards and reports using Power BI.</li><li>Experience in the retail domain will be an additional advantage. </li><li>Strong analytical and problem-solving skills, excellent communication and collaboration skills. Have to collaborate with cross-functional teams to deliver high-quality data solutions that drive business intelligence and analytics initiatives.</li></ul> Technical Skills:Power BI, DAXJavaAzure Data bricksAzure CloudAzure Data Factory (ADF)Azure SQL, PostgreSQLVisual StudioTest Driven DevelopmentPowerShellGitHub, Github Actions, JIRATools : IntelliJ, Splunk, New Relic

We have an immediate requirement for a Senior Data Engineer with one of our direct clients in Westwood MA. Requirement:<ul><li>Experience building schema to scale and automate workflows</li><li>Experience and knowledge of modern data stores, pipeline and reporting/analytic techniques and tools</li><li>Expertise in SQL, MYSQL, and Python is required</li><li>Strong analytical skills:</li><li>Ability to collect, organize, and analyze data; summarize findings and develop conclusions and recommendations</li><li>Self-starter who takes initiative and is proactive and able to prioritize multiple projects involving various stakeholders by meeting deadlines and proactively communicating status updates</li><li>Ability to communicate at all levels of the organization, from end-users to Senior Management</li><li>Data Science & Machine Learning, Systems Architecture & Engineering </li></ul> Responsibilities<ul><li>This person will have a passion for problem-solving and building robust data pipelines that support critical reporting and analysis across the business</li><li>They will gain a deep understanding of the data sources that populate DOMO, our BI reporting platform, and the tools/processes that integrate those systems</li><li>The ideal candidate will have a proven track record of providing data solutions that empower stakeholders to make critical business decisions and will play a key role in powering our go to market and product development strategies through data</li><li>They will also serve as a steward of data quality and consistency across the business</li><li>Streamline the current data landscape and create a visible and reusable architecture to increase transparency and standardization of definitions</li><li>Partner with stakeholders and BI Analysts to define and build a centralized data repository purpose-built for reporting</li><li>Create and maintain a single source of truth data dictionary</li><li>Streamline ETL's into coherent views to support effective and consistent reporting to the business</li><li>Work closely with vendors from PI's tech stack to evaluate all API integration options with DOMO</li><li>Build historical datasets to eventually leverage them into data science investigations</li><li>Work closely with the systems team to understand and develop expertise in a growing range of PI data sources and their applications across the business</li><li>Staying up to date on the data lineage is critical</li><li>Constitute rules of engagement and governance processes regarding the analytics data landscape</li><li>Support and train team members on data architecture and similar concepts</li></ul>Job descriptionWe are seeking a talented and experienced Senior Data Engineer to join our growing Business Intelligence team. This person will have a passion for problem-solving and building robust data pipelines that support critical reporting and analysis across the business. They will gain a deep understanding of the data sources that populate DOMO, our BI reporting platform, and the tools/processes that integrate those systems. The ideal candidate will have a proven track record of providing data solutions that empower stakeholders to make critical business decisions and will play a key role in powering our go to market and product development strategies through data. They will also serve as a steward of data quality and consistency across the business. YOUR DAY-TO-DAY:Streamline the current data landscape and create a visible and reusable architecture to increase transparency and standardization of definitions. Partner with stakeholders and BI Analysts to define and build a centralized data repository purpose-built for reporting. Create and maintain a single source of truth data dictionary. Streamline ETL's into coherent views to support effective and consistent reporting to the business. Work closely with vendors from PI's tech stack to evaluate all API integration options with DOMO. Build historical datasets to eventually leverage them into data science investigations. Work closely with the systems team to understand and develop expertise in a growing range of PI data sources and their applications across the business. Staying up to date on the data lineage is critical. Constitute rules of engagement and governance processes regarding the analytics data landscape. Support and train team members on data architecture and similar concepts. Experience building schema to scale and automate workflows. Experience and knowledge of modern data stores, pipeline and reporting/analytic techniques and tools. Experience building data models and data warehouses is highly desired. Expertise in SQL, MYSQL, and Python is required. Strong analytical skills:Ability to collect, organize, and analyze data; summarize findings and develop conclusions and recommendations. Self-starter who takes initiative and is proactive and able to prioritize multiple projects involving various stakeholders by meeting deadlines and proactively communicating status updates. Ability to communicate at all levels of the organization, from end-users to Senior Management. Bachelor's degree in engineering, mathematics, computer science, or equivalent data engineering work experience, preferred

We have an immediate requirement for a Senior Data Engineer (Big Data) with one of our direct clients in Sunnyvale, CA. Contract and Hybrid (2-3 days a week onsite).Need data engineer with big data experience. 3+ years of experience to work on specific code in our Ads space to implement new privacy controls. Designs, develops, and implements Hadoop eco-system-based applications to support business requirements. Follows approved life cycle methodologies, creates design documents, and performs program coding and testing. Resolves technical issues through debugging, research, and investigation. Experience/Skills Required: <ul><li>Experience in building scalable, robust applications using Big Data technologies like Hadoop, Spark, Hive, Map reduce.</li><li>Proficient with SQL</li><li>Experience with Scripting – Python, shell.</li><li>Nice to have - Experience with MySQL</li><li>Nice to have – experience with GCP, BigQuery, Apache Nifi.</li><li>Experience in Scala and Java is a plus</li></ul> Bachelors degree in Computer Science, Information Technology, or related field and minimum 5 years experience in computer programming, software development or related

Drishticon Interview Questions

Drishticon Interview Guides

Drishticon Interview Questions

Drishticon Salaries by Position

Drishticon Opening Jobs