Anthony K. Email & Phone Number

• Experience in migrating existing legacy applications into Optimized data pipelines utilizing Spark w and Python with testability and perceptibility.
• Developed Optimized and tuned ETL operations in Azure Data Factory.
• Developed ETL solutions using SSIS, Azure Data Factory and Azure Data Bricks.
• Worked on Talend integrations to ingest data from various sources into Data Lake.
• Worked on migration On Prem Databases on to Azure Cloud with appropriate business transformations.
• Extensive hands-on experience on Azure GIT Repos

United Kingdom

• Coordinating with functional team and business analysts and stack holders to discuss on application flows.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Designed Data Modeling, System/Data Analysis, Design and Development for Data warehousing environment.
• Architect and implement ETL and data movement solutions using Azure Data Factory, Azure Data Bricks.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities and Mapping Data flows.

• Built Data flows and processes using Informatica cloud / IICS and Azure Data Factory
• Designed and developed the Azure Data bricks (Spark SQL), Microsoft Azure Data Lake analytics, Azure Data Factory, Azure SQL DW, Azure Dev Ops, Microsoft SQL Server, Business Intelligence SSIS (ETL)
• Designing the new solution for streaming and batch processing of data into multiple analytical data component in Azure cloud as well as on-premises
• Experience with developing mappings using various transformation logics like Lookup, Multicast, Conditional Split, Merge, Derived column.
• Used Informatica Data Quality (IDQ) for Parsing, cleansing, Address doctor validation and involved in data profiling activities
• Good Experience in Address doctor, Geospatial data validations.

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, work let designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.