One of the key starting points is to consolidate the information we have about each consumer into a central repository. Claims Highway imports, extracts, and transports consumer information from a variety of legacy source systems across the organization – characteristic of a “bonding agent” that keeps our virtual data intact and glued together – to ensure we can compile the entire history and relationship with each individual we serve. Data is updated daily through contributing sources and is accessible on a transactional basis.Roles & Responsibilities:● Implemented Azure Data Pipelines and Data flows for data ingestion and data processing.● Worked on migration of data from On-prem SQL Server to Cloud databases (Azure Synapse Analytics & Azure SQL DB).● Good experience working with Azure BLOB and Data Lake storage and loading data into Azure SQL Synapse analytics.● Implemented ETL Architecture and Data Modeling approaches for business intelligence.● Creating Linked Services, Datasets, Data management Gateway and Pipeline in Azure Data Factory● Managing data migration and transformation from one data source to another using Azure Data Factory.● Monitor the Pipeline Run &Troubleshoot the Pipeline● Monitoring of the Daily Data Load and resolving any issues related to it.● Implemented a dynamic pipeline to extract multiple files into multiple targets with the help of a single pipeline.● Developed batch processing solutions by using Data Factory and Azure Databricks.● Worked on Manage data recovery for Azure Data Factory Pipelines.● Involved in Business requirement document walk-through to understand functionality● Involved in planning and development of ETL pipelines using ADF.● Extract the Data from Azure Data Lake storage to Azure Data Factory

Amgen is a biotechnology company based in Thousand Oaks, California, USA to develop therapies that could restore Kidney function and improve the lives of people with kidney disease disorders. For this Amgen manufactures a drug called Aranesp/Prolia. Transactions captured by Specialty Pharmacies and other data providers will be sent to the Hub data management platform for cleansing and MDM process. Hub will then send the finalized transactions and dimensions to Amgen where they will be integrated into the Amgen MS Data Warehouse for end-user reportingRoles & Responsibilities:● Involved in Business requirement document walk-through to understand functionality● Involved in planning and development of ETL pipelines using ADF.● Extract the Data from Azure data lake storage using Azure Data Factory.● Prepare the transformations as per requirement by using activities and data flows.● Run the Rest APIs to get the transaction ID and merge that to each record.● Scheduling and monitoring pipelines.● Load the transformed data from ADF to the Azure SQL database.● Involved in daily status calls● Designed Azure ADF pipelines to move data from Blob Storage, and SQL server data to Azure SQL to load data.● Implement in Error Log, audit log Functionality.● Involved with Tracing Pipeline using Alerts and Monitor.● Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes.● Experience in working with Agile boards with DevOps, and CICD.