Summary
Overview
Work History
Education
Skills
Certification
Core Technical Skills
Timeline
Generic

SAMANTH TUMATI

Dallas,TX

Summary

Results-oriented Senior Data Engineer with extensive 10 years of experience in enterprise data platform design and support across multiple domains. Expertise in Azure Databricks, Apache Airflow, and AWS, with a track record of successful data migrations and performance tuning. Strong analytical background in machine learning and big data analytics, enhancing task efficiency and productivity. Skilled in SQL database management and data visualization, fostering collaboration and adaptability in diverse environments.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior ETL / Data Engineer

Sumitomo Mitsui Banking Corporation
10.2023 - Current
  • Integrated Azure Databricks with batch ETL workflows, enabling near real-time analytics capabilities.
  • Optimized high-volume banking data pipelines using parallelism, partitioning, and pushdown logic.
  • Reduced end-to-end ETL runtime by refactoring legacy jobs and tuning SQL transformations.
  • Designed and enhanced enterprise data warehouse solutions with IBM DataStage and Snowflake, improving data accessibility and reporting.
  • Developed metadata-driven, reusable ETL frameworks to ensure consistent and maintainable development practices.
  • Implemented data validation, reconciliation, and audit controls to meet regulatory requirements.
  • Collaborated with business, data governance, and architecture teams to align data solutions.
  • Supported production releases, monitoring, incident resolution, and root-cause analysis.

ETL / Cloud Data Engineer

Freedom Mortgage Corporation
08.2022 - 09.2023
  • Migrated legacy on-prem DataStage pipelines to SnapLogic and cloud-native architectures, enabling improved scalability and performance.
  • Implemented ADF pipelines for orchestrating cloud data movement and transformations.
  • Developed PySpark jobs on Databricks and Amazon EMR for large-scale mortgage data processing.
  • Designed secure ingestion pipelines using AWS S3, Snowflake external tables, and encryption standards.
  • Automated job scheduling and dependencies using Control-M, Airflow, and UNIX shell scripts, streamlining data processes and reducing manual intervention.
  • Worked with business stakeholders to design scalable data marts and reporting layers.
  • Integrated ServiceNow change management and Git-based version control for deployments, enhancing collaboration and deployment reliability.

Senior ETL Data Engineer

USAA
05.2020 - 07.2022
  • Delivered enterprise-grade ETL solutions using IBM DataStage, Snowflake, and Oracle.
  • Collaborated with governance, modeling, and Agile teams to implement compliant data solutions, ensuring adherence to regulatory standards.
  • Created Python and PySpark utilities for schema creation and metadata management, enhancing data accessibility and usability.
  • Built reusable data quality frameworks using QualityStage and automated validation rules.
  • Created detailed source-to-target mappings, lineage, and audit documentation.
  • Contributed to SAFe Agile PI planning, sprint execution, and release management, fostering alignment across teams and timely project delivery.

Senior ETL / DataStage Developer

The Vanguard Group
12.2018 - 04.2020
  • Designed scalable ETL pipelines sourcing data from Oracle, DB2, Netezza, and flat files.
  • Standardized transformations by implementing shared containers and reusable routines.
  • Enhanced batch reliability and performance through tuning and parallel execution.
  • Streamlined workflows and monitoring with automation using Control-M and UNIX shell scripting.
  • Led DataStage platform upgrades and migration from version 11.5 to 11.7.

Senior DataStage Developer

State Street Bank
06.2017 - 11.2018
  • Developed complex DataStage sequences, enhancing workflow efficiency through effective dependency handling and timely notifications.
  • Optimized ETL performance using partitioning and load-balancing strategies.
  • Designed enterprise data marts using dimensional modeling techniques.
  • Authored technical design and ETL mapping documentation to ensure clarity and support seamless implementation across projects.

DataStage Developer

Zions Bank
04.2016 - 05.2017
  • Developed ETL jobs for fact and dimension tables, ensuring accurate historical data tracking with SCD Type 2 logic.
  • Implemented data profiling and quality checks with QualityStage, enhancing data integrity and reliability.
  • Automated batch scheduling with Autosys and shell scripting, streamlining data processing workflows.

Education

Master of Science - Information Technology

Murray State University
KY

Bachelor of Technology - Electronics & Communication Engineering

JNTU
India

Skills

  • ETL and orchestration: IBM DataStage
  • SnapLogic
  • Azure Data Factory
  • Apache Airflow
  • Big data analytics: Azure Databricks
  • PySpark
  • Spark SQL
  • Cloud platforms: Azure
  • AWS (S3, EMR, IAM)
  • IBM Cloud Pak for Data
  • Databases and warehousing: Snowflake
  • Oracle
  • DB2
  • Teradata
  • Netezza
  • SQL Server
  • data modeling: Star schema
  • SCD type 1 and 2
  • Programming languages: SQL
  • PL/SQL
  • Python
  • UNIX Shell
  • Scheduling and monitoring: Control-M
  • Autosys
  • Airflow
  • BI and reporting: Cognos
  • Tableau
  • MicroStrategy
  • DevOps and collaboration: Git
  • Bitbucket
  • ServiceNow
  • Confluence

Certification

  • SnowPro Core Certification
  • AWS Certified Developer – Associate

Core Technical Skills

IBM DataStage, SnapLogic, Azure Data Factory (ADF), Apache Airflow, Azure Databricks, PySpark, Spark SQL, Azure, AWS (S3, EMR, IAM), IBM Cloud Pak for Data, Snowflake, Oracle, DB2, Teradata, Netezza, SQL Server, Star Schema, Snowflake Schema, SCD Type 1 & 2, SQL, PL/SQL, Python, UNIX Shell, Control-M, Autosys, Airflow, Cognos, Tableau, MicroStrategy, Git, Bitbucket, ServiceNow, Confluence

Timeline

Senior ETL / Data Engineer

Sumitomo Mitsui Banking Corporation
10.2023 - Current

ETL / Cloud Data Engineer

Freedom Mortgage Corporation
08.2022 - 09.2023

Senior ETL Data Engineer

USAA
05.2020 - 07.2022

Senior ETL / DataStage Developer

The Vanguard Group
12.2018 - 04.2020

Senior DataStage Developer

State Street Bank
06.2017 - 11.2018

DataStage Developer

Zions Bank
04.2016 - 05.2017

Master of Science - Information Technology

Murray State University

Bachelor of Technology - Electronics & Communication Engineering

JNTU
SAMANTH TUMATI