IICS Data Integration / Developer

# 2046857
Type: 6-month contract to start
Role: IICS Data Integrator/Developer
Hybrid: Monday, Tuesday, Thursday onsite. Wednesday and Friday remote
Other: Open to w2 or c2c working engagements
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:Bachelors degree in Computer Science, Information Technology, or a related field.

Please reach out to [email protected] !

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178 .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.