•Gathered business and technical requirements, wrote BRD and prepared FSD (functionalspecification document).•Consolidated business and technical requirements from clients for maintenance tasks.•Prepared technical design documents (both hld and lld) for each enhancement andmaintenance releases.•Involved as primary offshore ETL developer during the analysis, planning, design, development, and implementation stages of various projects using Talend Data Integration tool - 5.6/6.0.1/7.1.1, quality stage,Data Cleansing, Data Verification and identifying Data Mismatch.•Utilized Talend Enterprise Edition version 7.1 for development of re-engineering existing ETL SAS jobs to expedite the cycle time using Vertica database.•Talend migration from enterprise edition to open studio.•Optimized Talend Components and SQL queries for better performance and performed code review.•Developed stored procedures, functions, triggers, indexes and views.•Prepared test cases, performed unit testing, User Acceptance Testing (UAT) and data validation.•Involved in code migration, deployment and scheduling of jobs to different environments (DEV,QA,UAT & PROD),fixing defects/bugs from UAT & PROD environments.•Regular Interactions with Onsite team & coordinated with reporting teams.•Skills and Tools : Talend Data Integration 6.0.1/7.0.1, Vertica, MS SQL Server, Filezilla, Unix, Putty,WinScp, Windows Scheduler.Servicenow,Python,JSON,TAC Scheduler.

•Providing design,coding and testing of ETL solutions to optimize data feeds from multiple vendors to build Datawarehouse and DataMart.•Responsible for Developing complex ETL design and coding for Facts and Dimension modeling while transforming,cleansing and applying busines logic to the data and full-load and delta-load logic to ETL jobs.•Developed ETL jobs to implement bulk upload,Error Handling,Incremental, maintaining SCD2 while data loading and improving performance of ETL loads using Talend tool.•Actively participated in data profiling of source,target database and design of database objects-Tables,Views,Stage tables and appropriate column widths to ensure no data rejection during ETL loading.•Responsible for writing various Vertica queries as part of analysis and code design.•Involved in production code maintaining post go-live,analysis on various defects,best practices during ETL loads,deployment and Scheduling of ETL jobs to different environments (DEV,QA,UATand PROD).•Skills and Tools : Talend Data Integration 6.0.1, MS SQL Server, Filezilla, Unix, Putty,WinScp,Windows Scheduler.Python,R,Jeera,Tibco Spotfire