SUMMARY

• 7+ years of strong Data Warehousing experience using Informatica PowerCenter 8.x//7.x/6.x/5.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 7x/6x, Power Connect, Power Exchange.
• Extensive experience in Banking, Insurance, Pharmacy, Financial, Retail and Healthcare domains.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.
• Experienced in complete life cycle Implementation of data warehouse.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin, Visio
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Involved in different database modeling techniques like Object Oriented Design and Modeling, Database Design and Modeling, etc.
• Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
• Extensively worked with Oracle PL/SQL Stored Procedures, Triggers, Functions, Packages and also involved in Query Optimization.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2008/2005/2003 , Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
• Expertise in Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments, managing Users, Groups, associated privileges and performing backups of the repository.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Expertise in using UNIX and writing Perl and UNIX shell scripts.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End - user training and Production support.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
• Experienced in developing SSIS packages for processing fact and dimension tables.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 8x/7x/6x, Informatica PowerMart 7x/6x Informatica PowerExchange 7.x/8.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor.

Databases: Oracle11x/10g/9i/8i/7.3,Sybase12.0/11.x/10,TeradataV2R5/V2R4/V2R3 (Fast-Load, Multi-Load, T-Pump, BTEQ), DB2 UDB 8.0/7.0/6.0, MS SQL Server 2008/2005/2000/7.0/6.5/6.0 , MS Access 2003/2000/97/7.0.

BI Tools: Cognos 8.4/7.1/6.0 (Impromptu, Power Play, Transformer), Business Objects XiR3/XiR 2/6.0/5.1/5.0 , Crystal Reports 4.0/6.0.

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Denormalization

Programming: C, C++, Visual Basic, Unix Shell Scripting, SQL, T-SQL, and PL/SQL, HTML, XML.

Environment: Windows XP/2000/98, Win NT, UNIX(SunSolaris10, HP,AIX Linux), MS-Dos

Other Tools: SQL*Plus, Toad, SQL Navigator, Putty, Ms-Office.MS VISIO.

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr Informatica Developer

Responsibilities:

• Worked as a Business analyst, Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification documents.
• Involved in creating logical and physical data models using MS Visio based on business requirements.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server...etc into the Staging table and then to the target database Oracle.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Re-designed ETL mappings to improve data quality.
• Used Korn-Shell Scripting to automate the loading process.
• Created Stored procedure transformations to populate targets based on business requirements.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.
• Developed the pre & post session shell scripts, which will create the parameter file dynamically.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensive use of Persistent cache to reduce session processing time
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Within specified time, projects are delivered making sure all the requirements gathering, business analysis and designing of the data marts.
• Project and Version management using PVCS Version Manager.
• Involved in Unit and Integration testing of Mappings and sessions.
• Developed Schedules for daily and weekly batches using Unix Maestro.
• Prepared ETL mapping specification document.
• Assisted Testing team in creating test plan and test cases.
• Involved in creating multi dimensional universe and reports in Business Objects Environment.
• Used BRIO reporting tool to generate reports. And also created and run BRIO SQR Programs.
• Designed and developed ad-hoc and customized reports using Cognos 8.
• Created Informatica mappings with PL/SQL Procedures/Functions and triggers in T-SQL to build business rules to load data.

Environment: Informatica Power Center 8.6.1, Oracle 11i, MS SQL Server 2008, MS Visio, Toad, Power exchange 8.1, Business objects XiR3/XIR2/6.5/5.0, Hyperion BRIO reporting, ERWIN 4.2, Control-M.

Confidential, New York

Sr. Informatica Developer

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Participated in designing the data model using Erwin.
• Used Informatica Designer to create, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
• Developed PL/SQL stored procedures and triggers in T-SQL for various data cleansing activities.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Also used Data Integrators to club data from different kind of sources.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Done powerful data profiling and mapping capabilities by using Informatica Data Explorer, to empower data analysts to investigate and document data quality issues.
• Involved in Version control of code from development to test and Production environments.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets, and Transformation objects.
• Developed UNIX shell scripts using PMCMD and PMREP utilities and scheduled ETL load using Maestro.
• Extensive use of Persistent cache to reduce session processing time.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Developed BTEQ scripts to load data from Teradata Staging area to Data warehouse, Data warehouse to data marts for specific reporting requirements.
• Tuned the existing BTEQ script to enhance performance.
• Partitioned sessions for concurrent loading of data into the target tables of Teradata.
• Involved in moving Mappings, Sessions and Workflows between development and production environments.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Server Manager.
• 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.
• Integrated data mart with Hyperion BRIO reporting tool. Used BRIO object models.
• Developed complex dashboard reports using Report Studio.
• Designed & developed reports, Drilldown reports using Business Objects Reporter.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Prepared Run books providing guidelines to troubleshoot the errors occurred during the run time and instructions on how to restart the loads.
• Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power center 8.6.1, DB2, SQL Server 2008, Oracle 11i/10g, Business Objects XiR3/XIR2/6.5/5.0, PL/SQL, Power exchange 8.1, TOAD, Windows XP, UNIX maestro, ERWIN 4.2,, Hyperion BRIO reporting.

Confidential, Camden, NJ

ETL Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Created ETL detail design document and ETL standards document.
• Created Repository using Informatica Power Center - Repository Manager.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on SQL queries and tuned them to improve performance.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Performed data manipulation using basic functions and Informatica Transformations.
• Developed various reports using Cross Tab, Master Detail and different charts including Line, Column, Area, and Pie Charts for analysis.
• Modified Universes and generated reports using Business Objects.
• Designed & developed reports, Drilldown reports using Business Objects Reporter.
• Designed reports with Slice and Dice & Drill down operations.

Environment: Informatica PowerCenter 7.1.1, Oracle 8i, SQL Server, ERWin 3.5, Business Objects 5.1, UNIX (AIX), Windows NT