Vishnuvardhan N.J

DIgital Technology Analyst

NTT Data•  August 2021 - Present

Transforming SSIS package scripts into SnowSQL scripts for seamless migration to Snowflake platform and developing efficient stored procedures in Snowflake based on existing SQL Server stored procedures. - Implementing Change Data Capture (CDC) framework for over 60 data integration packages in Matillion, enabling efficient data transformation from source to target while capturing changed data. - Conducting thorough comparisons between SQL Server and Snowflake databases to ensure data accuracy and consistency. - Utilizing Matillion's Github deployments and component handling, ensuring seamless code versioning and management for data integration workflows. - Conducting Metadata validation and DDL (Data Definition Language) validation for both SQL Server and Snowflake, ensuring the integrity and quality of the data warehouse structures. - Leveraging Python for data extraction, showcasing proficiency in Python concepts to efficiently retrieve and process data for integration tasks. - Utilizing Snowflake's time travel and cloning features for data recovery and creating copies of databases for testing and analysis purposes. - Conducting data transformations, data cleansing, data enrichment, and data aggregation using Matillion components to ensure high data quality and accuracy. - Demonstrating proficiency in error handling, debugging, and troubleshooting data integration issues in Matillion workflows, ensuring smooth and reliable data processing. - Successfully connecting Matillion to various data sources and target systems, ensuring seamless data flow and integration.