PROFESSIONAL SUMMARY: 

• Over 7+ years of experience in software design, development, maintenance, testing and troubleshooting on ETL/DWH applications.
• Expertise in Requirement Analysis, Design, Coding, and Testing & Implementation of ETL/DWH projects using Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange, Data Masking, Test Data Management, PL/SQL, COBOL,DB2 and UNIX Shell Scripts
• Extensive experience in designing, developing, and implementing Extraction, Transformation, and Load (ETL) techniques on multiple database platforms and operating system environments.
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.0/8.6.1/7.1/6.2.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Used the Informatica Workflow Monitor extensively to run, schedule, monitor, debug Informatica Jobs
• Experience in integration of various data sources like SQL Server, Oracle, XML, IBM Mainframe Flat files, DB2 into the staging area
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center9.1/9.0.1/8.6.1/x (Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor), Power Exchange 9.0.1, Informatica Analyst

Data Modeling

Relational and Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Erwin, MS Visio

Databases

Oracle 11g\\10g\\9i, MS SQL server 2008/2005 R2, MS-Access, Teradata V12

Programming

SQL, Unix, SQL Tuning/Optimization, C

Tools

SQL *Plus, SQL* LOADER, MS Office,ILM, Active Batch

OS

Sun Solaris, Windows 7/98/95/NT/2000/2003/XP/Vista.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine CA March 2012- Till date
Sr.Informatica/ETL Developer

Confidential is one of the leading financial companies in USA specializing in banking and other financial services. My work at Capital Group was with the Private Client Services (PCS) department which maintains the accounts for company’s wealthiest clients. The ETL process involved extracting the data, temporarily placing the data in a ODS and then directing the data into the actual target Brokerage Data Mart. 
Responsibilities:

• Gathering requirements from Team Lead and implement them into source to target mappings in landing, staging and ODS.
• Interacting with Business Analysts in understanding the Database requirements whenever debugging is required without changing the code.
• Focused on new system and tools with minimal supervision and trained Project Architecture to team members.
• Involved in populating data from flat files, XML files, oracle into SQL Server 2008 R2 database from landing to ODS (Staging) and into EDW using the common code.
• Involved in generating and applying rules to profile data for flat files and relational data by creating rules in IDE and case cleanse, parse, standardize data through mappings in IDQ and generated as Mapplets in PC.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Effectively worked on Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Used shortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in checking Data accuracy standards for NULLS, Comparison, key generator and labeler using reference table manager in PWH and rolled based on statistics through Threshold value and Score Cards applied the Data cleansing process in Model Repository on same domain and merged to Power center.
• Extensively worked on performance tuning and also in isolating header and footer in single file.
• Performed code migration of mappings and workflows from Development to Test and Production Servers through deployment groups for DEV, TEST and PROD repositories in retaining shortcuts, dependencies with versioning.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Tuned and optimized mappings to reduce ETL run time and ensuring they ran within designated load window.
• Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Perform analysis profiling on existing data and identify root causes for data inaccuracies, Impact Analysis and recommendation of Data Quality.
• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Involved in meeting minutes for status reports, updates, any issues for any change procedures to Lead, Manager.
• Effectively played a multi dynamic role facing all challenges and managed working on similar projects as well.

Environment: Informatica Power Center 9.1,IDQ,Active Batch ,oracle 11g, SQL Server 2008,SSIS,T-SQL,Flat Files, XML files ,Windows 2003, RFC for Change Requests, MS Visio

Confidential, Willington DE Oct 10 - March 12 
Sr. Informatica Developer

Global Data Hub: 
This Project focuses on integration of financial data from banking, insurance annuity, financial and marketing including checking accounts, mortgage and shared builder to define anew Global Data warehouse in optimizing the performance and reducing the cost and provides best decision support solutions to business at the end user level.DD transactions are moving into database and thereby moving business to DWH. It involves loading metadata into Oracle 10g from integration of flat files, Oracle, SQL Server and resolves issues on time.
Responsibilities:

• Gathered requirements and developed mappings to maintain metadata in Repository.
• Extensively worked to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
• Implemented various Transformations: Joiner, sorter, Aggregate, Expression, Lookup, Filter, Update Strategy and Router.
• Modified the existing mappings for the updated logic and better performance.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Used Error Handling to capture error data in tables for handling nulls, analysis and error remediation Process.
• Involved in massive data cleansing and data profiling of the production data load.
• Tuning the complex mappings based on source, target and mapping, session level.
• Avoided Duplicate issues through SQL override using look up, Joiner transformations.
• Performed Unit Testing on the mappings.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Actively participated in resolving Email tasks working on priority and non-priority issues.
• Developed and Scheduled jobs for daily loads that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables for batch process.
• Ensured that integration testing and system testing followed with QA and change management procedures.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, MS SQL Server 7.0/2000, Flat files, SQL*Loader, Erwin 3.5, Toad 7.0, Unix, windows 2003, UNIX.

