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.
• 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.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• 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.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access.
• 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 noledge 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

ETL Tools: Informatica 9.1/8.x/7.x (PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

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

Languages: SQL, PL/SQL, Data Structures, Unix Shell Script

Tools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Informatica Developer

Responsibilities:

• 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 halp business for preliminary validation.
• To externalize the business logic instead hard coding in the mapping me 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, New York, NY

ETL Developer

Responsibilities:

• 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 noledge 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, Chicago, IL

Informatica Developer

Responsibilities:

• 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.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments.
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• 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, Tampa,FL

Junior Etl Developer

Responsibilities:

• 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 Mappingsto 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 themappings, 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.