SUMMARY

• Over 8 years of software experience in analysis, design, development, testing includes data warehousing experience using Informatica ETL (Extraction, Transformation and Loading Tool) Power center in Finance, Insurance and Transport domains
• Strong experience in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing
• Expertise in ETL process using Informatica PowerCenter Designer, Workflow manager, Workflow monitor, Informatica server and Repository Manager
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions
• Expertise in creating mappings, mapplets, mapping wizards and reusable Transformations using Informatica
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer
• Highly Skilled with the Integration of various data sources like Oracle, SQL Server,DB2,XML files and Flat Files
• Designed and developed efficient Error Handling methods and implemented throughout the mappings
• Created Business Objects Reports that had multiple data providers, drilldown, slice and dice features using Business Objects
• Strong Experience in creating StoredProcedures using Oracle PL/SQL
• Good experience in UNIX and writing shell scripts for Informatica pre & post session operations anddatabase administration activities
• Closely monitoring the jobs, which are scheduled to run on a daily & weekly basis, fixing the issues in case of any failures and giving the permanent solution to solve the issues
• Effective Team Player with excellent analytical, programming, written and verbal communication skills

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 9.5/9.0/8.6.1/7.1 (Designer, Manager, Workflow Manager), Power Exchange, Informatica Data Quality 9.1 (IDQ).

Database: Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2000, MS Access, MySQL

Operating Systems: Unix, Windows 2000/NT 4.0 Server

BI & Reporting Tools: Business Objects 6.5/5.x (Designer, Supervisor)

GUI: Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

Web Technologies: C,SQL,PL/SQL,JAVA, PHP, HTML, JavaScript

Testing Tools: Win Runner, Load Runner, QTP 8.2

Web/App servers: Internet Information Server, JWS, Apache Web server, Web Logic

Additional Tools: Erwin, Toad, SQL Navigator, ControlM, Autosys, Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mappings and Business rules associated with the ETL Processes.

Environment: Informatica 9.5/9.1, Toad for DB2, SQL server 2008 R2, SQL, T - SQL, PL/SQL, Toad 10.6,SQL Loader, Peregrine ticketing tool, Control-M, HP Quality center.

Confidential, St. Louis, MO

ETL/Sr. Informatica Developer

Responsibilities:

• Worked heavily with Business Analyst to understand the business and to design the architecture of the data flow.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Designed the metadata tables and created mappings to populate the same. These tables were used to generate the parameter files.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the Data Mart with only required information.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Developed and tested stored procedures, functions and packages in PL/SQL
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g, Netezza.
• Developed flowcharts for complex stored procedures.
• Created and Executed workflows and worklets using Workflow Manager to load the data into the Netezza Database.
• Developed Perl Script. Maintained Versions of SQL Scripts, PERL Scripts, and Documentation using StarTeam/Accurev.
• Performed flat file to database tables uploads using the NZLOAD, DB utility of Netezza and performed NZCHECKVIEW to maintain database view integrity
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• 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.

Environment: Informatica Power Center 8.6.1, Teradata, Power Exchange 8.1, IDQ, Oracle 9i, SQL Server 2008, PL/SQL, SQL, DB2, UNIX, Business Objects 5.1, Shell script.

Confidential, Stamford, CT

ETL Developer

Responsibilities:

• Created functional ETL routines and verify their reliability to ensure compliance of business rules and propagation of data definitions throughout the ETL processes.
• Implement ETL tools - code to extract, transform, correlate, integrate, load and verify data being migrated
• Manage ETL defects, enhancement, and new functionality requests to meet changes in the business needs.
• Identify and investigate data quality/integrity problems, determine impact and provide solutions to problems.
• Understand SQL, PL/SQL scripts and converted the rules to mappings.
• Extract data from Oracle, flat files and used various transformations such as Expressions, Joiner, Filters, and Aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load data into different SQL Server databases.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
• Understanding the conceptual model produced using Object Role Model (ORM) as the methodology to gather business facts and rules.
• Build Mapping using transformations: Union, Lookup, Joiner, Router, Aggregator, Normalizer and Update strategy transformation.
• Enhance existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Developed SQL scripts, AIX Korn Shell scripts to implement business rules.
• Involved in creating views for PPR Publishing report.
• Validated results of all data migrations and review those results.
• Involved in unit testing and documenting the processes.

Environment: Informatica Power Center 8.6, Oracle 9i, Clear Case, Clear quest, XML, PL/SQL, Toad 9.6.1.1, Unix Korn-shell scripts, Perl scripts, SQL Server Query Analyzer, Erwin, Linux.

Confidential, Carson City, NV

Informatica Developer

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Implemented recovery solutions by writing stored procedures and cursors using Sybase SQL to undo mistakes made by traders.
• Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
• Created mappings/workflows to extract data from SQL Server, Sybase and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Participated in the review and maintenance of data security standards to protect information assets.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Involved in designing Business Objects Universes, Queries, and Reports.

Environment: Informatica 7.1.3, Oracle 9.i, SQL Server 2005, Excel, Windows, Visio, TOAD, Korn Shell Script.

Confidential

Informatica Developer

Responsibilities:

• Modeled the Data Warehousing Datamart’s using Star Join Schema.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write stored procedures to increase the performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources (Flat files, Oracle, Sql Server,XML) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Java, XML Source Qualifier, Union and Update Strategy to load the data into the target.
• Worked on Data cleansing, data conversion & process implementation.
• UNIX Shell scripting for backup and monitoring of databases.
• Responsible for the development, implementation and support of the database of the server.
• Provided daily support to clients including data research and test environment data refreshes
• Monitored the processes to identify potential issues and apply preventative and corrective actions.
• Testing all forms, PL/SQL code for logic correction.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Involved in production support and stabilizations.
• Coordinated between Development, QA and production migration teams.
• Reports were generated using Business Objects for analysis.

Environment: Informatica Power Center 7.1, Oracle 8i/9i, MS SQL Server 2005/2000, SSIS, Business Objects, XML, Web Services, Sun Solaris 2.6 and Windows NT