SUMMARY

• Proficiency in gathering and analyzing user requirements and translating them into business solutions.
• Experience in Talend Open Studio and Talend Integration Suite.
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing ETL Solutions.
• Excellent experience working on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, tmap, tFileCopy, tFileCompare, tFileExist file components, tIterateToFlow, tFlowToIterate, tHashoutput, tHashInput, tRunjob, tJava, tNormalize etc.
• Developed slowly changing dimension (SCD) mappings using type - I, type-II, and type-III methods.
• Experience in using AWS cloud components and connectors to make API calls for accessing data from cloud storage (Amazon S3, Redshift) in Talend Enterprise Edition.
• Performed Importing and exporting data into HDFS and Hive using Sqoop.
• Involved in TAC (Talend Administrator Console) activities such as Job Scheduling, Server Monitoring, Job Conductor, Task Creation, Job Deployment etc.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat-files, CSV files and XML files.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills
• Excellent communication skills and interpersonal abilities with maximum contribution to attain the team goal.
• Prepared Design document for the requirements assigned.
• Written SQL queries required to retrieve and manipulate data from the database.
• Given strong technical support for development of all other modules.
• Defect logging/fixing.
• Write ETL logics using Java.

TECHNICAL SKILLS

• Talend Studio Data Integration
• 6.3/6.2.1/5.6.2/5.5.2/5.3.1 , Talend Administrator Console
• Windows 98/2000, 2003, Windows NT 4.0
• PostgresSQL, SQLdeveloper, SQLServer Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook Terrace, IL

ETL / Talend Developer

Responsibilities:

• Worked closely with Business Analysts to review the business specifications of the project and to gather the ETL requirements.
• Worked on multiple projects
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Migrated jobs from BODI to Talend and SSIS Packages to Talend.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Analyzing the source data to know the quality of data by using Talend Data Quality.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and SSMS.
• 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 Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tHashInput, tHashOutput,TpreJob, tpostJob, tSendEmail and many more)
• Created error Handling Job and notifies on job success and failure.
• Created Joblets and using trunjob created MasterJobs.
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including XML, CSV, and Flat file structures.
• Experienced in using debug mode of talend to debug a job to fix errors.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
• Developed Talend jobs to populate the claims data to data warehouse - star schema.
• Created History preserve jobs (SCD Type 2)
• Used Talend Management Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis and created tasks and plans.
• Worked on various Talend components such as tMap, tFilterRow, tAggregateRow, tFileExist, tFileCopy, tFileList, tDie etc.

Environment: Talend Data Integration 7.0.1, Talend Management Console to Schedule Jobs in Job Conductor, MS SQL Server 2012/2008, Oracle 11g, Amazon S3.

Confidential, Baltimore MD

ETL Talend Developer

Responsibilities:

• Working on TOS DI 7.0.1 version with PostgreSQL as input and output.
• Expertise in Talend Installation and many more applications helped for colleagues in installation and changing the workspace or to copy the code from workspace.
• Expertise in transferring the Talend code from higher version to lower version.
• Expertise working in Agile methodology.
• Designed ETL jobs for Data Migration from Legacy system (ASSIST, CHESSIE, JUVINIEL) to new systems(CJAMS)
• Prepared Mapping documents and participated actively in Mapping Validation meetings.
• Created tables in PostgreSQL as part of unit testing in Dev environment.
• Designed, developed, tested and delivered code as per business requirements
• Expertise in creating functions and using them in the ETL jobs.
• Expertise working with big group of teams and leading Off shore team.
• Wrote SQL queries for Validating ETL job as part of Unit testing.
• Used Components like tprejob, tpostjob, tpostgresconnection, tdbclose, tDBInput(PostgresSQL), tDBOutput(PostgresSQL), tmap, tDBconnection, tflowmeter, tDBrow, tschemacomplaincecheck, tdie, tlogcatcher, tstatcatcher, txml, tsendmail related components.
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Expertise working in AWS environment.
• Expertise working in JIRA, CONFLUENCE and BITBUCKET SERVER.
• Cloned the code from bit bucket and committed the changes in bitbucket server.
• Expertise in integrating jobs from two different projects.
• CJAMS got different Modules like Child Welfare, DJS and Adult Services. Played a key role in data migration teams for three modules.
• Generated reports using Qlik view.
• In Analysis and development of various modules in the project.
• Prepared Design document for the requirements assigned.
• Used jQuery for client-side validations.
• Written business logic to validate the data returned from the interfacing system using
• Written SQL queries required to retrieve and manipulate data from the database.
• Given strong technical support for development of all other modules.
• Defect logging/fixing.
• Write ETL logics using Java Batch.
• Peer Review of deliverables
• Environment: Talend Data Integration Open Studio 7.0.1, Pgadmin3 & 4, Qlik view.

