SUMMARY

• Seven years of experience in the IT industry and wide range of progressive experience in providing product specifications, design, analysis, development and documentation
• Seven years of experience in Senior Data Warehousing and ETL using Informatica Power Center 9.6/9.5.x/9.1/8.6.x (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, ETL)
• Experience in Business objects.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, CSV files, and XML files.
• Expertise in performance tuning source, mapping, target and sessions.
• Two years of experience in technical leadership
• Strong understanding of Dimensional Modeling, OLAP, Star, Snow flake Schema, Fact and Dimensional tables and DW concepts along with Oracle Data warehouse Configuration, Admin Console, Materialized views, Indexes.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Extensively worked on Senior Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union and XML Source Qualifier.
• Experience in developing, designing and reviewing Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experience in using Mapping parameters, Mapping variables, Session parameter files.
• Extensive experience in supporting Informatica applications, data extraction from heterogeneous sources using Informatica Power Center
• Experience in working with Informatica Data Quality and Informatica Data Explorer
• Designed complex Mappings and expertise in Performance Tuning
• Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Proficient in using Informatica Work Flow Manager, Work Flow Monitor, PMCMD (Informatica Command line utility) to create, schedule and control workflows, tasks and sessions
• Experience in Oracle 10g/9i, PL/SQL, Sybase, UNIX and Windows operating systems
• Excellent overall software development life cycle (SDLC) experience, conceptual and logical thinking, Goal oriented, self - motivated and able to work independently and as a member of a team
• Experience in Business Documentation especially in the Insurance Industry, Pharmaceutical Industry, Financial and Service Industry.
• Excellent communication, analytical and interpersonal skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

Data warehousing ETL: Informatica Power Center 9.6/9.5.x/8.6x, Informatica Data Quality(IDQ), Informatica MDM, Informatica Data Explorer, Repository Server Administrator Console

Data Modeling: ERwin, Power Designer

Databases: Oracle 11g/10g/9i/8i, MS Access, MS SQL Server2005,2008,2012

Programming: UNIX Shell Scripting, SQL, PL/SQL

BI Tools: Business Objects XI, Crystal Reports 8.5

Scheduling Tools: Informatica Scheduler, Autosys, Control-M

OS Environment: UNIX (AIX, Solaris), Linux, Windows

Tools: Quick Test Pro, MS - Visio, HP Quality Centre

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Informatica Developer

Responsibilities:

• Involved in designing of Data Modeling for the Data Warehouse. Also involved in requirement gathering and Business Analysis.
• Worked on creating Staging tables and loading data into it and wrote PL/SQL Packages and Stored procedures to implement Business and Validation rules. In this process worked on extracting data from various types of sources like Flat files, XML files, Databases.
• Also involved in performance tuning of the Informatica mappings, stored procedures and the SQL queries inside the source qualifier. Worked on performance tuning of database and Informatica, improved performance by identifying and rectifying the performance bottlenecks.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Router, Lookup, Stored procedure, Sequence generator, Joiner, XML.
• Created and scheduled sessions, jobs based on demand, run on time and run only once.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Implemented slowly changing dimension methodology for accessing the full history of the accounts.
• Performed unit testing at various levels of ETL and was involved in team code reviews. Worked on fixing the invalid mappings and troubleshooting the problems in the database.
• Prepared Technical Design documents and Test cases.

Environment: Informatica Power Center 9.6/9.5.x, IDQ 8.6.1, Oracle 10g, SQL server, MS Access, MS Excel.

Confidential, Columbus, OH

Informatica Consultant

Responsibilities:

• Contributed in the development of system requirements and design specifications.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA and Prod Environments.
• Participated in the design and development of Dimensional modeling.
• Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router
• Developed Mapplets to implement business rules using complex logic
• Converted the PL/SQL Procedures and SQL*Loader scripts to Informatica mappings
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Tuned the Sessions for better performance by eliminating various performance bottlenecks
• Created and scheduled Sessions and Batches through the Informatica Server Manager
• Strong experienced in Slowly Changing Dimension Mappings of type I, II and III.
• Expertise in Informatica command line utility pmcmd to schedule and control sessions and batches
• Wrote UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Involved in analysis of Session, Event and Error logs for troubleshooting Mappings and Sessions.
• Adjusted the most frequently used reporting structures for optimal usage.
• At session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals etc.
• Analyzed the Data models of the source systems to develop Mapping Specs.

Environment: Informatica Multidomain MDM 9.5.0, Informatica Power Center 9.5, Oracle 9i, SQL, PL/SQL, SQL*Loader, UNIX

Confidential, TX

Informatica Developer

Responsibilities:

• Responsible for data analysis and legacy ETL code (stored procedure’s) analysis and convert the same in to Informatica Workflows.
• Extensively used the Power Center client tools Power Center Designer, Workflow Manager, and Workflow Monitor
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Used Dynamic lookups to load a constantly changing target table.
• Extensively used various transformations like Expression, Aggregator, Router and Update Strategy.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Created Shell Scripts to FTP files and add or delete timestamp from files and drop unprintable characters from files.
• Extensively worked with workflow and mapping variables.
• Responsible for migrating the workflows across development, test, QA and production environment
• Creating workflows that behave as a file watcher using even wait task.
• Scheduling workflows with Informatica scheduler and home built schedulers

Environment: Informatica Power Center 9.5.x(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g,PL/SQL, Unix, Flat files.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Responsible for requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Involved in the complete SDLC with data modeling - form logical, physical and conceptual data model.
• Extracted data from various heterogeneous sources like Oracle, SQL Server and Flat files.
• Worked with power center tools like Designer, Workflow Manager, Task Developer, Workflow Monitor, and Repository Manager
• Extensively used various active and passive transformations like Filter, Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Scheduling of the jobs as per the requirements using Workflow manager along with Tidal Job scheduler.
• Worked with index cache and data cache in transformations like Rank, Lookup, Joiner and Aggregator Transformations.
• Completed documentation of database structures and processes used to move data in and out database for future development and expansion of database.
• Responsible for Unit Testing of Mappings and Workflows.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL server, MS Access, Flat files, UNIX AIX, MS Excel.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Created Logical and Physical models for Staging, Transition and Production Warehouses.
• Developed complex mappings using Lookups connected and unconnected, Rank, Sorter, Joiner, Aggregator, Filter, Router transformations to transform the data per the target requirements
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Implemented constraint based load ordering of target data with in the pipeline.
• Implemented Aggregation logic using expression transformation to implement the business logic.
• Created the reusable transformations and Mapplet objects
• Used the Incremental Aggregation process to capture the changes from various sources and apply to Targets incrementally.
• Developed shell scripts for running batch jobs and scheduling them
• Involved in creating test plans, test cases to unit test the mappings, sessions and workflows.
• Involved in migrating the ETL application from development environment to testing environment.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL server, MS Access, Flat files, UNIX AIX, MS Excel.

Confidential

Informatica Developer

Responsibilities:

• Configuration of Oracle 8.1.6 server and creation of databases
• Performed database and SQL tuning to improve performance of loads
• Developing PL/SQL programs for data manipulation
• Installation of Oracle client tools and establishing connectivity to databases
• Creating table spaces, tables, indexes, users etc.
• Implementing table portioning to improve performance and data management
• Assisted in logical and physical database design
• Creating and assigning appropriate roles and privileges to users depending on the user activity
• Data loading using SQL*Loader to assist Data Warehouse developers.
• Implemented changes in the database design and modified stored procedures if necessary.
• Providing assistance in physical data modeling.
• Implemented procedures for backup and recovery of production servers
• Managing database security.

Environment: SQL, PL/SQL, Oracle 8i