Prepare for and practice interview questions from Directv.

Directv Interview Questions

Directv 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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Directv Salaries by Position

DIRECTV is seeking a Principal, Software Engineer 2 to support initiatives that will deliver step-function improvements in customer experience and dramatic improvements in cost structure. This role demands a creative problem-solver who is a strong partner to our internal customers and a technical innovator. Experienced in complex software delivery scenarios, this lead will understand the business problem to be solved, guide employee and outsourced teams through execution, overcome obstacles, continuously improve processes, and quickly deliver solutions to market. This leader must be both a technical expert on digital delivery, but also an excellent communicator and one who productively challenges the status quo.Heres what youll do:<ul><li>Work with business leaders to understand execution priorities and how they result in business value; ensure that developed capabilities meet desired business outcomes.</li><li>Participate in feasibility and cost/benefit discussions to guide prioritization and feature roadmap creation.</li><li>Oversee technical delivery and devise approaches to implement enhancements that efficiently take advantage of existing platform capabilities where possible; consult on application architecture; deliver capabilities that are economical to sustain in the long term.</li><li>Develop delivery plans that anticipate risks and mitigate them early.</li><li>Lead delivery teams to work with urgency and focus to deliver quality enhancements at a high velocity; remove barriers, negotiate dependencies, and manage resourcing concerns.</li><li>Ensure that teams are operating in a standardized, measurable way; monitor and manage agile delivery metrics; drive adoption of modern delivery practices and DIRECTV standards.</li><li>Understand backlog demands and manage vendor capacity and budgets to ensure resourcing is in place when needed, and that resources are efficiently utilized.</li><li>Execute quality management processes (e.g. testing) to ensure solutions developed are performant and meet business requirements.</li><li>Identify needed nonfunctional requirements (performance, alerting/monitoring, capacity, compliance, security, etc.) and ensure they are addressed.</li><li>Prepare and provide updates to leadership.</li></ul>Heres what youll need to be successful:<ul><li>A bachelors degree in computer engineering, computer science, or a related field is preferred and highly recommended.</li><li>7+ years of experience in software engineering and the design, development of complex systems, including as a team lead.</li><li>Experience working in multiple Agile methodologies (scrum, Kanban, SAFe) and familiarity with the tooling used to coordinate this work (mainly Jira, Jira Align).</li><li>Experience with web-specific processes and technologies, including requirements, design/UX, accessibility, content management systems, front-end frameworks (e.g. React), SEO, clickstream analytics, and tag management.</li><li>Robust knowledge of several programming languages (e.g. Java, C++, Python, etc.).</li><li>Expertise in modern delivery and deployment practices, such as CI/CD, quality automation, test-driven development, blue/green releases strategies, etc.</li><li>Experience developing for and deploying to cloud environments.</li><li>Strong written and oral communication skills.</li><li>Demonstrated judgment and decisiveness in a fast-paced, changing work environment.</li><li>Leadership, organizational, and delegation skills to break large projects down into milestones and assign tasks best suited to team members, and to coach team members.</li><li>May require a background check due to job duties requiring routine access to DIRECTV and DIRECTV customers proprietary data. Qualified applicants with arrest and conviction will be considered for employment in accordance with local ordinances and state law.</li></ul>This role requires, but is not limited to, 5% travel.This is a remote position that can be located anywhere in the United States. #LI-RemoteA career with DIRECTV comes with big rewards: DIRECTV's compensation structure is designed to be market-competitive and fully supports efforts to attract and retain employees. It is the company's policy to offer pay that is competitive with other employers in the local market. Our salary ranges are determined by role, level, and location.The Base Salary range displayed below reflects the minimum and maximum target salary for each of DIRECTV's 4 (four) US Labor Market Zones. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.DIRECTV WAGE ZONES: $140,790 - $255,530Low (N1): $140,790 - $211,090Mid (N2): $148,200 - $222,200High (N3): $163,020 - $244,420Top (N4): $170,430 - $255,530Click <a href="https://tbcdn.talentbrew.com/company/390/pdf/GeoZone-by-DMA-003.pdf" target="_blank">HERE</a> to review information on some of the largest Designated Market Areas (DMAs). Your recruiter can share more about the specific salary range for your preferred location during the hiring process.Please note that the salary ranges reflect base salary only and do not include bonus or benefits - when you consider all of these together, it represents a pretty impressive total compensation package.Apply today!<a href="https://tbcdn.talentbrew.com/company/390/pdf/fcoe-official-notice-eng-final-8302024.pdf" target="_blank">Fair Chance Ordinance Notice for Los Angeles County applying for jobs at DIRECTV</a><h3></h3><h3>RSRDTV</h3>

Directv Interview Questions

Directv Interview Guides

Directv Interview Questions

Directv Salaries by Position

Directv Opening Jobs