SUMMARY

• 9 years of IT experience and Technical proficiency in Data Warehousing, teamed with Business Requirement Analysis, Data - Modeling, ETL, IDQ and Production Support.
• Expertise in Data Warehousing using ETL Tools Informatica PowerCenter, IDQ Developer tool, OBIEE in Windows and UNIX environments - (Developer, Designer, Repository Manager, Workflow Manager) on Oracle, SQL Server, DB2 and SAP R/3 databases.
• Extensive Experience in: Data Warehousing implementations across Health Care, Financial, Pharmaceutical verticals.
• Integration of Relational and Non-Relational databases i.e. Oracle, SQL Server, DB2, SAP R/3 and flat files.
• Involved in end to end project in Informatica: data modeling, designing mappings with complex business logic and scheduling worklets/workflows.
• Extensively worked on transformations like Aggregator, Ranker, Union, Lookup, Filter Update Strategy, XML, Normalizer, SQL and Stored Procedure Transformations.
• Implemented error handling strategy in Informatica mappings.
• Expertise in Performance tuning of targets, sources, mappings and sessions.
• Participated in advance tuning options - Session partitioning, Push Down Optimization, Concurrent worfklows etc
• Used scheduling tools like Control-M, Maestro to automate running of Informatica Workflows on daily Batch Jobs.
• Data profiling using Informatica IDQ Developer tool. Parsing, Standardizing, Matching, and ETL integration implementations.
• Experienced in using IDQ transformations - Standardizer, Parser, Case Converter, Exception, Labeller etc
• Address data cleansing using Informatica Address Doctor to discover deliverable personal and business addresses.
• Thorough understanding on Match and Merge concepts in defining Match path components and Match rules.
• Good understanding on Informatica MDM hub process, landing, staging and loading of Base Objects.
• Conversant in creating Command tasks for FTP, dynamic mapping/session Parameters and variables. - Maintained the batch processes using Unix Shell Scripts
• Documentation on data conversions, test plan/ test cases and execution.
• 24/7 Production Support and fixing errors under critical SLAs.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level, excellent written and verbal communication skills

TECHNICAL SKILLS

ETL tools: Informatica PowerCenter9.x/8.x/7.x/6.x, Power Exchange Informatica PowerMart, Designer, Mapping Designer, Warehouse Designer

Data Modeling: Star-Schema, Snowflake Schema, Facts and DimensionsBI tools Cognos Report Net

OS: Sun Solaris, Windows XP, Windows 2000, Windows 95/98, UNIX

RDBMS: Oracle 9i/Oracle 10g/Oracle 11g, SQL Server 2005/2008Tools/Others SAP R/3, SQL, SQL*Plus, PL/SQL, T-SQL

Languages: C, C++, BASIC, UNIX Shell scripting

GUI: SQL Developer/2000, Oracle Developer 9i, Oracle Toad, SAP GUIPackages MS Office, MS Project, MS Visio

Testing Tools: WinRunner, LoadRunner, TestDirector, Astra Site Manager, Quickest Pro

Acquired Knowledge: SAP BW Reporting, TeraData, AbInitio

PROFESSIONAL EXPERIENCE

Confidential

Senior Informatica Developer

Responsibilities:

