SUMMARY:

• Certified Informatica power center Developer with 9 years of experience in IT industry having extensively involved in designing, developing, implementing and supporting Data Warehouses, data marts and data integration projects using Informatica 7.x/8.x/9.x ETL tool.
• Followed ETL best practices and standards in implementing ETL mappings using different transformations like Source Qualifier, Expression, Connected / Unconnected Lookup, Aggregator, Sorter, Router, Filter, Update strategy, etc.,
• Experience in full lifecycle design & Implementation of Star and Snowflake Schemas. Hands on Experience in Performance Tuning techniques and Implemented advanced Features/properties of Power Center including Partitioning, Concurrent Execution, Creating Indexes and Workflow Recovery.
• Experience on Creating re - usable objects like Mapplets, worklets etc. for optimal utilization of Informatica objects.
• Used Load balancing techniques with the help of push down optimization and SQL override’s that will help to minimize the IO operations and improve performance.
• Extensively worked on Informatica End to End Installation / Up gradation / User Roles creation / groups creation / migration activities / Repository & Integration services creation / Repository Back up Re store .
• Sourced Data from various source systems like Oracle, SQL Server, Flat files, Accesses database’s with the help of ODBC and native connections.
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Expert on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Worked extensively in preparing Unit test cases (UTC) documents, Design documents, for data validation and migration purposes.
• Worked on Incremental logic for extracting incremental data or delta data for performing Incremental data loads using control tables, parameter files, mapping Parameters/variables.
• Experience on Post / pre SQL scripts for performing any DML operations on the table after the session run or before the session run depending on the requirement. Also, archiving the source files with the help of configuring the post session variables.
• Implemented E mail configuration for e mail notification when session failed or when the session didn’t run. Also, worked on Command task and Event Raise & Wait Tasks
• Experience in Data Warehouse Administration Console (DAC) / Control-M scheduling tools for Monitoring ETL jobs.
• Good knowledge on OBIA 7.9.6.3 seeded ETL vanilla mappings & Customizing vanilla mappings as per the customer requirements. Good understanding of Reporting tools like OBIEE & Tableau.
• Strong experience in Production support environment at all levels including releases and change requests. Also, well management capabilities in resolving the tickets with in the SLA time lines.
• Excellent problem solving skills with strong technical background, Excellent Team Player with interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica power center 7.x/8.x/9.x, Informatica IDQ, Informatica Metadata Manager, Abinitio 2.8.x

Version control: Microsoft visual studio, Peregrine, Star Team

Databases: Oracle 11g/10g, SQL Server 2005/2008 R2

Languages: T: SQL, PL/SQL, basic Unix Shell Script.

DB Tools: Toad, SQL* Loader, SQL server management studio

Scheduling Tools: DAC, Control: M

ERP Systems: SIEBEL, EBASE, PEOPLESOFT,SAP

Operating Systems: Windows 2003/08, UNIX,LINUX UBUNTU

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Informatica ETL Developer

Responsibilities:

• Worked on gathering Public/private Data for Analysis and to build Applications/Interfaces such as Global Growth Radar, Demand Estimator, Company Performance, Cost Quality apps.
• Data Catalogue Created with respect to the available datasets and understanding of Source Data and Creation of ETL interface documents.
• Created low level design documents, review log documents, unit test cases, Issue logs, Impact Analysis and validated the data against the source.
• Created Dimension and fact tables for data analysis and data visualization.
• Data loaded to Dimensions Temp/stage/user tables by writing SQL scripts and by using Informatica tool.
• Created one to one mappings to load data from Temp tables to Main stage tables.
• Analyzed complete dataset with respect to their metric information, and maintained a master table to capture list of all metrics.
• Created Indexes in order to increase performance. Also, implemented Partition techniques at Informatica level such as pass through, key range etc.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Sorter, and Router etc.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD’s (Type 1/Type 2) loads.
• Worked extensively on loading and formatting data by writing SQL scripts. This involves lot of cleansing, dicing, slicing the data using both excel and sql scripts.
• Worked as offshore Coordinator for frequent interaction with onsite Team for requirement clarifications.
• Worked on converting rows into columns and vice versa as per the requirements.
• Prepared weekly deck, time sheets, and presented SMR (Senior Management Review ) presentation to the top officials.

