Prepare for and practice interview questions from Conocophillips.

Conocophillips Interview Questions

Conocophillips 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

Conocophillips Salaries by Position

Welcome to ConocoPhillips, where innovation and excellence create a platform for opportunity and growth. Come realize your full potential here.
Who We Are We are one of the world’s largest independent exploration and production companies, based on proved reserves and production of liquids and natural gas. With operations and activities in 13 countries, we explore for, develop, and produce crude oil and natural gas globally. We are challenged with an important job to safely find and deliver energy to the world. Our employees are critical to our success, and with them we power civilization.
We’re grounded by our SPIRIT Values – safety, people, integrity, responsibility, innovation, and teamwork. These values position us to deliver strong performance in a dynamic business – but not at all costs. We believe it’s not just what we do – it’s how we do it – that sets us apart.
We strive to make a significant difference in the communities where we live and operate. We create an inclusive environment that values all voices and opinions. Together, the different backgrounds, experiences, ideas, and perspectives of our employees drive our success.
Job Summary ConocoPhillips Alaska, Inc. is Alaska’s largest crude oil producer and largest owner of exploration leases, with approximately 1 million net undeveloped acres at year-end 2023. The company produced an average of 195 thousand barrels of oil equivalent per day (MBOED) in 2023. ConocoPhillips Alaska holds major ownership interests in two of North America’s largest legacy equivalent per day conventional oil fields, both located on Alaska’s North Slope: Kuparuk, which the company operates, and Prudhoe Bay. Additionally, ConocoPhillips Alaska owns and operates several fields on the Western North Slope. The company also has an ownership interest in the Trans-Alaska Pipeline System and owns and operates the Polar Tankers fleet.
Job Description The Data Engineer role within Alaska Digital Technologies (AKDT) in ConocoPhillips will be responsible for building data pipelines from source systems into the analytics environment with validation to allow creation and operations of analytical solutions and computational models.
The Alaska Business Unit (BU) is undergoing a transformational data modernization initiative which will require refactoring legacy platforms and code to a modern technology stack. The initial focus of this role will be modernizing a business-critical Oracle database hosted on Unix leveraging Perl scripts for integration and transformation logic.
The role will also monitor, optimize, and support the development, test, and production environments working closely with the database administrators, analytics architect, and IT (Information Technology) infrastructure support to ensure system availability.
This role will be proficient at integrating and preparing large, varied datasets including time series data and designing specialized database tables and information links within the environment. The person will work closely with engineers, data scientists, geo-scientists, project/program managers, and IT teams to provide clean and reliable data.
This role requires a strong and current technology focus, practical analytical experience, and excellent written and communications skills.
Your responsibilities may include: Develop, test, and manage data pipelines
Collect, explore, validate, and condition data
Collaborate with business subject matter experts and data scientists to create data sets and engineer features for analytical models
Productionize and operationalize analytical models
Adhere to ConocoPhillips’ governance and compliance policies for data and processes
Monitor model performance
Basic/Required: Must be legally authorized to work in the United States on a full-time basis for anyone other than current employer
Bachelor’s degree or higher in Computer Science, Math, Engineering, Statistics, Information Systems, Information Science, other related field, or foreign equivalent
5+ years of experience as a Data Engineer, Architect, or Database Administrator
3+ years experience with data visualization/analytics tools, RDBMS, and Cloud DevOps and Infrastructure as Code (IaC)
3+ years experience handling large volume operational data
Advanced level of proficiency with one or more programming languages
Advanced level of proficiency with SQL
Advanced level of proficiency with Excel
Intermediate level of knowledge of Python
Preferred: 1+ years experience as Oracle DBA
1+ years experience with Spotfire and Power BI
1+ years experience with Snowflake, Oracle hosted on Unix, Teradata, and connecting to enterprise systems
1+ years experience with Azure, AWS (Cloud Formation, Terraform)
1+ years experience with Oil & Gas time series data feeds in combination with historical and unstructured data
Advanced knowledge of Python, R, C++, Java, and Perl
Advanced verbal and written presentation skills, with the ability to communicate clearly and persuasively
Intermediate understanding of project processes and methodology to support Project Management initiatives and delivery such as Scrum, Kanban, SAFe
Open attitude towards and ability to learn and utilize modern technologies and standards
Invites dialogue to gain a shared understanding and influences with confidence to drive performance and achieve business results.
Builds positive relationships based on trust and seeks collaboration across organizational boundaries to achieve goals
Apply Before: August 17, 2024
Sponsorship: ConocoPhillips’ sponsorship for employment authorization in the U.S. is NOT available for this position.
EEO: In the US, ConocoPhillips is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, veteran status, gender identity or expression, genetic information, or any other legally protected status.

