Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Timeline
Generic

Mamatha Velturi

Georgetown,TX

Summary

Experienced ETL Developer and Data Engineer with over 10 years of proven experience in designing, optimizing, and maintaining high-performance data pipelines. Skilled in various ETL tools like SSIS, Azure Data Factory, AWS Glue, Informatica, and Talend, as well as cloud platforms including Azure, AWS, and Snowflake. Expertise extends to data migration, modeling, and governance, resulting in improved data accessibility and enhanced business insights. Possesses strong skills in SQL, Python, and T-SQL, with a deep understanding of CDC, Agile development methodologies, and performance tuning. Known for exceptional problem-solving abilities and a history of effective collaboration with cross-functional teams.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr. Data Engineer/ETL Developer

Ventechsoft INC
10.2024 - Current
  • Led cloud migration project transferring critical data from on-premises SQL databases to Cloud.
  • Ensured compliance with HIPAA regulations through innovative solutions.
  • Implemented indexing, partitioning, and parallelization for faster data processing.
  • Collaborated with IT department to formulate data security measures.

Sr. Data Engineer/ETL Developer

Merck
01.2021 - 11.2023
  • Implemented strategies that led to a 50% decrease in manual data handling.
  • Managed Databricks cluster configuration and deployment process.
  • Engineered an automated setup using PowerShell and Azure Cloud Shell.
  • Designed and implemented ETL pipelines utilizing Azure Data Factory.
  • Developed data models that streamlined data processing pipelines in Azure environment, resulting in an increase of 30% in productivity
  • Created tailored data integration workflows using IDMC and Azure Data Factory to enhance MDM processes.
  • Enhanced MDM scalability using Azure Databricks for efficient data processing.
  • Implemented effective solutions for data storage and retrieval with Azure Blob Storage.
  • Validated ETL processes in Informatica IDMC during UAT.
  • Directed data migration projects utilizing Informatica IDMC to transfer on-premises data to cloud-based platforms.
  • Developed Python scripts to automate data validation checks.
  • Enhanced ETL processes in Informatica IDMC to accelerate data processing.
  • Automated MDM processes utilizing Azure Logic Apps and Power Automate, boosting efficiency.
  • Utilized SQL/Excel to validate raw data against Power BI Dashboards.
  • Reported discovered trends, analysis results, and forecast data to senior management.

Sr. ETL Developer

Teema Solutions Group
06.2019 - 10.2019


  • Enhanced stored procedures to boost ETL process efficiency by 35%.
  • Developed and evaluated Azure monitoring dashboards and reports to reduce customer issues by 20%.
  • Developed data transfer pipelines between Azure services and on-premises systems, enhancing network throughput by 95%.
  • Implemented end-to-end data management systems using Azure technologies.
  • Optimize data storage and retrieval processes within Azure SQL Data Warehouse.
  • Enhanced accuracy in migration process by 75% through automation.
  • Created cloud migration system enhancing speed of tasks
  • Achieved a 25% reduction in Azure costs.
  • Possess strong understanding of data warehousing concepts.
  • Demonstrated expertise in Azure services such as ADB and ADF.


Data Engineer/ ETL Developer

Quasar Business Solutions Inc
01.2016 - 03.2019
  • Analyzed business requirements to transform and document attribute mappings.
  • Authored T-SQL queries including DDL and DML.
  • Utilized Informatica IICS and PowerCenter to create intricate ETL workflows for diverse environments.
  • Led data migration projects using Informatica and Azure.
  • Developed data security protocols to reduce incidents by 20%.
  • Performed routine performance optimization and data profiling to ensure database efficiency.
  • Built robust data solutions by incorporating Azure Blob Storage, VMs, SQL Database, and AAD in Databricks.
  • Enhanced data storage and retrieval with Azure solutions.
  • Created big data solutions with Azure HDInsight.
  • Maintained adherence to HIPAA regulations through systematic reviews.
  • Optimized ETL processes using Informatica PowerCenter for efficient data handling.
  • Designed detailed ETL Visio flows for streamlined processes.
  • Developed effective ETL architecture.

