Data Warehouse / ETL Engineer (Oracle Cloud, GCP BigQuery) Job at SolutionIT, Remote

U2ZZT1VrcjF4WW9VanF3YVlLeURIRXlBNmc9PQ==
  • SolutionIT
  • Remote

Job Description

Solution IT Inc. is looking for Data Warehouse / ETL Engineer (Oracle Cloud, GCP BigQuery) for one of its clients in Remote.

Job Title: Data Warehouse / ETL Engineer (Oracle Cloud, GCP BigQuery)

Summary:

We are seeking a Senior Data Warehouse (DW) and ETL Expert to lead end-to-end data integration, transformation, and analytics initiatives. This role requires a deep understanding of complex ETL pipelines, data modeling, and business logic implementation, particularly in large-scale enterprise environments using Oracle Cloud Fusion applications and GCP BigQuery.

The ideal candidate will be a hands-on senior technologist who can independently design, build, and optimize complex data flows - from extraction to analytics - while collaborating closely with both business stakeholders and technical teams.

Responsibilities:

  • Design and implement robust ETL workflows using either of these tools Informatica OR Talend, OR FiveTran or ORBIT.
  • Build and manage data integration pipelines pulling from Oracle Cloud Fusion Apps (multiple modules) and Oracle Cloud HCM.
  • Develop and optimize data loading processes into Google Cloud BigQuery data warehouses.
  • Perform advanced data transformations, rationalization, and cleansing to ensure accuracy and consistency across multiple data domains.
  • Implement business logic and rules derived from stakeholder discussions into ETL processes.
  • Determine the appropriate approach for data sanitation (real-time pipeline vs. staging area) based on customer use cases.
  • Work collaboratively with senior technologists, architects, and business users to translate business needs into technical solutions.
  • Operate autonomously in a fast-paced, dynamic environment - capable of "diving into the deep end and swimming on your own."

Required Skills:

  • 10+ years of experience in Data Warehousing, ETL design, and implementation.
  • Expert-level proficiency in one or more ETL tools: Informatica, Talend, FiveTran (strong preference for Informatica).
  • Proven experience integrating Oracle Cloud Fusion and Oracle Cloud HCM data sources.
  • Hands-on experience with Google Cloud Platform (GCP), particularly BigQuery.
  • Strong understanding of data modeling, data transformation logic, and cleansing strategies.
  • Ability to translate complex business rules into technical ETL logic.
  • Excellent communication skills and the ability to work directly with business users and senior stakeholders.
  • Demonstrated ability to work independently and take ownership of large-scale projects.

Work Site: Remote

Duration: 6 Months

Expected Start Date: Immediate

Number of Positions: 1

Please send your responses back to contracts@solutionit.com

About Solution IT

Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston, Massachusetts.

Job Tags

Immediate start, Remote work,

Similar Jobs

Thermo Fisher Scientific

Senior Financial Analyst Job at Thermo Fisher Scientific

Work Schedule Standard (Mon-Fri) Environmental Conditions Office How you will make an impact: IES is a Services business supporting both AIG and LPG. Seeking a Sr Financial Analyst FP&A who will be an integral part of the IES finance team to support...

Bittersweet Farms

Sleep Shift Part time DSP - Pemberville, OH (Bowling Green Area) Job at Bittersweet Farms

 ...those with a desire to help others. We are seekingPart-timeemployees to work the overnight Sleep Shift from 11:00pm-8:30am. No experience necessary, we...  ...time or a position that allows you to sleep during the night and earn money!*Due to the nature of our work we... 

World Equestrian Center Ocala

Social Media Content Creator Job at World Equestrian Center Ocala

 ...The World Equestrian Center is hiring a Social Media Content Creator/ Managerto join our...  ...align with social media storytelling and marketing goals. Oversee daily social media...  ...sports and horse show culture, including experience in the hunter/jumper industry (multi-discipline... 

Thermo Fisher Scientific

QC Scientist II - Microbiology Job at Thermo Fisher Scientific

Work Schedule Standard (Mon-Fri) Environmental Conditions Adherence to all Good Manufacturing Practices (GMP) Safety Standards, Laboratory Setting, Some degree of PPE (Personal Protective Equipment) required (safety glasses, gowning, gloves, lab coat, ear plugs...

AdventHealth

Clinical Nurse Educator PRN ICU Job at AdventHealth

 ...recreations**The role you'll contribute:**Professional nurse who provides leadership in the development of staff education at the unit level in compliance with regulatory...  ...physician expectation. The educator combines clinical expertise and passion for teaching in both the...