We are looking for a highly skilled Senior ETL Developer with over 7 years of experience in designing, developing, and supporting robust data integration solutions. This role requires expertise in ETL development using SSIS, SQL Server, and Azure Data Factory, along with strong knowledge of database management, performance tuning, and cloud-based data solutions on Microsoft Azure. You will play a critical role in ensuring data quality, scalability, and seamless integration while collaborating with cross-functional teams to deliver enterprise-grade data solutions.
Key Responsibilities
- Design, develop, and implement ETL packages using Microsoft Integration Services with both full and incremental load strategies.
- Build and maintain frameworks, design documents, and implementation checks to ensure high-quality SSIS package deployments.
- Develop and optimize stored procedures, views, and functions in Microsoft SQL Server.
- Troubleshoot and resolve SQL performance issues, package debugging errors, and configuration challenges.
- Design and manage Azure Data Factory pipelines, triggers, linked services, and blob storage integrations.
- Work with Azure SQL MI including configuration of failover groups, backups, and database restores.
- Ensure database security, health checks, and performance monitoring using advanced tools.
- Implement Azure DevOps CI/CD pipelines for deploying SSIS packages and other production support processes.
- Collaborate with third-party providers for releases, hotfixes, and integration testing, ensuring smooth delivery.
- Provide technical guidance, estimates, and reviews of development tasks while mentoring junior developers.
Qualifications
- 7+ years of experience in ETL design, development, and support.
- Strong expertise in SSIS, SQL Server, and T-SQL (procedures, functions, performance tuning).
- Hands-on experience with Azure Data Factory (ADF) including pipelines, triggers, blob storage, and logs.
- Proficiency with Azure portal and core Azure services (Key Vault, Log Analytics, Functions, File Storage).
- Experience in Azure SQL Managed Instance (MI) with database creation, restore, and failover management.
- Strong knowledge of database security, backups, and health monitoring.
- Familiarity with Azure DevOps, Git, and source control systems.
- Experience in C#.NET development and working with KingswaySoft adaptor for Dynamics CRM is a plus.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work across system integration testing, UAT support, and production deployments.
At Delivery Centric, you’ll be part of a collaborative team that values innovation, quality, and growth. This role offers the opportunity to work on cutting-edge cloud and data technologies while making a real impact on enterprise data solutions. If you’re a passionate ETL professional eager to take on new challenges and deliver high-performing solutions, we’d love to hear from you.