Haystack
← Back to Jobs
Technology
MU

Senior Software Engineer, Data Warehousing

Momento USA LLCIrving, TX🇺🇸United StatesPosted 24 Aug 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Irving, TX, United States
Posted
23 hours ago
OracleSQLSQL ServerSnowflakeAzureData PipelineREST

Job Description

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges. We currently looking  Senior Software Engineer, Data Warehousing Please see the job description below for your reference.

Role: Senior Software Engineer, Data Warehousing
Location: Irving, TX (Need Local) 
Duration: 12 Months
 
Job Summary
The Senior Data Warehouse Engineer is responsible for designing, building, and optimizing enterprise data pipelines and data models to transform complex operational data into scalable, consumable datasets. This role will focus on modernizing data from Oracle EBS and other sources into Azure-based platforms, enabling near real-time data availability through incremental load and UPSERT patterns. This role requires deep expertise in Azure Data Factory, strong SQL engineering skills, and experience working with both structured and semi-structured data, including JSON. The engineer will also integrate external data sources via REST APIs and help standardize data for downstream reporting and analytics.
 
Primary Responsibilities
•    Design, build, and maintain data pipelines using Azure Data Factory (ADF)
•    Develop and implement incremental data processing patterns, including UPSERT/MERGE logic
•    Ingest and transform data from Oracle EBS into Azure SQL and Snowflake
•    Integrate REST API-based data sources into enterprise data pipelines
•    Design and maintain data warehouse and data mart structures (star/snowflake schemas)
•    Transform and normalize semi-structured data (JSON) into relational models
•    Optimize performance for large-scale datasets (indexing, partitioning, query tuning)
•    Establish standards for data modeling, naming conventions, and pipeline design
•    Partner with BI/reporting teams to ensure data is accurate, performant, and consumable
•    Troubleshoot and resolve issues across ingestion, transformation, and storage layers
•    Provide technical leadership, mentoring, and best practices in data engineering
 
Required Qualifications
•    7–10+ years of experience in data engineering or data warehousing
•    Advanced SQL expertise across: 
o    Oracle
o    SQL Server / Azure SQL
o    Snowflake
•    Strong hands-on experience with Azure Data Factory (ADF) (required)
•    Advanced SQL query capabilities, including but not limited to: Joins, aggregations, memory tables, CTEs, subqueries (all candidates will be screened for this ability)
•    Experience implementing: 
o    Incremental data loads
o    UPSERT / MERGE patterns
•    Experience integrating data from: 
o    Oracle EBS or similarly complex ERP systems
o    REST APIs as data sources
o    Managing orchestrated workflows involving placement of sFTP files
•    Strong experience working with: 
o    JSON data structures and parsing in SQL
o    Hybrid structured and semi-structured datasets
•    Deep understanding of: 
o    Dimensional data modeling (star/snowflake schema)
o    Data pipeline architecture and lifecycle
 
 

Thanks,

Muskan Attar

Direct: | Board: Ext 1024

w: e:

LinkedIn:

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

Interstate Business Park

 

Minority Certified by SWAM
National Minority Certified by NMSDC

One of the fastest growing companies in NJ
Awarded fastest growing Asian American business by Diversitybusiness.com
E-verified Company

Information transmitted by this e-mail is proprietary to Momento USA and/ or its customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at and delete this mail from your records.

 

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.

Similar jobs

Browse related jobs

Apply now