Overall 14+ years of experience in ETL Architecture, ETL Development, Data Modelling, Database Architecture with Talend Bigdata, Lyftron, Informatica, Apache Spark, AWS, NoSql, Mongo, Postgres, AWS Redshift Snowflake. Designed and developed a new ETL process to extract and load Vendors from Legacy System to MDM by using the Talend Jobs. Having experience in Snowflake cloud data warehousing shared technology environment for providing stable infrastructure, architecture, best practices, secured environment, reusable generic frameworks, robust design architecture, technology expertise, best practices and automated SCBD (Secured Database Connections, Code Review, Build Process, Deployment Process) utilities. Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM. 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. Extensively used Talend BigData components like tRedshiftinput, tRedshiftOutput, thdfsexist, tHiveCreateTable, tHiveRow, thdfsinput, thdfsoutput, tHiveload, tS3put, tS3get. Extensive experience in migrating data from legacy platforms into the cloud with Lyftron, Talend, AWS and Snowflake. Experience in data modeling, data warehouse, and ETL design development using RalphKimball model with Star/Snowflake Model Designs with analysis - definition, database design, testing, and implementation process. Data analysis, Database programming (Stored procedures; Triggers, Views), Table Partitioning, performance tuning Strong knowledge of Non-relational (NoSQL) databases viz. Document, Column, Key-Value and Graph databases Developed jobs in both Talend (Talend Platform for MDM with Big Data ) and Talend (Talend Data Fabric). Neo4j architecture, Cipher Query Language, Graph Data modelling, Indexing. Trained in all the Anti money laundering Actimize components of Analytics Intelligence Server (AIS) and Risk Case Management (RCM), ERCM and Plug-in Development. Very good experience in UNIX shells scripting. Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM. Strong Experience in Business Analysis, Data science and data analysis.
-
Snowflake ArchitectAmerihealthFort Wayne, In, Us
-
Snowflake ArchitectAmerihealth May 2023 - PresentIndianapolis, Indiana, United States 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. -
Senior Snowflake Developer/AdminstratorDiscount Tire Oct 2021 - Apr 2023Scottsdale, Arizona, United States Worked in industrial agile software development process i.e. Daily Stand-ups, pre-iteration meetings, Iteration planning, Backlog refinement, Demo calls, Retrospective calls. Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM. Worked on Snowflake Shared Technology Environment for providing stable infrastructure, secured environment, reusable generic frameworks, robust design architecture, technology expertise, best practices and automated SCBD (Secured Database Connections, Code Review, Build Process, Deployment Process) utilities Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations. Worked on Snowflake Schemas and Data Warehousing Developed Talend Bigdata jobs to load heavy volume of data into S3 data lake and then into Redshift data warehouse. Talend MDM Designed and developed the Business Rules and workflow system. Migrated the data from Redshift data warehouse to Snowflake. Expertise with MDM, Dimensional Modelling, Data Architecture, Data Lake & Data Governance. Build dimensional modelling, data vault architecture on Snowflake. Developed Talend jobs to populate the claims data to data warehouse - star schema, snowflake schema, Hybrid Schema -
Snowflake DeveloperMorgan Stanley Mar 2019 - Sep 2021Alpharetta, Georgia, United States Involved in End-to-End migration of 800+ Object with 4TB Size from Sql server to Snowflake. Data moved from Sql Server Azure snowflake internal stage Snowflake with copy options. Managed datasets using Panda data frames and MYSQL. Queried the database queries using Python-MySQL connector and retrieved information using MySQLdb Created roles and access level privileges and taken care of Snowflake Admin Activity end to end. Solution based architecture for ETL problems, unit testing strategies and development of ETL jobs for data warehouses. Registration and Extraction Oracle CDC tables using Power exchange navigator. Expertise in defects logging, tracking, and managing defect life cycle using JIRA and Service Now. Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema). Converted 230 views query is from Sql server snowflake compatibility. Retrofitted 500 Talend jobs from SQL Server to Snowflake.Worked on SnowSQL and Snowpipe -
Data Engineer/AnalystPennywise Solutions Private Limited Jul 2014 - Feb 2019Hyderabad, Telangana, India Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin 4.5. Responsible for design and build data mart as per the requirements. Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality. Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database. Created Data acquisition and Interface System Design Document. Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs. Deploy various reports on SQL Server 2005 Reporting Server Installing and Configuring SQL Server 2005 on Virtual Machines Migrated hundreds of Physical Machines to Virtual Machines Conduct System Testing and functionality after virtualization Extensively involved in new systems development with Oracle 6i. USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code. Used Import/Export Utilities of Oracle. -
Sql Data EngineerDhunis Technologies Pvt Ltd Nov 2010 - Jun 2014Andhra Pradesh, India Dataflow design for new feeds from Upstream. Data warehouse design and development. Using SQL Server profiler to diagnose the slow running queries. Tuning the slow running stored procedures using effective indexes and logic. Writing stored procedures in SQL server to implement the business logic. ETL development using Informatica powercenter designer. Scheduling the jobs using Control-M. Root cause analysis for any issues and Incidents in the application. Documenting guidelines for new table design and queries. Change Coordinator role for End-to-End delivery i.e. taking requirements from clients for any change, providing initial timelines, analysis of change and its impact, passing on the change to the respective module developer and following up for completion, tracking the change in system, testing the change in UAT, deploying the change in prod env, post deployment checks and support for the deployed changes.
Swathi E Education Details
-
Electrical, Electronics And Communications Engineering
Frequently Asked Questions about Swathi E
What company does Swathi E work for?
Swathi E works for Amerihealth
What is Swathi E's role at the current company?
Swathi E's current role is Snowflake Architect.
What schools did Swathi E attend?
Swathi E attended Jntuh College Of Engineering Hyderabad.
Not the Swathi E you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial