Data Engineer
Current1. Worked on Analysis, Design, Development of Data Migration projects using snowflake and Matillion ETL.2. Extensive experience in ETL methodology for performing data migration, Extraction, Transformation, and loading using Matillion ETL from wide variety of source system.3. Designed and maintained robust data pipelines to ensure seamless integration from diverse data sources.4. Utilized temporary and transient tables for optimized performance.5. Managed the seamless ingestion of data from Amazon S3 into Snowflake environment using the COPY INTO command from different stages.6. Enhanced system performance by creating dedicated virtual warehouses and utilizing scaling features.7. Developed complex SQL queries, joins, and aggregation functions using MySQL and PostgreSQL, and utilized 8. SQL windowing functions for advanced data analysis.9. Utilized Snowflake features such as time-travel, fail-safe, zero-copy cloning, and data sharing to enhance data availability and resilience.10. Mentored junior engineers on snowflake and conducted thorough code reviews to maintain high-quality standards across the team.11. Good Knowledge on Snowflake features such as snow pipes, streams, and tasks for continuous data loading and processing.