Samatha Amsala
@samathaamsala
Data Engineer specializing in scalable cloud ETL/ELT, dimensional modeling, and analytics.
United StatesWhat I'm looking for
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.
I build scalable ETL/ELT pipelines and dimensional models (Star & Snowflake schema), delivering high-performance reporting systems with Informatica PowerCenter, Snowflake, and AWS cloud technologies.
I integrate heterogeneous data sources (Teradata, Oracle, SQL Server, and flat files) into centralized data warehouses, and I implement Slowly Changing Dimensions (Type I & II), data quality frameworks, and performance tuning for ETL workflows and SQL queries.
In my recent work, I’ve engineered near real-time ingestion using Snowflake Streams/Tasks/Snowpipe and automated scheduling/monitoring with Control-M and CloudWatch. I also deliver CI/CD pipelines with Git/Bitbucket/Jenkins, support Agile (Scrum/JIRA), and help teams apply data governance, data lineage, and secure access patterns (AWS IAM roles, Snowflake RBAC, KMS).
Experience
Work history, roles, and key accomplishments
Architected cloud-native data pipelines on Snowflake, AWS S3, AWS Glue, and Python to process structured/semi-structured financial datasets, handling billions of records in an enterprise environment. Built near real-time ingestion with Snowflake Streams/Tasks/Snowpipe, implemented SCD Type I/II, and reduced ETL execution time by 35% through extensive performance tuning and optimized transformation
Data Analyst
Delta Airlines
Jan 2023 - Apr 2024 (1 year 3 months)
Delivered analytics for airline operations and predictive maintenance by transforming high-volume passenger and operational datasets into models and executive dashboards. Built automated KPI reporting in Power BI and Tableau and improved performance by optimizing data extraction/transformations from Teradata and SQL Server to reduce query runtime.
Built and maintained end-to-end Informatica PowerCenter ETL pipelines for financial services clients, integrating customer, policy, claims, and financial data into dimensional data warehouse layers. Implemented Star/Snowflake modeling with SCD Type I/II, tuned SQL/ETL performance to reduce report generation time, and delivered KPI reporting via Tableau and SSRS with governance-focused documentatio
Education
Degrees, certifications, and relevant coursework
Bellevue University
Master of Science in Information Systems, Information Systems
Completed a master’s in information systems at Bellevue University (graduated June 2024).
Jawaharlal Nehru Technological University (JNTU), Hyderabad
Master of Science in Computer Science, Computer Science
Completed a master’s in computer science at JNTU Hyderabad (graduated June 2012).
Availability
Location
United StatesAuthorized to work in
Job categories
Skills
Interested in hiring Samatha?
You can contact Samatha and 90k+ other talented remote workers on Himalayas.
Message SamathaFind your dream job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
