Job Details

Role: Data Integrator/Developer
Hybrid: Monday, Tuesday, Thursday Onsite

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.

Required Skills : SQL Snowflake IICS Oil and Gas experience

Basic Qualification :

Additional Skills :

Background Check : Yes

Drug Screen : Yes

Notes :
Selling points for candidate :
Project Verification Info :"The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Blanket Approval Received Client Letter: Will Not Provide"
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :
Master Job Title :BUS
Branch Code :