Chaitanya C•••

About

On the record

• Overall 12+ years of experience in ETL Architecture ETL Development Data Modelling Database Architecture with SSIS SQL Informatica AWS & Snowflake • Work with Domain experts Engineers and other Data Scientists to develop implement and improve upon existing systems • Participate in design meetings for creation of the Data Model and provide guidance on best data architecture practices • Operationalize data ingestion data transformation and data visualization for enterprise use • Managing & working with the offshore Team in designing & building Data warehouse part of various projects • Lead mentor and train junior team members and ensure coding standard is followed across the project. Help talent acquisition team in hiring quality engineers • Review the low-level technical design coding and testing deliverables from team. • Manage ETL team ensure deliverables ready for each cycle (Agile Application Development /Iterative approach) on time by providing technical and process related assistance to the team members • Design dimensional model data lake architecture on Snowflake and used Snowflake logical data warehouse for compute • Developed ETL pipelines in and out of data warehouse using Snowflakes SnowSQL Writing SQL queries and procedures against Snowflake • Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table. • Well versed with Snowflake features like Data Share time travel cloning copy and caching etc. • Experience with Extraction Transformation and Loading (ETL) between homogenous and heterogeneous sources using SSIS packages and DTS (Data Transformation Services) • Designed and developed a new ETL process to extract and load Vendors from Legacy System to MDM by using the SSIS and Informatica jobs • Experience in migrating data from legacy platforms into the cloud with AWS and Snowflake. • Experience in data modeling data warehouse and ETL design development using Star/Snowflake Model Designs with analysis - definition database design testing and implementation process. • Work with huge volumes of IQVIA data – Terabytes of data with billions of records loading these into snowflake cloud data lake performing various schema validation checks on the data