PROFESSIONALSUMMARY:

• 8 years of strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 9.x, 8.x,7.x,6.x
• Experience in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing reporting tools
• Strengths in Informatica Transformations such as Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedures, Normalizer, xml Transformation.
• Experience on Informatica designer tools like transformations, reusable transformations, mappings, mapplets, and workflows. Worked closely with Slowly Changing Dimensions Type I, Type II and Type III .
• Extensive experience creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources Oracle, SQL server, Flat files to targets persistent data stores.
• Strong knowledge in RDBMS Concepts, Dimensional Data Modeling Star Schema, Snow-flake Schema, FACT and Dimension tables , Logical and Physical Data Modeling.
• Heavy SQL/Database developer experience in writing efficient SQL queries, PL/SQL Scripts, stored procedures fine tuning queries, and writing SQL queries for adhoc reporting and Cognos, BO, OBIEE reporting tools.
• Created Workflows with event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Experience in UNIX Shell Scripting in order to fetch the input files and archive them for the Power center usage
• Worked on Parameter files to pass parameter and connection string in case of Oracle table as the source or target
• Extensive experience in performance tuning, identified and fixed bottlenecks, and tuned the complex Informatica mappings for better performance.
• Experienced in administrative work by creating users, user groups, folders, configure security and giving permissions in folders and to users in Repository manager.
• Involved in debugging the failed mappings and developing error handling methods experience monitoring schedules, running, completed and troubleshooting failed sessions.
• Excellent written and communication skills, analytical skills with ability to perform independently and in a team.

EXPERIENCE:

Confidential

ETL Developer Informatica

Responsibilities:

• Team member of the Data Warehousing module. Involved in designing, developing and documenting of the ETL Extract, Transformation and Load strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Java, SQL, Transaction control, Source qualifier, Look up connected and unconnected , Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked with database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations aggregations and created target mappings that contain business rules.
• Extensively used Informatica MDM for match and merge process.
• Built some preventive rules for the match and merge data according to PPDM rules.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Implemented Change Data Capture CDC to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions SCD to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
• Developed control-m scripts for scheduling in CONTROLM
• Responsible for raising tickets and request of the project and been the root contact.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Wrote shell scripts and control files to load data into staging area and then into database tables.
• Provided extensive support in UAT user acceptance testing and deployment of mappings.
• Performed extensive testing on the mappings and wrote queries in SQL to check with the use HP-ALM tool to find whether the data was loading to the dimension tables and fact tables properly.
• Worked with third party Control-M scheduling Team for scheduling the Informatica PowerCenter Workflows.
• Documented and drafted major aspects of the project.

Environment: Informatica PowerCenter 9.1, Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor , Oracle 11g, SQL, TOAD,PL/SQL, SQL Server, Control-M,HP-ALM, Windows 7 and UNIX.

Confidential

Sr.ETL Developer Informatica

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files and loading into Staging and Data Ware House Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed Type1 and Type2 mappings
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Implemented Incremental load logic.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre Post Session SQL
• CreatedScript to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Scheduled Informatica workflows to run at regular intervals.
• Used SQL tools likeQuery Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.1 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, Oracle 11g, MS SQL Server 2005/2008, SQL,PL/SQL,T-SQL, Windows XP, Unix, Cognos, Tidal.

Confidential

Sr.ETL Developer Informatica

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings.
• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse
• Used all the Informatica client components like Designer, Workflow Manger Monitor, Repository Manger, and Admin Console
• Worked extensively with various Passive transformations in Informatica Power Center like Expression, Sequence Generator, and Lookup Transformation
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented
• Worked with SCDs slowly changing dimension Type 2
• Responsible for performance tuning at various levels like mapping level, session level, and database level
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Worked on Designer Tools: Source Analyzer, Warehouse, Transformation Developer, Mapplet and Mapping Designer.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Used Source Qualifier Transformation, and used most of its features like router, sorter, and SQL Override.
• Performed complex SQL queries on Source tables in Oracle 11g.
• Used Router transformation whenever multiple filters are there in the mapping design
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Creating source and target table definitions using Informatica Designer.
• Wrote pre-session shell scripts to check session mode enable/ disable before running/scheduling batches.
• Wrote post-session shell scripts to check status failure/success after completion of all batches
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Responsible for Unit Testing and Integration Testing of mappings and workflows.
• Worked with third party CA Autosys scheduling Team for scheduling the Informatica PowerCenter Workflows

