SUMMARY

• Around 5 + years of experience in Design, Analysis and development of software applications.
• Around 5 years of experience with ETL Tool like Ascential DataStage and Database systems such as Oracle, SQL Server.
• Around 4 years of experience with Talend Open Studio & Talend Enterprise platform for Data Management (V5.5.1, V6.1.1, V6.4, V7.0) and Data Integration.
• Expertise in 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, tFilter, tGlobalmap, tDie, etc.
• Solid Knowledge on relational database management Systems, Data Warehousing Basics and Dimensional modeling (Snowflake schema and Star schema).
• Hands on Experience on many components which are there in the palette to design Jobs & used Context Variables to Parameterize Talend Jobs.
• Deep understanding of OLTP, OLAP and data warehousing environment and tuning both kind of systems for peak performance.
• Excellent knowledge of studying the data dependencies using metadata of Datastage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Experience in designing and developing complex Talend/DataStage jobs, routines.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and loading relational and using Talend/SSIS and designed data conversions from wide variety of source systems including non - relational sources like flat files.
• Implemented Slowly Changing Dimension phenomenon while building Data Warehouses.
• Implemented Error Logging, Error Recovery, and Performance Enhancement's & created Audit Process (generic) for various Application teams.
• Experience in automation by using scheduling jobs on a daily, on a weekly and yearly basis depending on the requirement using Talend Management Console.
• Analyze Develop, Design and Implement Data Warehousing Applications using Talend, Teradata, SQL Server, DB2 & UNIX, building Data Marts.
• Experience in working with parallel extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
• Written stored procedures to insert and clean data into the data warehouse tables, fired triggers upon completion of load to obtain the log of all the tables loaded with job name and load date.
• Ability to solve complex technical problems and have unique ability to understand long-term project development issues at all levels and interpersonal skills with powerful desire to achieve specified goals within the given time frame.
• Strong interpersonal, written and verbal communication skills. Highly organized professional with strong technical skills.

TECHNICAL SKILLS

ETL Tools: Talend Open Studio & Talend Enterprise Platform (V5.5.1, 5.6.1/5.6.2 , 6.1.1/6.3.1/6.4/7.0 ) for Data management, Ascential DataStage: 8.1, 7.5.1, 7.5, 7.0.1, 7.0

Database Tools: Oracle 11g/10g/9i, SQL Server Management Studio, SQL*Plus, SQL* Loader, TOAD, Oracle SQL Developer, Teradata

Languages: UNIX, Shell Programming, SQL, PL/SQL, T-SQL, Java

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook Terrace, IL

Talend Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Worked with Data Mapping Team to understand the source to target mapping rules.
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load
• Created Talend jobs using the dynamic schema feature.
• Tracked backlogs and fixed bugs using Azure DevOps.
• Worked on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tMSSQLOutput, file components.
• Extensively used components like tWaitForFile, tIterateToFlow, tFlowToIterate, tHashoutput, tHashInput, tMap, tRunjob, tJava, tNormalize and tFile components to create Talend jobs.
• Experience in creating Joblets in TALEND for the processes which can be used in most of the jobs in a project like to Start job and Commit job.
• 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.
• Implemented Talend to extract data from XML, JSON & flat files and load data into SQL Server/Oracle Database for downstream process.
• Optimized SQL Queries for maximum performance.
• Designed target tables as per the requirements from the reporting team, and designed Extraction, Transformation and Loading (ETL) using Talend.
• Introduced effective ways of communication and stream-lined use of Azure DevOps Confluence and to maximize productivity and bring discipline between Dev-QA communication gaps.
• Incorporated error handling in project level to validate data integrity and completeness in database.
• Used to be on call if the Project is deployed to further Phases.
• Experience in handling Incident Management, Ticket Handling, Co-ordination among different Teams, Initial analysis on problems, co-ordination with SME on identifying the Root cause
• Coordinating with onsite and offshore teams as necessary during project delivery including daily connect calls.

Environment: Talend Big Data Enterprise Platform (V7.0), Talend Management Console, SharePoint, Outlook, Visual Studio, SQL Server Management Studio 17.9.1, SSIS, Windows 10

Confidential, Charlotte, NC

