SUMMARY

• Having 7+ years of experience in development, maintenance, support and enhancement in Informatica Power Center, Informatica Data Quality and Informatica MDM.
• Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
• Extensive experience in Extraction, Transformation and Loading of Data into Enterprise Data Warehouse using Informatica Power Center 9.x, 8.x,7.x versions.
• Strong experience in Designing the Workflows, Mappings, creation of Sessions and scheduling them using Informatica PowerCenter 9.x, 8.x, 7.x versions.
• Extracted the data from the SAP source systems SAP BW and SAP ECC and loaded the data into ODS tables.
• Varied experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy, Normalizer and more.
• Experience in Debugging sessions and mappings, Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment.
• Experience in Implementing the Informatica MDM (Master Data Management) process for Customer and Product Master Data Implementation.
• Implemented Exception Handling Mappings by using Data Quality, Data Profiling, Data cleansing and data validation by using IDQ..
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, SAP Source Systems, XML Files) to load into Data Warehouse/Datamart targets.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Worked with DBMS like Oracle 9i/10g/11g, Teradata, MS SQL Server.
• Experience in Database development skills using Oracle PL/SQL to write stored procedures, functions, packages and triggers.
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data Warehousing and Business Intelligence.
• Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 9.X/8.X/7.X, Power Exchange, Informatica MDM 10.0, Informatica DVO 9.6.1, Address Doctor, Informatica Data Quality(IDQ) 9.x/8.x.

Databases: Oracle 9i/10g/11g, IBM DB2, SQL Server 2005/2008,Teradata

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer, Teradata SQL Assistant

Programming: COBOL, JCL, SQL, PL/SQL, Unix Shell Scripting

Scheduling Tools: Autosys, Robot, Informatica Job Scheduler,CA7, UC4

Version Control Tools: Sub Version, SharePoint

Operating Systems: MS DOS, Win 98/2000/XP/7/8, UNIX, Linux

Other Tools: SAP BW 7.3, SAP ECC 6.0, Win SCP, Putty, JIRA, Confidential ALM, Confidential Quality Control

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Developer

Responsibilities:

• Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed code, performed Code Deployment and provided production support.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
• Implemented the Change data capture (CDC) using the Informatica Power Exchange.
• Extracted the data from SAP ECC and BW system’s and loaded the data into ODS tables.
• Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing tablespaces and partitioning schemes.
• Scheduled the Workflows using the Job Scheduler Skybot.
• Responsible for identifying the missed records in different stages from source to target and resolving the issues.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.
• Installing and Configuring of Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications.
• Created Landing tables, Staging tables, BO tables, Mappings, transformations for the MDM development.
• Setting Trust configuration and Validation Rules, Created Match Rules and Merge Settings for MDM process.
• Configured the data flow Land, Stage, Load, Tokenize, Match, Consolidate and Created Query and Packages in HUB..
• Created Informatica Data Director (IDD) UserExits to perform server side validations.

Environment: Informatica Power Center 9.6.1, Informatica Power Exchange, Oracle 11g, Informatica Data Quality(IDQ) 9.6.1, SAP BW 7.3, SAP ECC 6.0, Toad, UC4, Informatica MDM 10.0, Teradata, Informatica Data Director(IDD/BDD), Confidential ALM, Address Doctor.

Confidential, St. Louis, MO

Senior Informatica Developer

Responsibilities:

• Worked on the analysis, design and development to ensure the successful implementation of the data loading processes.
• Set up connection parameters for the source and target using Relational Connections and to hold the path for source and target.
• Involved in analysis and performance of mappings/sessions. Increased performance by tuning the transformations and discussing database issues with the DBA.
• Worked with Data Extraction from Relational DBMS and Flat Files.
• Developed Mappings using Active Transformations such as Aggregator, Filter, Joiner, Router, Sorter, and Union Transformations.
• Also used Passive Transformations such as Expression, Lookup, and Sequence Generator in various mappings.
• Created and used reusable Transformations for easier maintenance of the data.
• Analyzed the sources, Targets, Transformed the data and Mapped the data and loading the data into Targets using Informatica.
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created tables, views, synonyms and sequences. Used SQL Loader for data loading.
• Testing and maintaining of Informatica Mappings.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Environment: Informatica PowerCenter 9.5, Sub Version, Oracle 11g, MS Access, SQL, Confidential Quality Control, Autosys, Unix Shell Scripting, Windows NT, Toad, Flat Files, Informatica MDM 9.7, Address Doctor 5, IDD, Informatica Data Quality(IDQ) 9.5, PL/SQL, Shell Scripting.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Worked on the Module Call Detail Record, sustaining its Production support, implemented digits analysis on the called number to identify the called country, within and outside the nation and identified the international long distance calls.
• Developed the shell scripts to automate the Call Detail Records - Informatica processes and subsequent concatenation of load ready files.
• Involved in drafting Software Requirement Specification for the project.
• Co-ordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Extensively used ETL to load Flat Files, Oracle, XML Files, DB2 and legacy data as sources and Oracle as Targets.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Developed Mappings to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter and Sorter transformations.
• Worked on Data Extraction, Data Transformations, Data Profiling, Data Loading, Data Conversions and Data Analysis.
• Worked with Informatica Power Center Workflow Manager to create sessions, work flows and work-lets.
• Created Workflows and monitored Sessions to execute Informatica mappings.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs using Robot Scheduler Tool.
• Worked on performance tuning of Informatica Jobs by optimizing all transformations.
• Prepared all documents necessary for knowledge transfer such as Data Lineage, ETL Development Standards, ETL Processes, etc..

Environment: Informatica PowerCenter 9.1, Informatica Power Exchange 9.1, Informatica Data Quality (IDQ) 9.1, Oracle 11g, PL/SQL, SQL, Flat Files, TOAD, Unix, SQL Server 2012.

Confidential, NY

Informatica Developer

Responsibilities:

• Involved in gathering functional and technical requirements.
• Designed mappings according to the mapping standards, naming standards and warehouse standards for application development.
• Created mappings using transformations in Informatica PowerCenter like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Worked extensively with passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator and Lookup Transformation.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last and Count in Aggregator Transformation.
• Extensively used SQL Override, Sorter and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in the Joiner Transformation.
• Used Type1 SCD and Type2 SCD mappings to update slowly changing dimension tables.
• Done caching optimization techniques in Aggregator, Lookup and Joiner Transformation.
• Involved in performance tuning for sources, targets, mappings, and sessions.
• Created reusable transformations used in various mappings.
• Used various debugging techniques to debug the mappings.
• Wrote stored PL/SQL procedures for certain Business Requirements
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Created sessions and workflows for designed mappings.

Environment: Informatica Power Center 8.5.1/8.5, MS SQL Server 2005, DB2, PL/SQL, Windows XP, Microsoft Office 2003

Confidential

Informatica Developer

Responsibilities:

• Assisted in creating fact and dimension tables as per requirement.
• Designed Data Warehousing tables in STAR schema methodology.
• Extensively used Informatica Power Center to create data maps for extracting data from Relational, Mainframe system (VSAM files) & DB2 and loaded into Oracle Staging tables initially.
• Used Informatica client tools such as Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Optimized Query Performance, Session Performance and Reliability.
• Configured mappings to handle updates to preserve existing records using Update Strategy Transformation (Slowly Changing Dimensions SCD Type-2).
• Created stored procedures and functions, as per requirements in PL/SQL.
• Used Source Pre-Load, Source Post-Load, Target Pre-Load, Target Post-Load functionality of Stored Procedure Transformation.
• Performed Performance tuning of targets, sources, mappings and session.
• Involved in Partitions of Pipelines to improve performance.
• Used UNIX scripting while writing cron jobs for batch processing.
• Used Test Director to log and keep a track of defects. Worked with Test team in resolve defects.
• Provided Production Support at end of every release.
• Generated reports using Business Objects from Oracle target database.
• Created Multi-Dimensional analysis using Slice/Dice and Drill methods to organize data along with a combination of “Dimension” and “Hierarchies” giving ability to end-users to review data from various viewpoints.
• Documented Technical specifications, business requirements and functional specifications for development of ETL mappings to load data into various tables.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2 UDB, Teradata, UNIX, SQL Server, PL/SQL, SQL*Loader, Win NT/2000.