Professional Summary

• 7 plus years of experience working in all the phases of the Data warehousing life cycle including Analysis, design, development, testing and Implementation.
• Experience working with various source systems/files like RDBMS DB2,Oracle,SQL Server, Teradata Flat Files, XML Files etc..
• Proficient in databases including DB2 , Oracle 11g/10g/9i /8i, Teradata, MS SQL Server, MS Access.
• Proficient in using tools like Microsoft Visio, Microsoft Project, Microsoft Office Excel,Access,Word, PowerPoint .
• Experienced working on Ralph Kimball Inmon Appoach.
• Extensive experience in handling ETL using Informatica Power Center 9.x/8.x/7.x
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer,
• Transformation Developer, Mapplet and Mapping Designer
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow Worklet Designer
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter,Ranker Joiner, Stored Procedure, Update Strategy etc and Re-usable transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load.
• Good experience in performing Integration testing, System testing, Unit testing and User Acceptance testing.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Extensively involved in performance tuning of Informatica mapping and sessions by reducing Data Flow, Eliminating I/O bottlenecks, optimize resources, optimize common ETL processes and data parallelism.
• Extensive experience in error handling and problem fixing in Informatica
• Strong Knowledge of Star and Snow Flake Schemas.
• Excellent knowledge in Creating database objects like Stored Procedure, Views, packages, functions and Triggers using PL/SQL
• Good knowledge of UNIX Shell Scripting
• Ability to prioritize multiple tasks
• Self-motivated and able to work independently and as a member of a team
• Excellent communication, interpersonal and analytical skills

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer,

Project Responsibilities included:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Participated in developing logical and physical data models that capture current state/future state data elements and data flows.
• Created complex reusable transformations and mapplets in Transformation Developer, and Mapplet Designer, respectively.
• Involved in Performance Tuning of Sessions and Mappings.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Worked extensively on different types of transformations like normalizer, lookup,rank,expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and developed Complex mappings like Slowly Changing Dimensions Type 2 Time Stamping to maintain full history of transactions.
• Created Workflows, re-usable Sessions using Workflow Monitor.
• Performed Performance tuning and also have used debugger to troubleshoot errors.
• Loaded data to and from Flat files and databases like Oracle, SQL Server and DB2.
• Developed PL/SQL stored procedures/functions and Unix Shell Scripts as a part of the project.
• Widely used Parameter file to override mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.1/8.6, Workflow Manager, Windows Server 2003,Erwin4.0, Oracle 11g/10g, SQL server, XML,SQL,PLSQL, Unix Shell Scripts,Flat Files, Windows NT

Confidential

Informatica Developer,

Project Responsibilities included:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Design of HLD/LLD and Job-Linkage Diagrams of the documents for various interfaces using MS-Visio.
• Interacted with business users to gather requirements and understand business logic/other features expected from ETL and Reporting system.
• Involved in the data analysis for source and target systems.
• Integrated various data sources like Oracle, Fixed Width and Delimited Flat Files, DB2, COBOL files XML Files.
• Identified the flow of information, analyzed the existing systems and evaluated the alternatives.
• Designed and developed mappings based on the requirements using Informatica Power Center.
• Involved in Performance Tuning of Sessions and Mappings.
• Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, look up, Sequence Generator, Router, Sorter and Stored Procedures etc.
• Developed Sessions and Workflows for the project.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Worked with Informatica PowerConnect to get data from PeopleSoft XLATTABLE table and modules like General Ledger, Accounts Payable, Accounts Receivable, and Asset Management.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring.
• Used debugger to test the mappings and fix the bugs.
• Performed Perfomance Tuning, Testing as a part of the project.
• Performed Defect analysis and fixed the issues raised by end users
• Created mappings involving Slowly Changing Dimensions SCD Type 2 as a part of the project.
• Created PLSQL Procedures/Unix Shell scripts as a part of the project.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2, SQL,PL/SQL, Test Director, Erwin, TOAD SQL Loader, Autosys, Windows, UNIX.

Confidential

Informatica Developer,

Project Responsibilities included:

• Worked closely with Business Analyst and Data Architect in analyzing the source systems and preparation of ETL specifications for Data warehouse.
• Used Informatica ETL tool for extracting, transformation, cleansing, and loading of data from source to target
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Responsible for weekly status updates showing the progress of the ETL process.
• Extracted Customer data from XML and oracle database as source data.
• Parsed all corporate Flat file feeds , which are sent from external customers and loaded into Oracle .
• Widely used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Involved in Performance Tuning of Sessions and Mappings.
• Created/Scheduled Batches and Sessions using the Workflow Manager.
• Used Autosys 3.0 to schedule UNIX shell scripts, PL/SQL scripts and Informatica jobs
• Interacted with the end users and resolved any Application/Informatica related issues.
• Documented Process Flow for mappings and sessions
• Performed UAT and regression tests prior to Informatica code being placed in production environment.

Environment: PowerCenter8.6, Oracle9i, Excel, SQL,Server,SQL, PL/SQL,SQL Plus,UNIX, Autosys,Microsoft Office, Microsoft Visio,Windows 2003.

Confidential

Informatica Developer,

Project Responsibilities included:

• Analyzed Business/ functional Specifications and worked with Business Analyst team and identified the source data and transformation logic needs and review of final mapping documents. Also, participated in the review meetings/ project check in and user requirement gathering meetings.
• Design of HLD/LLD and Job-Linkage Diagrams of the documents for various interfaces using MS-Visio.
• Handled slowly changing dimensions of Type I, Type II to populate current and historical data to Dimensions tables in the data warehouse.
• Understanding existing business model and customer requirements.
• Worked on ETL tool Informatica to create maps and transformations.
• Involved in Performance Tuning of Sessions and Mappings.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer Mapplet and Transformations.
• Used Filter, Router, Aggregator, Lookup, Expression Update Strategy etc. transformations whenever required in the mapping.
• Involved in creation of sessions and scheduling of sessions.
• Created PLSQL Procedures as a part of the project

Environment: Oracle9i, Powercenter7.1/8.6,Cognos, SQL Plus,SQL, PLSQL, Windows NT