Sonata Software · 16 hours ago
Senior ETL Developer
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.
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
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
Sonata is a global software services company.
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)
Funding
Current Stage
Public CompanyTotal Funding
unknown1999-07-28IPO
Leadership Team
Recent News
2025-12-12
2025-11-19
Company data provided by crunchbase