← Back to jobs

Technology Management Solutions Logo
Senior Software Engineer
Posted On: Just posted
Experience: 10+ years
Availability: Hybrid
Openings: 1
Category: Senior Software Engineer
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You design, build, and maintain data pipelines using Azure Data Factory (ADF) and optimize large-scale datasets across Azure SQL and Snowflake.

This role is hybrid.

Responsibilities

  • Develop incremental data processing patterns, including UPSERT/MERGE logic, and ingest data from Oracle EBS.
  • Design and maintain data warehouse structures (star/snowflake schemas) and normalize semi-structured JSON data into relational models.
  • Integrate REST API-based data sources and manage orchestrated workflows involving sFTP file placement.
  • Partner with BI teams to ensure data accuracy and provide technical leadership on data engineering best practices.
  • Optimize query performance through indexing, partitioning, and tuning, while establishing naming conventions.

Required Skills

  • 10+ years of experience in data engineering or data warehousing.
  • Advanced SQL expertise across Oracle SQL, SQL Server/Azure SQL, and Snowflake.
  • Strong hands-on experience with Azure Data Factory (ADF).
  • Experience implementing incremental loads, UPSERT/MERGE patterns, and complex joins/CTEs.
  • Experience integrating data from Oracle EBS or similarly complex ERP systems.
  • Ability to parse and manipulate JSON data structures in SQL.
  • Deep understanding of dimensional data modeling and data pipeline architecture.

Education

Bachelor's degree

Related Jobs

No related jobs found

← Back to jobs