SUMMARY:

• Having 7 plus years of total IT experience and Technical proficiency in the Data Warehousing involving Analysis, Application Design, Data Modeling, Development Implementation and deployment of Data Warehouses/Data Marts.
• Over 6 years of strong Data Warehousing experience using Informatica PowerCenter (Workflow Manager, workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplet Designer, Transformation developer).
• Over 3 years of Teradata experience using Tools and Utilities like BTEQ, Fast Export, Multi Load, Fast load, TPUMP, SQL Assistant, Queryman, Teradata Manager, Teradata Administrator, Teradata Query Manager, Teradata Performance Monitor and Priority Scheduler.
• Experience in developing Informatica mappings, mapplets, sessions, workflows and repository creation and maintenance.
• Experience in administering Informatica server activities like creating, scheduling and managing sessions.
• Knowledge of full life cycle development for building a Data Warehouse.
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• 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, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
• Expertise in Query Analyzing, performance tuning of Informatica mappings and testing.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, MS Access.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Experienced in populating Fact/Dimension tables for adhoc queries and summary tables.
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.

TECHNICAL SKILLS:

Operating systems: Windows 95/98/00/NT/XP, Windows Server 2003, UNIX .

ETL Tools: Informatica PowerCenter 6.x/7.x/8.x/9.x.

Data Modeling: Star - Schema Modeling, Snowflake Modeling, FACT and Dimension Tables.

Databases: Oracle, MS SQL Server, DB2, MS Access, Teradata.

Languages: PL/SQL, SQL, UNIX, C, C++.

Web technologies: HTML.

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Vis.

Teradata Utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPump, Teradata Sql Assistant.

Other tools: ERWIN, Toad.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of different source systems and prepared technical specifications for the ETL.
• Involved in enhancing the data model for new additions of dimension and tables.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created mappings and Mapplets using the transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator and Update Strategy.
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
• Restructured the Data stage jobs to enhance the performance and clarity of the job and also sent the exact data to the downstream systems.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching.
• Created BTEQ scripts to in corporate the transformation rules.
• Used Toad to write queries and interact with Oracle database.
• Developed several PL/SQL procedures, functions to provide data consistency.
• Developed Unix scripts to automate different tasks involved as part of loading process.
• Performed Unit Testing and Integration Testing on the mappings.
• Did Informatica mapping specification documents for the mappings developed and documented them according to Business standards.

Environment: Informatica Power Center 9.0, Erwin, Oracle 11g, SQL, Power Connect, PL/SQL, UNIX, C#, Windows XP, TOAD, Teradata, Netezza.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Analyzed the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
• Managing Team, Timelines and Coordinating with the Business Partners.
• Converting Logical models into physical models using data modeling software like Erwin.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Interacted with the business people on user requirements.
• Setting up Batches and sessions to schedule the loads at required frequency using Control M scheduler.
• Used the Power Exchange Navigator to read Mainframe Files.
• Extracted data from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi Load, and BTEQ.
• Extensively worked in fixing invalid Mappings and testing Stored Procedures and Functions.
• Involved in Writing Shell scripts to automate the Pre-Session and Post-Sessions Processes.
• Assisted in creating queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• 24*7 job monitoring & fixing the production failures.
• Gathering the Requirements for new products and enhancements.
• Setting up Batches and sessions to schedule the loads at required frequency using control M scheduler.

Environment: Informatica PowerCenter 7.x/8.x, Power Exchange, Teradata, SSRS, Erwin, Oracle, SQL, BTEQ, Power Connect, Share Point, PL/SQL, UNIX, TOAD.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, flat files and identifying data anomalies in operational data.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote Unix Shell scripts to automate workflows.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Used FTP services to retrieve Flat Files from the external sources.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica PowerCenter 7.1.2, Oracle 11i ERP/9i, PL/SQL, SQL*Plus, SQL Loader, HTML 4.0, Erwin 4.0/3.5.2,DB2, Sybase, MS SQL Server 2000, MS-Excel, XML, Flat files, Windows NT, HP-UX, Shell Scripting

Confidential

Informatica Developer

Responsibilities:

• Involved in designing technical specifications for building a Data Mart.
• Created mappings with transformations using Informatica for extraction, transformation, and loading data.
• Worked with transformations such as Source Qualifier, Joiner, Aggregator, Router, and Lookup.
• Performed Debugging and Validation of mappings.
• Involved in Project life cycle, from analysis to production implementation, with emphasis on testing plans, execution, analysis, and results.
• Tuned the mappings using different logics to provide maximum efficiency and performance.
• Created Effective Test Data and Unit Test cases for Vendor Reporting System to ensure the successful execution of the data loading process.
• Developed sessions for loading the data into target database.
• Setup Procedures to Extract, Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse by Using Informatica.
• Defined the Source databases and Target databases in Informatica.
• Involved in the development of extensively used PL/SQL procedures to implement business rules.
• Created PL/SQL packages and procedures to build business rules to load data.
• Designed strategy and coded procedures to extract daily incremental data.
• Created UNIX shell scripting for file handing and archival and also to run the workflows for Informatica mappings.
• Developed materialized views for aggregate data information.
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
• Involved in performance tuning of SQL statements on Oracle database.

Environment: Informatica PowerCenter 7.1.2,Oracle 8i, SQL, HP/UX, Erwin, TOAD Tool, Windows XP PL/SQL, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Involved in the Data warehouse data modeling based on the client requirements.
• Developed Logical and Physical database designs for the transaction system.
• Responsible for migrating the folders or mappings/workflows from development to production environment and Created shortcuts to share the repository objects.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Responsible for configuring the Workflow manager, Repository Server Administration Console, PowerCenter Server, Database Connection.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Used various Informatica Error handling technique to debug failed session.
• Done various optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Developed mapping to implement Type II slowly changing dimensions
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
• Responsible for scheduling the workflow based on the nightly load.
• Supported Oracle 8i databases running mission critical 24*7 systems.

Environment: Informatica PowerCenter 6.1.2,Oracle 8i, SQL, HP/UX, Erwin Data Modeler, MS Visio, TOAD Tool, Windows XP, Teradata.