Qualifications and Skills

• In-depth knowledge of SQL Server, demonstrating proficiency in database management and query optimization.
• Proven experience with Microsoft SSIS for integrating and managing data across different sources and destinations.
• Solid understanding of ETL processes to effectively extract, transform, and load data from diverse systems.
• Advanced skills in T-SQL programming for developing complex queries and data manipulation routines.
• Experience in data warehousing and data modeling for efficient storage and retrieval of large datasets.
• Expertise in data transformation techniques necessary for cleaning and converting data for analysis and reporting.
• Proficiency with Azure Data Factory in orchestrating data movement and transformation in cloud environments.
• Ability to perform performance tuning to optimize ETL processes and database operations for speed and efficiency.

Roles and Responsibilities

• Design and implement ETL solutions using Microsoft SSIS to meet business data integration requirements.
• Collaborate with stakeholders to understand data needs and translate them into technical specifications.
• Develop and maintain data warehousing strategies to support business intelligence and analytics.
• Optimize ETL pipelines and database operations to enhance performance and efficiency.
• Ensure data accuracy and quality through rigorous testing and validation processes.
• Utilize T-SQL for complex database queries and data manipulation to support application needs.
• Employ Azure Data Factory for cloud-based data orchestration and seamless integration with existing systems.
• Lead initiatives to improve data processing methods and advocate for best practices in ETL development.