Job Title: Data Integrator/Developer
Location: Houston, TX
Work Arrangement: Hybrid (Onsite: Monday, Tuesday, Thursday)
Job Description:
We are seeking a skilled Data Integrator/Developer to join our team at ConocoPhillips in Houston, TX. The ideal candidate will have a strong background in data integration and development within the oil and gas industry.
Role: Data Integrator/Developer
Hybrid: Monday, Tuesday, Thursday Onsite
Required Skills
SQL Snowflake IICS Oil and Gas experience
Key Responsibilities:
- Data Integration: Design, develop, and maintain data integration solutions to support oil and gas operations. This includes integrating data from various sources such as Oracle, SQL Server, Snowflake, and other ETL tools. Ability to write complex SQL queries in traditional or virtual databases is required
- Database Management: Manage and optimize SQL Server databases to ensure high performance, availability, and security.
- ETL Processes: Develop and maintain ETL processes to extract, transform, and load data from various sources into Snowflake and other data warehouses using Informatica Cloud Services. Proficient knowledge of Informatica Cloud Services is required
- Data Quality: Ensure data quality and integrity by implementing data validation and cleansing processes. Proficiency with well completions and production data integration in Wellview is preferred.
- Collaboration: Work closely with cross-functional teams and business stakeholders to understand data requirements and deliver effective data solutions.
- Documentation: Create and maintain comprehensive documentation for data integration processes, database schemas, and ETL workflows.
Qualifications (Basic/Required):
- Experience: Intermediate knowledge in oil and gas industry, with good understanding of at least production & completions data side of the Well Life Cycle. Good working knowledge of production and completions data in Wellview
- Technical Skills: Proficient in SQL Server, Snowflake, and Informatica Cloud Software for building & maintaining ETL pipelines. Experience with data modeling, database design, and performance tuning.
- Analytical Skills: Strong analytical and problem-solving skills, with the ability to analyze complex data sets and derive actionable insights.
- Communication: Excellent communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
- Education: Bachelor’s degree in computer science, Information Technology, or a related field.