Professional Summary:

• 5 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica PowerCenter9.1/ 8.x/ 7.x / 6.x
• Experience in using Informatica Power Center tools Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager, metadata Manager.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica Sources, Targets, Mappings and Sessions and fine-tuned transformations to make them more efficient in terms of session performance.
• Expertise in design and implementation of Slowly Changing Dimensions SCD type1, type2, type3.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling Star Schema, Snow Flake Schema, FACT Dimension Tables , OLTP and OLAP.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Experience in Data Modeling tool Erwin and Data Warehousing Concepts
• Extensive experience using database tool such as SQL Plus, SQL Loader
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

Technical Skills:

Professional Experience

Confidential

ETL Developer

Confidential is a Pharmaceutical company, which provides new and improved biotech drugs for various diseases and their symptoms. The objective of the project is to extract data stored in different databases and load into oracle system which is the staging area and the business logic is applied to transform the tables in the required way. The data warehouse is fed by marketing data, sample data, market competitor data, prescription data and others.

• Designed and Implemented the ETL Process using Informatica power center.
• Data is sourced from 22 different Work Units. These Work Units span across huge variety of data sources like Oracle, Flat Files, MS Access and Spread Sheets.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Source and Target Definitions are imported from Source Analyzer and Target Designer connecting to databases using Relational and ODBC Connections.
• Developed Informatica Mappings for the complex business requirements provided using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup, Sorter, Filter, Router and so on.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment and Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• To externalize the business logic instead hard coding in the mapping I have used Parameter file in Informatica.

Environment: Informatica Power Center 9.1.0/8.6.1, Flat Files, Mainframe Files, SQL Server 2008, Web services, Oracle 11g.

Confidential

ETL Developer

Confidential leading financial companies, which serves its customers a broad range of first class banking services. I have assisted in the design and the development of the Data Warehousing project for the improvement of Account Management System. This data warehouse was developed to provide reports for the portfolio managers to assist in deciding the potential customers, the potential customer who can afford the loan and the graduate students who can afford the car loan.

• To attend meetings and get the business requirements.
• Update mappings, sessions and workflows as a part of ETL change.
• Develop and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Schedule the workflows in the workflow manager.
• Call stored procedures in oracle as pre sql session.
• Create reusable failure and success email tasks.
• Cached up all informatics jobs along with my team.
• Working with slowly changing dimensions type 1,2,3.
• Create job status report in excel sheet during weekends.
• Design and develop Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system.
• ETL Job daily verification.
• Good knowledge on Informatica administration work.
• Modifications to existing ETL Code and document the changes.

• Created repositories in development, QA and production environment.

Environment: Informatica Power Center 9.1, PL/SQL, SQL Server 2008, Windows 07.

Confidential

Informatics Developer Confidential is one of the leading companies in the nation for the auto insurance with more than 10 million policyholders. Its companies have consistently received high ratings for financial strength and claims paying ability from various independent rating agencies. The Insurance DW project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were some of the modules to deal with.

• Interacted with Business analyst, developers, Clarify Customer service team developers and Functional consultants to identify the business requirements and data realties.
• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Used Shortcuts Global/Local to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used Control-M as a scheduler tool to schedule the production workflows.
• Worked on SQL tools like PLSQL Developer/SQL Plus/MS SQL Visual studio to run SQL queries and validates the data.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Provided production support by monitoring the processes running daily.
• Scheduled the Jobs by using Informatica scheduler.

Environment: Informatica Power Center 8.x/7.x, PL/SQL, SQL Server 2008, Windows 07.

Confidential

Junior Etl Developer

The primary objective of this project is to capture different Customers, Policies, Claims Agents, Products and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Powercentre and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of Allstate Insurance products that are sold. The reports are used for identifying agents for various rewards and awards and performance, risk analysis reports for Business development Managers.

• Gathered user Requirements and designed Source to Target data load specifications based on Bussiness rules.
• Used Informatica Power Center 7 for extraction, loading and transformation ETL of data in the datamart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets Parameter files in Mapping Designer using Informatica Power Center.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using workflow monitor.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Created test Developed cases and ran the queries for staging, ds and dm to all the environments before migrating the data to production and tested all the mappings, sessions and workflows.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 8.x/7.x, PL/SQL, MS Access, DB2, SQL Server 2008.