SUMMARY

• Over Seven years of IT experience as an ETL developer/programmer/analyst, including Data Warehouse / Database Developer experience using Informatica Power Center 9.x/8.x/7.x/5.x as ETL tool.
• Extensive experience in Data warehousing tools including ETL process using different modules of Informatica Power Center and Power Mart.
• Experience in the areas of Healthcare, Financial and Insurance domain.
• Worked with Agile Software Development Methodology.
• Good knowledge of OLTP / OLAP system, analysis and E - R modeling, developing Database schemas like Star schema and Snowflake schema.
• Experience in developing Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Worked extensively on Informatica Power Center and Informatica Power Exchange.
• Implemented Slowly Changing Dimensions (SCD) Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Extensively worked in tuning and troubleshooting the mappings to perform maximum efficiency and performance.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, Teradata, MS Access and worked on integrating data from flat files, CSV files and XML files.
• Extensively worked on Data Modeling.
• Good knowledge of Master Data Management (MDM),data profiling, data quality, data cleansing
• Working knowledge of SSIS, SSRS and SSAS.
• Expert in SQL, PL/SQL, Procedures/Functions, Triggers and Packages.
• Knowledge of software testing and quality assurance.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x / 8.x / 7.x

Operating Systems: Windows-98, 2000/NT, ME, XP, UNIX, MS-DOS

Scripts: Shell Scripting, Python

Languages: SQL, PL/SQL, T-SQL, C, C++, JAVA, Visual Basic 6.0

Databases: Oracle 11g/10g/9i/8.x, SQL Server 2008, Teradata and MS- Access, DB2

Web Technologies: HTML, DHTML, XML

Application Software: MS office, MS Visio

Others: Toad, SQL Developer, PVCS, Remedy, Erwin, Tivoli, AutoSys.

PROFESSIONAL EXPERIENCE

Informatica - Technical Lead

Confidential

Responsibilities:

• Created Technical Design Document along with Data Discovery sheet
• Closely worked with SME's, Application owners and end users to get details on their apps and requirements
• Provided training to Jr Informatica Developers
• Extensively worked on Data Masking transformation to mask data in QA/DEV/SIT environments
• Worked on ILM to create and define rules for data masking.
• Worked on Performance Tuning to optimize the Session performance by utilizing, partitioning, push down optimization, Index Cache, Data Cache and incremental aggregation.
• Worked on different databases such as Oracle, DB2 and Teradata
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used Power Exchange for Mainframe VSAM file
• Developed Mapplets, created mappings in pipeline structure
• Used Target Load Plan in order to execute the mappings sequentially in a pipeline structure
• Used mapping parameters and variables
• Used Session level parameters such as connection strings
• Closely worked with DBAs on Performance Tuning
• Used Constraint Based Loading, partitioning, performance tuning on existing mapping
• Developed workflows with sequential and parallel sessions
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic
• Worked with DBA's for performance tuning and to get privileges on different tables in different environments
• Worked with Change Management Team to roll-out final solution
• Created UNIX script to run batch jobs according to business requirements
• Created technical documents for end user - Instruction Manuals for the solution provided

Environment: Informatica 8.6/9.0, Oracle 11g, DB2 9.7, Teradata, Toad for Oracle and Toad for DB2, SQL Assistant, IBM AIX, Visio, Citrix Client.

Informatica Developer

Confidential, Kansas City, MO

Responsibilities:

• Converted business requirements into technical documents.
• Developed Data Flow diagrams to create Mappings and Test plans.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and Sql Server, IBM DB2, XML files.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, Index Cache, Data Cache and incremental aggregation.
• Used Target load plan, constraint base loading, partitioning, and performance tuning the existing mapping.
• Used mapping parameters and variables.
• Involved in Change Data Capture (CDC)
• Worked on complex Informatica Mappings for Household dimension, Multi valued dimension and Point in time dimension.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Modified existing shell script to suite the existing business logic and developed the utility script to archive, move and copy files and also to automate the batch jobs.
• Developed UNIX shell scripts to automate manual tasks.
• Developed Test plan to verify the logic of every Mapping in a Session.
• Utilized Quality Center 9 web based test management tool to keep track of all the releases, requirements, test plans, labs and defects.
• Worked with DBA and infrastructure team to implement the DDLs, refresh data, create DB links, setup environment and delete the log files from the Unix boxes.
• Migrate the code and release documents from DEV to QA and Production.
• Extensively worked on Integration testing and User Acceptance Testing (UAT). Reviewed UAT with business users.
• Utilized Autosys to schedule all the jobs and closely worked with the production team.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2 UDB, UNIX (Sun-Solaris), UNIX (AIX 6.2), Harvest, SQL Loader, Autosys, Visio, Synsort, TOAD for Oracle, SQL Developer, Windows XP.

