Vamsi Gulla

About Vamsi Gulla

Having 8+ Years of experience with Talend Real-time Big Data Platform 7.3.1, Talend Enterprise Data Integration 6.2/6.5/7.1, Snowflake and Pervasive Data Integrator 9.2, Informatica as an ETL Developer in the implementation of the projects. • Hands on Experience to use scheduling tools like Talend Administration Center (TAC) & Talend Management console (TMC), Control-M, Autosys, Amazonredshift and Code migration. • Developing Talend Jobs based on the Mapping Specification Provided. • Solid experience and understanding of implementing large scale Data warehousing Programs and E2E Data Integration Solutions on Snowflake Cloud, AWS S3, AWS Athena, Salesforce and Talend ESB integrated with multiple Relational databases (MySQL,Oracle,DB2). • Worked on Dimensional Data modeling in star and Snowflake schemas and Slowly Changing Dimensions(SCD). • Extensively worked on Talend Designer Components – HDFS files, Flat files, Excel, XML, Positional flat files and tMap, tJoin, tHashInput and tHashoutput etc. • Extensively worked on Talend S3 Components –tS3Connection, tS3List, tS3Get, tS3Put, tS3copy, tS3Close etc. • Extensively worked on Talend Rest Components –tRestClient, tRest, tRestRequest, tRestResponse etc. • Extensively used tRest components in both FTP and SFTP mode to load data from staging files. • Extensively used CRM tool Snowflake components tSnowflakeConnection, tSnowflakeInput, tSnowflakeOutput, tSnowflakeOutputBulk, tSnowflakeBulkExec. • Owning the Ownership of the Jobs Developed and resolving the defects on the fly if any, once when moved to different environments. • Created reusable frame works by writing java code and integrated them in multiple projects. • Hands on Experience to write java code and create the Routines (User defined functions) using java. • Wrote Java code to capture global variables and use them in the job. • Having Problem-solving skills, ability to do hot fixes and Data Cleansing and Standardizations of Data. • Gained knowledge on Data warehouse concepts like Data warehouse Architecture, Star schema, Snowflake schema, and Dimension and Fact tables. • Proficient in interacting with Business Analysts, Users and Business executives to understand the requirements and come up with innovative and efficient solutions by working with the data modelers and Architects. • Good Experience in both Waterfall & Agile Methodology.

Experience

1. Talend Etl Lead

   eBay

   Sep 2021 — Present

   Responsibilities: • Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the copy command. • Loading data into snowflake tables from the internal stage using snowsql. • Used Copy, List, Put and Get commands for validating the internal stage files. • Used Import and Export from the internal stage (snowflake) from the external stage (AWS S3). • Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting. • Used Flatten table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column. • Used SNOW PIPE for continuous data ingestion from the S3 bucket. • Developed snowflake procedures for executing branching and looping. • Created clone objects to maintain zero-copy cloning. • Wrote and integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines. • Understand the mapping specification document and developed the Talend esb jobs. • Used various Talend components for implementing business logic. • Created Metadata tables and load job specific information. • Created various jobs in Talend for implementing business logic. • Designed and Implemented the ETL process using Talend Enterprise Big Data Edition to load the data from Source to Target Database. • Worked on Migration project from Web methods to Talend Using RestApi Components. • Worked with different sources such as tRestClient, tRest and tRestResponse. • Worked with Azure components tAzureStorageConnection, tAzureStoragePut, tAzureStorageGet. • Extensively used CRM tool Snowflake components tSnowflakeConnection, tSnowflakeInput, t SnowflakeOutput, tSnowflakeOutput Bulk, tSnowflakeBulkExec. • Extensively used tRest components in both FTP and SFTP mode to load data from staging files. • Used tDBOutput and tSnowflakeOutput component to load data from Webmethods. • Using Debugger to find the bottlenecks in the Jobs. • Prepare unit test cases for the developed etls.

Education

• Sana engineering college

  Bachelor of Engineering - BE, Computer Science

• Sri Prathibha junior college

  Intermediate, Mpc

  2006 — 2008

• Vikas High School

  10th Grade