Talend Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Implemented Talend to extract data to/From JSON & flat files and populated into Oracle Database for downstream process.
• Created Talend jobs to publish data to Kafka topics from oracle tables.
• Consumed Events from Kafka topics and extracted Json and xml fields to write into flat file.
• Designed with basic Talend job for moving data from source tables to target tables and performed enhancement process by including incremental (DELTA) process.
• Experience in creating common jars for Error handling in Talend for the processes which can be used in most of the jobs in a project like to Start job, Commit job and Capture errors.
• Implemented log4j mechanism to create logs for Talend job.
• Designed target tables as per the requirements from the reporting team, and designed Extraction, Transformation and Loading (ETL) using Talend.
• Prepared Technical Design Documents for all the work flows and got good appreciation from the manager.
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load.
• Created Talend jobs using the dynamic schema feature. Designed Talend Jobs and Created Jobs for Audit Process, Exception Handling framework.
• Created jobs for Encryption & Decryption of data while processing using Public and private key concept.
• Involved in Data Extraction for various Databases & Files using Talend.
• Extensively used components like tWaitForFile, tIterate, toFlow, tFlowToIterate, tHashoutput, tHashInput, tMap, tRunjob, tJava, tNormalize and tfile components to create Talend jobs.
• 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.
• Introduced effective ways of communication and stream-lined use of Smartsheet application and to maximize productivity and bring discipline between Dev-QA communication gaps.
• Tracked backlogs and fixed bugs using Smartsheet (SaaS) application for collaboration and work management.
• Worked on Talend Administration Centre (TAC) for scheduling the Jobs using Job Conductor, Execution Plan and Triggers.
• Incorporated error handling in project level to validate data integrity and completeness in database.
• Used to be on call if the Project is deployed to further Phases.

Environment: Talend Open Studio Data Integration 6.3.1, Talend Enterprise Platform for Bigdata (V6.2.1, 6.1.1), confluent kafka 4.0.0, UNIX, Smartsheet, Oracle, Cloudberry Explorer, WINDOWS XP.

Confidential, Richmond, VA

Talend Developer

Responsibilities:

• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Developed and implemented Software Release Management strategies for various applications per the Agile process.
• Extensively worked on creating repositories in GIT and assigning roles to developers and crating same projects in TAC.
• Developed complex ETL mappings for Stage, Dimensions, Facts and Data marts load
• Created Talend jobs using the dynamic schema feature. Designed Talend Jobs and Created Jobs for Audit Process, Exception Handling framework.
• Experience working with Big data components for extracting and loading data into HDFS file system.
• Implemented fast and efficient data acquisition using Big Data processing techniques and tools.
• Tracked backlogs and fixed bugs using JIRA.
• Involved in Data Extraction for various Databases & Files using Talend.
• Extensively used components like tWaitForFile, tIterate, toFlow, tFlowToIterate, tHashoutput, tHashInput, tMap, tRunjob, tJava, tNormalize and tfile components to create Talend jobs.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Experience in creating Joblets in Talend for the processes which can be used in most of the jobs in a project like to Start job and Commit job.
• Implemented Talend to extract data from XML & flat files and load data into SQL Server/Oracle Database for downstream process.
• Worked Extensively on Talend Admin Console & Schedule Jobs in Job Conductors, this option is not available in Talend Open Studio Data Integration.
• 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.
• Introduced effective ways of communication and stream-lined use of JIRA Confluence and to maximize productivity and bring discipline between Dev-QA communication gaps.
• Worked in Talend Administration Centre (TAC) for scheduling the Jobs using Job Conductor, Execution Plan and Triggers.

Environment: Talend Open Studio Data Integration 6.0.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, Green Bay, WI

Talend Developer

Responsibilities:

• Closely worked with Business Analysts to gather requirement's and worked with Data Architects to design Tables (TAC Tables, AMC Tables).
• Hands of Experience on many components which are there in the palette to design Jobs & used Context Variables/Groups to Parameterize Talend Jobs.
• In parallel to Development acted as a Talend Admin: Creating Projects/ Scheduling Jobs / Migration to Higher Environments & Version Upgrades.
• Implemented Error Logging, Error Recovery, and Performance Enhancement's & created Audit Process (generic) for various Application teams.
• Used Talend reusable components like routines, context variable and global Map variables.
• Analyzing the source data to know the quality of data by using Talend Data Quality.
• Involved in implementing common Talend framework process for all the jobs in projects.
• Extensively worked on Talend Coding and Unit testing activities.
• Created UNIX scripts to automate the process for long running jobs and failure jobs status reporting.
• Experienced in versioning, importing and exporting Talend jobs. Set up Triggers for Talend jobs in Job conductor.
• Maintained and upgraded Jira issue tracker, Crucible code review tool.
• Schedule Jobs using Autosys (Scheduling), Hermes (Deployment) as we are using Open Studio.
• Implemented Talend POC to extract data from Salesforce API as an XML Object & .csv files and load data into SQL Server Database.
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger).
• Track and report Scrum team velocity.
• Introduced effective ways of communication and stream-lined use of JIRA Confluence and to maximize productivity and bring discipline between Dev-QA communication gaps.
• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion).
• Used to be on call if the Project is deployed to further Phases.

Environment: Talend Open Studio Data Integration 5.5.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

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 (on an ad hoc or scheduled basis).
• 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.