Veeragandham, Chanikya

www.linkedin.com/in/chanikya-veeragandham

Email:ac896z@r.postjobfree.com

Phone: +91-830*******

CAREER OBJECTIVE:

To pursue a highly rewarding career, seeking for a position in challenging and healthy work environment where I can utilize my skills and knowledge efficiently for organizational and personal growth.

PROFESSIONAL SUMMARY:

Having 3+ years of total experience in IT as Talend ETL Developer.

Expertise in using Talend Data Integration tool for Extracting, Transforming and Loading Data.

Designing ETL framework, data flow and processes, analysing data mapping requirements, identifying functional specifications, developing mappings and writing process documentation for clients.

Advance Knowledge, excellent concepts and experienced in querying and analysis, Extraction Transformation Loading (ETL) Talend and Data Warehousing.

Expert level Experience in Talend DI.

Widespread experience in using Talend features such as context variables, triggers, connectors for Database and flat files.

Hands on Involvement on many components which are there in the palette to design Jobs & used Context Variables to Parameterize Talend Jobs.

Tracking Daily Data load, Monthly Data extracts and send to client for their verification.

Strong experience in designing and developing Business Intelligence solutions in Data Warehousing using ETL Tools.

Excellent understanding and best practice of Data Warehousing Concepts, involved in Full Development life cycle of Data Warehousing.

Experienced in analysing, designing and developing ETL strategies and processes, writing ETL specifications.

Experienced in working with different data sources like Flat files, Spreadsheet files, log files and Databases.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Created Talend mappings to populate the data into dimensions and fact tables.

Frequently used Talend Administrative Console(TAC).

Implemented new users, projects, tasks with in multiple different environments of TAC(Dev,Test,Prod,DR).

Educational Qualification:

Education

Year

Board/University

Percentage

Graduation

2011-2015

B.Tech (CSE)

62

12th

2009-2011

Board Of Intermediate

76

10th

2008-2009

SSC

76

WORK EXPERIENCE:

Working as Talend ETL Developer in FIRST AMERICAN CORPORATION LIMITED (November 2015 to Till Date)

TECHNICAL SKILLS:

Data Warehousing Tools

Talend Data Integration (5.6v, 6.2v),

TAC (Talend Administrator Console).

Programming Languages:

Python

Operating Systems:

Windows (7,10), Linux.

Databases:

SQL SERVER, Oracle DB 11g, MySQL 5.6.

Applications and Tools:

Microsoft Office 2013, Notepad++, FTP Server.

Talend Components (Hands on experience)

Category

Components

Data Quality Components

tAddCRCRow, tFuzzyJoin, tDataMasking, tDuplicateRow, tintervalmatch, treplacelist, tSchemaComplianceCheck, tStandardizePhoneNumber, tStandardizeRow, tUniqRow, tExtractRegexFields, tFuzzyMatch

Processing Components

tDenormalize, tDenormalizeSortedRow, tExtractDelimitedFields, tExtractPositionalFields, tExtractRegexFields, tExtractXMLField, tNormalize, tSplitRow, tAggregateRow, tAggregateSortedRow, tConvertType, tMap, tJoin, tFilterRow, tFilterColumns, tReplace, tSampleRow, tSortRow, tXMLMap, tBufferInput, tBufferOutput.

Orchestration Components

tParallelize, tFlowToIterate, tIterateToFlow, tForeach, tInfiniteLoop, tLoop, tPostjob, tPrejob, tReplicate, tSleep, tWaitForFile, tfilelist, trunjob

Custom Code Components

tjava, tjavarow, tjavaflex, tSetGlobalVar, tlibraryload

Project 1

Project Name: Expanded Plant Record.

Client: First American Corporation

Title: Talend Developer

Environment: Talend data integration 5.6, oracle 10G, Windows 7.

Description:

Expanded Plant Record (EPR) is based on mortgage based document type. Mortgage or Deed of Trust. The Mortgage or Deed of Trust is a legal document in which the borrower transfers the title to a third party (trustee) to hold as security for the lender. When the loan is paid in full the trustee transfers the title back to the borrower. The main usage is to provide accurate data instead of providing complete data because the data should be hidden. The complexity is here it is American government data which should be secured.