Confidential

Talend Developer (Internship)

Responsibilities:

• Closely worked with Data Architects in designing of tables and even involved in modifying technical Specifications.
• Designed and Implemented the ETL process using Talend Enterprise Big Data Edition to load the data from Source to Target Database.
• Involved in Data Extraction from Oracle, Flat files and XML files using Talend by using Java as Backend Language.
• Used tWaitForFile component for file watch event jobs.
• Used over 20+ Components in Talend Like (tMap, tfilelist, tjava, tlogrow, toracleInput, toracleOutput, tsendEmail etc)
• Used debugger and breakpoints to view transformations output and debug mappings.
• Develop ETL mappings for various Sources (.TXT, .CSV, .XML) and also load the data from these sources into relational tables with Talend Enterprise Edition.
• Worked on Global Context variables, Context variables, and extensively used over 100+ components in Talend to create jobs
• Created child jobs to use them in parent job in using tRunJob.
• Extracting transformed data from Hadoop to destination systems, as a one-off job, batch process, or Hadoop streaming process.
• Worked on Error handling techniques and tuning the ETL flow for better performance.
• Worked Extensively TAC (Admin Console), where we Schedule Jobs in Job Conductor
• Extensively Used Talend components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, b, tOracleInput, tOracleOutput, tfileList, tDelimited etc
• Worked with Oracle SQL Developer while Implementing Unit Testing of ETL Talend Jobs.
• Scheduling the ETL mappings on daily, weekly, monthly and yearly basis.
• Working on POC Big Data like loading the data into HDFS and creating Map Reduce Jobs
• Worked on the project documentation and also prepared the Source Target mapping specs with the business logic and also involved in data modeling
• Worked on migrating data warehouses from existing SQL Server to Oracle database.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Created Workflows using various tasks like sessions, control, decision, e-mail, command, worklets, and assignment and worked on scheduling of the workflows.
• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
• Migrated the code and release documents from DEV to QA (UAT) and to Production.
• Environment: Talend OpenStudio5.0.1, UNIX, Oracle 12c, TAC (Admin Center), SQL Server, TOAD, Autosys.

Confidential

Talend Developer (Internship)

Responsibilities:

• The project was aimed to support existing clients by changing from manual Process to Automation through ETL development using Talend
• Closely worked with Data Architects in designing of tables and even involved in modifying technical Specifications.
• Designed and Implemented the ETL process using Talend Enterprise Big Data Edition to load the data from Source to Target Database.
• Involved in Data Extraction from Oracle, Flat files and XML files using Talend by using Java as Backend Language.
• Used tWaitForFile component for file watch event jobs.
• Used over 20+ Components in Talend Like (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tDelimited tfilelist, tjava, tlogrow, toracleInput, toracleOutput, tsendEmail etc)
• Used debugger and breakpoints to view transformations output and debug mappings.
• Develop ETL mappings for various Sources (.TXT, .CSV, .XML) and also load the data from these sources into relational tables with Talend Enterprise Edition.
• Worked on Global Context variables, Context variables, and extensively used over 100+ components in Talend to create jobs Created child jobs to use them in parent job in using tRunJob.
• Worked on Error handling techniques and tuning the ETL flow for better performance.
• Worked Extensively TAC (Admin Console), where we Schedule Jobs in Job Conductor
• Worked with Oracle SQL Developer while Implementing Unit Testing of ETL Talend Jobs.
• Worked on the project documentation and also prepared the Source Target mapping specs with the business logic and also involved in data modeling
• Worked on migrating data warehouses from existing SQL Server to Oracle database.
• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.
• Migrated the code and release documents from DEV to QA (UAT) and to Production.

Environment: Talend Platform Big Data 6.2, Talend OpenStudio5.0.1, Oracle 12c, TAC (Admin Center), SQL Server.