VINITH UMAR

Created pipelines in ADF using Linked Services/Datasets/Pipeline/to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse. Designed a regional solution model with complex queries which is supported across 13+ countries and can be used a central soluƟon model for various countries. Designed and developed complex queries for the transformation of IFRS4 model to IFRS17 model with the help of functional inputs provided by Actuarial and Charted Accountants. Responsible in designing 3 ETL components which transforms billions of records with functional transformations and calculations involved for IFRS17 solution. Designed and developed Audit Balance Control checks which helps in tracking the batch details, reconciliation of data and data quality checks to ensure high data accuracy which results in less data discrepancy. Extract Transform and Load data from Source Systems to Azure Data Storage services using combination of Azure Data Factory, T-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services- (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing data in Azure Databricks. Performed extensive debugging, data validation, error handling mechanism, transformation types and data clean up analysis within large datasets. Operated as part of development team for data migration project to building SSIS Packages, providing ongoing contributions to rapid development efforts. Analyzed problematic areas to provide recommendations and solutions. Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.

Worked as Data Engineer - ETL Developer in Tata Consultancy Services for 2.5 years. Responsible for extraction of the sales and inventory data from various source systems such as DB2, Oracle, POSTGRES, Mainframe files and ingesting into Teradata and Snowflake Data warehouse. The data from DWH is used to generate multiple business reports using MSTR and Tableau tools. Designed and developed the Workflows, Mappings, Sessions, Transformations and scheduled the workflows and Sessions using Informatica application and Mainframe. Hands on experience in identifying the issues such as duplicates, invalid data, missing data in reports and back tracking to the source systems. Fixing the recurring data issues by implementing necessary code changes to avoid the failure in work flows. Familiar with data warehousing architectures such as Star schema. Had hands on experience with Teradata Utilities like FastLoad, Mload, FAST Export, BTEQ scripts. Designed the workflow to identify Fraud transactions based upon the history transactions done by the customer. Processed to generate real time data with day to day basis and update the report with new customer transactions which saved million dollars of amount to skip fraud transactions. Automated and scheduled the workflows to generate the reports as per business requirement. Permanent fix is done for the workflows which fails due to data issues. Involved in migration of Teradata Datawarehouse to Snowflake Datawarehouse. Designed workflows in Informatica 10.2 to pull data from various databases and load in Snowflake Datawarehouse. Migrated all the workflows from Informatica 9.6(which loads Teradata) to Informatica 10.2(Snowflake).