PROFESSIONAL SUMMARY:

• 7+ years of professional experience in warehouse project and ETL/MDM with Talend, Pentaho and Informatica.
• Hands on experience in Talend MDM for creating data model, data container, views and workflows.
• Used different components in Pentaho like Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence
• Used different components in talend MDM like tMDMInput, tMDMOutput, tFilterRow.
• Created complex mappings in Talend 5.2.2 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Broad design, development and testing experience with Talend Integration Suite & Talend MDM and knowledge in Performance Tuning of mappings.
• Proficient in supporting Data warehouse ETL activities using queries and functionalities of SQL, PL/SQL,SQL*Loader and SQL * Plus. Solid experience in implementing complex business rules by creating re - usable transformations and robust mappings/mapplets using various transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Talend Platform Setup on Windows and Linux.
• Experience in working on Talend Administration Activities and Talend Data Integration ETL Tool.
• Highly experienced in row and column oriented databases and also experienced in SQL performance tuning and debugging of existing ETL process
• Familiar with design and implementation of the Data Warehouse life cycle and excellent knowledge on entity-relationship/multidimensional modeling (star schema, snowflake schema).
• System design architecture, Data ware house design, ingestion
• Development of staging, Data warehouse scripts and deployment.
• Experience on MySQL Database and Teradata Administration on Linux and Windows.
• Experience on MSSQL Server Database Development and Administration
• Coordination with Offshore team, providing them guidance and clarifications related to reports, underlying queries
• Experience in analysis, design, and development using Amazon Redshift.
• Extensive expertise in Data Warehousing, ETL design and development process using Talend and Informatica Power center.
• Datamart and Power Center and informatica-IDQ (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).
• Experience on Teradata development and performance tuning.

TECHNICAL SKILLS:

Languages: C#, Java, C/ C++, HTML, SQL, PLSQL

Databases: Oracle 11G, SQL Server2008/ 2012, Mongo DB, Amazon RedshiftMySQL, MDM, Teradata.

Tools: Pentaho 4.x, 5.x, Talend 5.4.1, Talend MDM, Informatica

9.1/8.6/8.1/7.1/6.1

Informatica: IDQ SQL Navigator, TOAD, Eclipse, Jasper Studio 5.5Jasper Server 5.5

Operating Systems: Windows, Linux, Solaris

Web Technologies: HTML, CSS, Java Script, Macromedia Dreamweaver

Reporting Tools: Business Objects 6.5/6.1, Crystal Reports

Middleware: Web Services, Talend SOA, Oracle SOA

Industry Verticals: Retail, Manufacturing, Healthcare, telecom

PROFESSIONAL EXPERIENCE:

Confidential, New York

Data Warehouse Developer

Responsibilities:

• System design architecture, Data ware house design, ingestion
• Analyzed business requirements to design, develop, and implement highly efficient, highly scalable Pentaho/ Talend ETL processes.
• Developed the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Pentaho
• ETL design and development, Creation of the Pentaho ETL mappings, and workflows to implement the Business Logic.
• Used different components in Pentaho like Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc
• Developed complex jobs in Pentaho to move the ETL jobs from Informatica.
• Development of staging, Data warehouse scripts and deployment
• Writing specifications for ETL processes
• Validating customer requirements, performing analysis to fit in the Jasper reports framework
• Design of Jasper embedded report components to embed them into customer’s application
• Development of Jaspersoft reports, dash boards UI components, writing complex queries to support the interactive reporting logic
• Development of reports using various chart types
• Coordination with Offshore team, providing them guidance and clarifications related to reports, underlying queries
• Perform validation check and deployment of reports to customer’s staging environment Client, Business objects.

Environment: Talend Integration Suite 5.5, Pentho 5.4, Oracle 10g, PL/SQL,TOAD, XML Files, Unix

Confidential, BOSTON, MA

Talend ETL/MDM Developer

Responsibilities:

• Designed and developed a new ETL process to extract and load Vendors from Legacy System to MDM by using the Talend Jobs.
• Talend MDM 5.1.1.Designed and developed the Business Rules and workflow system.
• Developed Talend ETL jobs to push the data into Talend MDM and develop the jobs to extract the data from MDM.
• Developed data validation rule in the Talend MDM to confirm the golden record.
• Developed data matching/linking rules to standarize the record in Talend MDM.
• Writing specifications for ETL processes.
• Installation and configuration of MySQL database servers and Amazon Redshift.
• Experience in Talend MDM for functionality integration and creating data model, data container, views and workflows.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Rolled out documentation for the ETL Process, early Data Inventory, and Data Profiling
• Implementing Data Integration process with Talend Integration Suite 3.2/4.2./5.1.2/5.2.2
• Designing, developing and deploying end-to-end Data Integration solution.
• Used different components in talend like tmap, tmssqlinput, tmssqloutput, tfiledelimitede, tfileoutputdelimited, tmssqloutputbulkexec, tunique, tFlowToIterate, tintervalmatch, tlogcatcher, tflowmetercatcher, tfilelist, taggregate, tsort, tMDMInput, tMDMOutput, tFilterRow.
• System design architecture, Data ware house design, ingestion
• Development of staging, Data warehouse scripts and deployment
• Led a team of 5 developers working on BI reports, one UI specialist
• Coordinated with onsite and Offshore team located in India
• Extensively worked on Data Mart Schema Design.
• Developing the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Talend ETL
• Extensively worked on Data Mart Schema Design.
• Working with Healthcare EDI 834.
• Backup / Restore of databases and Writing Complex Queries
• Experience on Teradata development and performance tuning.
• Analysis, design, development using Amazon Redshift.
• Used efficient optimization techniques to design ETL Scripts.
• Loaded data into Infobright using Talend, FastLoad, MultiLoad, and shell scripts.
• Validating customer requirements, performing analysis to fit in the Jasper reports framework
• Design of Jasper embedded report components to embed them into customer’s application
• Development of Jaspersoft reports, dash boards UI components, writing complex queries to support the interactive reporting logic
• Development of reports using various chart types
• Coordination with Offshore team, providing them guidance and clarifications related to reports,underlying queries
• Perform validation check and deployment of reports to customer’s staging environment