• Leaded the Informatica developer team.
• Upgraded the Informatica environment from 9.1 to 9.6 and configured Informatica PowerCenter on Windows 2012 Server and established connections with SAP.
• Created and managed database connections to various data store.
• Integrated Yara’s new SAP systems into Confidential
• Extracted data from SAP tables through Application Source Qualifier and Integrated data from various ERP systems like FICO, SD, MM and PP, using Informatica.
• Created the ETL design documentation and set the standards for development and testing. • Actively involved in data architecture design, analysis, development, Unit/System testing and performance tuning.
• Developed ETL routines using Informatica Power Center using different transformations like Aggregator, Expression, Stored Procedure, XML, Normalizer, Filter, Joiner, connected and unconnected Lookups, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created the Design solution for Incremental loading, Exception Handling and Process/Error Logging mechanisms.
• Worked with Flat files Source/Targets - FTP batch scripts
• Analysis of PL SQL - Stored Procedures
• Implemented advanced optimization techniques - Session partitioning
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Created simple to complex mappings using Powercenter Designer, worked on various transformations.
• Performed Data Quality Analysis to determine cleansing requirements.
• Extensively used mapping Parameters and variables.
• Created Transport Request for ABAP Codes in SAP Dev environment to be deployed to test and finally to Production environments.
• Created sessions and scheduled workflows using Power Center Workflow Manager.
• Conducted Status calls with the Client and prepared reports.
• Involved in execution of the test plans and Prepared Test cases.
• Monitored jobs on daily basis using Workflow monitor.(24/7 Production Support)

Environment: Windows, Informatica 9.1/9.6, Oracle 11, SQL Server, SAP R/3, TeraData

Confidential

Senior Informatica Developer

Responsibilities:

• Used Informatica Data Quality 9.1/9.6.1 (IDQ) for Analysis, data cleansing, data matching, data conversion and exception handling.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Used IDQ transformations- Standardizer, Parser, Exception, Case Converter, Labeller transformations to perform data cleansing and profiling.
• Performed Address data standardization and Validation using Address Doctor for more than 200 countries.
• Used Match and Key Generator transformations to Identify and eliminate duplicates in datasets thorough IDQ components of Edit Distance, Jaro Distance and Mixed Field matcher, enabling the creation of a single view of customers.
• Created IDQ mappings and Applications using Informatica Developer tool to move data from multiple sources into targets
• Created IDQ workflows with Human tasks to capture the Data Stewards updates in IDD, using the exception tables.
• Involved in creating and executing MDM Hub mappings and Batch group jobs to load data into IDD
• Responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs.
• Partnered with data stewards to provide summary results of data quality analysis through IDD, which will be used to make decisions regarding how to measure business rules and quality of the data.
• Exported IDQ mapping to PowerCenter.

Environment: Windows, Informatica 9.1 IDQ, IDD, MDM 9.1/9.6.1,Oracle

Confidential, Dallas

Senior Informatica Developer

Responsibilities:

• Created the ETL design documentation and set the standards for development and testing.
• Actively involved in data architecture design, analysis, development, Unit/System testing and performance tuning.
• Developed ETL routines using Informatica Power Center using different transformations like Aggregator, Expression, Stored Procedure, XML, Normalizer, Filter, Joiner, connected and unconnected Lookups, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created the Design solution for Incremental loading, Exception Handling and Process/Error Logging mechanisms.
• Written Unix scripts to automate Informatica workflows involving dynamic parameter file generation.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Used UNIX Shell Scripts to search for trigger file for the loop to schedule the workflow
• Involved in Design review, code review, Performance analysis and Performance test.
• Extensively worked on Performance Tuning (Both Database and Informatica) and thereby improving the load time.
• Extracted data from sources like DB2, Oracle, XML, Fixed width and Delimited Flat files transformed the data according the business requirement and then Loaded into the Oracle Database.
• Converted PL SQL Procedures into efficient Informatica workflows.
• Performed caching optimization techniques in aggregator, lookup, and joiner transformation.
• Tested all the applications and transported the data to the target Warehouse Oracle tables.
• Created Migration Documentation and Process Flow for mappings and sessions.
• Experience in Informatica Upgrade form Version 8.6.1. to 9.0.1

Environment: Windows, Unix, Informatica 9.1.1/8.6.1 , Oracle 10/11, SQL Server

Confidential

Senior Informatica Developer

Responsibilities:

• Co-ordinated with the Client side IT team and Business Users.
• Installed and configured Informatica PowerCenter 8.6.1 on Windows 2000 Server and established connections with SAP.
• Created and managed database connections to various data store.
• Worked on Logical Data Model and Physical Data Model with Star Schema and converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings.
• Extracted data from SAP tables through Application Source Qualifier and Integrated data from various ERP systems like FICO, SD, MM and PP, using Informatica.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Created simple to complex mappings using Powercenter Designer, worked on various transformations.
• Performed Data Quality Analysis to determine cleansing requirements.
• Extensively used mapping Parameters and variables.
• Created Transport Request for ABAP Codes in SAP Dev environment to be deployed to test and finally to Production environments.
• Created sessions and scheduled workflows using Power Center Workflow Manager.
• Conducted Status calls with the Client and prepared reports.
• Involved in execution of the test plans and Prepared Test cases.
• Monitored jobs on daily basis using Workflow monitor.(24/7 Production Support)

Environment: /Technology: Windows, Informatica 8.6.1, Oracle 9, SQL Server, SAP R/3, TeraData

Confidential

Informatica Developer

Responsibilities:

• Monitoring jobs every day using Workflow monitor.
• Identifying the errors when session fails and rectifying the same ASAP
• Understanding existing business model and customer requirements.
• Reviewed source systems and proposed data acquisition strategy.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Extensively used joiner, expression, lookup, update, filter, and router transformations.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Created Sessions and Worklets using Workflow Manager.
• Used shell scripts for automating the execution of maps.
• Prepared Unit Test cases as per business Requirements.

Environment: Windows, Unix, Informatica 7.1/8.6.1, Oracle 9, SQL Server

Confidential

Informatica Developer

Responsibilities:

• Fund Transfer Pricing (FTP)
• Financial Analysis through Cost Allocation and Aggregation
• Capital Risk Management
• 24/7 Production Support and Resolving of Incident tickets.
• Used Informatica as ETL tool for building the data warehouse.
• Scheduling of Informatica using Unix Jobs, Maestro and Mainframe JCLs
• Production Support for the existing IPPMS application.
• Enhancement of the application by modifying and creating new mappings and workflows in Informatica 7.1.1., using various transformations, parameters and variable.
• Involved in Data modeling with Star Schema.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.
• Accustomed to working on People Soft EPM module and UNIX Programming.
• Used windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Extensively worked on files FTP in Unix.
• Created upgrade plan to migrate all internal applications populating data marts and data warehouse to new version.
• Implemented upgrade plan including testing of all production mappings, sessions, workflows.

Environment: /Technology: Windows, Unix, Informatica 7.1/8.6.1, Oracle, SQL Server

Confidential, New Jersey

Junior Informatica Developer

Responsibilities:

• Informatica Designer tasks such as creating mappings, mapplets and Transformations and import of source and target metadata.
• Involved in source data analysis, data cleansing and validation.
• Created Sessions using Designer and extracted data from various sources, transformed data according to the requirement and loaded into data warehouse schema.
• Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load in to the target warehouse.
• Developed various transformations like Filters, Expressions, Sequence Generator and Update Strategy using the Transformation Developer in the Informatica Power Center Designer.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Developed various professional reports using Cognos Report Studio
• Used Stored Procedures and triggers for faster processing of bulk volume of the data.
• Worked on Extraction, Transformation and Loading of data using Informatica Power Center.

Environment: /Technology: Windows, Unix, Informatica 6.1, Oracle

Confidential, MN

Junior Informatica Developer

Responsibilities:

• Involved in Data transfer from legacy systems forming the extracted sources.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Used various transformations like Aggregator, Ranker, Lookup transformation, Filter transformation, Update transformation, stored procedure transformations etc.
• Created sessions using Power Center Server Manager.
• Designed data model for Hospital data.
• Implemented logical and physical data modeling with STAR Schema using Erwin.
• Analyzed the sources, targets, transformed the data, mapped the data and loading the data into target tables.
• Created complex detail, summary report, sub-reports and drill-through reports with prompts.
• Created SQL Server views and materialized views to improve the performance of the reports. These views were then imported to the catalogs.

Environment: /Technology: Windows, Informatica 6.1, Oracle, Cognos