Mohana Sai Krishnaveni Mamidi

Data Engineer

Wipro

Bangalore

10.2018 - Current

Optimized existing queries to improve query performance by creating indexes on tables.
Developed and implemented data models, database designs, data access and table maintenance codes.
Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
Created stored procedures for automating periodic tasks in SQL Server.
Configured SSIS packages for scheduled data loads from source systems to target tables.
Developed Python scripts for extracting data from web services API's and loading into databases.
Integrated multiple sources of structured and unstructured datasets into a single platform.
Configured and maintained cloud-based data infrastructure on platforms like AWS, Azure, and Google Cloud to enhance data storage and computation capabilities.
Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
Provided technical mentorship to junior data engineers, guiding them on best practices and project execution.
Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
Managed version control and deployment of data applications using Git, Docker.
Conducted rigorous testing and validation of data pipelines to ensure accuracy and completeness of data.
Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.