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

Talent Consultants

Pattern Maker Job at Talent Consultants

 ...Talent Consultants is seeking a skilled and creative Pattern Maker to join our client's design team. As a Pattern Maker, you will play a crucial role in the development of garments, translating design concepts into three-dimensional patterns that can be used for production... 

Wells Fargo

Relationship Banker- Greensboro Village Expansion Job at Wells Fargo

 ...Why Wells Fargo: Are you looking for more? Find it here. At Wells Fargo, we're more than a financial services leader were a global trailblazer committed to driving innovation, empowering communities, and helping our customers succeed. We believe that a meaningful... 

Monroe County Sheriff's Office

Deputy Sheriff Trainee Job at Monroe County Sheriff's Office

 ...personal contact with individuals at their home or place of business; processes papers for criminal actions. Transports inmates to prison, the courts, or to health facilities; assists in the extradition of prisoners in other counties or states. Provide information... 

The Club at Renaissance

Director of Racquet Sports Job at The Club at Renaissance

 ...The Director of Racquet Sports is responsible for directing and managing the Clubs tennis and racquet sports programs, including developing and promoting racquet sports programs for all age groups. The Director of Racquet Sports will organize clinics and private lessons... 

KeystoneCare

RN Registered Nurse- Home Health Full time Job at KeystoneCare

 ...KeystoneCare is looking for a dedicated and compassionate RN Registered Nurse to join our Home Health team on a full-time basis. The ideal...  ...Reliable transportation and valid Driver's License. Proof of COVID-19 Vaccination or an approved Medical or Religious exemption....