Hemanth Kumar .G Email & Phone Number

Coimbatore, Tn, In

Chennai, Tamil Nadu, India

Designing and implementing efficient data models to support the project's data needs.Building and maintaining ETL pipelines, and loading it into the Snowflake data warehouse.Writing and optimizing SQL queries to ensure they are performant and meet the requiredbusiness logicImplementing security measures to ensure data privacy and access controls to restrict dataaccess based on user roles and permissions.Monitoring the performance of Snowflake databases, identifying bottlenecks, and finetuning configurations to optimize query performance and overall system efficiency.Integrating Snowflake with other data systems and tools to facilitate seamless data flowacross the organization.Implementing backup and recovery strategies to safeguard data against potential loss orcorruption.Ensuring data quality and compliance with data governance policies and regulationsWorking closely with data engineers, data analysts, and business stakeholders tounderstand requirementsPerformance tuned Postgres SQl queries based on ETL ScheduleDeveloped an automated DB backup system which was implemented in all environments .Monitored Daily and Weekend Jobs on Airflow and Databricks.Visualized the end data in Tableau Documented Db related best practices document ·Supported team with daily issues related to Database

Chennai, Tamil Nadu, India

Developed PL SQl queries based on BA Requirements.Supported for Full Unit Testing, User Acceptance Testing(UAT), System Testing and System Integration TestingPerformance Tuning of SQL QueriesDesign and Implementation of database migration and integrationMaintaining Code Version Using BitBucketHandled Pharmaceutical Product and Financial Product DataAnalyzing and Building Data ModelsMonitoring Airflow Job logs and Fixing the Defects in AWS.Scheduling and monitoring Jobs in Control MSupported for full Software Development Life Cycle in Business Process - Agile Development Methodology

Chennai, Tamil Nadu

Developed application "Railway Reservation system" using Java, JDBC, MySQL

Coimbatore Area, India

Embedded Projects, Research and Development

Coimbatore Area, India

Handled Clients and gathered Requirements for the Product.Airtel Communication Database using MySQLDigital Advertisement Bill board using Arduino Microcontroller.Workshop conducted on Cyber Security and IoT – SNS College of Technology.Workshop conducted on IoT Data Security and Data Security – Dr. Mahalingam College ofEngineering and Technology.