Informatica Developer

Confidential, Memphis, TN

Responsibilities:

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used workflow manager to create and configure workflow and session task to load data, used workflow monitor to create, monitor workflow in case of process failure.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Tuning Informatica Mappings and Sessions for optimum performance
• Used Informatica features to implement Type I & II changes in slowly changing dimension tables.
• Worked on various lookup caches like static, dynamic and persistent.
• Used target load plan, constraint based loading, partitioning, performance tuning on existing mapping.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic.
• Worked on XML files MQ series to extract the Market Risk Data.
• Worked with offshore team in fixing existing mapping, deployed mappings and workflow to UAT, SIT environment.
• Responsible for ETL process under development, test and production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Developed PL/SQL procedures/packages to load the data into Oracle.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management
• Modified existing shell script to suite the existing business logic and developed the utility script to archive, move and copy files and also to automate the batch jobs.
• Worked with Unix team to create UNIX shell scripts to automate manual tasks.

Environment: Informatica Power Center 8.6 (Source Analyzer, Target Designer, Mapping Designer, Mapplets, Workflow Manager, Workflow Monitor), UNIX, Windows XP, SQL Server, Teradata, SQL, PL/SQL, PVCS, ERWIN.

Informatica Developer

Confidential, Birmingham, AL.

Responsibilities:

• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Optimized the sql override to filter unwanted data and improve session performance.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Prepared unit testing document covering field to field’s validations and source to target count.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in promoting the folders from Development to Test and Test to Production Environment.

Environment: Informatica Power Center 7.1, Oracle l0g, Toad 7.6, Autosys, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, DB2, Sun Solaris Unix 2.6, Shell Scripting.

Oracle Developer

Confidential, Cookeville, TN

Responsibilities:

• Developed data model using ER/Studio as a data modeling tool.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Helped in the enhancements to increase the ease of use and efficiency for the end user depending on the clients’ functionality.
• Used UTL file in packages to read/write the data from/to a flat file and SQL*Loader for migrating flat file data into target.
• Created tables using Toad as well as created and managed roles for different users to access database objects.
• Wrote complex SQL statements using date functions and inline views according to the requirements.
• Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table and Oracle Functions and Procedures to centralize the business logic in the database.
• Improved the performance of the application by rewriting the SQL queries.
• Designed Forms for the data entry, update, data retrieval and developed web forms using XML.
• Generated reports and modified the existing reports using Crystal Reports.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links, then display the data in Oracle forms.

Environment: Oracle 10g (PL/SQL, SQL*Loader), UNIX, Toad 9.6, Crystal Reports XIOracle Reports 4.5/6.0, Windows 2000, ER/Studio 7.6.

Informatica Developer

Confidential

Responsibilities:

• Creating the mappings and involved in Extraction, Transformations and Loading.
• Worked on Informatica Source Analyzer, Mapping Designer and used various transformations such as the Source Qualifier, Aggregators, Lookup, Update strategy, Router, Filters & Sequence Generator, Joiner
• Creating and testing sessions.
• Involved in extracting the data from Oracle 8i and Flat files
• As a Technical Team Member I involved in Development of different modules and PL/SQL procedures.
• Identifying the business user requirements
• Developed transformation logic and developed various mappings in Designer
• Extensively used Informatica Power Center 5.1 as an ETL tool to extract, transform and load data from remote sources to DW.
• Worked with various active & passive transformations.
• Developed complex Informatica mappings and tuned them for better performance.
• Used ODBC to connect to the target Oracle database.
• Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
• Used transformations for data joins, complex aggregations.
• Responsible for improving query and session performance.
• Created complex mappings using Lookup, Aggregator and Router transformations for populating target table in efficient manner. Performed Unit testing
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator and joiner transformations.
• Created, launched & scheduled sessions and batches using Server manager.
• Defined mappings slowly changing dimensions and slowly growing Targets.

Environment: Informatica Power Center 5.1, Oracle 9i, PL/SQL, Win NT, UNIX, Flat FilesSQL loader and Oracle9i