• Designed and implemented data-driven workflows with Azure Data Factory, orchestrating end-to-end integration, transformation, and loading processes, ensuring automation and reliability.• Built scalable data pipelines with efficient logging mechanisms, prioritizing data integrity and enabling effective troubleshooting capabilities.• Developed Data bricks notebooks for data reading, transformation, and writing to Data Lake, resulting in improved data reliability and performance.• Excellent problem-solving skills, adaptability, and the ability to work in cross-functional teams to deliver data engineering solutions in Azure.• Automate manual activities, like Incremental processing of the AAS Model and continuous deployment.• Experienced in integrating Azure Data Factory with other Azure services, such as Azure Data Lake Storage, Azure SQL Database, and Azure Data Bricks, to create comprehensive data solutions and support advanced analytics.

• Proficient in Azure Data Factory, the cloud-based data integration service from Microsoft Azure, for orchestrating and automating end-to-end data workflows.• Extensive experience in (ETL) process from source systems to Azure Data Storage services using a combination of Azure Data Factory, and T-SQL. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL) and processing the data in SQL procedures.• Capability to work with various data formats, including JSON, CSV, REST APIs, to facilitate seamless data integration within Azure Data Factory.• Experience in performance tuning, optimizing data processing workflows, and troubleshooting data-related issues in Azure.• Collaborative team player experienced in working with cross-functional teams to deliver data solutions that meet the needs of the organization.

• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Azure Data Lake storage, Azure SQL Data warehouse, write-back tool, and backward.• Skilled at using Azure Data Factory's scheduling and triggering capabilities to automate data processing, ensuring data availability at the right time and in the desired format.• Proficient in data pipeline monitoring and troubleshooting, utilizing Azure Data Factory's logging and monitoring capabilities to maintain data quality and performance.• Collaborative team player experienced in working with cross-functional teams to deliver data solutions that meet the needs of the organization

• Extensive experience in designing, developing, and deploying SSIS packages for data extraction, transformation, and loading (ETL) processes in SQL Server environments.• Familiarity with advanced T-SQL features, such as common table expressions (CTEs), window functions, and dynamic SQL, for solving complex data challenges.• Strong knowledge of indexing, query optimization, and query execution plans in SQL Server, with the ability to enhance query performance.• Experienced in data migration, data warehousing, and ETL processes, leveraging T-SQL for data extraction, transformation, and loading

• Crafting and maintaining robust database schemas, tables, and relationships to ensure organized and accessible data.• Creating and refining complex SQL queries and stored procedures to enhance data retrieval and performance.• Monitoring and optimizing database performance through indexing and query optimization strategies.• Designing and executing data migration processes and integrating data from diverse sources.