SUMMARY

• 6+ years of IT experience in the Analysis, Design, Development, Implementation and Testing of Client/Server Applications using Informatica Power Center.
• Experience in working with various versions of Informatica PowerCenter 9.x/8.x/7.x/.6.x - Client and Server tools.
• Experience in data extraction, migration, transformation and loading using PowerCenter (Source Analyzer, Repository Manager, Mapping Designer and Mapplet Transformation).
• Directly responsible for Extraction, Cleansing, Transformation and Loading of data from multiple feeds and sources into Data Warehouse
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse
• Experience in managing Slowly Changing Dimensions (SCD) such as Type 1, 2, 3, De-normalization, Cleansing, Conversion, Aggregation, and Performance Optimization and so on.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels such as sources, targets, mappings and sessions.
• Extensive experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Worklet & Workflow Designer.
• Excellent knowledge and experience in configuring connections to various sources and creating source to target mapping, edit rules and validation, transformations, and business rules and ensures adherence to locally defined standards for all developed components
• Performed Performance tuning in RDBMS sources by implementing complex SQL query over rides in Source qualifier transformation, which reduced unwanted data to be processed, thereby increasing the data processing speed
• Experience in Informatica Code Migration, scheduling Tools and Version Control.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Control).
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Worked in Operational environment, following the agile methodology with 6 weeks iterative approach and also worked in the development, testing and integration of the project at a faster pace
• Worked closely with the Business Analyst, Database and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work articles
• Excellent management, communication, documentation, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.1/8.5/8.1.1/7.1

Database & Related Tools: ORACLE 8i/9i,10g,11g, MS Access 2007/2010, SQL server 2005/2008R2,Teradata,MYSQL,Sybase, Netezza, Mainframes(DB2, VSAM and Sequential Files), TOAD,SQL Plus, Erwin 4.1.

Languages: C,C++, SQL, PL/SQL, shell scripting(Bash,Korn)

Operating Systems: UNIX (Sun Solaris 8.0, AIX 5.1), LINUX, MS Windows NT /XP/7

Reporting And Scheduling Tools: Business Objects XI, Crystal Reports, Xcelcius, Autosys, Control M

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Sr.ETL Developer

Responsibilities:

• Developed mappings/transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.1.
• Created complex mappings in PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup and Joiner Transformations.
• Involved in Data Modeling based on the business, technical and design Requirements.
• Coordinated with Business Analysts for requirements gathering and to justify impact on other databases due to new requirements.
• Extensively used ETL to load data from multiple sources to Staging area using Informatica PowerCenter. Worked with pre and post sessions.
• Developed SQL scripts for Data loading and Data extraction.
• Involved in Unit Testing and Integration Testing of the application. Supported Integration testing by analyzing and fixing the issues.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from DB2, Oracle & flat file sources to target persistent data stores.
• Involved in fine tuning SQL overrides and Look-up SQL overrides for performance enhancements, Executed Pre and Post session commands on Source and Target database using Shell scripting and Proficiency in error handling mechanisms.
• Scheduled and run Extraction and Load process and monitor sessions using Informatica Workflow Monitor

Environment: Informatica Power Center 9.1, Netezza 4.0X, Business objects, Mainframes (VSAM, Flat Files, DB2, Copybooks),XML, UNIX, Erwin, SQL Scripting, UNIX, Shell Scripting, Windows, TOAD 9.0.

Confidential, San Francisco, CA

Sr.ETL Developer

Responsibilities:

• Developed Informatica Mappings, Sessions, Workflows, UNIX Shell Scripts to extract, validate, transform data according to the business rules
• Translated the business requirements into Informatica mappings/sessions/workflows and BTEQ scripts
• Created Complex Mappings which involved slowly Changing Dimensions to implement Business Logic and capturing the deleted records in the source systems
• Participated in design and development reviews
• Developed Mappings that extract and load the data to Data Warehouse and monitored the Daily, Weekly, Monthly and Quarterly Loads
• Executed Pre and Post session commands on Source and Target database using Shell scripting
• Experienced in Troubleshooting and Performance Tuning of sessions
• Proficiency in error handling mechanisms
• Worked with System owners to resolve source data issues and refine transformation rules
• Ensured performance metrics are met and tracked
• Used Informatica Data Quality for Data Analysis, Cleansing, Matching, Reporting and Monitoring
• Provided Production Support and Maintenance for all the applications with the ETL process
• Involved in review of the code and enhancements for better optimization of the Informatica mappings, sessions and workflows

