SUMMARY:

• Having work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing using Informatica Power Center.
• Strong expertise in Relational data base systems like Oracle, Oracle data integrator, SQL Server and MS Access.
• Have extensively worked in developing for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations.
• Expertise in using Informatica client tools - Designer, Repository, Manager, Repository Server, Administration Console, Workflow Manager, and Workflow Monitor.
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Experience in working with Erwin and TOAD.
• Proficient in the use of ORACLE (PL/SQL) SQL Loader, ETL Design and programming, Shell Scripting, TERADATA.
• Worked on Webservices as a part of Informatica and obtained the successful connection of the external Webservice call.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Expertise in Performance Tuning of overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2.0/9.6/9.5/9.1/8.6/8.1 , Informatica Power Exchange 9.1/8.6

Databases: Oracle 12c/11g/10g/9i, DB 2 8.0/7.0/6.0 , MS SQL Server 2000/7.0/6.5 , MS Access 7.0/97/2000, Teradata 14.0

Other Tools: Oracle Report Writer, TOAD, MLOAD, TPUMP, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, UNIX Shell Scripting, Java, Unix Commands

Operating Systems: Windows Server 2008/2003, UNIX, OS, Sun Solaris 2.x.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Informatica ETL Production Support & Developer

Responsibilities:

• Involved in Informatica upgrade from 9.5.1 to 10.2.0 project and was responsible for performing End-to-End testing.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Automated the Informatica jobs using UNIX shell scripting.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Used ETL process to load data from multiple sources to staging area (Oracle) using Informatica Power Center 10.2.0.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created post-session and pre-session shell scripts and mail-notifications

Confidential, Chicago, IL

Informatica ETL Production Support & Developer

Responsibilities:

• Performed fine tuning of existing mappings in order to increase the performance of the mappings.
• Developed Claims processing data mappings to provide more feasibility to end users from the downstream applications.
• Implemented Type II slowly changing dimension to keep full history of dimensional data in the table.
• Managed and compile documentation for all ETL processes.
• Performed maintenance of SQLs, Views, and Informatica objects.
• Provide production database support, enhance existing system and design and develop new systems.
• Monitor the usage of database space and performance. Performance optimization of the database and applications. Resolve on-call issues for hundreds of production databases.
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle) using Informatica Power Center 9.5.1.
• Tuned sources, targets, mappings and sessions to improve the performance of data load. Worked on dimensional models like Star schema and Snowflake schema.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Worked on WebService Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
• Extensively used Data Stage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle and XML sources.
• Involved in the development of Informatica mappings and sessions and also tuned their performance for Optimum performance.
• Written complex SQL queries for data validation by querying data from different database tables as per the requirement.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure, Java, Normalizer and Router transformations for populating target table in efficient manner.
• Extensively used UNIX commands for fetching and checking the Log files.

Environment: Informatica Power Center 9.5.1, TOAD DB2, Oracle SQL Developer, UNIX, Tivoli (TWS), Microsoft SharePoint, HP Service Manager.

Confidential

Database Developer/Informatica Developer

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Handled Data Conversion functions and defined constraints, indexes and views based on requirements.
• Involved in people soft migration project.
• Developed complex ETL mappings using various transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations.
• Worked on mapplets and created parameter files wherever necessary to facilitate reusability.
• Extracted the data from Flat files (Delimited and fixed width) like CSV files or text files, XML files, Oracle 11g, SQL server, IBM mainframe, Sybase and load into Oracle data warehouse.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Used Error Handling to capture data errors in error tables to correct and reprocess them by analysis and error remediation Process.
• Created mapping documents to outline data flow from sources to targets.
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Extensively worked on Mapping Variables and Parameters, Workflow Variables and Session Parameters.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Migrated mappings, sessions, and workflows from Development to Testing environments

Environment: Informatica Power Center v 8.6, Teradata, Oracle 9i/10g, XML Files, Excel files, Oracle 10g/11g, PL/SQL, SQL, TOAD, UNIX.