Professional Summary
Dedicated IT professional with 5+ years of experience in System design, development and delivery of enterprise software and Implementation of complex Client/Server and Intranet/web based n-tier architecture systems utilizing Object oriented and Internet technologies with strong domain knowledge. Around 6 years of ETL experience in Database programming for creating Data Warehouse with IBM Infosphere DataStage11.5/8.5. (Manager, Designer, Administrator, Director), Parallel Extender, Talend and Teradata 14.10/13.10/12/10, DB2 UDB. Experience in working with Talend open source, Talend Enterprise version and Talend cloud. Experience in working with Standard jobs, Batch jobs and streaming jobs using Talend for Bigdata and Talend for real time Big Data. Experience with SDLC including analysis, design, construction, testing, and implementation. Extracted data from multiple operational sources and implemented SCDs (Type 1/Type 2/ Type 3) using Talend. Extensively used Talend components like tfileinputdelimited, tparquetinput, tspakrow, tSetGlobalVar tMap, tReplicate, tJoin, tFileList, tSortRow, tBufferInput, tBuffer Output, tDenormalize, tNormalize, tParseRecordSet, tUniqueRow, t$3put, tS3get, tS3FileList, tRedshiftInput, tRedshiftOutput, tRedshiftRow,tsnowflakeinput, tsnowflakeoutput, tsnowflakerow tKafkalnput, tKafkaOutput, tAzurestorageput, tAzurestorageget, tAzureStorageConnection, tAzureStoragelist. Extensively worked on Error logging components like tLogCatcher, tStatCatcher, tAssertCatcher, tFlowMeter, tFlowMeter Catcher. Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc. Well knowledge and experience in Hadoop ecosystem (HDFS, YARN, Hive, SQOOP, HBASE,) Data pipeline, data analysis and processing with hive SQL. Experience in Importing and Exporting data using Sqoop from Relational database system to HDFS, Hive tables, and vise-versa Implemented various projects on Agile Development & Waterfall model and hybrid model. Enhanced the design of current systems to improve system capabilities to meet the changing needs of the business. Modified application systems and procedures to optimize functional requirements including capacity, operating time, response time, and form of desired results. Strictly followed Title II of HIPAA, known as the Administrative Simplification (AS) provisions, security and privacy of health data. Expertise in writing UNIX shell scripts and hands on experience with scheduling of shell scripts using ASG-ZENA. Excellent experience in Relational Database (RDBMS) and ODS, Oracle 11g,10g.9i, Microsoft SQL Server, Netezza, Teradata Load and MultiLoad, SQL, PL/SQL, TOAD. Created Business Requirement, functional, technical, and mapping design documents. Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.