SUMMARY

• ETL Expert with 7 years of Data warehousing experience using Informatica Power Center and experience in implementation of ETL methodology, Data Extraction, Data collection Transformation and Loading for Business Intelligence.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development using modern programming languages.
• Extensively worked on ETL using Informatica - Power Center /Power Mart.
• Designed complex Mappings and expertise in performance tuning.
• Experience in data warehousing specializing in Star Schema / Snow Flake schema Design and ETL strategy design.
• Participated in Business User’s Meetings to understand their requirements discussed and designed Reports.
• Extensively worked on ETL using Informatica Power Center/ Power Mart.
• Extensive experience in Data Base back-end programming writing/tuning complex SQL queries and also writing stored procedures using PL/SQL.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in dimensional modeling.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, (Interactive, command line utility) to create, schedule and control workflows, tasks and sessions.
• Extensive experience in developing Stored Procedures, Database Triggers.
• Familiar with financial services, General Ledger, Account receivables and payables and assets.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x/6.x, Power Exchange, IDQ

Languages: SQL, PL/SQL, C, C++, XML, HTML, Visual Basic 6.0

Operating Systems: UNIX, Windows NT/ 98/2000/2003/2007, Sun Solaris

Tools: Erwin, TOAD, SQL Navigator, SQL Developer, Teradata SQL Assistant, SQL Loader, Salesforce

Databases: Oracle 11g/10g/9i/8i, T-SQL, MS SQL Server 2000/2005/2008, TeradataV2R5/V2R4, MS Access, DB2, Postgres

Job Scheduling: Autosys, Tidal, Control-M

BI Tools: Cognos 6.5, Business Objects XI R3

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. ETL/Informatica Consultant

Responsibilities:

• Responsible for Requirement Gathering, Project Co-ordination and Analysis of source data
• Translated business rules and functionality requirements into ETL procedures
• Implemented extraction/transformation/load (ETL) interfaces to facilitate transitioning from old legacy Postgres and Salesforce systems to Oracle systems.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Implemented best practices in ETL Design and development and ability to load data into highly normalized tables and star schemas.
• Performance tuning has been done to increase the throughput for both mapping and session level and SQL Queries Optimization as well.
• Successfully implemented Type 1 and Type 2 dimensions for inserting and updating slowly changing dimension tables in target for maintaining the history
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data to optimize the performance of mappings.
• Prepared unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
• Automated the jobs thru scheduling using Built in informatica scheduler, which runs every day by maintaining the data validations
• Prepared deployment documents, user guides, coding standards, and other technical documents
• Performed data profiling and data cleansing in order to remove inconsistent data to increase the performance.
• Involved in the Defect analysis call for UAT environment along with users to understand the data and to make any modifications if suggested by the user.
• Prepared Change Request's, Work Order's, Problem Ticket's, and Work Request are for the deployment process.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Provided end user training and Production System Support.

Environment: Informatica Power Center 9.1/9.5, Postgres, Salesforce, DB Solo, ER/Studio Enterprise 8.5, WinSCP 5.1.4, UNIX, Oracle 11g/10g, Toad10.5, SQL Developer, JIRA, Quality Center

Confidential, Colorado Springs, CO

Sr. ETL Developer

Responsibilities:

• Implemented near real time data warehousing solution. Informatica Power Exchange has been used to read the Oracle database logs to capture the changes in the data. The changes are then propagated to a staging area through a “Pull” mechanism using Informatica Power Centre & Power Exchange connector.
• Involved in designing and developing logical & physical data models using Erwin to support the operational reporting applications.
• Performed peer code reviews to ensure compliance with ETL standards.
• Enhanced system performance by optimizing and tuning database objects, reports and ETL processes.
• Assisted the team members in designing & developing ETL mappings and workflows.
• Tuned Existing Oracle scripts for better performance.
• Coded SQL Scripts to create the Development Database, Testing Database, Production Database, including Tablespaces, added datafiles to tablespaces, managed control files, Rollback segments creation, Users, Synonyms, Roles, profiles, Privileges.
• Developing the Informatica mappings, executing sessions, and validating the results.
• Developed SQL and PL/SQL codes for various procedures, functions, and packages to implement the business logics in an Oracle database.
• Managed Metadata associated with Informatica. Queried the metadata for reporting purposes.
• Worked on the complete Life cycle of Business Intelligence project with focus on Extraction, Transformation and Loading of data using Informatica Power Center.
• Developed several complex Oracle Scripts.
• Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-sessions and Pre/Post commands.
• Created, updated and maintained technical documentation, Unit Test plans and release notes.
• Worked as a backup Admin, handled production support issues and resolved issues during Project deployment.

Environment: Informatica Power Center 8.6/9.1, Informatica Power Exchange 8.5, Oracle11g, DB2, UNIX, Windows 2000/XP, FTP Voyager, Quality Centre & Toad.

Confidential, Overland Park, Kansas City

Informatica Developer

Responsibilities:

• Extensively used Informatica 8.1 to load data from sources involving Oracle, SQL Server and Flat files to Oracle Database.
• Involved in the Extraction, Transformation and loading of the data from various sources into the dimensions and the fact tables in the Data Warehouse.
• Created reusable Transformations and Mapplets and used them in various mappings.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
• Assisted in Generating reports using the report-generating tool, Business Objects 6.0

Environment: Informatica 8.6, Business Objects XI, Oracle 11g, SQL Server 2005, Flat files, SQL, PL/SQL, Windows NT.

Confidential

Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Extensively worked on Power Center Designer to develop mappings using several transformations such as Filter, Joiner, Lookup, Rank, Sequence Generator, Aggregator and Expression transformations.
• Implemented Type 1 and Type 2 Slowly Changing Dimensions.
• Created parameter files and used mapping parameters and variables for incremental loading of data.
• Involved in performance Tuning of Transformations, mappings, and Sessions for better performance.
• Used pre-session and post-session scripts for dropping and recreating indexes on target table.
• Generated test plans and performed unit testing.
• Involved in developing the Tables, Views, Stored Procedures, Materialized views and Indexes.

Environment: Informatica Power center, Oracle 8i, TOAD, windows 2000/XP

Confidential

Oracle Developer

Responsibilities:

• Involved in design and development activities of the project.
• Interacted with the end users and superior staff at branch level, region level and corporate level, for collecting the user requirements
• Analyzed requirements and drawn E-R Diagrams
• Developed stored procedures and triggers in PL/SQL
• Developed around 35 screens to support all activities

Environment: Oracle 8i, PL/SQL, SQL*Plus, SQL Loader, HTML 4.0, XML, Flat files, Windows NT 4.0, HP-UX, Shell Scripting