SUMMARY

• Over 7 + years of experience in Information Technology with a strong background in Database development and Data warehousing and 7 years ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2 , Power Exchange using Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Expertise in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling.
• Worked on Repository Server Administration Console, Informatica Power Center Transformations, informatica PowerConnect,, such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer, Union and XML Source Qualifier,Taradata.
• Experience in implementing Slowly Changing Dimensions (Type1, Type2 and Type3) mappings.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link.
• Experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports and SAP.
• Extensively executed SQL queries on Oracle using Toad and SQL Server tables in order to view successful transaction of data and to validate data.
• Experience in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in using the Informatica data quality command line utilities like pmcmd to execute Workflows in non - windows environment.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.6/8.1/7.1/6.1 , Power Mart 6.2/5.1, Informatica PowerConnect,OLAP, OLTP

Data Modeling: ER Model, Dimensional Data Modeling, Ralph-Kimball Methodology, Bill-Inman Methodology,Star Schema Modeling,Snow-Flake Modeling.

Reporting Tools: Business Objects 6.5/6.1, Crystal Reports

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008r2, Teradata (Fast-Load, Multi-Load, Fast Export), SFDC, MS Access, MS Excel, flat filesDB Tools TOAD, SQL Developer, SQL * Plus, Maestro Job Scheduler.

Languages: VB, Java, SQL, PL/SQL, UNIX Shell Scripting, XML, COBOL

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

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

ETL Developer

Responsibilities:

• Working with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions
• Designed the mapplets while focusing on code reusability in order to enable future data migration to newer target systems.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Used Ralph Kimball Methodology for building the data warehouse.
• Worked with various active transformations in Informatica PowerCenter with B2B like Filter Transformation, Aggregator Transformation, Joiner Transformation,Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.Developed the mapplets to support data migration.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• I have good experience in web services HUB with SDFC integration experience.
• Worked with re usable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, Std Deviation in the Aggregator Transformation.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation
• Extensively use Power Exchange to extract data from MQ series.
• Extensively used SQL Override function in Source Qualifier Transformation,SAP, Sybase. Data stage.
• Responsible for migrating the workflows from development to production environment
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Used the command line program pmcmd to run Informatica jobs from command line. And used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.
• I have experience in Pervasive and Data Conversion.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica power center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Teradata, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), power Exchange, Data Explorer, informatica PowerConnect,teradata, Data Quality, Control M, Micro Strategy, DB2 UDB 8.1, MQ Series, Cobol, PL/SQL,Oracle 11g/ 10g, Netezza 6.0.4. Flat Files, XML and perl script.

Confidential, Dublin, OH

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Prepared a handbook of standards for Informatica code development.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Developed Custom metadata repository.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, Sybase and Oracle sources.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings. Configure Informatica Servers for better Performance and ODBC drivers for source.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• I have good experience in developement and implement applications using ETL-SSIS and SSRS. Oracle data integrator.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• I Supporting material that address changes in existing processes or new processes introduced by Facets v5.01.
• I have good experience in web services.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX.

Environment: Informatica PowerCenter 9.1/8.6/8.1.1/7.1.3 , Oracle 10g/9i/8i, SQL Server 2000, Netezza 6.0.4 PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, UDB, Sybase, XML, Windows, Linux and HP-UNIX, Pentaho data Integrator,Teradata. ESP JOB, Mainframe.

Confidential, Georgia

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirement based on changing need.
• End-to-end ETL development of the Premium Module Data Mart.
• Designed and developed Star and Snow Flake Schema in Data warehouse.
• Used Informatica Designer to create complex mapping using different transformation like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformation to move data to a Data warehouse.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Wrote many SQL/PLSQL scripts to verify data in the DB. Taradata.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Provided technical support to internal users of Data Mining products.
• Extracted data from shipping department to flat files and load the data to the target database.
• Worked on performance tuning for ETL processes.
• Worked with many existingInformaticaMappings to produce correct output.
• Extracting, Scrubbing and Transforming data from Flat Files, Oracle, SQL Server, and then loading into Oracle database using Informatica.
• Translated business requirement to technical specifications and developed Informatica mapping/Workflows.

Environment: Informatica 8.6/8.1, SQL, PL/SQL, Oracle 9i, Erwin 7.0, DB2, Autosys, SQL Server 2000, Sybase.

Confidential, Oklahoma City, OK

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirement based on changing need.
• End-to-end ETL development of the Premium Module Data Mart.
• Designed and developed Star and Snow Flake Schema in Data warehouse.
• Used Informatica Designer to create complex mapping using different transformation like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformation to move data to a Data warehouse.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• I have good experience in developement and implement applications using ETL-SSIS and SSRS.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Provided technical support to internal users of Data Mining products.
• Extracted data from shipping department to flat files and load the data to the target database.
• Worked on performance tuning for ETL processes.

.Environment: Informatica PowerCenter 8.1, Oracle10g, XML, PL/SQL, Unix.

Confidential, Mason, OH

ETL DEVELOPER

Responsibilities:

• Extracted data form Flat Files, applied business logic to load them in the central Microsoft SQL Server database.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure and Sequence generator, Joiner, Union and Normalize.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Performed Optimization at both the Mapping Level and Session Level.
• Used Debugger making use of Breakpoints to monitor data movement and troubleshoot the mappings.
• Implemented Error Processing for Informatica Mappings and Workflows.
• I Supporting material that address changes in existing processes or new processes introduced by Facets v5.01.
• Effectively documented all Development work done.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Successfully moved the Sessions and Batches from the development to production environment.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Reviewing the ETL process design & ETL design documents with the business analysts, end users, data quality team and enterprise test team.
• Interacting with client in weekly meetings, status meetings.

Environment: Informatica PowerCenter 7.1, Oracle 9i, Windows XP/2000.

Confidential

ETL Developer

Responsibilities:

• Designed and developed mappings using aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Talend
• Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
• Created and populated the intermediate aggregate tables to make the reporting efficient and fast.
• Designed processes to extract, transform, and load data to the Data Mart with B2B.
• I have experience in Pervasive and Data Conversion.
• Worked on ETL Design for developing optimized ETL scripts
• Loaded data into Oracle using Talend Open Studio for Data Integration
• Worked closely with the source team and users to validate the accuracy of the mapped attributes
• Troubleshoot and created automatic script/SQL generators.
• Checked the quality of data loaded into Target tables and assured the performance of system.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues
• Rolled out documentation for the ETL Process

Environment: Talend Open Studio for Data Integration 5.1, ETL, Oracle 8i.