SUMMARY

• Informatica Certified Senior Developer with over 7years’ experience within the Healthcare, Pharmaceutical and Consulting Industries.
• Extensive ETL experience using Informatica Power Center 9.x/8.x. with expertise in upgrade. Experience in Creating Repository, Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica, Pentaho, OWB.
• Experience in working with Informatica Data Quality and Data profiling.
• Expertise in implementing Business rules by creating complex Informatica mappings/mapplets, shortcuts, reusable transformations, tasks, sessions, workflows/worklets using Designer and Workflow Manager.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator, Union and Stored Procedure transformations.
• Extensively used BMC Control-M to schedule the jobs. Wrote UNIX shell Script for processing/cleansing incoming text files and for the Data flow and Control flow order.
• Exposure to the entire process of Software Development Life Cycle (SDLC) including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation, Testing and Maintenance.
• Expertise in Relational Database Systems and Data warehousing like Oracle, DB2, Teradata, MS Access, SQL Server.
• Experienced in Data Modeling in Erwin - Enterprise Data Model (EDM), Star/ Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling.
• Comprehensive experience in UNIX scripting and basic Perl scripting for the optimal process flow.
• Create notification UNIX shell scripts for maintaining Informatica box. This includes scripts for removing logs on a regular basis, checking disk usage and sending mail if the space is over threshold.
• Excellent communication skills.

TECHNICAL SKILLS

ETL: ETL Informatica Power Center 9.5/8.x/7.x/6.x, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer and Worklet Designer, OWB 10g, Pentaho Kettle PDI.

DATABASES: Oracle 10g/9i, DB2 UDB, Teradata

REPORTING TOOLS: Business Objects XI, CSV reports to read in MS Excel

DATABASE TOOLS: Oracle tools Toad, SQL Analyzer and Squirrel SQL Client Version 3.2.1

SCHEDULING TOOLS: Tivoli Work Scheduler (TWS), BMC Control M, Informatica Scheduler

SCRIPTING: UNIX, PERL

ENVIRONMENT: UNIX, AIX Windows XP/2000/NT, Windows Vista, Window 7 and LINUX

OTHERS: MICROSOFT Word, Microsoft Excel and Microsoft Access, EDM, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr ETL Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Worked on B2B Transformation to process the data coming in HL7 File format.
• Created complex mappings to load data directly from salesforce using API call to load Donor data into MDM.
• Worked exclusively on CDC Type 1 & Type 2 mappings to load data into relational tables on SQL Server database using MD5 Hash functions.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created mappings for loading data files received from external vendors. Worked with different kinds of input files like CSV, XML, Tab delimited files etc.
• Created data file cache for improving the performance for lookups.
• Used hints for suppressing the order by clause in lookup for improving the performance.
• Used PLSQL stored procedures as part of mappings to improve performance.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup
• Created events and tasks in the work flows using workflow manager
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Developed UNIX Shell Scripts and Windows Batch Files
• Developed mappings for various sources in Inbound.
• Created extracts for different clients in XML, .txt and. csv formats.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them

Environment: Informatica Power Center 9.5.1/9.6 Work Flow Manager/Monitor, Power Exchange 9.5, Erwin, Oracle 11g/10g, SQL, PL/SQL, TOAD, SQL * Loader,, UNIX Shell Scripting, Tivoli Work Scheduler (TWS), SQL Server 2012.

Confidential, IL

ETL Developer/Designer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader& OWB.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.

Environment: Informatica Power Center 8.6.1/7.x (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), OWB 10g, Oracle 10g, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris)

Confidential, NY

ETL Developer

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a
• Mapplet and created new mappings using Designer module of Informatica.
• Modeled the data warehousing data marts in Star join schema.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 8.6.1/7.x, Oracle 10g/9i, PL/SQL, Erwin 3.5, Sun Solaris, TOAD, SQL Navigator

Confidential

ETL / DW Developer

Responsibilities:

• Involved in requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Involved in designing, implementing and maintaining the database system.
• Created database objects such as tables, views,and database links as well as custom packages tailored to business requirements.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Used different transformation like Expression, Aggregator, Source Qualifier, Sequence Generator, Filter, Router, Update strategy and Lookup Transformations.
• Developed SQL queries to performed DDL, DML, and DCL.

Environment: Informatica Power Center 8.6.1, Oracle 9i, TOAD, SQL Server 2008.