Environment: Informatica Power Center/Power Exchange Development 9.1.0, Oracle 11g, SQL, TOAD 9.5, UNIX, Oracle eTRM 12.0.0, Windows2000/XP/7, Autosys, Erwin 4.1, PuTTY, OBIEE.

Confidential, Scranton, PA

Sr.ETL Developer

Responsibilities:

• Worked with Data Architects, Business Analysts and Independent Testing Team
• Responsible for analyzing, programming and implementing modifications to existing systems required by changes in the business environment
• Provided technical documentation of Source and Target mappings
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple sources (flat files, HTML files, DB2, Oracle) to targets persistent data stores
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Source Qualifier, Expression, Stored Procedure and Update transformations
• Developed Shell scripts for initial conversion of dimensions, for validation of source files and data loading procedures, written multiple scripts for pre processing the files
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse
• Performed other performance tuning techniques like reducing the number of transformations used in the mapping, using unconnected lookup when multiple values has to be returned from the same table, performing joins at the source level (homogenous sources) instead of using joiner transformation etc
• Used the Teradata external loading utilities like MultiLoad, Tpump, FastLoad and FastExport to extract from and load effectively into Teradata database
• Worked on Data Partitioning that optimizes Parallel Processing with Multi Thread Processing
• Involved in Unit testing Interacted with QA team for system/integration testing
• Scheduled the Informatica Sessions and Batches based on Event based scheduling
• Used Debugger in troubleshooting the existing mappings
• Involved in Fine tuning SQL overrides and Look-up SQL overrides for performance Enhancements
• Extensively involved in parameterization of the workflow objects
• Executed sessions, sequential and concurrent batches for proper executionof mappings

Environment: Informatica 8.6.1, Teradata V2R6, Teradata Tools and Utilities 8.2, Data Quality, Windows NT, DB2, Oracle 10g, Flat Files, Unix shell scripting

Confidential

ETL Developer

Responsibilities:

• Interacted with users to understand the business requirements
• Involved in creation of ETL Technical Design and Process Documents for the Fact and Dimension Loads
• Developed ETL Mappings and Mapplets using Informatica Power Center Designer tool to extract and load the data from Flat files, Cobol copy books, DB2 to Teradata database
• Extensively used Lookup, Aggregator, Expression, Update Strategy, Stored Procedure, Filter and Router Transformations
• Tuned the ETL mappings and sessions for better performance by eliminating various interacted performance bottlenecks
• Created Mapplets to load Session Control Tables used for updating Mapping Parameters and Variables in Parameter Files
• Developed consolidated DDL scripts to Create/Alter Oracle objects like Tables, Views, Indexes, Sequences to analyze tables
• Monitored and Scheduled Workflows, Worklets and Sessions for daily extracts
• Involved in unit and integration testing of mappings in ETL Test environments
• Followed the quality standards and guidelines for configuration management, testing, project planning and execution
• Scheduled and run Extraction and Load process and monitored sessions using Informatica Power Center Workflow Manager and Workflow Monitor

Environment: Informatica 7.1.3, Power Exchange, Cognos, Oracle9i,Teradata, MS SQL Server 2000, MS Enterprise Manager, MS Query Analyzer, Flat files, XML, Control-M (scheduler), Linux, UNIX Shell scripting, TOAD, Erwin 4.0, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Extensively involved in understanding the client’s database and identifying the significant fields to extract
• Coordinated with the Business Analysts and users to understand business and functional needs and implement the same into an ETL design document
• Developed Informatica Mappings, Sessions, Workflows, UNIX Shell Scripts to extract, validate, transform data according to the business rules
• Involved in Logical and Physical modeling of the database
• Created Tables, Indexes, Views, Triggers, Sequences, Constraints and Snapshots
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations
• Created High level/Detailed level design documents, ETL specifications and also involved in creating Business System Design (BSD) and Technical System Design (TSD) documents
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica
• Worked with pre and post sessions, and extracted data from Transaction System into the Staging Area
• Tuned the Mappings for Optimum Performance, Dependencies and Batch Design
• Used database objects like Views and partitioned for accomplishing the Complex logical situations

Environment: Informatica 7.1, Business Objects 5.1, IBM DB2 7.1, COBOL, UNIX Shell Scripts, MS Excel, Oracle 8i, Autosys, Windows NT.