SUMMARY:

• Around 8 years of IT experience in the analysis, design, development and testing of data warehousing applications using Informatica Power center.
• Experience in all the phases of data warehouse life cycle involving Requirements gathering, Analysis, Design, Development and Testing.
• Extensively worked with various components of the Informatica Power Center - PowerCenter Designer, Repository Manager, Workflow Manager, and Workflow Monitor to create mappings.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
• Integrating data from various sources ranging from Flat files, Oracle, SQL Server, COBOL and XML.
• Implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets.
• Experience in implementing Update strategies, Incremental loads and slowly changing dimensions.
• Implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings.
• Using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience in writing Test plans, Test cases, Unit testing, System testing and Integration testing.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Experience in PL/SQL programming: Procedures, Functions, Packages, and Triggers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1(Designer, Work flow Manager, Work Flow Monitor,Repository Manager and Informatica server)

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2000, DB2, and MS Access 2007

Languages: SQL, PL/SQL, UNIX, Shell Programming, XML

Operating Systems: Windows 2000/XP/NT/, HP UNIX

Scheduling Tools: CNTRL M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

ETL/Informatica Developer

Responsibilities:

• Interact with business users in the analysis, development and requirement gathering phase.
• Extracting the data from source systems and loading into the staging tables and then into data warehouse based on the business rules.
• Extensively used Informatica designer to create and manipulate source, target definitions, mappings, transformation, and mapplets.
• Used various transformations like Expression, Filter, Sorter, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, SQL and Joiner.
• Created reusable sessions and workflows using the workflow manager.
• Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Developed UNIX scripts and SQL scripts to configure the database tables to perform different kinds of checks.
• Performed Unit Testing and Created detailed Unit Test Document with all possible Test cases.
• Used Control-M for scheduling the Informatica workflows.
• Developed documentation for the ETL processes.

Environment: Informatica 9.5, Oracle 11g, Control-M, UNIX, Erwin, XML, SQL developer.

ETL/Informatica Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Created mapplets to use them in different mappings.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Sorter and Union to develop robust mappings in the Informatica Designer.
• Created and configured workflows and reusable sessions to load data from external sources into Oracle data warehouse using Informatica Workflow Manager.
• Used Control-M scheduling tool for scheduling UNIX shell script & Informatica jobs.
• Performance monitoring and tuning of Informatica mappings.
• Developed Unit test cases and Unit test plans to check data is correctly loading.
• Worked on different tasks in Workflow Manager like Sessions, E-mail, Command, Timer and Scheduling of the workflow.

Environment: Informatica 9.0.1, Oracle 11g, Control-M, UNIX, Toad, Erwin, Flat files, Excel files, XML, Windows 7/XP.

Informatica Developer

Responsibilities:

• Interacted with business users in the analysis, development and requirement gathering phase.
• Extracted data from various sources like Flat files, relational tables and loading into staging tables and then into data mart.
• Used various transformations like connected and unconnected lookups, update strategy, filter, and SQL, joiner and aggregator transformations to implement complex business logic.
• Created and configured workflows and reusable sessions to load data from external sources into Oracle data warehouse using Informatica Workflow Manager.
• Used Autosys scheduling tool for scheduling UNIX shell script & Informatica jobs.
• Written SQL queries, stored procedures on different databases (Oracle, IBM DB2,) for SQL overrides, Extractions, Updates
• Performance monitoring and tuning of Informatica mappings.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts and Expected Results.
• Modified existing mappings for enhancements of new business requirements.
• Used debugger to test the mappings and fixed the bugs.

Environment: Informatica Power Center 9.0.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, Erwin, Autosys, UNIX.

Jr. Informatica Developer

Responsibilities:

• Extracted data from various source systems and loading into data warehouse.
• Analyzed, identified, fixed bad data and imported data from Salesforce - CRM to Oracle.
• Used Informatica PowerCenter to create mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing.
• Documented Informatica mappings in Excel spread sheet.
• Created and Configured Workflows and Sessions to transport the data to target warehouse.

Environment: Informatica Power center 7.5, Oracle 9i, SQL, PL/SQL, and UNIX.