Swathi e
Lead Snowflake
- Role
- Snowflake Architect at Amerihealth
- Location
- Fort Wayne, IN, US
- LinkedIn followers
- 500 followers
About Swathi e
Overall 14+ years of experience in ETL Architecture, ETL Development, Data Modelling…
Experience
Snowflake Architect
May 2023 — Present · Indianapolis, IN, US
Creating new tables and audit process to load the new input files from CRD. Created complex mappings in Talend 7.1 using tMap, tJoin, tReplicate, tParallelize, tFixedFlowInput, tAggregateRow, tFilterRow, tIterateToFlow, tFlowToIterate, tDie, tWarn, tLogCatcher, tHiveIput, tHiveOutputetc tMDMInput, tMDMOutput. Working on Snowflake modeling and highly proficient in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture. Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts and data load. Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations. Developed Talend Bigdata jobs to load heavy volume of data into S3 data lake and then into Snowflake data warehouse. Design dimensional model, data lake architecture, data vault 2.0 on Snowflake and used Snowflake logical data warehouse for compute. Well versed with Snowflake features like clustering, time travel, cloning, logical data warehouse, caching etc Developed Talend MDM jobs to populate the claims data to data warehouse - star schema, snowflake schema, Hybrid Schema. Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
Education
JNTUH College of Engineering Hyderabad
Bachelors, Electrical, Electronics and Communications Engineering
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.