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• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like SQL Server, Blob storage, Azure SQL Data warehouse.• Extensively worked on Copy, Foreach, get meta data, look up activities, Data flows, Azure Functions and notebooks.• Implemented the Change Data capture and email notifications using Azure Logic Apps.• Performed unit testing for all the ADF pipelines and published the pipelines to master branch by raising pull request.• Automated the deployments using Azure Pipelines and automated the test plan execution using Azure Test Plans.• Developed the Dashboards and analytical reports using Power BI.• Extensively worked on Self hosted integration run time issues, Data Quality Issues and Key Vault issues• Handled all kind of data formats including Parquet, Avro, Json and Delimited files.• Practiced Azure Boards for Project management and deliverables.• Experience in Developing Spark applications using Spark - SQL in Azure Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.• Responsible for estimating the cluster size, monitoring, and troubleshooting of the Hadoop cluster.

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.• Develop Spark applications using pyspark and spark SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data uncover insight into the customer usage patterns.• Improved application performance using Azure Search and SQL query optimization.• Examine and identify database structural necessities by evaluating operations and applications.• Migrate data from SQL Server database systems to Azure databases.

• 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.• Involved in CI / CD, Admin, DevOps, GIT HUB tasks• Experience in Data modelling and Data migration activities• Produced and enhanced reports & dashboards using Power BI• produced effective data visualization across reports and dashboards• Used DAX queries for calculations in Power BI.• Have good DAX, Data modeling and Power Query Editor capability• Worked on development initiatives through the SDLC from conception, to design, development, QA, deployment, and support phases• Coordinated with different Client teams to support new and existing implementation activities• Worked with technical leads and developers to ensure development is in line with architecture• Identified process improvements, initiate, and implement improvement plans• Worked on development initiatives through the SDLC from conception, to design, development, QA, deployment, and support phases.• Coordinating with different Client teams to support new and existing implementation activities.• Working with technical leads and developers to ensure development is in line with the architecture.• Experience in implementation of SSIS packages

• 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.• Created various tasks like Session, Command, Timer and Event wait.• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.• Prepared SQL Queries to validate the data in both source and target databases.• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.• Created Test cases for the mappings developed and then created integration Testing Document.• Prepared the error handling document to maintain the error handling process.• Automated the Informatica jobs using UNIX shell scripting.• Closely worked with the reporting team to ensure that correct data is presented in the reports.• Interaction with the offshore team daily on the development activities.

• 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. • Designed and developed ETL mappings for all the layers of the project such as Operational,• Staging, Data warehouse area according to the business rules.• Responsible for gathering and analyzing requirements and creating design documents, mapping sheets, and requirement flow diagrams based on requirements.• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse. • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer. • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer. • Developed several reusable transformations and mapplets that were used in other mappings. • Create HLD, DLD, and other technical documents as applicable.• Identifying process improvements, initiating and implementing improvement plans. • Used Tera data as a source system• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Master Data Management(MDM), D