SUMMARY

• 8 years of Strong experience in Complete Software development Life cycle SDLC which includes Business Requirements Gathering, System Analysis, Design, Data Modeling, Development, Testing and Implementation of Data Warehouse.
• 6 years of technical hands-on experience in development of Data warehousing solutions using Informatica PowerCenter 9.5.1/9.0.1/8.1/7.1/6.1 Workflow Manager, Workflow Monitor, Repository Manager, Designer -- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer , Informatica, DataMart, ETL, OLAP, ROLAP, MOLAP, OLTP, Star/Snowflake Schema, Autosys.
• Strong experience in installation of Informatica and configuration of Informatica PowerCenter 8.6/9.0.1/9.5.1.
• Experience in using Oracle 11g/10g/9i/8i, MS SQL Server 2005, MS Access 2007, SQL, PL/SQL.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.
• Proficient in transforming data from various sources flat files, XML, Oracle to Data warehouse using ETL tools.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets Tasks and Scheduling using Workflow Manager.
• Extensively involved in development of Informatica mappings and tuned for their better performance.
• Experience in integration of various data sources Multiple Relational Databases like Oracle, Autosys, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, XML files.
• Experience in design of logical and physical data modeling using Erwin.
• Expertise in using SQL LOADER to load Data from external files to Oracle Database.
• Worked with various SQL Editors such as TOAD, SQL Plus, and Query Analyzer.
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
• Strong experience in RDBMS Oracle and MS Access .
• Strong knowledge on Oracle Business Intelligence.
• Developed Batch Jobs using UNIX AIX Shell scripts csh, bash, ksh to automate the process of loading, pushing and pulling data from to different servers.
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr.ETL Informatica Developer

Responsibilities

• Interacted with the client to understand the business requirements.
• Hands on experience in writing Technical Documents as per the requirements.
• Used Informatica PowerCenter 9.0.1/9.5.1 to migrate the data from legacy systems to Data Warehouse.
• Experience in upgrading from Informatica version 9.0.1 to 9.5.1
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier, XML Parser, XML Generator, SQL, HTTP, Normalizer, Rank, Sorter, Router and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.5.1/9.0.1
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Extensively used Mapping Variables Parameters, Workflow Variables and Session Parameters.
• Experience in migrating objects from one instance/folder to other.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Expertise in SQL, PL/SQL, stored procedures triggers, cursors for implementing business rules and transformations.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Documents were prepared and the existing modified for future reference.

Environment: Informatica PowerCenter 9.5.1/9.0.1 Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor , XML, Oracle 11g/10g, TOAD 6.0, SQL, PL/SQL, UNIX.

Confidential

Sr.ETL Informatica Developer

Responsibilities

• Involved in Designing the specifications, Design Documents, Data Modeling and design of datawarehouse.
• Used Informatica PowerCenter 8.6.1/9.0.1 to migrate the data.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed Reusable mappings as per the specifications using Informatica PowerCenter 9.0.1/8.6.1
• Extensively used Mapping Variables Parameters, Workflow Variables and Session Parameters.
• Handle slowly changing dimensions of Type 2 to populate current and historical data in to the data warehouse.
• Actively involved in analyzing and data profiling/data cleansing/purging the source data to load into target tables
• Experience in migrating objects from one repository to another.
• Worked on different environments for development and testing.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Validation of transformed data from the source.
• Expertise in SQL, PL/SQL, stored procedures triggers, cursors for implementing business rules and transformations.
• Interacted with system administrators, DBA's other teams to troubleshoot application performance issues.
• Involved in scheduling the jobs to run at regular interval of time daily, weekly and monthly.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Provided knowledge transfer to the end users and developed documentation on the design, development, implementation daily loads and process flow of the mappings.

Environment: Informatica PowerCenter 9.0.1/8.6.1 Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor , SQL Server 2005, XML, Oracle 11g/10g, TOAD 6.0, SQL, PL/SQL, UNIX.

Confidential

Sr.ETL Informatica Developer

Responsibilities

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used Informatica PowerCenter 8.1.1/8.6.1 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Experience in upgrading from Informatica version 8.1.1 to 8.6.1.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.1.1/8.6.1
• Used Informatica PowerCenter 8.1.1/8.6.1 for extraction, loading and transformation ETL of data in the data warehouse.
• Handle slowly changing dimensions Type I, Type II and Type III based on the business requirements.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Involved in scheduling the informatica workflows using Autosys.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Wrote PL/SQL stored procedures triggers, cursors for implementing business rules and transformations.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache Static, Dynamic, Persistence and Shared .
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Informatica PowerCenter 8.1.1/8.6.1 Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor , SQL Server 2005, UDB DB2 8.1,XML, Autosys, Oracle 10g, TOAD 6.0, SQL, PL/SQL, UNIX, Erwin.

Confidential

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Created sessions, database connections and batches using Informatica Workflow Manager.
• Developed mappings to load data in slowly changing dimension.
• Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
• Migrate Informatica objects and Database objects to Integration Environment and schedule.
• Created complex PL/SQL stored procedures and functions.
• Monitoring the ETL jobs and fixing the Bugs.
• Worked along with the DBA to resolve performance and tuning issues.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Involved in doing Unit Testing, Integration Testing and System Testing.
• Identified and created various classes and objects for report development.

Environment: Informatica PowerCenter 8.1.1, Oracle 10g/9i, DB2, XML, Flatfiles, SQL, PL/SQL, TOAD, Perl, SQL Plus, Windows, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Developed the repository manager, users, user groups and their access profiles.
• Extracted data from different sources like DB2, Sql server, flat files and loaded into DWH.
• Developed complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Developed connected and unconnected Lookup transformations to lookup the data from the source and target tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Developed SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Involved in unit, integration and system tests for Data warehouse.

Environment: Informatica PowerCenter 8.1.1/7.x Repository Manger, Designer, Workflow Monitor, Workflow Manager , Flat files, DB2, SQL server 2005, SSIS, SQL, PL/SQL, Win 2000.

Confidential

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica PowerCenter 7.1.2/8.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area Oracle 9i using Informatica PowerCenter 7.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Experience in data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• In charge of converting data using SQL Server 2005 using SSIS.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.

Environment: Informatica PowerCenter 7.1.2/8.1, Oracle 10g/9i, PL/SQL, TOAD, SQL Plus, Erwin, Windows, UNIX HP UX

Confidential

Oracle Developer

Responsibilities:

• Develop new features with analysis, documentation, coding and testing in Oracle PL/SQL.
• Involved in processing external vendor data related to Shares/Stocks for
• management BI reporting purposes.
• Involved in database development by creating PL/SQL functions, procedures, triggers, packages.
• Created database Tables, Indexes, Views, Materialized Views, Sequences in Development and Production environment using PL/SQL, SQL Plus and Toad.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and manipulated PL/SQL tables and Varrays, Nested and Index-By tables i.e. PL/SQL Tables .
• Generated Business reports, crystal reports using the SQL queries, PL/SQL as per the requirements.
• Involved in processing large volumes of data on a monthly cycle.
• Generating SQL Scripts for Database Objects like Sequences, Views and Indexes.
• Imported data through various environments by using SQL Loader.
• Actively participated in the meetings to monitor the status of the project.
• Involved to prepare user level and system level maintenance documentation.

Environment: Oracle 9i, PL/SQL, TOAD, SQL PLUS, SQL Loader, UNIX, Windows NT.