Prepare for and practice interview questions from Conocophillips.

Conocophillips Interview Questions

Conocophillips Interview Guides

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>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.</p>

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

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


<p>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?</p>

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?

Conocophillips Salaries by Position

<p>ConocoPhillips is a leading oil and gas company, which is hiring a Data Analyst for contract. JOB DESCRIPTION Key Accountabilities: Responsible for providing quality data to the businesses and functions in an efficient manner so that critical decisions can be made effectively and efficiently. Supports, promotes and documents all Data Management processes and procedures. Develops workflows and tools that automate data loading processes and help ensure data quality and integrity. Ensures the quality, consistency, and integrity of data in a timely, effective and reliable manner. Receives, archives, distributes, loads, and disposes off technical data according to policies, standards and procedures. Required and Preferred Skills and Experience: Experienced level, typically 5-7 years of experience. Requires a strong understanding of discipline. Able to apply knowledge and experience to complex problems and develop recommendations. Makes decisions within broad parameters. Acts as an informal resource for others with less experience. ConocoPhillips contract opportunities are for project-based or other short-term engagements that require specialized skills. Successful candidates for contract opportunities will not be considered employees of ConocoPhillips or any of its subsidiaries nor will candidates be eligible for employment benefits. Candidates looking for regular full-time employment opportunities should begin their search here: https://careers.conocophillips.com/ Published on 24 Oct 2024, 6:19 PM</p>

<p>ConocoPhillips is a leading oil and gas company which is hiring GGRE IT Sr. Analyst for contract positions. Geology, Geophysics, Reservoir Engineering (GGRE) IT organization provides GGRE IT strategy, roadmap & governance, application & workflow practices and support, Global Portfolio management & execution support to Geoscience and Reservoir Engineering staff. Key Accountabilities Primary Job Responsibilities: GGRE IT Sr. Analyst is accountable for building relationship with Geoscience and Reservoir Engineering staff primarily in Global Technical Functions (GTF) organization, management of projects with varying scale; understanding both GG, RE and IT requirements; facilitating communication across disciplines, and ensuring that IT solutions are executed in line with the GGRE capability priorities. The analyst will work closely with Global Technical Functions (GTF) to execute Digital Enablement activities associated with delivering Fiber Optic Workflows and Platform Modernization in support Alaska's Willow Development. Additionally, they will partner with Willow Digital Team to consult and execute GGRE focused initiatives in service of Willow Development. Responsibilities include but are not limited to the following: Conduct comprehensive analysis of fiber optic workflows, subsurface modelling business processes and workflows to document requirements for digital solutions delivery. Develop and maintain detailed business process models, use cases, and functional specifications. Lead solutions assessment and evaluation, develop evaluation decision criteria, solution selection criteria. Lead and participate in cross-functional project teams and collaborate extensively with GTF to drive strategic initiatives and achieve business objectives. Coordinate with Enterprise and Alaska Digital Teams in solving complex data, solution design challenges associated with a diverse range of G&G data and application systems, in service of cross functions (GG, Planning, Wells) integration and collaboration. Direct business unit point of contact and project manager for GGRE data and application integrations, interoperability, and modifications. Lead multi-disciplinary teams to deliver on newly designed data, applications & analytics solutions. Manage G&G Software Portfolio, Budget. Provide input in overall GGRE Roadmap. Lead Project & Resource planning & execution in support for projects tied to GGRE Roadmap and Alaska Willow Development Strategy. Required and Preferred Skills and Experience Must be legally authorized to work in the United States as a U.S. citizen or national, or an alien admitted as a permanent resident, refugee or asylee. Bachelor's degree or higher in Engineering, Geosciences, Computer Science, Management Information Systems, or other technical discipline, or foreign equivalent 7 years of experience as a Business Analyst in the upstream oil and gas industry Preferred Requirements 5 years of experience collaborating with Geology, Geophysics, Reservoir Engineering domains and having familiarity with their workflows and problems. Knowledge of Geoscience & Reservoir Engineering workflows, terminology, and software (Petrel, Techlog, Intersect, DELFI, etc.). Intermediate level of knowledge of Cloud Environment, SaaS Solution Model. Intermediate level of proficiency with MS O365 applications: Excel, Outlook, PowerPoint, Word, SharePoint, and Teams. Proficiency in Agile methodology, business analysis tools and software, such as Microsoft Excel, Microsoft Project, Jira, Power BI, and project management software. Proficiency in Software Portfolio Management & Vendor Engagement. Proficiency in OSDU industry standard, data management, solution architecture and IT security. Understands and anticipates the needs of clients and stakeholders. Delivers results through realistic planning to accomplish goals. Takes ownership of actions and follows through on commitments by holding self & others accountable. Understands how key financial and quantitative indicators impact the business. Builds positive relationships based on trust and seeks collaboration across organizational boundaries to achieve goals. Drives thoughtful and pragmatic change, encourages innovative thinking and continuous improvement, and models adaptability through resourcefulness, partnership & collaboration. Excellent communication and interpersonal skills, with the ability to collaborate effectively with diverse teams. ConocoPhillips contract opportunities are for project-based or other short-term engagements that require specialized skills. Successful candidates for contract opportunities will not be considered employees of ConocoPhillips or any of its subsidiaries nor will candidates be eligible for employment benefits. Candidates looking for regular full-time employment opportunities should begin their search here: https://careers.conocophillips.com/ Published on 26 Sep 2024, 7:05 PM</p>

Conocophillips Interview Questions

Conocophillips Interview Guides

Conocophillips Interview Questions

Conocophillips Salaries by Position

Conocophillips Opening Jobs