Apply on Employer Site

Sonata Software · 16 hours ago

Senior ETL Developer

United States

Contract

Remote

Senior Level

Sonata Software is a leading Modernization Engineering company focused on delivering modernization-driven hypergrowth for clients. They are seeking a Senior ETL Developer to design, develop, and maintain ETL/ELT pipelines using Azure Data Factory and collaborate with teams to ensure data quality and compliance.

Software

H1B Sponsor Likely

Hiring Manager

Simmee Kumari

Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory

Develop and optimize SQL Server databases, including tables, views, stored procedures, and functions

Build data ingestion and transformation processes from multiple source systems (on-premises and cloud)

Write complex and efficient T-SQL queries for data transformation and validation

Implement data quality checks, error handling, and logging within ETL pipelines

Monitor, troubleshoot, and optimize ADF pipeline performance

Support data migration and integration projects to Azure

Collaborate with data architects, analysts, and business teams to understand data requirements

Ensure adherence to data security, governance, and compliance standards

Maintain detailed documentation for ETL processes and data flows

Qualification

Azure Data FactorySQL ServerT-SQLETL/ELT conceptsData warehousing principlesPerformance tuningData migrationData integrationData quality checksDocumentation

Required

Proven experience as an ETL Developer or Data Engineer

Hands-on experience with Azure Data Factory

Strong expertise in SQL Server and T-SQL

Solid understanding of ETL/ELT concepts and data warehousing principles

Experience with incremental loads, CDC, and data transformations

Knowledge of performance tuning for SQL Server and ETL workflows

Experience working with relational and dimensional data models

Familiarity with Azure SQL Database or SQL Managed Instance

Company

Sonata Software

Glassdoor3.9

Sonata is a global software services company.

Founded in 1986

Bangalore, Karnataka, IND

5001-10000 employees

http://www.sonata-software.com/

H1B Sponsorship

Sonata Software has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2022 (2)

2021 (1)