Talent.com
DataWarehouse/ETL Engineer
DataWarehouse/ETL EngineerMomento USA • NJ, United States
DataWarehouse / ETL Engineer

DataWarehouse / ETL Engineer

Momento USA • NJ, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Hi,

I hope you're doing well,

Momento USA is a global technology consulting, talent acquisition, and creative development firm that addresses clients' most pressing needs and challenges. We are currently looking for an DataWarehouse / ETL Engineer.

Job Title : Senior Data Warehouse ETL Engineer (Should be hands on resource)

Location : Remote

Duration : Long Term

Position Overview

We are seeking a Senior Data Warehouse (DW) and ETL Expert to lead end-to-end data integration, transformation, and analytics initiatives for Aramark. 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.

Key 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 Qualifications

  • 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.
  • Thanks,

    Adam Walker (Aquib)

    Technical Recruiter

    Momento USA | Exceeding Customer Expectations

    440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031

    Interstate Business Park

    Direct : 856-452-8849 || Tel : (856) 456-1805 Ext 1021; Fax : (866) 605-1171

    Email : adam@momentousa.com ; Web : www.MomentoUSA.com .

    Note : Momento USA is an Equal Opportunity / Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

    serp_jobs.job_alerts.create_a_job

    Engineer • NJ, United States