SUMMARY:

• Experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center 9.5/8.6/8.0/7.1.
• Expertise in Dimensional and Relational Physical & logical data modeling using Erwin and ER/Studio.
• Extensively worked on Informatica Components like, Admin console, Repository manager, Designer, Workflow manager, Workflow monitor.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Strong in Data Warehousing concepts, dimensional star schema and Snowflake Schema methodologies.
• Experience inPerformance tuningof theInformaticaandOracle.
• Strong expertise in Relational data base systems likeOracle, SQL Server, MS Access, DB2.
• Worked wifXMLandFlat filesources coming from various legacy source systems and residing on Mainframe and UNIX.
• Created personalized version of reports as well as statements for customers using the data from Informatica metadata and then generated Business Objects reports using slice and dice capabilities.
• Created Stored Procedures to transform the Data and worked extensively in T - SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Extensively worked wif SQL loader for bulk loading into the oracle database.
• Proficient in understanding business processes /requirements and translating them into technical requirements.
• Highly adept at creation, execution, testing and debugging ofInformatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environments.
• Interacted wif both Technical, functional and business audiences across different phases of the project life cycle.

PROFESSIONAL EXPERIENCE:

Senior Informatica Developer

Confidential, Danville, PA

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from SQL, Oracle, Db2, Flat files and other sources using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Created Informatica mappings to populate the data into dimension and fact tables.
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on Erwin and UML Data modeling tools to create conceptual, logical and physical processes of the business in accordance to business regulations.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Used Informatica debugger to test the mappings and fix bugs.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.
• Involved in system testing and user defined testing.

Environment: Informatica Power Center 9.5, SQL Server 2012, Windows 7, Linux, Oracle 10g, DB2, Erwin/UML data modeling.

Senior Informatica Developer

Confidential, Raleigh, NC

Responsibilities:

• Worked wif informatica power center, DB2, oracle 10g, Flat files and other sources to integrate data and also worked in Data warehouse Development life cycle to generate reports.
• Worked wif different mappings like getting data from Oracle tables and flat files, getting data from dimension and fact tables in 2 separate data marts and loading to oracle target tables. Also used pre-loaded stored procedures.
• Used Informatica features to implement Type me, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router etc. in Mappings.
• Created Metadata manager Service, Reporting Service and Reference Table Manager Service in power Centre Admin Console to effectively use Metadata Manager.
• Configured the Reusable command task for sending the triggers, invoking different scripts and Reusable Email tasks for sending failure mail along wif session details and appending logs wif it and success mails. Also used Event wait, Event Raise, Scheduler options in the workflows.
• Worked wif other teams for bug fixing, documenting QA DOCS (checking list, design document, performance test doc, business Approval doc, and code review doc) and getting approved.
• Developed SQL, PL/SQL, Stored Procedures, and triggers for Implementing Complex Business Rules, Transformations and Loading.
• Tuned various SQL queries, mappings, targets and sources to improve the performance.
• Used session and workflow logs for debugging the session. Knowledge in using Cognos for report generation.
• Used debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Configured the workflows for running concurrently, used various types of migration techniques for moving code to Test environment from Development environment.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Worked wif the QA team to resolve and fix the defects found.

Environment: Informatica Power Center 9.5 (Power Center Designer, workflow manager, workflow monitor), UNIX, Flat files, Windows 7 Professional

Senior Informatica Developer

Confidential, Alpharetta, GA

Responsibilities:

• Understanding business needs and implement the same into a functional database design.
• Participated in requirements gathering.
• Developed Batch Processing, Source and Target Reconciliation.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy. Developed various Ad-hoc mappings for various business needs.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Make a build wif automation process deploy gateway .war and Movie time’s .war on Application server Jboss and Tomcat.
• Install gateway files Start Tomcat and Jboss servers.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them wif Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked wif production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL Server 2008, PL/SQL, DB2, Cognos, Windows XP, UNIX.

Informatica Developer

Confidential

Responsibilities:

• Primary role is to design and setup infrastructure for new projects as well as provide support to existing projects.
• Create and maintain file system, database, and metadata repositories, implement security in repository, backup strategies.
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank.
• Debug the sessions by utilizing the logs of the sessions.
• Create Users in Informatica using Repository Manager. Worked extensively on Repository Manager.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Involved in troubleshooting the scripts and providing the solutions.
• Created project documents for best practices for Administration and production environment.
• Designed mapping processes and strategies including implementation of slowly changing dimensions.
• Worked on tuning overall system performance to reduce the load window.
• Conducted detailed analysis of end user requirements.
• Worked wif Sales team on administering OLTP and OLAP processes, implementing and deploying reports.
• Administered end user documentation for application
• Ensured the quality of process deliverable, including implementation of system into production
• Possesses noledge of relational database functioning.
• Supervising and executing the offshore Administration activities.
• Organizing weekly status meetings for the updates done in project
• Post-Production support for the applications

Environment: UNIX, Pl/SQL, Oracle 9i/8, Informatica 8.1, Business Objects 6.5.

Informatica Developer

Confidential

Responsibilities:

• Understanding business needs and implement the same into a functional database design.
• Participated in requirements gathering.
• Involved in all the phases of SDLC.
• Developed new Informatica mappings and workflows based on specifications.
• Developed Batch Processing, Source and Target Reconciliation.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy. Developed various Ad-hoc mappings for various business needs.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them wif Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked wif production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.5 (Power Center Designer, workflow manager, workflow monitor), UNIX, Flat files, Windows 7 Professional.

Informatica Developer

Confidential

Responsibilities:

• Involved in OLTP system analysis
• Backup & Restore Oracle Table space containing Informatica data.
• Participated in system design and data modeling (logical and physical).
• Developed customized routine (ETL system) to capture and load data from external (Oracle 8x, Flat files) data sources into Oracle database.
• Extensively used Informatica to load data into Centralized Data Warehouse.
• Worked on Informatica tool - Source Analyzer, Target Designer, PowerCenter Designer, Mapping Designer, Mapplet Designer and Transformations.
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance Developed Mapplets, reusable transformations and creation of shortcuts.
• Created Informatica mappings to build business rules to load data Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generators.
• Creating Jobs and Scheduling the Jobs based on target load Order.
• Developed mapping based on ABAP Functional modules developed by ABAP developers and closely co-coordinated wif them in migrating the data to staging tables using Informatica Power connect adaptor.
• Wrote stored PL/SQL procedures for certain Business Requirements.
• Involved in Unit Testing and tuning process for better performance.
• The ETL tool is an integral part of the data warehousing architecture that will be.
• Used to model and create target Warehouse, extract data from multiple data sources, transform the data to make it Accessible to business analysis, and loading target data marts.

Environment: Informatica Power Center 7.x, Oracle 9i, SQL*PLUS, SQL, PL/SQL, Erwin, UNIX