Data Warehouse / ETL Engineer (Oracle Cloud, Google Cloud Platform BigQuery)

Overview

Remote
Full Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

data integration
Oracle Cloud HCM
Oracle Cloud Fusion
Data Modeling
Informatica
Communication Skills
technical solutions
data transformation
Data Analytics
Google Cloud Platform (GCP)
BigQuery
Stakeholder Collaboration
Data Cleansing
Talend
ETL Engineer
Data Warehouse Engineer
ETL Design
ETL Implementation
FiveTran
ORBIT
Data Integration Pipelines
Business Logic Implementation
Data Sanitation
Enterprise Data Solutions
Data Loading Processes
Data Rationalization
Complex ETL Pipelines
Large-scale Data Projects
Autonomous Working
Cloud Data Warehousing
Data Pipeline Optimization
Informaticas

Job Details

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

Job Title: Data Warehouse / ETL Engineer (Oracle Cloud, Google Cloud Platform 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 Google Cloud Platform 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 (Google Cloud Platform), 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

About Solution IT

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.