PROFESSIONAL SUMMARY

• Around 8+ years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center Informatica 9.x/8.x/7.x, Power Exchange, IDQ, Informatica Developer, IDE, MDM, SSIS, OBIEE, QlikView etc.
• Extensive experience using tools and technologies such as Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, DB2 UDB, Sybase, Teradata 13/12/ V2R5/V2R4, Netezza MS Access, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, Erwin 4.0/3.5, SQL* Loader, TOAD, Stored procedures, triggers.
• Strong data modeling experience using Star/Snowflake schemas, Re - engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Experienced in all stages of the software lifecycle Architecture (Waterfall model, Agile Model) for building a Data warehouse.
• Involved in Troubleshooting data warehouse bottlenecks, Performance tuning - session and mapping tuning, session partitioning & implementing Pushdown optimization.
• Extensively worked on various transformations like Lookup, Joiner, Router, Rank, Sorter, Aggregator, Expression, etc.
• Strong understanding to Data Warehousing, Data Architecture, Data Modeling, Data Analysis, SDLC Methods and GUI applications.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Expertise in Installing and Managing Informatica MDM, Metadata Manager and Informatica Data Quality(IDQ), Informatica power center.
• Worked with Informatica Data Quality(IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 10.
• Hands on experience with Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Experience in Informatica MDM Installation, Upgrade, Bugfix and Migration of data.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
• Experience with Teradata utilities like Fast load, Fast Export, Multi Load, TPUMP & TPT & have experience in creating Basic Teradata Query definition (BTEQ) scripts.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Developed the DataStage parallel Jobs using various Processing Stages like Join Stage, Connector Stages, Copy Stage, Merge Stage, Aggregator Stage, Filter Stage, Look up Stage, Transformer Stage, Modify, Filter Stage, Funnel Stage, Change capture stage, Row Generator and Column Generator Stage ..
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2.
• Experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Congo’s and knowledge in MicroStrategy.
• Experienced dealing with outsourced technical resources and coordinating global development efforts
• Excellent communication and interpersonal skills. Committed and Motivated team player with good Analytical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Power Exchange 9.1/8.6/8.1 7.1, Metadata Manager, Power-Exchange, IDQ, IDE, MDM, IDS, SSIS, DataStage, Salesforce etc.

Databases: Oracle 11g/10g, MS SQL Server 2008/2005/2000, MS Access, IBM, DB2, Teradata V12, Siebel CRM, PeopleSoft.

Reporting Tools: QlikView, OBIEE, Tableau, MicroStrategy, Oracle Analytics, etc.

DB Tools: TOAD, SQL Developer, SQL Assistant, Visio, ERWIN.

Languages: C, C++, Java, SQL, PL/SQL

Operating Systems: UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS.

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, Ok

Sr. INFORMATICA Developer

Responsibilities:

• Involved in Business Analysis and Requirements collection.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Experience in extracting addresses from multiple heterogeneous source like flat files, oracle, SAS and SQL server.
• Created custom rules to validate zip codes, states and segregated address data based on country.
• Created web services for address mapplets of different countries to integrate with SOAP UI.
• Used Informatica MDM 10.1 tool to manage Master data of EDW.
• Extracted consolidated golden records from MDM base objects and loaded into downstream applications.
• Experience in validating data quality & business rules by using Mapping document and FSD to maintain the data integrity.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems & created reference tables to standardize data.
• Experience in writing SQL test cases for Data quality validation.
• Experience in various data validation and Data analysis activities to perform data quality testing.
• Experience in Investigating and communicating data quality issues and data failures to onsite DQ development team and fix them.
• Experience in end to end Data quality testing and support in enterprise warehouse environment.
• Experience in maintaining Data Quality, Data consistency and Data accuracy for Data Quality projects.
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica 8.6/& 9.1 Integration servers.
• Experience in Data profiling and Scorecard preparation by using Informatica Analyst.
• Strong knowledge in Informatica IDQ 9.6.1 transformations and power center tool.
• Strong exposure in source to target data flows and Data models for various Data quality projects.
• Involved in daily status call with onsite Project Managers, DQ developers to update the test status and defects.
• Strong knowledge in Databases, Data ware house concepts, ETL process and Business Intelligence.

Environment: Informatica Power Center 9.5/9.1.1/8.6, Power Exchange, Informatica Data Quality 9.6.1, Informatica MDM 10.1, UNIX,Windows NT/2000/XP, SQL Server 2008, SSIS, OBIEE, QlikView, DB2.

Confidential, New Jersey, NJ

Sr. INFORMATICA Developer

Responsibilities:

• Requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Involved in Designing High-level Technical Documentation based on specification provided by the Project Manager.
• Migrated Outbound Data Feeds from SQL Server as source to Oracle as destination.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes when necessary.
• Designed Parallel jobs using various stages like join, merge, remove duplicates, filter, dataset, lookup file set, modify, aggregator and funnel stages. Extensively used Built-in (Sort, Merge, Oracle, Aggregator, DB2 Stages), Plug-in Stages for extraction, transformation and loading of the data.
• Used Quality Stage stages such as Investigate, Standardize, Match and Survive for data quality and data profiling.
• As per Data Architect's directions, created and executed the SCD Type 2 implementation on Dimensional data.
• Used MetaStage for the synchronization and Integration of Metadata from various Data Warehouse related tools and also used for automatically gathering process data from operational systems.
• Developed the customized routines, stored procedures and functions for complex joins to achieve better job performance.
• Used Autosys to schedule the Datastage ETL batch jobs on a daily, weekly and monthly basis.
• Created shell scripts that will invoke the Data Stage jobs passing all variables for job to execute with parameterized databases connection information.
• Exclusively used SQL query to query data from MS SQL Server warehouse for extraction and to also query data from Oracle data warehouse for loading.
• Used the Datastage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Performed Unit, System Testing and modified jobs running in production environment, with minimized downtime.
• Optimized partitioning and parallelism in jobs by doing performance tuning and using indexes for the tables being used.
• Worked on performance tuning and enhancement of Datastage jobs by reducing the use of stages like sort, aggregate and avoided using routines which eliminates the overhead of the procedure call for better performance.

Environment: Informatica Power Center 9.0.1/8.6, IBM Information Server (Datastage) 8.5 (Designer, Manager, Director, Administrator), Oracle 10G, MS Access,Windows NT/2000/XP, SQL Server 2008, UNIX Shell Scripts.

Confidential, East Norriton, PA

ETL Developer

Responsibilities:

• Documented high and low-level design document specifications for source-target mapping, based on the transformation rules.
• Documented technical requirements for ETL process and Design documents for each source. Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration.
• Experience with incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Worked on requirements gathering, architecting the ETL lifecycle and creating design specifications, ETL design documents.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Responsible for Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Schedule the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, XML, SQL server and Flat files and loaded into Oracle.
• Use version mapping to update the slowly changing dimensions to keep full history to the target database.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Extensively worked with Teradata in data Extraction, Transformation and loading from source to target system using BTEQ, Fast Load, and Multi Load.
• Work on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2/XML and migrated those to Teradata.
• Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Data stage jobs.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved writing shell scripts for running Data stage jobs, Using CSV, Excel, text (Hierarchy file for Data stage jobs).
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.

Environment: Informatica Power Center 9.0.1/8.6, Informatica Data Quality 8.6.1, Informatica DataStage 8.5/8.1 - DataStage Designer, DataStage Director, DataStage Manager, Data Stage Administrator, Quality Stage, Oracle, PL/SQL, UNIX Shell Programming, Erwin, DB2.

Confidential, Omaha, NE

ETL Developer

Responsibilities:

• Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and best Practices were followed in mapping development.
• Extensively used Informatica various tasks like Decision, Command, Event Wait, Event Raise, Assignment, Timer, control, Link and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, lookups, Stored procedure and data flow management into multiple targets using router transformations.
• Optimized the SQL override to filter unwanted data and improve session performance.
• Used Debugger to track the path of the source data & also to check the errors in mapping.
• Prepared unit testing document covering field to field's validations and source to target count.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in promoting the folders from Development to Test and Test to UAT and UAT to Production Environment.
• Involved in different Team review, Time estimation and UAT meetings.

Environment: Informatica Power Center 8.6, Oracle 11g, Toad, Autosys, PL/SQL, SQL*Plus, XML, Unix Shell Scripting.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica Power Center 8.6.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for Test and Production issue resolutions.
• Developed shared folder architecture with reusable Mapplets and Transformations.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Created events and various tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Migrating Informatica Objects using Deployment groups.
• Trouble issues in TEST and PROD. Do impact analysis and fix the issues.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes.

Environment: Informatica Power Center 8.6, Power Exchange, Teradata, Access, UNIX,SQL Server 2008, SQL Assistant, DB2.

Confidential

Informatica Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design and development.
• Hands-on Experience in working with Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets to extract, transform and load data.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Resolving technical and design issues.
• Developed data transformation processes, maintain and update loading processes.
• Developed and implemented the UNIX shell scripts for the start and stop procedures of the sessions.
• Used UNIX shell scripts to run the batches.
• Developed standards and procedures to support quality development and testing of data warehouse processes.

Environment: Informatica power center 8.5,Windows NT/2000/XP, SQL Server, Autosys, UNIX. Shell scripting.