#J-18808-Ljbffr

Welcome to ConocoPhillips, where innovation and excellence create a platform for opportunity and growth. Come realize your full potential here.
Who We Are We are one of the world’s largest independent exploration and production companies, based on proved reserves and production of liquids and natural gas. With operations and activities in 13 countries, we explore for, develop, and produce crude oil and natural gas globally. We are challenged with an important job to safely find and deliver energy to the world. Our employees are critical to our success, and with them we power civilization.
We’re grounded by our SPIRIT Values – safety, people, integrity, responsibility, innovation, and teamwork. These values position us to deliver strong performance in a dynamic business – but not at all costs. We believe it’s not just what we do – it’s how we do it – that sets us apart.
We strive to make a significant difference in the communities where we live and operate. We create an inclusive environment that values all voices and opinions. Together, the different backgrounds, experiences, ideas, and perspectives of our employees drive our success.
Job Summary This Senior Data Engineer role within Applied Digital Technology in ConocoPhillips will be responsible for building data and machine learning model pipelines from source systems into the analytics environment with validation to allow creation and operations of machine learning models and pipelines. The role will also monitor, optimize, and support the development, test and production environments working closely with the database administrators, system architects, and IT infrastructure support to ensure system availability. This role requires a strong and current technology focus, practical analytical experience, and excellent written and communications skills.
If you are selected as the Data Engineer, you will need to be proficient at integrating and preparing large, varied datasets including time series data and designing specialized database tables within the environment. You will work closely with engineers, data scientists, geo-scientists, project/program managers, and IT teams to provide clean and reliable data.
Your responsibilities may include: Develop, test, and manage data pipelines
Collect, explore, validate, and condition data
Collaborate with business subject matter experts and data scientists to create data sets and engineer features for analytical models
Productionize and operationalize analytical models
Adhere to ConocoPhillips’ governance and compliance policies for data and processes
Monitor model performance
Basic/Required: Must be legally authorized to work in the United States on a full-time basis for anyone other than current employer
Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems/Science, Mathematics, Statistics, other related business field, other related technical field, or foreign equivalent
10+ years of IT or programming experience
5+ years of experience in a programming language
3 + years of experience with data visualization/analytics tools and Excel
3 + years of experience with SQL
3+ years of experience with handling large amount of operational data and/or creating ETL/ELT pipelines
3+ years of experience with CI/CD pipelines and source control
1+ years of experience with Infrastructure as Code (CDK, Terraform, Bicep, ARM Templates)
Preferred: Master's degree or higher in Computer Science, Engineering, Information Technology, Information Systems/Science, Mathematics, Statistics, other related business field, other related technical field, or foreign equivalent
5 + years of experience with Python
5 + years of experience writing Snowflake SQL
3 + years of experience with Terraform, or CDK
5 + years of experience using git
3 + years of experience with Spotfire, PowerBI, or Streamlit
3 + years of experience with Parallel/Distributed computing, (e.g. Spark, Dask, Ray, …)
3 + years of experience with Oil & Gas time series data feeds in combination with historical and unstructured data
5 + years of experience with Oil & Gas industry
1 + years of experience with project management
3 + years of experience with data virtualization
3 + years of experience in deploying Machine Learning based applications and/or pipelines
3 + years of experience using Bash shell scripting
3 + years of experience using Linux/Unix systems
Intermediate knowledge of Mlflow or other MLOps platform
Intermediate level of understanding of agile processes and methodology to support project management initiatives and delivery
Efficient verbal and written presentation skills, with the ability to communicate clearly and persuasively
Efficient interpersonal skills in areas such as teamwork and communications
Open attitude towards and ability to learn and utilize new technologies and standards
Takes ownership of actions and follows through on commitments by holding others accountable and standing up for what's right
Delivers positive results through realistic planning to accomplish goals
Builds effective solutions based on available information and makes timely decisions that are safe and ethical
Apply Before: August 14, 2024
Sponsorship: ConocoPhillips’ sponsorship for employment authorization in the U.S. is NOT available for this position.
EEO: In the US, ConocoPhillips is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, veteran status, gender identity or expression, genetic information, or any other legally protected status.