Environment: Informatica Power Center9.x, Oracle 11g, SQL Server 2008 R2,Windows 2008 R2, Informatica Data Quality (IDQ) 9.x, Microsoft excel csv/acesses db files.

Confidential, Minneapolis, MN

Sr. Informatica ETL Developer

Responsibilities:

• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Sorter and Router.
• Installation of Informatica 9.0.1 hotfix 2 environments and 7.8.4 contents back up.
• Sand box environment created for regression/Load testing.
• Informatica 7.8.4 Repository Backup and restore.
• Folder migration from old repository to upgraded repository.
• Repository and Integration services creation.
• End to end ware house upgrade from Siebel analytics 7.8.4 to apps 7.9.6.3
• Running DDL, CTL scripts using DDLIMP utility.
• Data migration to upgraded tables from obsolete tables. Using vanilla UPG Informatica repository.
• Configuring Infa sequence generator.bat file during data migration
• Unit test case preparation and data validation.
• Retro fixing Informatica mappings in order to replace obsolete tables
• Data ware house full load using DAC scheduler, load monitoring and fixing issues if any.
• SCD type mappings creation using different transformations.
• Extensively worked on source qualifier transformation with query override.
• Data analysis from SIEBEL source to ware house to BI front end.
• Unit testing, surface testing, and sandbox testing.
• Dry run activities before go live and support activities.
• Developed Mapplets to implement business rules that involved complex logic.
• Tuned the mappings and sessions for better performance by eliminating various performance bottlenecks.

Environment: Informatica Power Center 9.0.1,SQL,PL/SQL, Toad, MS SQL 2008, DAC 10.1.3.4.1 , OBIA apps 7.9.6.3

Confidential, Phoenix, AZ

Sr. ETL Informatica Developer

Responsibilities:

• Created Staging, Dimension Fact tables based on the source data and the warehouse design.
• Worked with the Informatica Designer and created various mappings using different transformations like filter, Router, lookups, Sorter, joiner, update strategy, expressions and aggregator transformations.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star schema.
• Created repository using Informatica Power Center - Repository Manager.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Created and ran sessions/workflows using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance, example - the SQL override in source qualifier, lookup overrides in lookups, and other fixes based on the bottlenecks identified.
• Created reusable transformations and mapplets and used them in mappings.
• Extensively used Shell scripts to automate the Pre-session and Post-sessions processes.
• Performed data manipulation using basic functions and Informatica transformations.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/ server.
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing rank, lookup, joiner and aggregator transformations
• Created various tasks like Event wait, Event Raise, E-mail and command etc.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.

Environment: Informatica 8.6, UNIX, CSV Files, Excel files, SQL, PL/SQL, Unix Shell scripting, Oracle 11g, Toad.

Confidential

Sr. Informatica ETL Developer/Support

Responsibilities:

• Created different types of Transformations, mapplets, for different business logics.
• Migrating into Production systems. Batch Monitoring and Production issue resolutions.
• Hyperion report to Informatica mapping conversion work request and development.
• Resolving data issues and sending mails to DBA teams to data base change request.
• Created different transformations for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Informatica mappings enhancements, monitoring log information in batch run times.
• Breaks fix works for already implemented Mappings.
• Kalido BEID error resolution and Hyperion out of memory Issue aspects.
• Informatica mapping design for loading the data into extract schema from source schema.
• Performance tuning on Informatica maps.
• Production based ticket management and follow up’s using peregrine tool

Environment: Informatica 8.6, Oracle 11g, Toad, Hyperion, Peregrine

Confidential

Informatica/ETL Developer

Responsibilities:

• Preparation of the mapping document like Design/UTC/Impact/Issue log.
• Preparation of Mappings and Mapping review.
• Creating Different types of transformations and applying different business logics to load data into warehouse.
• Extensively used Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Expressions, Aggregator, and Sequence Generator
• Creating Sessions and workflows.
• Worked on Production issues, Database change request
• Sending communication emails to production coordinator and team with data load status
• Communication with control-M team for any job failures
• Resolution of Production issues which may include development activities in Informatica.
• Identifying redundancy and taking steps to control it.

Environment: Informatica 8.x, Oracle 9i,Toad, Unix, csv files, java, pl/sql