SUMMARY

• 5+ years of experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of ETL applications which includes strong experience in OLTP & OLAP environments as a Data Warehouse/Business Intelligence Consultant.
• 5+ years of experience in Talend Open Studio (7.x/6.x/5.x) for Data Integration, Data Quality,Data mining and Big Data.
• 3+years of experience with Talend Admin Console (TAC).
• 3+ year of experience with Talend Data Management Platform & Talend Enterprise Big Data 6.4.1
• Experienced in Data Migration from Oracle and SQL server to cloud.
• Experienced in Data Migration from MySQL Tables to JSON & highly experienced in extracting JSON data and migrating to MySQL Tables using Talend components like textractJSON.
• Expertise in ETL designs involving Source databases Oracle, Flat Files (fixed width, delimited), DB2, SQL Server, and Target databases Oracle and Flat Files.
• Extensive experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and loading using Talend and designed data conversions from wide variety of source systems.
• Extensively created mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tJava, tJavarow, tDie, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap etc.
• Experience in Talend Administration Center (TAC) for scheduling and deployment.
• Knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
• Knowledge of monitoring and managing Hadoop cluster using Hortonworks.
• Worked with application teams to install operating system, Hadoop updates, patches and version upgrades as required.
• Expertise with managing and reviewing Hadoop log files.
• Experience in Waterfall and Agile methodology.
• Extensive experience in On Shore - Off Shore Coordination/Design Reviews/Code reviews/Implementing Standards.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business customers and developers across multiple disciplines.

TECHNICAL SKILLS

Databases: Microsoft SQL Server, Oracle, Hive, as400.

Programming Languages: C, SQL, PL/SQL,Hive, Java

Tools: Talend, Tableau and Power BI

Operating System: Windows, Unix

Packages: Micro Soft Office Suite - MS-Word, MS-Excel, MS-Power point.

Other: Testing (Manual Testing (System, Regression, User Acceptance Testing), MS-Visio, ESP scheduling Tool

PROFESSIONAL EXPERIENCE

Confidential, Chicago,IL

Talend Developer

Responsibilities:

• Worked with Data Mapping Team to understand the source to target mapping rules.
• Analyzed the requirements and framed the business logic for the ETL process using Talend.
• Involved in the ETL design and its documentation.
• Developed Jobs in Talend Enterprise edition from stage to source, intermediate, conversion and Target.
• Worked on Talend ETL to load data from various sources to Oracle DB. Used tmap, treplicate, tfilterrow, tsort and various other features in Talend
• Designed and Developed ETL process using Talend Open Studio (Data Integration) & Even Worked on Enterprise Latest Version’s
• In parallel to Development acted as an Talend Admin: Creating Projects/ Scheduling Jobs / Migration to Higher Environments & Version Upgrades
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
• Hands of Experience on many components which are there in the palette to design Jobs & used Context Variables/Groups to Parameterize Talend Jobs.
• Involved to open firewall requests for applications which are connecting to different environments.
• Closely to worked with Talend architects to implement the work design.
• Worked on debugging issues if developers have any committing issues with GIT and worked to resolve TAC related issues
• Worked on talend Big Data components like Hadoop, Hive etc.
• Worked with AWS EMR to managed cluster platform that simplifies running big data frameworks, such as Apache Hadoop and Apache Spark, on AWS to process and analyze vast amounts of data.
• Worked on Custom Component Design and used to have embedded in Talend Studio
• Used to be On-call Support if the Project is deployed to further Phases
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs. creating mappings in TALEND using tMap, tJoin, tReplicate, tParallelize, tConvertType,, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc.
• Utilized Big Data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.
• Created many complex ETL jobs for data exchange from
• Extensively used tMap component which does lookup & Joiner Functions, tjava, tOracle, txml, tdelimtedfiles, tlogrow, tlogback components etc. in many of my Jobs Created and worked on over 100+components to use in my jobs.
• Performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.

Environment: Talend Open Studio 5.5.1, Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 ), UNIX, Oracle, Microsoft SQL Server management Studio, WINDOWS XP

Confidential

Talend Developer

Responsibilities:

• Implemented File Transfer Protocol operations using Talend Studio to transfer files in between network folders.
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load
• Worked on Data Migration using export/import.
• Created Talend jobs using the dynamic schema feature.
• Used the Talend Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.
• Wrote complex SQL queries using joins, sub queries and implemented in Oracle Input components.
• Performed unit testing and developed test case documents.
• Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Have used AWS components (Amazon Web Services) - Downloading and uploading data files (with ETL) to AWS system using S3 components.
• Used tParalleize component and multi thread execution option to run subjobs in parallel which increases the performance of a job.
• Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc.
• Experienced in Building a Talend job outside of a Talend studio as well as on TAC server.
• Experience with Hadoop technology stack such as: Hive, HBASE, MapReduce.
• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger)
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing statsz
• 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.
• Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
• Mainly Involved in Performance Tuning of Talend Jobs.
• Hands on Experience in creating Generic schemas, Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Designed Talend Jobs and Created Jobs for Audit Process, Exception Handling framework.

Environment: Talend Open Studio Data Integration 6.3.1, Enterprise Platform for Data management (V5.5.1, 5.6.1/5.6.2 ), UNIX, JIRA, Oracle, Microsoft SQL Server management Studio, WINDOWS XP.

Confidential

Talend Developer

Responsibilities:

• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts loadInvolved in Data Extraction for various Databases & Files using Talend
• Created Talend jobs using the dynamic schema feature.
• Have used Big Data components (Hive components) for extracting data from hive sources.
• Performance tuning - Using the tmap cache properties, Multi-threading and tParallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in ETL process.
• Used more components in Talend and Few to be mentioned: tjava, toracle, txmlMap, tdelimited files, tlogrow, tlogback components etc. in many of my Jobs Design
• Worked on Joblets (reusable code) & Java routines in Talend
• Implemented Talend POC to Extract data from Salesforce API as an XML Object & .csv files and load data into SQL Server Database
• Experience in using Repository Manager for Migration of Source code from Lower to higher environments. and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Created Talend jobs using the dynamic schema feature. Designed Talend Jobs and Created Jobs for Audit Process, Exception Handling framework.
• Designed target tables as per the requirements from the reporting team, and designed Extraction, Transformation and Loading (ETL) using Talend.
• Design and Implement ETL to data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2 to capture the changes.
• Written shell scripts for scheduling the jobs, moving files between different servers, file modifications or used as additional procedures along with Talend jobs.
• Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment, which is project oriented, scalable and optimized.
• Performed ETL mappings using MS SQL Server Integration Services.
• Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin.
• Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using DataStage.
• Mapping Data Items from Source Systems to the Target System.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on programs for scheduling Data loading and transformations using DataStage from legacy system to Oracle 9i using SQL* Loader and PL/SQL.

Environment: DataStage 7.0 (Manager, Designer, Director), ERWIN, Oracle 9i, PL/SQL, SQL* Loader, SQL Server 2000, Windows NT 4.0, UNIX.