#J-18808-Ljbffr

Develop, test, and manage data pipelines. Collect, explore, validate, and condition data. Collaborate with business subject matter experts and data scientists to create data sets and engineer features for analytical models. Productionize and operatio Data Engineer, Engineer, Data Scientist, Technology, Experience

Welcome to ConocoPhillips, where innovation and excellence create a platform for opportunity and growth. Come realize your full potential here. Who We Are We are one of the world's largest independent exploration and production companies, based on proved reserves and production of liquids and natural gas. With operations and activities in 13 countries, we explore for, develop, and produce crude oil and natural gas globally. We are challenged with an important job to safely find and deliver energy to the world. Our employees are critical to our success, and with them we power civilization. We're grounded by our SPIRIT Values - safety, people, integrity, responsibility, innovation, and teamwork. These values position us to deliver strong performance in a dynamic business - but not at all costs. We believe it's not just what we do - it's how we do it - that sets us apart. We strive to make a significant difference in the communities where we live and operate. We create an inclusive environment that values all voices and opinions. Together, the different backgrounds, experiences, ideas, and perspectives of our employees drive our success. Job Summary Description This Senior Data Engineer role within Applied Digital Technology in ConocoPhillips will be responsible for building data and machine learning model pipelines from source systems into the analytics environment with validation to allow creation and operations of machine learning models and pipelines. The role will also monitor, optimize, and support the development, test and production environments working closely with the database administrators, system architects, and IT infrastructure support to ensure system availability. This role requires a strong and current technology focus, practical analytical experience, and excellent written and communications skills. If you are selected as the Data Engineer, you will need to be proficient at integrating and preparing large, varied datasets including time series data and designing specialized database tables within the environment. You will work closely with engineers, data scientists, geo-scientists, project/program managers, and IT teams to provide clean and reliable data. Job Description Your responsibilities may include: <ul> <li>Develop, test, and manage data pipelines </li><li>Collect, explore, validate, and condition data </li><li>Collaborate with business subject matter experts and data scientists to create data sets and engineer features for analytical models </li><li>Productionize and operationalize analytical models </li><li>Adhere to ConocoPhillips' governance and compliance policies for data and processes </li><li>Monitor model performance </li></ul>Basic/Required: <ul> <li>Must be legally authorized to work in the United States on a full-time basis for anyone other than current employer </li><li>Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems/Science, Mathematics, Statistics, other related business field, other related technical field, or foreign equivalent </li><li>10+ years of IT or programming experience </li><li>5+ years of experience in a programming language </li><li>3 + years of experience with data visualization/analytics tools and Excel </li><li>3 + years of experience with SQL </li><li>3+ years of experience with handling large amount of operational data and/or creating ETL/ELT pipelines </li><li>3+ years of experience with CI/CD pipelines and source control </li><li>1+ years of experience with Infrastructure as Code (CDK, Terraform, Bicep, ARM Templates) </li></ul>Preferred: <ul> <li>Master's degree or higher in Computer Science, Engineering, Information Technology, Information Systems/Science, Mathematics, Statistics, other related business field, other related technical field, or foreign equivalent </li><li>5 + years of experience with Python </li><li>5 + years of experience writing Snowflake SQL </li><li>3 + years of experience with Terraform, or CDK </li><li>5 + years of experience using git </li><li>3 + years of experience with Spotfire, PowerBI, or Streamlit </li><li>3 + years of experience with Parallel/Distributed computing, (e.g. Spark, Dask, Ray, ...) </li><li>3 + years of experience with Oil & Gas time series data feeds in combination with historical and unstructured data </li><li>5 + years of experience with Oil & Gas industry </li><li>1 + years of experience with project management </li><li>3 + years of experience with data virtualization </li><li>3 + years of experience in deploying Machine Learning based applications and/or pipelines </li><li>3 + years of experience using Bash shell scripting </li><li>3 + years of experience using Linux/Unix systems </li><li>Intermediate knowledge of Mlflow or other MLOps platform </li><li>Intermediate level of understanding of agile processes and methodology to support project management initiatives and delivery </li><li>Efficient verbal and written presentation skills, with the ability to communicate clearly and persuasively </li><li>Efficient interpersonal skills in areas such as teamwork and communications </li><li>Open attitude towards and ability to learn and utilize new technologies and standards </li><li>Takes ownership of actions and follows through on commitments by holding others accountable and standing up for what's right </li><li>Delivers positive results through realistic planning to accomplish goals </li><li>Builds effective solutions based on available information and makes timely decisions that are safe and ethical </li></ul> Apply Before: August 14, 2024 Sponsorship: ConocoPhillips' sponsorship for employment authorization in the U.S. is NOT available for this position. EEO: In the US, ConocoPhillips is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, veteran status, gender identity or expression, genetic information, or any other legally protected status.

