Implemented Change Data Capture (CDC) in SQL Server to capture and propagate data changes seamlessly.Orchestrated the ingestion of data into S3 buckets partitioned on a daily basis for efficient data flow.Streamlined data integration processes across heterogeneous systems by implementing a data pipeline leveraging Snowflake, SQL Server, and Kafka.Designed and implemented external stages and tables on top of S3 to streamline data integration, ensuring seamless access and facilitating real-time data processing through the development of streams on external tables.Created stored procedures for loading data into SCD Type 2 tasks, ensuring data accuracy and integrity.