Insightful Senior Data Engineer known for high productivity and efficiency in task completion. Possess specialized skills in data modeling, ETL development, and cloud computing solutions. Excel in problem-solving, teamwork, and communication, ensuring successful project outcomes and effective collaboration with cross-functional teams.
Overview
7
7
years of professional experience
Work History
Senior Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
Remote
09.2022 - Current
Designed and streamlined databases in MySQL, including tables, views, indexes, and constraints for improved performance
Optimized MySQL object performance by conducting routine audits and refactoring inefficient stored procedures, leading to a reduction in database response times by an impressive 83% during peak usage hours.
Wrote and optimized SQL queries for data retrieval, improving database and application performance
Directed and designed ETL processes using AWS services like Glue and Lambda, ensuring efficient data transfer and transformation
Deployed and managed AWS RDS for database hosting and performance optimization
Performed MySQL version upgrade from 5.7 to MySQL 8
Led a team of three database engineers, mentoring, overseeing daily operations and task management
Configured and coordinated AWS services like EC2, RDS, Load Balancers, Route 53, and Certificate Manager to ensure high availability, reliability, and secure communication.
Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
Remote
04.2022 - 09.2022
Created and coordinated MySQL objects, including tables, views, and stored procedures
Developed SQL queries to derive insights, supporting data-driven decisions
Used Python and Pandas for data cleansing and prepared datasets for loading into databases
Enhanced database performance through query optimization techniques.
Product Implementation Engineer
Good Methods Global
Trivandrum
02.2018 - 07.2019
Developed over 100 SQL queries to validate data migration, ensuring data integrity post-migration in MS SQL Server
Analyzed and enhanced complex queries using CTEs, window functions, and execution plans
Worked closely with cross-functional teams to execute test cases and improve migration processes
Mentored new recruits on SQL querying and best practices for query optimization and data manipulation.
Education
Bachelor of Technology in Computer Science -
Marian Engineering College
Kerala
01.2017
Skills
Database Technologies: MySQL, MS SQL Server, DynamoDB, MongoDB
ETL and Data Processing: Query Optimization, Stored Procedures, Functions, Performance Tuning, Data Modelling