The Data Analyst expression of interest (EOI) job is used to fill high-volume roles or frequently hired positions to be used for future openings. By filling out an EOI job application you are joining our Talent Community, where you have the opportunity to be matched with openings that are the right fit for you. ConocoPhillips is a leading oil and gas company, based in Houston, TX, and is hiring Data Analysts for contract positions. The Data Analyst is responsible for providing quality data to the businesses and functions in an efficient manner so that critical decisions can be made effectively and efficiently. Key Accountabilities <ul> <li>Responsible for providing quality data to businesses and functions in an efficient manner so that critical decisions can be made effectively and efficiently. </li><li>Supports, promotes, and documents all Data Management processes and procedures. </li><li>Develops workflows and tools that automate data loading processes and help ensure data quality and integrity. </li><li>Ensures the quality, consistency, and integrity of data in a timely, effective and reliable manner. </li><li>Receives, archives distributes, loads, and disposes of technical data according to policies, standards, and procedures. </li></ul>Required and Preferred Skills and Experience <ul> <li>Entry level, typically 0-3 years of experience. </li><li>Requires basic knowledge of discipline. </li><li>Uses established procedures to solve standard, straight-forward problems. </li><li>Has the ability to perform routine assignments based on detailed instructions/past practices. </li></ul>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/ <ul><li>Published on 24 Aug 2023, 3:31 PM </li> </ul>

The Gulf Coast Ammonia Project is a proposed blue ammonia facility in the Texas Coastal Bend Area. The project is currently in Pre-FEED with FEED expected to commence in December 2024 and first commercial production in early 2030. The Lower Carbon Co Engineering Manager, Manager, Engineer, Energy, Contractor, Technology, Design

Conocophillips Interview Questions

Conocophillips Interview Guides

Conocophillips Interview Questions

Conocophillips Salaries by Position

Conocophillips Opening Jobs