Environment: Informatica Power Center 9.0.1 Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer , Oracle 11g, SQL Server, Sybase, Access, Flat Files, SAP Business Objects, AIX UNIX, Windows XP, CA Autosys Scheduler.

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems

• Responsible for Informatica ETL development DAC Execution Plan creation. In order to develop OBIEE report, implemented star schemas.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Worked on Informatica Power Center 8.6 tools - Source Analyzer, Mapping Designer, Power Exchange and Transformations.
• Extracted source data using power exchange from Siebel System.
• Created complex mappings using Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner.
• Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, and Source Qualifier Transformations in the Informatica Designer.
• Developed Informatica mappings, sessions and workflows for all mappings.
• Implemented Type II slowly changing dimensionto keep a full history of dimensional data in the tables.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Used SQL tools like SQL Plus to run SQL queries and validate the data pulled in OBIEE reports.
• Used debugger to trace errors in the mapping.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Worked on creating and customizing DAC Datawarehouse AdministrationConsole Tasks, Subject Areas and Execution plans to load data from Siebel CRM application to Siebel Relationship Management Warehouse SRMW using Informatica PowerCenter 8.6 pre-built vanilla mapping.
• Created DAC Execution plan to schedule the Informatica mappings to load the data incrementally on a daily basis.
• Created BI Publishers in OBIEE Repositories. Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.

Environment Informatica PowerCenter 8.6, DAC 10.1.3.4, Siebel 8.1.1, OBIEE 10.1.3.4, Oracle 10g, SQL Plus, TOAD, BI APPS 7.9.6

Confidential

Sr. ETL Developer Informatica

Responsibilities:

• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Extensively worked with database and Informatica for performance tuning.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Designed and developed complex mappings in Informatica to load the data from various sources such as SQL server, Flat files, Oracle using different transformations such as, Source qualifier, Look up connected and unconnected , Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Involved in designing, developing and documenting of the ETL Extract, Transformation and Load strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Created Mapping Parameters and Variables.
• Implemented Slowly Changing Dimensions SCD to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX commands shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Worked with PMCMD command line program to talk with the Informatica server, Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica PowerCenter 8.6, Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor , Oracle 10g, SQL, PL/SQL, SQL Server, Windows 2000 and UNIX, Cognos

Confidential

Sr. ETL Developer

Responsibilities:

• Team member of the Data Warehousing module. Involved in designing, developing and documenting of the ETL Extract, Transformation and Load strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Java, SQL, Transaction control, Source qualifier, Look up connected and unconnected , Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked with database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations aggregations and created target mappings that contain business rules.
• Extensively used Informatica Power Exchange.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Implemented Change Data Capture CDC to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions SCD to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Wrote shell scripts and control files to load data into staging area and then into database tables.
• Provided extensive support in UAT user acceptance testing and deployment of mappings.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica PowerCenter 8.1.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console , Power Exchange, UNIX, Oracle 10g.

Confidential

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Populated the business rules using jobs into the Repository for Metadata management.
• Creating the Entity relationship diagrams and maintaining the corresponding documentation for corporate data dictionary with all the attributes, table names and constraints.
• Defining entities, attribute and relationships. Worked on data granularity and cardinality.
• Worked on Daily atomic, monthly atomic and monthly aggregations of the reporting data mart.
• Worked Extensively on Informatica modules Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
• Development of major reports on weekly, monthly quarterly basis for multidimensional analysis.
• Reports were built using impromptu and PowerPlay the model was built using Cognos Transformer.
• Involved in creating periodic backup of the repository based on the requirement
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Power Cubes used to create Multidimensional Reports using Cognos PowerPlay.
• Developed and fine-tuned PowerPlay Reports.
• Unix Shell Scripts were written for Automation.
• Performance tuning of Databases

Environment: Informatica Power Center 7.1.4, Oracle, Access, Flat Files, Cognos, AIX, UNIX, Windows XP, Autosys