SUMMARY:

• 8+ years of total IT experience in Business Requirements analysis, Application Design, Data Modeling, Designing, Coding, Development, Testing and implementation of business applications with ETL, RDBMS, Data Warehouse/Data Mart, OLAP, Client/Server environment applications for Financial, Pharmacy and Insurance Verticals.
• 7+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.x, 8.x, 7.x, and 6.x (Workflow Manager, Workflow monitor, Warehouse Designer, Source Analyzer,, Repository manager, informatica server), Informatica Power Mart, Informatica Power Exchange, Data mart, OLAP, OLTP, SQL, PL/SQL, Stored Procedures.
• Experience in Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation
• Worked on conversion projects and converted PL SQL code to Informatica.
• Converted stored procedures to Informatica ETL code
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center.
• Extensively executed SQL queries on Oracle, Netezza, Teradata, DB2 and SQL server tables in order to view successful transaction of data and to validate data.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files, COBOL files and XML files.
• Experienced in writing Database Objects like Stored Procedures, Triggers.
• Experienced in implementing error-handling process.
• Experienced in using parameter files, mapping parameters in mappings.
• Experience working with UNIX Shell Scripts and Perl for automatically running sessions, aborting sessions and creating parameter files.
• Strong Database skills in Teradata, Netezza, Oracle 11g/10g, DB2 UDB, MS SQL Server.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.01/8.6/8.1/ (Repository Manager, Source Analyzer, Designer, Server manager, Work Flow Monitor, Warehouse Designer, Mapplet Designer, Mapping Designer, Workflow Manager)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Erwin 4.5/4.1/4.0/3.5.2/2. x.

Databases: Oracle 11g/9i/, MSSQL Server 2008,2005, 2000, PL/SQL, PL/SQL, DB2 UDB, Teradata V2R6/V2R5/R12/R13, Netezza TwinFin.

Programming: SQL, PL/SQL, TOAD, UNIX Shell Scripting.

Job Scheduling: Autosys, Control: M.

PROFESSIONAL EXPERIENCE:

Confidential, IA

Sr. Informatica Developer

Responsibilities:

• Extensively worked on Informatica to extract data from flat files, Oracle, DB2 and Netezza, and to load the data into the target database.
• Used Informatica tools such as Designer and Work flow Manager for Extraction, transformation and Loading.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Used Informatica Source Analyzer, Mapping Designer, Transformation Developer and Warehouse Designer for Extraction, Transformation and Loading.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Interacted with the DBA to create staging and target tables.
• Participated in team meetings to analyze the requirements and build the mapping design document.
• Converted PL SQL code to Informatica.
• Converted stored procedures to Informatica ETL code
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Used various kinds of the transformations to implement simple and complex business logic. Transformations used are: Lookup, Router, Expressions, Source Qualifier, Aggregator, Filter, Union, Sequence Generator Update Strategy etc.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows).
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Identified the errors by analyzing the session logs.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.1/8.6, Erwin, SQL, PL/SQL, Oracle 11g, DB2 UDB, Flat Files, Netezza.

Confidential, Denver, CO

Informatica Consultant

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse.
• Used Informatica to load data from source to Data Warehouse.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Converted PL SQL code to Informatica.
• Converted stored procedures to Informatica ETL code.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Involved in creating and maintaining various database objects like SQL Joins, synonyms and aggregate conditions and worked on various databases and their connectivity from various parts of the Source Systems.
• Extracted data from sources such as Oracle, DB2 and loaded to DB2 and Netezza
• Used Informatica client tools for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter etc.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Responsible for performance tuning for several ETL mappings, Mapplets, workflow session executions.
• Implemented performance tuning logic on Targets, Sources, Mappings, Sessions to provide maximum efficiency and performance.
• Used Autosys for automating Batches and Session.
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the Sessions.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange, UNIX Shell Scripting, Oracle 10g, TOAD 8.6, PL/SQL, DB2, Netezza, UNIX.

Confidential, MN

Informatica Developer

Responsibilities:

• Requirements gathering and Business Analysis in support of Data Warehousing efforts.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user’s privileges.
• Developed transformations and validated and fine-tuned the ETL logic coded into mappings. Extensively used Informatica Transformations.
• Involved in extracting the data from the Flat Files and other RDMS databases into staging area and pro-actively involved in Storage of data.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Worked on Informatica PowerCenter tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Migrated Mappings, Sessions, Workflows from Development to Test and then to Production environment and development.
• Monitoring all the environments regularly and provided 24x7 production support for Informatica
• Tuning of SQL queries for better performance.
• Loaded data to Teradata using TPUMP, FASTLOAD, MLOAD and was involved with creating physical objects.
• Migrated Mappings, Sessions and Common Objects from Development to Test environment.
• Performed tunings of mappings for optimum performance.
• Involved in Unit Testing and Integrated testing for the mappings created.
• Provided Production support by monitoring the process running daily.

Environment: Informatica Power Center 8x, PL/SQL, Teradata, DB2 8.0, Flat Files, FTP, UNIX Shell Scripts, Cron, SQL*Loader

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Actively involved in Data Gathering, recognizing and confirming the data sources/elements.
• Designed the ETL processes using Informatica to load data from Oracle to target Teradata Database.
• Responsible for developing, support and maintenance for the ETL processes using Informatica Power Center 8.x.
• Extensively used ETL to load data from flat files into staging area and then to Data warehouse.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Involved in writing SQL queries based on the given requirements.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.

Environment: Informatica Power Center, Teradata, Oracle8i, Flat Files, Shell scripting, SQL Assistant.

Confidential

ETL Developer

Responsibilities:

• Used various Informatica transformations like expressions, filters, joiners, aggregators, routers and lookups to load better and consistent data into the targets.
• Monitored the production loads and fixed them, when necessary.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server, and DB2.
• Worked on performance tuning by making changes to SQL in Source Analyzer.
• Worked with the reporting team as well to create detailed reports.
• Used Control-M to schedule jobs on a regular and required basis.
• Wrote shell scripts to join or concatenate target files, to delete or remove one or more such files if not needed after joining, and etc.
• Documented business rules, functional and technical designs, test cases, and user guides.