ETL Developer

AXA Canada Inc
09.2013 - 10.2015


  • Migrated data from SQL Server 2008 to SQL Server 2012.
  • Followed AGILE Development methodology for execution.
  • Installed SQL Server 2005, 2008, 2008R2, 2012, and 2014 on virtual machines.
  • Created and updated clustered and non-clustered indexes to maintain SQL Server performance.
  • Specialized in creating SSIS Packages,experienced in enhancing performing and optimizing queries.
  • Developed ad hoc reports tailored to specific business needs.
  • Skilled in executing database backup processes.
  • Demonstrated strong interpersonal skills.
  • Developed data flow diagrams for current and upcoming ETL processes.
  • Managed data extraction, transformation, and loading into data warehouse.
  • Created user-defined functions for custom operations.


SQL Server Developer

Nico Info Systems India
07.2011 - 08.2013


  • Designed data profiling, validation jobs in SSIS, and created ETL jobs using SSIS.
  • Provided detailed explanations to support Data Transformation process for ETL teams.
  • Designed and created Tables, Views, and Indexes.
  • Created warmup programs to initialize recently logged-in user profiles in MSSQLDB.
  • Analyzed and interpreted Excel data for database integration.
  • Created complex SQL queries for data reporting.
  • Conducted thorough database analysis to apply correct data filters, randomizations, and stratifications based on business requirements.
  • Facilitated data warehouse loading via various transformation techniques.
  • Designed custom SSRS reports tailored to user needs.
  • Implemented integration with multiple destinations including OLE DB Destination, Flat file, and Excel.
  • Developed workflows using Data Flow and Containers.
  • Implemented advanced transformations including Aggregate, Row Count, and Sort.
  • Executed comprehensive data extraction, transformation, and loading using SQL Server 2008 Integration Services.


Education

Master of Science - Engineering

JNTU
Hyderabad
10-2011

Bachelor of Science - Engineering

JNTU
Hyderabad
04-2009

Skills

  • ETL tools: SSIS, ADF, AWS Glue, SSIS, Informatica Power Center, Talend
  • Database Technologies: MS SQL Server, Snowflake
  • Program languages: SQL, PYTHON, T-SQL
  • Cloud Technologies: Databricks (AZURE/AWS), Spark, Delta Lake, Data Lake Architecture S3, EC2, RDS, IAM, Lambda, Glue, Athena
  • Data warehousing: Kimball Dimensional Modeling, Star/Snowflake Schema, Data Mesh Architecture
  • Data integration
  • Reporting tools: Power BI, Tableau, SSRS
  • IDE s: SQL Server Data Tools (SSDT), SSMS, Visual Studio, Azure Data Studio
  • Data Security & Compliance: Data Masking, HIPAA Compliance, GDPR, AWS IAM, RBAC,

Accomplishments

New Canadian Centre Canada - 2015

(Non-Profit Organization Volunteer)

National Conference on Industry Interactions - 2010

(Certification of coordination)

A National Level Technical Symposium - 2007

Certification

Microsoft Certified Azure Data Fundamentals

2024

Timeline

Sr. Data Engineer/ETL Developer

Ventechsoft INC
10.2024 - Current

Sr. Data Engineer/ETL Developer

Merck
01.2021 - 11.2023

Sr. ETL Developer

Teema Solutions Group
06.2019 - 10.2019

Data Engineer/ ETL Developer

Quasar Business Solutions Inc
01.2016 - 03.2019

ETL Developer

AXA Canada Inc
09.2013 - 10.2015

SQL Server Developer

Nico Info Systems India
07.2011 - 08.2013

Master of Science - Engineering

JNTU

Bachelor of Science - Engineering

JNTU

Similar Profiles

CREATE PROFILE
Mamatha Velturi