SUMMARY:

• Over 7 years of strong experience in the IT industry as ETL Developer in various domains like Financial, Tele - communication and Banking. Maintained positive communications and working relationship at all levels.
• Expert noledge of all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Around 4 years of experience with Talend Open Studio & Talend Enterprise platform for Data Management (V5.5.1, V6.1.1, V6.4) and Data Integration.
• Expert in using the Talend Troubleshooting and DataStage to understand the errors in Jobs and used the tMap/expression editor to evaluate complex expressions and look at the transformed data to solve mapping issues.
• Created complex mappings in Talend using components like: tMap, tJoin, tReplicate, tParallelize, tAggregateRow, tDie, tUnique, tFlowToIterate, tSort, tFilterRow, tWarn, tbuffer, tcontextload.
• Experience in analytical Database Design and Data Modeling skills using MS Visio, ERWIN, ER Studio Data Architect.
• Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files.
• Hands on Experience on many components which are there in the palette to design Jobs & used Context Variables to Parameterize Talend Jobs.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.
• Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Excellent noledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, and reporting tools.
• Experienced in designing high-level ETL architecture, creating, configuring, and fine-tuning ETL workflows for overall data transfer from the OLTP to OLAP with the halp of SSIS.
• Good noledge Object Oriented Concept, Data Structure and Algorithms. Hand

PROFESSIONAL EXPERIENCE:

Confidential

Talend Developer

Responsibilities:

• Designed target tables as per the requirement from the reporting team and designed Extraction, Transformation and Loading (ETL) using Talend. 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, and MySQL. Designing, developing, and deploying end - to-end Data Integration solution. Implemented custom error handling in Talend jobs and worked on different methods of logging.
• Used Talend components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator. Worked on Azure blob and Databricks for bunk load and dataframe work.
• Created triggers for a Talend job to run automatically on server. Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines. Experienced in using debug mode of talend to debug a job to fix errors.
• Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow. Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
• Installation of Talend Enterprise Studio (Windows, UNIX) and configuring along with Java. Set up and manage transactional log shipping, SQL server Mirroring, Fail over clustering and replication. Developed high level data dictionary of
• ETL data mapping and transformations from a series of complex Talend data integration jobs. Worked on AMC tables (Error Logging tables) Developed Talend jobs to populate the claims data to data warehouse-star schema.

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:

• 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.
• Created Complex mapping using various components like TMAP, HDFS CONNECTIONS, TCASSANDRA CONNECTION, TJAVA, TWRITEJSON, and TRESTCLIENT. Designed and Developed ETL process using Talend Open Studio (Data Integration) & Even Worked on Enterprise Latest Version's.
• Develop the ETL mappings for XML, CSV, TXT sources and loading the data from these sources into relational tables with Talend ETL Developed Jobs for reusability and to improve performance. Troubleshooting, debugging & altering Talend issues, while maintaining the health and performance of the ETL environment. Schedule the Talend jobs with Talend Admin Console, setting up best practices and migration strategy. In parallel to Development acted as an Talend Admin: Creating Projects/ Scheduling Jobs / Migration to Higher Environments & Version Upgrades.
• Hands of Experience on many components which are there in the palette to design Jobs & used Context Variables/Groups to Parameterize Talend Jobs. Worked on Custom Component Design and used to has 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.
• 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. Implemented Error Logging, Error Recovery, and Performance Enhancement's & created Audit Process (generic) for various Application teams. Installation of Talend Enterprise Studio (Windows, UNIX) and configuring along with Java.
• Experience in using Repository Manager for Migration of Source code from Lower to higher environments. 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) Handle standards in jobs which include Java standards for routines and Talend standards.

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 ETL Developer

Responsibilities:

• Involved with business stakeholders, application developers, production teams 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. Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Extensively used components like tWaitForFile, tIterate, toFlow, tFlowToIterate, tHashoutput, tHashInput, tMap, tRunjob, tJava, tNormalize and tfile components to create Talend jobs. Performed ETL mappings using MS SQL Server Integration Services.
• Developed Data - architecture, ETL Batch processes in Talend, SQL-server and PostgreSQL for Call-center systems including architecture for parsing documents related to Call-center notes

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

Confidential

ETL Developer

Responsibilities:

• 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. Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables. Used the DataStage Director and its run - time engine to schedule running the solution, testing, and debugging its components, and monitoring the resulting executable versions.
• Worked with DataStage Manager for importing metadata from jobs, new job Categories and creating new data elements. Developing Shell Scripts to automate file manipulation and data loading procedures.

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