Environment: Talend Integration Suite 5.4.1, Talend MDM, Informatica Power enter 9.1, Informatica-IDQ,, Oracle JDE 9.1, Microsoft SQL Server 2008, Oracle 9i,Teradata, DB2, TIBCO, Robot Scheduler, Windows XP, Flat Files

Confidential, Philadelphia, PA

Pentaho/Talend MDM Developer

Responsibilities:

• Developed Talend ETL jobs to push the data into Talend and develop the jobs to extract the data from MDM.
• Developed the ETL mappings for XML, .csv, .txt sources and also loading the data from these sources into relational tables with Pentaho
• ETL design and development, Creation of the Pentaho ETL mappings, and workflows to implement the Business Logic.
• Used different components in Pentaho like Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc
• Developed complex jobs in Pentaho to move the ETL jobs from Informatica.
• Designed and developed a new ETL process to extract and load Vendors from Legacy System to MDM by using the Talend Jobs.
• Talend MDM 5.1.1.Designed and developed the Business Rules and workflow system.
• Developed data validation rule in the Talend MDM to confirm the golden record.
• Developed data matching/linking rules to standarize the record in Talend MDM.
• Writing specifications for ETL processes.
• Installation and configuration of MySQL database servers and Amazon Redshift.
• Experience in Talend MDM for functionality integration and creating data model, data container, views and workflows.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Rolled out documentation for the ETL Process, early Data Inventory, and Data Profiling
• Implementing Data Integration process with Talend Integration Suite 3.2/4.2./5.1.2/5.2.2
• Designing, developing and deploying end-to-end Data Integration solution.
• Used different components in talend like tmap, tmssqlinput, tmssqloutput, tfiledelimitede, tfileoutputdelimited, tmssqloutputbulkexec, tunique, tFlowToIterate, tintervalmatch, tlogcatcher, tflowmetercatcher, tfilelist, taggregate, tsort, tMDMInput, tMDMOutput, tFilterRow.
• System design architecture, Data ware house design, ingestion
• Development of staging, Data warehouse scripts and deployment
• Writing specifications for ETL processes
• Validating customer requirements, performing analysis to fit in the Jasper reports framework
• Design of Jasper embedded report components to embed them into customer’s application
• Perform validation check and deployment of reports to customer’s staging environment
• System design architecture, Data ware house design, ingestion
• Development of staging, Data warehouse scripts and deployment
• Installation and configuration of MySQL database servers.
• Good experience in T-SQL Querry.
• Loaded data into Infobright using Talend, Fast Load, and Multi Load.
• Experience on Teradata development and performance tuning.
• Worked on Star Join Schema Modeling, Snow Flake Modeling
• Worked closely with the source team and users to validate the accuracy of the mapped attributes.
• Monitoring System Performance.
• Writing SQL code and code review for evaluating the data quality.
• I have good experience in Jquery and java development with iway concept.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues
• Backup / Restore of databases and Monitoring System Performance
• Good working experience in MDM Developer and Rolled out documentation for the ETL Process, early Data Inventory, and Data Profiling

Environment: Talend MDM, Talend Integration Suite 4.1, Informatica PowerCenter 8.6.1, Oracle 11g,Teradata, UNIX Shell, PL/SQL, SQL * Plus, SQL * Loader, TOAD, Windows, UNIX, XML, flat files

Confidential, Dublin, OH

ETL Engineer

Responsibilities:

• Implementing Data Integration process with Talend Integration Suite 3.2/4.2./5.1.2/5.2.2
• Designing, developing and deploying end-to-end Data Integration solution.
• Used different components in talend like tmap, tmssqlinput, tmssqloutput, tfiledelimitede, tfileoutputdelimited, tmssqloutputbulkexec, tunique, tFlowToIterate, tintervalmatch, tlogcatcher, tflowmetercatcher, tfilelist, taggregate, tsort, tMDMInput, tMDMOutput, tFilterRow.
• System design architecture, Data ware house design, ingestion
• Development of staging, Data warehouse scripts and deployment
• Validating customer requirements, performing analysis to fit in the Jasper reports framework
• Design of Jasper embedded report components to embed them into customer’s application
• Perform validation check and deployment of reports to customer’s staging environment
• Created Talend & Informatica mappings for initial load and daily updates and also involved in the ETL migration jobs from Infromatica to Talend.
• Developed several mappings (Source Qualifier, Lookup, Filter, Joiner, Aggregate, Sequence

Environment: Talend Integration Suite 4.0, Informatica 8.6.1, Oracle 11g, SQL Developer Client, SQL Server 2008/2005, Serena ChangeMan Dimensions Desktop Client 3.1.3.3, HP Quality Center

Confidential

ETL Developer

Responsibilities:

• Involved in the product performance Turing right from the inception to installation on production servers.
• Installation and configuration of MySQL database servers.
• Backup / Restore of databases.
• Involved in 64 bit environment compatibility verification
• The job requirements included installation of the product right from the OS to the product including Apache, Tomcat, and Databases.
• Was involved in smoke testing, integration testing, load tests, performance testing, writing and executing test cases, and preparing bug reports.

Environment: Informatica 7.1.4, Oracle, MS SQL, UNIX, Windows XP, TOAD