SUMMARY

• 6 years of extensive experience in IT industry in the areas of analysis, design, development in client server environment.
• With focus on Data warehousing applications using ETL and OLAP tools like Informatica, Oracle, SQL Server.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flatfiles,XML,Excel,Oracle,SQL Server.
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica,Talend (ETL).
• Excellent working on Talend ETL and developed Slow Changing Dimensions types.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures.
• Involved in the complete life cycle of the project.
• Developed jobs/joblets in TALEND Integration Studio
• Experience in UNIX Shell scripts and job scheduling on multiple platforms like Windows, NT/XP/2000 and LINUX.
• Experience in writing complex sql and creating stored procedures like SQL Server, Oracle, Teradata and MySQL.
• Used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Performance tuning of sources,targets,mappings and SQL quires in the transformations.
• Experience with data modeling, logical and physical database design using Erwin.
• Excellent Knowledge in Data modeling, Logical/Physical model & ER - Diagrams.
• Stored reformatted data from relational, flat file, XML files using Informatica.
• Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• DevelopingInformatica mappings & tuningthem when necessary.
• Optimizing Query Performance, Session Performance.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server, DB2, MySQL Sybase, Teradata.

ETL Tools: Informatica (Power Center 9x/8x/7x),SSIS, Talend 3.x/4.x/5x/6.x

Operating systems: Windows 9x/NT/2000/XP/XP2/XP Professional/7 LINUX, AIX 5.3/6.0, Red Hat Linux

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, JAVA (Eclipse IDE and Net Beans IDE, JAVA Script, CSS.

Methodologies: Data Modeling - Logical Physical, Dimensional Modeling - Star / Snowflake

Tools: &Utilities: SQL plus, TOAD, SQL developer,MicrosoftVisual Studio 2005/2008, Cygwin, Autosys, BTEQ, Facets,SQL developer 5.0, SQL Loader, Aginity Netezza Workbench.

Office Packages: MicrosoftOffice 2003/2007 (PowerPoint,Word,Excel,Visio Outlook)

BI Tools: Cognos 8, Query Studio,SSRS, Report Studio,Cognos Impromptu Cognos Power- Play/ Transformer, OBIEE, Micro strategy

Web: HTTP/HTTPS, SOAPUI,XML, Visual Web JSF.

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

Sr.ETL Developer

RESPONSIBILITIES:

• Reviewed the business and data requirements of the various source and destination systems involved in enterprise ETL.
• Developed jobs/joblets in TALEND Integration Studio.
• Developed the specification for the extraction, translation, and loading of source and destination data sets.
• Worked on Talend ETL tool and used features like context variable and database components like input toracle,output toracle,tFile compare,tFile copy, toracle close ETL components.
• Worked onSlowly Changing Dimensions (SCD\'s) and its implementation(Type1, Type 2, and Type 3)to keep track of historical data.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Involved in the preparation of Technical design documents, Source to target document and program specification.
• Wrote SQL Scripts to extract data from sql server and mysql databases.
• Used tMap feature by joining an input file and a database table,mapping and transforming the data to create a database table.
• Used the Expression, Aggregator, Filter, Joiner, Sorter transformations.
• Extracted data from flat files, XML files and MYSQL Server sources, created jobs to load them in the staging tables in SQL server.
• Involved in the creation of partitions in mapping to improve the performance of sessions.
• Identified bugs in existing mapping by analyzing the data flow and evaluating transformations.
• Involved in troubleshooting and resuming failed jobs.
• Created Reports different formats like HTML, PDF, EXCEL and Delimited Text.
• Worked on creating documents and Reports using Micro strategy suite of tools.

Environment: Talend 5.6.1/5.5, Oracle 10g/9i, MySQL, DB2, XML, Flat files, PL/SQL, SQL*Plus,JAVA Scripts,Web Services, Microsoft Office Windows, UNIX, Micro strategy.

Confidential, Dallas,TX

Sr.ETL Developer

RESPONSIBILITIES:

• Involved in designing and development ofdata warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Created and implemented target definitions based on Star schema design and developed aggregate tables to accommodate storage of summarized data.
• Created facts and dimensions for Data Ware house in Oracle and built Primary and Foreign key relationships.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Extracted data from different flat files like MS Excel, and transformed the data, based on user requirement using Informatica Power Center and loaded data into target.
• Worked on Informatica tool-Source Analyzer, Warehouse designer, Mapping & Mapplet Designers and Transformation Developer.
• Extensively used the concepts of ETL tool to load data from Oracle database and flat files to Oracle database.
• Used UNIX Shell Scripts to automate the bulk load & update Processes developed interfaces.
• Involved in Migrating metadata and reports from, Crystal reports, Cognos.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Wrote SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Worked on Talend ETL tool and developed Slow Changing Dimensions types.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error condition.
• Used SQL tools like TOAD to run SQL queries and validated the data.
• Documented the mappings, ETL processes and the performance tuning steps followed in development and production environments.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g/9i, TALEND Integration Suite,Cognos,DB2, XML, Flat files, SQL,PL/SQL,TOAD,Perl,SQL*Plus,Windows, UNIX.

Confidential, Richardson, TX

Sr.ETL Developer

RESPONSIBILITIES:

• Interacted with the client to understand the business requirements.
• Involved in Analysis,Designand Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Developed complex mappings using Informatica Power Center Designerto transform and load the data from various source systems like XML files, Flat files, Oracle, MYSQL, DB2 and SYBASE to Oracle target database.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Handleslowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Involved in Performance tuningfor sources, targets, mappings and sessions.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Created complex PL/SQLstored procedures and functions.
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, and various other applications.
• Worked cooperatively with the team members to identify and resolve various issues related to Informatica and other database related issues.
• Performed data conversions from SQL server to flat file using SSIS.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Used SQL tools like TOAD to run SQL queries and validated the data.
• Worked on designing and developing STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Implemented JavaScript to add functionality to report in report studio.
• Identified and created various classes and objects for report development.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g/9i, Talend 3.x/4.x/5x/6.x, DB2, XML,fFlatfiles,SQL,PL/SQL,TOAD,SSIS,SQL*Plus,JAVA Scripts,Windows, Cognos,UNIX.

Confidential

ETL Developer

RESPONSIBILITIES:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with different sources such as Oracle, SQL and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center (ETL),Oracle, ERWIN, SQL, Flat files,Windows .

Confidential

ETL Developer

RESPONSIBILITIES:

• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Extensively worked on Informatica Designer Componenta - Source Analyzer, Warehousing Designer, and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Working experience in using Oracle, SQL Plus, ERWIN,Windows XP/2000/98/95,
• A basic understanding and experience with OBIEE,BO,cognos.
• Wrote SQL Scripts to extract data from Database and for Testing Purposes.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team.
• Understanding, flexible, and adept at working in high paced environments, adapting quickly to different business organizations needs.

Environment: Informatica Power Center,Oracle,SQLServer,MSAccess,ERWIN,Windows.