Responsibilities:

Involved in business requirement gathering, analysis and understanding the functional specification

Created metadata for oracle, vector wise, oracle, flat files for implementing ETL jobs in Talend.

Created various jobs in Talend for implementing business logic.

Worked with different sources such as Oracle and flat files, mysql.

Extensively used vector wise load to load data from flat files to staging tables.

Extensively used for joining different sources using tmap components Used different methods/functions in tmap for doing transformation logic.

Used input and output filters in tmap for filtering the data based on the requirement.

Created context variable to store metadata information of all the sources and targets Using Debugger to find the bottlenecks in the Jobs.

Applied MD5 concept on selected columns which will helped for time consuming.

Developed ETL applications using various Talend components like tFilterRow, tAggregateRow, tMap, tJoin, tOracleInput, tOracleOutput, tOracleConnection, tOracleSP, tOracleRollback, tJava, tJavaRow, tFilelist, tFileCopy, tWaitForFile, tFileInputDelimited, tfileOutputDelimited, tRowGenerator,twaitForFile, tFuzzyJoin, tFuzzyMatch.

Project 2

Project Name: Starters

Client: First American Corporation

Title: Talend Developer

Environment: Talend Data Integration 6.2, Oracle 11g, SQL Server and flat files, Windows10.

Description:

The aim of the project is to obtain data from the source tables and applying transformation and other business logic as required to obtain cleansed data. This cleansed data is further sent to other systems to detect anomalies in .CSV, flat files, XML and identify possible incorrect data by using Regular expression concepts and Regex components.

Responsibilities:

Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, and Flat Files.

Involved in writing SQL Queries and used Joins to access data from Oracle

Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.

Designing, developing and deploying end-to-end Data Integration solution.

Implemented custom error handling in Talend jobs and worked on different methods of logging.

Develop the ETL mappings for XML, .CSV, .TXT sources and loading the data from these sources into relational tables with Talend ETL Developed Joblets for reusability and to improve performance.

Developed high level data dictionary of ETL data mapping and transformations from a series of complex Talend data integration jobs.

Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2, Type 3 to capture the changes.

Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Created context variables and groups to run Talend jobs against different environments.

Used Talend components are tMap, tDie, tConvertType, tLogCatcher, tRowGenerator, tExtractRegexFields, tUnite, tSplitRow, tReplace, tSortRow, tFilterRow, tParallelize.

Created triggers for a Talend job to run automatically on server.

Installation of Talend Enterprise Studio (Windows, UNIX) and configuring along with Java.

Preparing required documents, Unit Testing and coordinating code reviews.

Worked on AMC tables (Error Logging tables)

Project 3

Project Name: Human Healthcare Insurance

Client: Guardian Life Insurance Company, USA

Title: Talend Developer.

Environment: Talend, Oracle, MS SQL Server, Oracle and MySQL, Unix commands, Linux.

Description:

Human Healthcare Insurance is a for-profit American health insurance company based in Louisville, Kentucky. As of 2014 Humana has had over 13 million customers in the U.S., [not in citation given reported 2013 revenue of US$41.3 billion, and has had 51,600 employees. In 2013, the company ranked 73 on the Fortune 500 list, which made it the highest ranked (by revenues) company based in Kentucky. It has been the third largest health insurance in the nation.

Responsibilities:

Develop the ETL mappings for XML, .CSV, .TXT sources and loading the data from these sources into relational tables with Talend ETL Developed Joblets for reusability and to improve performance.

Developed high level data dictionary of ETL data mapping and transformations from a series of complex Talend data integration jobs.

Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Used tRunJob component to run child job from a parent job and to pass parameters from parent to child job. Created Context Variables and Groups to run Talend jobs against different environments.

Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFile Copy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc.

Created context variables and groups to run Talend jobs against different environments.

Used Talend components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher,tRowGenerator.

Experienced in Building a Talend job outside of a Talend studio as well as on TAC server.

Experienced in writing expressions with in tmap as per the business need.

Handled insert and update Strategy using tmap. Used ETL methodologies and best practices to create Talend ETL jobs.

I hereby declare that the above details are true to the best of my knowledge.

Name : Veeragandham, Chanikya

Place : Hyderabad, India

Contact this candidate