Bhavya D.

Senior Snowflake Developer @IDB Bank

NY, US

As a Snowflake Lead Developer & ETL Developer at IDB Bank, I have been actively involved in building scalable, high-performance data solutions with a focus on cloud technologies and data migration. With hands-on experience across multiple Hadoop distributions (CloudEra, HortonWorks, MapR) and cloud services like AWS and Azure, my role revolves around developing robust data architectures and ensuring smooth transitions to modern cloud platforms.Successfully leading the end-to-end migration of 800+ objects (4TB in size) from SQL Server to Snowflake, ensuring seamless data movement from SQL Server to Azure to Snowflake using copy options.Managing Snowflake administration tasks, including creating roles, access privileges, and overseeing data security and access controls.Retrofitting 500 Talend jobs to ensure full compatibility with Snowflake, enhancing ETL pipelines to optimize performance.Implementing data sharing between Snowflake environments (Prod to Dev) and redesigning views to improve query performance.Writing complex Snowflake SQL queries and leveraging Snowpipe for efficient data ingestion.Migrating 500+ Redshift tables and views to Snowflake, validating data integrity, and optimizing performance.Spearheading the creation of data warehouse models for over 100 datasets, using WhereScape and ensuring alignment with best practices for data modeling.Developing Looker reports using Snowflake connections, ensuring accurate, high-quality business insights and validating them against Redshift data.I am deeply invested in building data-driven cultures within organizations, optimizing performance, and driving long-term solutions for efficient data management and analytics.Technologies : Snowflake, Redshift, SQL Server, AWS, Azure, Talend, Jenkins, SQL, SnowSQL, Snowpipe, Looker, Unix, Python, Cloud Era, HortonWorks, MapR.