Confidential, Atlanta GA Oct 09- Sept 10
Informatica Developer

Confidential on merging Retail Services and PBM (Pharmacy Benefits Management) operated by integrating Drug Manufacturers, Prescribers Retail Pharmacy, Employers, Members and Medical insurance for an Enterprise Data warehouse. This Project mainly focused to secure the confidential information: PHI, PII, PCI and claims existing in the non-production environments using ILM tool through Data Masking Transformation.

Responsibilities:

• Involved in Project Life Cycle of application access issues to Implementation phase.
• Working closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications
• Gathering requirements from Business Analyst’s in understanding the Databases and Structures required for masking in star schema data model.
• Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
• Designed, developed and tested mappings/sessions/workflows to move data from source to staging for data load and data cleansing.
• Good knowledge for working with parameterized DB connections using UNIX scripts to view processed data.
• Employed Power Exchange 9.0.1 for flat files and mainframe files for GDG’s, in which they are rearranged and edited for proper reading of files and avoiding errors.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performance by including partition points, modifying target load order and emphasizing more on SQL override in Lookup, Filter, Expression and Update strategy transformations.
• Used reusable UNIX shell scripts command in Pre/Post Sessions.
• Performed performance tuning on Informatica sessions, and mappings..
• Worked on Serena Dimensions in version control for a record history of version 8.6 and 9.0.1 versions of Informatica at DEV, SIT and PROD environments and deployment.
• Ensured that system testing and change management procedures are followed with an ability to prioritize and manage multiple tasks with effective time management skills.
• Precisely documented all data for further reference.

Environment: Informatica Power Center 9.0.1/8.6.1 HF2, Oracle 10g/9i, MS SQL Server 2000, IBM DB2/400, Flat files, Main Frames, MS Visio, Toad 7.0, Windows 2000, Unix, Putty, ILM Work Bench, Power Exchange 9.0.1, Serena Dimensions.

Confidential July 08- Sept 09
Database Developer/Informatica Developer

Description: This system provides online banking to its customers like money withdrawal, fund transfers between accounts and loans etc. The system aims at integrating data scattered in many legacy systems and presenting a centralized data warehouse interface.

Responsibilities:

• Involved in gathering Business requirements and technical aspects for development.
• Involved in deciding the architecture strategy, design of the physical and logical models of the data warehouse as well as two dependent data marts.
• Scheduling, monitoring, coding and testing of custom PL*SQL modules to load data into the data warehouse from the legacy systems.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.

Environment: Informatica PowerCenter6.1, Oracle7.0, SQL, PL/SQL, Oracle Designer, Business Objects

Confidential Jan 06- June 08
Data Developer

CRM Project involved developing Centralized historical Enterprise Data warehouse for sales that collects, organizes and stored data from different operational data sources

Responsibilities:

• Discussed with Group and Technical Manager for business issues to bridge the gap between user needs.
• Involved in Data model reviews and validated tables, columns and data types.
• Created shared folders, local and global shortcuts to reuse metadata.
• Configure database and ODBC connectivityfor various sources and targets.
• Configured packages using Package configuration wizard to allow package run on different environments.
• Created ETL package for data conversion using various transformations tasks.
• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
• Worked with various transformation types: Lookup, Update, Merge, Joiner, Filter, Sorter and Aggregation.
• Extracted Data from sources: SQL Server, and Flat files to load into ODS (staging area).
• Applied partitioning at session for data loads using target lookup and avoided duplicates records.
• Implemented Mapping Variables and Parameters in Transformations.
• Reduced complexity and time using re-usable components: worklets, Mapplets, and transformations.
• Implemented Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Utilized Informatica tasks: Session, Command, Timer, Email, Event-Raise, and Event-Wait.
• Created Parameter file for session parameters and called in the sessions.
• Used Debugger wizard to remove bottlenecks at source, transformation, and target for optimum loads.
• Worked with session logs, Error Handling and validated data populated by Unit testing and Integration testing on mappings.
• Worked with QA team and fixed bugs that were reported and validated code in the mappings.

Environment: IPC 7.1/8, SQL Server 2000, SSIS, SSRS, Flat Files, TOAD 8.0, Windows 98/2000

EDUCATION: Bachelor’s in Technology,