EXPERIENCE SUMMARY:

• Having close to 8 years of IT experience in Data warehousing projects.
• Extensive experience in ETL methodologies supporting Data Migration, Data Exchange, Data Transformation using Talend(DI and ESB) and Informatica Power Center.
• Excellent skills in Oracle, Business Objects and SQL Server.
• Have experience leading a team and mentoring junior member of the team.
• Extensive experience in the project life cycle phases like Analysis of User Requirements, preparation of Functional Specification Documents, Technical Design Document, Coding & Unit Testing, Integration Testing, Implementation, and Support & User .
• Excellent Analytical, problem solving, communication and presentation skills, willing to work in both independent and team environment.
• Ability and willingness to acquire knowledge about the new technologies, good analytical, problem solving and interpersonal skills with ability to interact with individuals at all levels.
• Ability to face new challenges and good problem solving capabilities
• Competitive, highly motivated, enthusiastic learner, team player and initiator.
• Experience in building database systems from end - to-end (including tables, keys, indexes, views, stored Procedures, user-defined functions) .
• Extensively worked with various source systems like flat files, delimited files, positional files excel files, SAP, XML and JSON file and others.
• Knowledge of OLTP/OLAP System Study, developing Database Schemas including Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling
• Experience interacting with business users to analyze the business process requirements and transform them into documentation, design, and rolling out the deliverables
• Developed numerous reusable ETL components across varied projects.
• Excellent debugging capabilities by both tool orientation and also manual techniques in ETL mappings, scripting and PL/SQL procedures.
• Extensive hands on integrating processing of different SOAP and REST web services in Talend ESB.
• Worked extensively with Dimensional modeling, Data migration, Data Integration, Data profiling.
• Experience in scheduling the jobs using Autosys , TAC Talend Administration Center .
• Have worked in all stages of SDLC in both Agile and Waterfall methodology.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.5.1, 9, Talend Integrated Studio 4.1.2, 5.0, 5.2, 5.4.1 (TOS), 6.1.1 Talend ESB Suite 5.4.1

OLAP Tools: BO-INFOVIEW

RDBMS: Oracle (9i/10G/11G), SQL Server 2000/2005, Postgres

Programming languages: Basic shell scripting, PL/SQL, Java

Operating system: Windows XP, UNIX, LINUX

Business Domain: IT Services, Investment Banking, Media, Entertainment

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Responsibilities:

• Develop Talend data integration jobs to perform some measure of transformations over the data files coming from EDW source systems.
• Guide associates in coding and testing of Talend DI jobs.
• Run Talend code & create enterprise extracts for operational reporting.
• Load the transformed data to target database tables Sql server data warehouse.
• Implement various parallel techniques in the Talend job design and also performance tuning of the jobs, debugging and resolution of the issues.
• Worked with many components which include processing components, database components, logs and errors components, file components, SQL template components.
• Have extensive hands on experience on processing components such as tmap,tjoin,tsortrow,taggregaterow, taggregatesortedrow,tnormailze,tdenormalize.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob,tfilelist,tparallelise etc.
• Doing peer reviews before the production implementation.
• Work closely with the production support team to resolve the potential issues related with databases and upstream systems.
• Requirements gathering for Change requests and schema design based on data model .

Environment: Talend ETL 6.1.1,Windows, ESP(in house scheduler), and SQL Server 2014.

Confidential, Chicago

Responsibilities:

• Develop Talend data integration jobs to perform some measure of transformations over the data files coming from EDW source systems.
• Guide associates in coding and testing of Talend DI jobs.
• Run Talend code & create enterprise extracts for operational reporting.
• Load the transformed data to target database tables Sql server data warehouse.
• Implement various parallel techniques in the Talend job design and also performance tuning of the jobs, debugging and resolution of the issues.
• Worked with many components which include processing components, database components, logs and errors components, file components, SQL template components.
• Have extensive hands on experience on processing components such as tmap,tjoin,tsortrow,taggregaterow, taggregatesortedrow,tnormailze,tdenormalize.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob,tfilelist,tparallelise etc.
• Doing peer reviews before the production implementation.
• Work closely with the production support team to resolve the potential issues related with databases and upstream systems.
• Requirements gathering for Change requests and schema design based on data model .

Environment: Talend ETL 6.1.1,Windows, ESP(in house scheduler), and SQL Server 2014.

Confidential

Senior Talend Developer

Responsibilities:

• Work closely with multiple cross functional teams to effectively coordinate and manage the business user’s expectations.
• Capture user-feedback/comments on the delivered systems and document it for the client and project manager's review.
• Participate in daily status meetings to update the status and task prioritization.
• Involved in resolving the production issues.
• Involved in design, development and testing of talend mappings.
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings.
• Understanding of Technical Specifications Documents.
• Maintaining proper code throughout the whole ETL process.
• Maintaining SLA for the new feeds on-boarded or procured.
• Tuned talend mappings for better performance on request.
• Developed jobs, joblets using TOS to load data from various source systems such as database, excel, flat files (delimited and positional) others to target systems.
• Have extensive hands on experience on processing components such as tmap, tjoin, tsortrow, taggregaterow, taggregatesortedrow, tnormailze, tdenormalize.
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob, tfilelist, tparallelise etc.

Environment: Talend Open Studio 5.6.2, Oracle 11g, Java, Linux.

Confidential

Talend Lead

Responsibilities:

• Working as Technical Lead and responsible for ETL code delivery and driving ETL developers to understand the business logic.
• Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques and tools to support the performance.
• Work closely with multiple cross functional teams to effectively coordinate and manage the business user’s expectations.
• Manage solutions delivery of concurrent projects using on-site/off-shore resources.
• Capture user-feedback/comments on the delivered systems and document it for the client and project manager's review.
• Participate in daily status meetings to update the status and task prioritization.
• Managing team for all end Involved in design, development and testing of talend mappings.
• Involved in resolving the production issues.
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings.
• Understanding of Technical Specifications Documents.
• Maintaining proper code throughout the whole ETL process.
• Tuned talend mappings for better performance on request.
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob,tfilelist,tparallelise etc.
• Scheduling jobs in job conductor in TAC.

Environment: : Talend ETL 5.6,UNIX, Autosys,Oracle and, TAC.

Confidential

Senior Talend Developer

Responsibilities:

• Involved in design, development and testing of talend mappings.
• Involved in environment setup-Talend installation,TAC setup, jobserver setup,SVN configuration in windows server
• Involved in resolving the production issues.
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings.
• Tuned talend mappings for better performance on request.
• Scheduling jobs in job conductor in TAC.
• Developed jobs, joblets using TIS to load data from various source systems such as database, excel, flat files (delimited and positional), SAP , XML and JSON files and others to target systems.
• Have extensive hands on experience on components such as tsortrow, taggregaterow, taggregatesortedrow, tnormailze.
• Have extensive hands on ESB tESBConsumer,tESBProviderFault,tESBProviderRequest,tESBProviderResponse,tRESTClient,tRESTRequest,tRESTResponse,tRouteFault .
• Application of SOAP and REST web services in Talend ESB .
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob,tfilelist,tparallelise etc.
• Extensively used XML and JSON file formats and components tExtractXMLField, tFileInputXML, tFileOutputXML, tWriteXMLField, tXMLMap.

Environment: : Talend ESB Suite 5.4.1 , Postgres,SAP.

Confidential

Senior Talend Developer

Responsibilities:

• Involved in design , development and testing of talend mappings.
• Involved in resolving the production issues.
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings .
• Understanding of Technical Specifications Documents.
• Maintaining proper code throughout the whole ETL process.
• Maintaining SLA for the new feeds on-boarded or procured.
• Tuned talend mappings for better performance on request.
• Involved primarily in release activities like DDL deployment and Hermes deployment in UAT and PROD.
• Developed jobs, joblets using TIS to load data from various source systems such as database, excel, flat files (delimited and positional) others to target systems.
• Have extensive hands on experience on processing components such as tmap, tjoin, tsortrow, taggregaterow, taggregatesortedrow, tnormailze, tdenormalize .
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob, tfilelist, tparallelise etc.

Environment: : Talend 5.2.1(TIS), Oracle11g SQL, PLSQL,BO,Autosys,Unix.

Confidential

Senior Talend Developer

Responsibilities:

• Involved in and design, development testing of talend mappings.
• Involved in resolving the production issues.
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings.
• Understanding of Technical Specifications Documents.
• Maintaining proper code throughout the whole ETL process.
• Maintaining SLA for the new feeds on-boarded or procured.
• Tuned talend mappings for better performance on request.
• Involved primarily in release activities like DDL deployment and Hermes deployment in UAT and PROD.
• Developed jobs, joblets using TIS to load data from various source systems such as database, excel, flat files (delimited and positional) others to target systems.
• Have extensive hands on experience on processing components such as tmap, tjoin, tsortrow, taggregaterow, taggregatesortedrow, tnormailze, tdenormalize.
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.

Environment: : Talend 5.2.1(TIS), Oracle11g SQL, PLSQL,BO,Autosys,Unix.

Confidential

Talend Developer

Responsibilities:

• Involved in design, development and testing of talend mappings.
• Involved in resolving the production issues .
• Understanding of Technical Specifications Documents, High Level Design.
• Involved in Unit and integration testing of jobs and joblets and fixed invalid Mappings.
• Understanding of Technical Specifications Documents.
• Maintaining proper code throughout the whole ETL process .
• Maintaining SLA for the new feeds on-boarded or procured.
• Tuned talend mappings for better performance on request.
• Involved primarily in release activities like DDL deployment and Hermes deployment in UAT and PROD.
• Developed jobs, joblets using TIS to load data from various source systems such as database, excel, flat files (delimited and positional) others to target systems.
• Have extensive hands on experience on processing components such as tmap, tjoin, tsortrow, taggregaterow, taggregatesortedrow, tnormailze, tdenormalize.
• Have created reusable joblets.
• Custom codes have been implemented using creation of routines and components such as tjava, tjavaflex, tjavarow.
• Have used Orchestration components like tflowtoiterate, tpre and tpostjob, trunjob, tfilelist, tparallelise etc.

Environment: : Talend 5.2.1(TIS), Oracle11g SQL, PLSQL,BO,Autosys,Unix.

Confidential

Informatica Developer

Responsibilities:

• Performed requirement analysis, designing, implementation, testing for the ETL requirements.
• Creation of Complex Mappings, Sessions and Workflows for the ETL requirements requested by the clients.
• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Load operational data from Oracle, SQL Server, flat files.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.

Environment: : Informatica 8.6, Oracle11g SQL, PLSQL.