PROFESSIONAL SUMMARY:

• 7+ years of IT experience in Analysis, Design, Development, Maintenance and Documentation for Data warehouse and related applications using ETL, BI tools, Client/Server and Web applications on UNIX and Windows platforms. Experience working in Banking, Financials, Healthcare, Pharmaceuticals and Insurance sector.
• Expert level experience in implementing advanced ETL methodologies for corporate wide - ETL solution using Informatica Power Center 8.6/7.x/6.x.
• Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
• Experience in user interaction to gather and analyze the project requirements.
• Strong expertise in design, development and integration of complex ETL processes.
• Experience with databases like Oracle, SQL Server, Teradata and MS Access 2000 and excellent in writing, testing and implementation of triggers, stored procedures, functions, packages, dimensional loading of tickets using PL/SQL.
• Strong Experience in designing and developing complex mappings using various transformations for implementing advanced ETL techniques such as slowly changing dimension, change data capture and incremental loading.
• Extensively worked on transformations like Aggregate, Lookup, Router, Filter, Joiner, Update Strategy, Sequence generator, Normalizer transformations.
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflows using shell scripting.
• Experience in performance tuning of ETL Mappings involving ETL Sources, Targets, Transformations, stored procedure and Sessions.
• Experience in upgrading Informatica Repository, making related changes to existing models, mappings to resolve upgrade issues and also responsible for Informatica server administration.
• Expertise in working on the releases, providing production, technical and onsite release support.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x/7.x/6.x, Informatica Power Mart 5.0, Informatica Power Connect, Informatica Power Exchange.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2.

Reporting Tools: Oracle BI Apps, OBIEE(10.x).

Data Modeling: Erwin 3.5/4.0, UML.

Data Modeling Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Life Cycle.

Programming Languages: SQL (DDL and DML), PL/SQL, C, Java

Operating Systems: UNIX, Linux, MS Windows 2000/NT/XP/VISTA/7.

Other Tools: TOAD, VISIO, SQL * PLUS, SQL * PLUS Loader, Trillium, QA

EXPERIENCE:

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Actively involved in the Design and development of the STAR schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Developed Informatica mappings/mapplets, sessions, Workflows for data loads and automated data loads using UNIX shell scripts.
• Used variouslookup caches like Static, Dynamic, Persistent and Non-Persistent in Lookup transformation.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Successfully migrated objects to the production environment while providing both technical and functional support.
• Developed E-MAIL tasks to send mails to production support and operations.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Designed and developed UNIX Scripts to automate the tasks.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.

Environment: Informatica Power Center 8.6, Oracle 11g, Erwin - 4.0, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, PL/SQL, and Sun Solaris UNIX, Windows-XP.

Confidential, Fairfield, CT

Sr. Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
• Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Created mappings to load the data mart with the use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and Update Strategy.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
• Implemented Error Handling Strategy in Mappings to fix the Errors.
• Co-ordinate off shore team and provided training in understanding business requirements and performed code reviews.
• Involved in creation of Technical specification document (Source to Target) for the project by conducting technical meetings.
• Created stored procedures to extract data from various data sources like Oracle and SAP.
• Involved in unit testing of the mappings and mapplets.
• Tuned performance of Informatica session for large Data Files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Used pmcmd to run workflows and used schedulers for scheduling of sessions.
• Used Trillium to improve data quality.
• Used different kind of tasks like Event wait and Event raise in the Workflow designer.
• Created and monitored sessions using workflow manager and workflow monitor.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server 2005, Windows XP, UNIX, SQL Developer, SQL, PL/SQL, Oracle SQL *Loader, QTP, Erwin 4.0, Trillium, OBIEE.

Confidential, Dublin, OH

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 7.1.2 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 7.1.2 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica Power Center 7.1.2, Oracle 10g, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, Malvern, PA

Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Responsible for dimensional modeling of the data warehouse to design the business process.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Loaded the data from IMS files into oracle tables using Informatica with any data cleansing required.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Used UNIX shell scripting for Scheduling Informatica Workflows.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
• Monitored workflows and collected performance data to maximize the session performance.

Environment: Informatica Power Center 7.1, MS SQL Server 2005, SSIS, Oracle 9i, ERWIN 4.0, WINDOWS XP, DB2, PL/SQL, SQL.

Confidential, Seattle, WA

ETL Informatica Developer

Responsibilities:

• Developed Logical and physical database designs for the transaction system.
• Extract the XML file from source transform it with multiple transformation including XML Transformation.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Used PL/SQL Views, Triggers, Procedures and Functions.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Developed and implemented the Unix shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.

Environment: Power Center 6.2, Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000,XML,UNIX.

Confidential

Informatica Developer

Responsibilities:

• ETL tool Informatica was used to load strategic source data to build the data marts.
• An operational data store was created. Metadata Build up was designed for performing data mapping.
• Also involved in Mass data loads, refreshing the data in various applications, Performance evaluations, modifying the existing code to accommodate new features.
• Used various Transformations like Aggregator, Router, Expression, Source Qualifier, Filter, Lookup, Joiner, Sorter, XML Source qualifier, Stored Procedure and Update Strategy.
• Worked extensively on Flat Files, as the data from various Legacy Systems are flat files.
• Have setup Test and Production Environment for all mappings and sessions.
• Created and configured Sessions in Workflow Manager and Server Manager.
• Debugged the sessions using Debugger and monitored Workflows, Worklets and Tasks by Workflow Monitor.
• Extensively used SQL & PL/SQL for Transformations.
• Developed Oracle stored procedures, packages and triggers for data validations.

Environment: Informatica Power Center 6.1, Oracle 8i, SQL, PL/SQL, IBM DB2, TOAD, Windows 2000