Open to opportunities

Samatha Amsala

@samathaamsala

Message

Data Engineer specializing in scalable ETL/ELT, Snowflake, and AWS analytics platforms for financial services.

United States

Message

What I'm looking for

I’m looking for a role where I can build and optimize secure, cloud-native data platforms—owning ETL/ELT pipelines, real-time ingestion, dimensional modeling, and data quality—while partnering with stakeholders to turn complex requirements into scalable analytics and measurable impact.

I’m a Data Engineer with 5+ years of experience designing, developing, and optimizing enterprise data warehousing and analytics solutions for financial services and airline domains.

At American Express, I architect and deliver cloud-native, scalable data platforms supporting financial analytics, regulatory reporting, risk modeling, fraud detection, and customer intelligence—handling billions of transactions in a high-volume environment. I’ve built end-to-end Snowflake/AWS pipelines, implemented near real-time ingestion with Snowflake Streams, Tasks, and Snowpipe, and engineered SCD Type I & II strategies while also improving performance by 35% through tuning and profiling.

Earlier, as a Data Analyst at Delta Airlines, I transformed operational and passenger datasets into analytics models and KPI dashboards using SQL, Power BI, and Tableau, while using Python (Pandas/NumPy) for profiling and automated data validation. Before that at Accenture, I delivered Informatica PowerCenter ETL/ELT solutions with star/snowflake modeling, reusable mappings, and governance-ready data lineage—always focused on translating complex business needs into secure, high-performing, scalable outcomes.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

American Express

May 2024 - Present (1 year 11 months)

Architected cloud-native data pipelines and ELT frameworks in Snowflake and AWS to support near real-time financial analytics and regulatory reporting at enterprise scale. Migrated legacy Teradata workloads to Snowflake and reduced ETL execution time by 35%, implementing dimensional models with SCD Type I/II, automated data quality checks, and Jenkins/Git CI/CD with Control-M scheduling.

Snowflake AWS S3 AWS Glue Pyspark Jenkins CI

Data Analyst

Delta Air Lines

Jan 2023 - Apr 2024 (1 year 3 months)

Built SQL transformation logic and reusable reporting datasets to support airline operations, revenue management, customer experience, and predictive maintenance decision-making. Developed KPI dashboards in Power BI and Tableau, improved extraction/transformation performance from Teradata and SQL Server, and implemented data validation for accurate operational and regulatory reporting.

Window Functions Teradata SQL Server Power BI Tableau NumPy Data Validation Incremental Refresh Dashboarding ETL Enhancements (Informatica)

Data Analyst

Accenture

Jan 2016 - Mar 2018 (2 years 2 months)

Delivered end-to-end ETL pipelines in Informatica PowerCenter for financial services clients, integrating heterogeneous OLTP data into staging, ODS, and dimensional warehouse layers using Star and Snowflake schemas. Implemented SCD Type I/II, reusable mapplets and parameterized workflows, and data reconciliation/validation while producing dashboards and reports in Tableau/SSRS and supporting deplo

Informatica ETL ELT Development Data Validation Tableau