We are seeking a Senior Database Developer with expertise in SQL Server development, ETL processes, and database optimization. The ideal candidate will have strong experience in data modeling and automated deployment processes
Key Responsibilities
Design and develop SQL Server components including stored procedures, functions, views, and triggers to support ETL processes and overall database functionality
Create and maintain comprehensive data models and database designs, with a focus on performance optimization and efficiency
Implement automated database deployments using Azure CI/CD pipelines and DACPAC
Develop and maintain SSIS packages for ETL processes, ensuring optimal performance and reliability
Create automated validation scripts for data quality assurance in target facts and dimensions
Implement comprehensive audit tracking systems to monitor all phases of the ETL process
Develop and maintain detailed documentation of ETL processes, including process flow diagrams
Collaborate with business users, team members, and other developers to resolve data integration issues and improve system functionality
Requirements
Extensive experience in database development and optimization
Proficiency in SQL Server and related technologies
Strong understanding of ETL processes and best practices
Experience with Azure CI/CD pipelines
Any Graduate