SUMMARY

• Senior Informatica MDM Developer with 9+ years of experience with Informatica PowerCenter (9.5.1, 9.1, 8.6, 8.1.1), Informatica MDM 9.1 and in developing & Administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager, Workflow Monitor & Admin console. Expertise in Informatica CDC, IDQ, MDM.
• Experience in data extraction, transformation and loading data using Informatica PowerCenter 9.0.1, 8.6, 8.3, 8.1/7.x (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Hands on experience on Informatica CDC, IDQ, MDM.
• Experience in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica /Business Data Director.
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub.
• Developing the Mappings to load the Data from Landing to Staging by using various cleanse functions.
• Expertise in Informatica MDM Hub Match and Merge process, Batch Jobs, Batch Groups, Validation Rules, Trust settings for source systems.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules and helped business to develop Trust Scores for MDM Hub.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Experience in analysis of source systems to uncover erroneous, duplicate data and integrity issues related to the data.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Data Validation and Data cleaning using User Exits
• Experience in Optimization and Performance Tuning of match rules as per the business requirements.
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects
• Data Quality and Data integration in real-time using SIF API's
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data
• Experience in creation of subject area groups, subject areas, subject area child and search queries for managing the MDM Hub data through IDD.
• Expertise in implementing the approval process for subject areas in IDD, according to business rules and requirements.
• Worked on Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-Production and Production environments.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Identified Golden Record (BVT) for Customer Data by analyzing the data cleansing and merging duplicate records coming from different source systems.
• Expertise in creating Test Plans and writing Test Cases.
• Experienced in integration of various data sources like Oracle 10g/9i/8i, IBM DB2, MS SQL Server 2012/2008/2005 , XML files, Mainframe COBOL sources into staging area and different target databases.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Performed data profiling in the source systems that are required for MDM system.
• Participated in all phases of the Software development lifecycle (SDLC) using both Agile and Waterfall methodologies.
• Experience in all stages of ETL - requirement gathering, designing and developing various mappings, unit testing, integration testing and regression testing.
• Design, develop, test and review & optimize Informatica MDM (Siperian) and IDD Applications.
• Experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica PowerCenter 9.x, 8.x, 7.x versions.
• Extensive Experience in designing and developing complex mappings applying various transformations such as Expression, Aggregator, Lookup, Source qualifier, Update strategy, Filter, Router, Sequence generator, Rank, Stored procedure, Joiner and Sorter.
• Good knowledge on Data Analysis/Validation and Profiling based on the business and functional requirements of the Project.
• Proficient in the implementation of Data Cleanup procedures, Stored Procedures, Scripts and execution of Test plans for loading the data successfully into the various Target types (Relational and flat file).
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change Data Capture (CDC), Customer Data Integration (CDI).
• Involved in performance improvements using partitioning, pushdown optimization and parallel loading.
• Involved in performance tuning and resolving performance bottlenecks of sources, transformation, targets, mappings and sessions.
• Experience in detecting/resolving bottlenecks at various levels like source, target, mapping and sessions.
• Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Used various database client tools like TOAD, SQL developer, SQL server to access/create/change database objects and create scripts.
• Extensively worked with Oracle, SQL Server and UNIX shell scripting, Linux
• Involved in preparing required Tech Specification Documents from the Business requirements following Organization standard.
• Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists (CMXUE), developed Match-Merge setup
• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
• Experience on Data Modeling Tools Erwin, Sybase Power designer.
• Experience in working on Enterprise Job scheduling tools like Autosys.
• Adept at communicating with business/clients for understanding business processes/problems, gathering requirements and providing solutions.
• Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to the team/organizational environment.

TECHNICAL SKILLS

• Informatica Power Center 9.0.1 8.x/7.x Informatica MDM 9.x
• Informatica Data Director (IDD)
• Informatica Power Exchange
• SqlServer Management Studio 2012/2008
• Dimensional Data Modeling (StarSchema Modeling
• Snowflake Schema Modeling
• FACT
• Dimensions Tables)
• SQL Navigator
• DB Artisan
• Cognos
• Oracle BI tools
• OBIEE 10.1.3.1
• Siebel Analytics
• Business Objects (Web-Intelligence 2.5
• Designer 5.0
• Crystal reports and Developer Suite & Set Analyzer 2.0)
• SQL
• PL/SQL
• T-SQL
• C
• VB 5.0
• Java
• Unix Shell Scripting
• Oracle 10g/9i/8i
• MS SQL Server 2012/08/05
• Teradata
• IBM DB2
• MS Access
• TOAD 8.6
• SQL plus
• Query Analyzer
• SQL Assistant

PROFESSIONAL EXPERIENCE

Informatica MDM Developer/Admin

Confidential, Houston, TX

Responsibilities:

• Collaborated closely with Business Analyst to understand the business data flow and in gathering requirements
• Informatica MDM Admin activities- creating users, roles, assigning privileges, starting and stopping Application server, maintaining operational repository store (ORS)
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Defined Trust and validation rules before loading the data into the base tables
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for crops, materials and breeders in IDD data tab.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Creating SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Using Linux shell scripts for Control-M Scheduling jobs

Environment: Informatica MDM 9.7.1, Hierarchy Manager, Informatica Data Director, JBOSS 6.2, PL/SQL, TOAD, SQL Developer, Linux, Oracle 11g, SQL Server 2008, Windows 7 Enterprise

Senior ETL Analyst/Informatica MDM Developer

Confidential, San Leandro, CA

Responsibilities:

• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists (CMXUE) etc.
• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
• Involved in translating business requirements to integrate into existing data mart design.
• Coordinated cross-functional team efforts in meeting and exceeding goals.
• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Interact with business users for requirements gathering and converting these requirements into technical solutions for Informatica Master Data Management product
• Lead E2E technical solution to master client data & integration complexity with various upstream and downstream systems
• Lead data mapping of source applications to the MDM data model
• Involved in System analysis, Estimations and design for enhancements.
• Troubleshooting and fine-tuning of mappings for maximum.
• Utilized Informatica Data Quality (IDQ) extensively for loading the data into Informatica MDM Hub
• Proven experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Strong hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Transformation, XML transformation, DT and Normalizer Transformation in Informatica.
• Interacted DBA team to make sure application database and also created all necessary data base objects for our project in Dev and Test Environments.
• Also provided all Database Object scripts for DBA team to deploy stage and prod DB environments.
• Reverse Engineered more than 20 SAP Business Objects reports and identified the source, underlying logic, and the transformation logic that was used to compile the Excel report
• Held meetings with business users to confirm business requirements.
• Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
• Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
• Done Data cleansing, single and cross table structure profiling, analysis on data, and analyze the patterns with Informatica Data Explorer and generating reports and logs.
• Working on Informatica Developer (Informatica Data Quality) 9.0.1 and Informatica Analyst9.0.1 to cleanse and profile the data
• Worked on writing Pl/Sql procedures in Oracle and captured those by using Informatica stored Procedures.
• Generated Scorecards based on profile results
• Done single table structure profiling, cross table structure profiling.
• Created Data quality mappings (plans) and exporting those to power center as mapplets.
• Created Rules on profiled data and used the same to data quality mappings.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.
• Developed BI reports comprising line and pie charts, trend analysis reports and sub-reports according to business requirements, using SQL Server Reporting Services (SSRS).
• Developed several stored procedures using T-SQL for data manipulation.
• Upgraded Informatica 9.5.1 Standard Edition to Informatica 9.6.0 Advanced Edition successfully without any defects/issues for 4 Environments. Configured Repository Service, Integration Service, Web Service, Model Repository Service, Data Integration Service, Analyst Service, Content Management Service, Metadata Manager Service.
• Developed database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

Environment: Informatica Developer9.0.1, Informatica Analyst9.0.1, SQL Server, and SAS. Informatica 9.6.0 & 9.5.1, SSRS, SSIS, Informatica Data Quality 9.6.0 & 9.5.1, Oracle 11g, UNIX, MS SQL Server, MDM, Teradata, MS Access, PL/SQL, My SQL and flat files, HP ALM, Microsoft Dynamics AX.

Informatica MDM Developer

Confidential, San Jose CA

Responsibilities:

• Responsible for writing requirements for automation of online contract management tool.
• Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• Configured and installed Informatica MDM Hub server, cleanse server, resource kit, and Address Doctor5 in Development, QA, Pre-prod and Prod Environments.
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Defined Trust and validation rules before loading the data into the base tables
• Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for crops, materials and breeders in IDD data tab.
• Involved in the UAT testing of the Items Data Mart price files tool automation project.
• Responsible for handling Supply Chain Management Data Warehouse and related database and online solutions.
• Work on writing use cases and requirements for Supply Chain Management data upload automation process.
• Involved in maintenance of reporting tools and processes utilizing Data Warehouse data.
• Worked with user support group to in corporate pharmacy contracts in the SCM Contract Catalog.
• Responsible for generating pricing reports from Finance & Procurement Data Warehouse and Data Mart using Business Objects.
• Responsible for managing the online contract management repository and items data mart pricing information.
• Work on formulating the ETL rules using Informatica and Ab Initio.
• Used Informatica Power Center 9.0.1for migrating data from various OLTP databases to the data mart.
• Worked with different sources like Oracle, flat files, XML files, DB2, MS SQL Server
• Extracted data from Sales department to flat files and load the data to the target database
• Developed complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
• Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, and Joiner, Sequence generator.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints for the performance tuning
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Worked with business users and gather data cleansing, data reconciliation and data convergence requirements
• Involved in Designing and developing the OBIEE/Siebel Metadata Repository (.rpd) using OBIEE/Siebel Analytics Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.

Environment: Informatica PowerCenter 9.0.1 (Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Data explorer, Oracle 10g, SQL Server 2012, PL/SQL, Flat files, PLSQL Developer.

Informatica MDM Developer

Confidential, Miami, FL

Responsibilities:

• Responsible for architecting and developing ETL projects for transferring legacy applications data to enterprise data warehouse from end to end. It includes Retail data, HR data, Procurement data and sales data. Designed MDM solution across the department, so that single source of trusted data can be obtained throughout the organization. Analyzed legacy and data sources to bring ALL DATA to a centralized environment and developed data governance, data quality and architected to analyze large volume of information. Responsible for delivering customer information systems across the organization. Took responsibility for integrating variety of data systems, and geographically fragmented customer information.
• Configured and maintained various components of the MDM Hub including the schema, landing and staging tables, configuring Base Objects, Look-ups, Hierarchies, Queries and Query groups.
• Utilized Informatica Data Quality (IDQ) extensively for loading the data into Informatica MDM Hub
• Proven experience in improving the data quality by Match analysis, analysis of the MDM system performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Strong hands on working knowledge in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Create high and low level ETL design to meet user requirements.
• Create other ETL artifacts such as functional requirement document, data model, source-to-Client mapping, test case matrix, deployment document etc.
• Independently develop efficient Informatica mappings, sessions and workflows as per the design specifications.
• Design ETL data model and conduct Knowledge Transfer sessions to share knowledge with the team.
• Support production ETL batch jobs.
• Evaluate, determine root cause and resolve production issues.
• Propose, implement and adhere to best practices, standards and processes.
• Installing and configuring the Informatica and supporting software’s and utilities.
• Perform testing on connections, scripts, workflows, mappings and other scheduled activities.
• Creating repository backup scripts and automated in Active Batch V8 scheduler.
• Creating strategy documents, installation documents and supporting documents.

Environment: Informatica IDQ/IDE, Informatica MDM 9.5.1, Windows 2008 R2, MS Sql Server 2008 R2, Oracle 10g/11g, Perl, TOAD, WINSQL and PLSQL Developer

Informatica Developer

Confidential, MA

Responsibilities:

• Involved in the design, development and implementation of ETL process using Informatica.
• Generated workflows using reusable tasks, worklets and workflows containing sessions, commands, event raise/wait, decision and timers for flow control
• Involved in optimization of ETL programs and SQL queries (overriding SQL query) in order to increase performance
• Worked with relational sources and flat files
• Involved in rigorous testing of ETL mappings
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance
• Provided excellent Informatica production support
• Used Debugger to test the mappings and fix the bugs
• Implemented Informatica Data Quality 8.5 to do data cleansing, data matching, reporting and monitoring the XML files

Environment: Windows XP, Informatica Power Center 8.1.x, DB2 8.1, WinSql 5.5, UNIX

Informatica Developer

Confidential, Camden, NJ

Responsibilities:

• Worked as Informatica Developer to design and develop Informatica mapping. To perform the Extraction, Transform and Load process by studying the business requirement from the users and the mapping documents
• Extensively used COBOL copybook to import the VSAM files from the Mainframe Source. The Mainframe flat file lists were indirectly accessed and implemented mapping with parameters and variables
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on company requirements and load into Oracle tables
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g
• Created XSD for XML files, imported into Designer as XML source qualifier
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Created pre-session and post-session shell scripts and mail-notifications
• Performed error handling for removing database exceptional errors
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica PowerCenter 8.1.1 (Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Mainframe, Solaris 10, Oracle 10g, Informatica PowerExchange, SQL Server 2008, PL/SQL, Flat files, XML Files, ERwin 4.0, TOAD 8.6

Informatica Developer

Confidential, Miami, FL

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehouse (EDW)
• Worked on ETL Migration process from legacy scripts to Informatica PowerCenter 7.1.1
• Involved in the creation of logical and physical designs using ERwin data modeler to develop Database schemas in dimensional modeling
• Worked on Informatica PowerCenter Designer - Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer
• Used various Informatica transformations to recreate data in the data warehouse
• Involved in Data cleansing before loading into Oracle data warehouse
• Designed and developed Aggregate, Join, Lookup transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions
• Used Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, update the records for Slowly Changing Dimension tables
• Worked on change data capture for slowly changing dimensions (SCD-2) to update a target table to keep full history
• Extensively used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Automated scheduling of sessions at regular intervals using Informatica Scheduler
• Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to Improve performance
• Extensively used debugger to troubleshoot logical errors
• Used workflow manager for session management, database connection management and scheduling of jobs
• Monitored workflows and session using PowerCenter workflow monitor

Environment: Informatica PowerCenter 7.1.4 (Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), Windows XP, UNIX, Solaris 9, Oracle 9i, MS SQL Server 2000, XML, Flat files, ERwin, TOAD

Informatica Developer

Confidential

Responsibilities:

• Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 6.x.
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
• Responsible for creating DLL for report design in HTML format and calling them from ASP pages to provide more security for Crystal Reports.
• Involved in the Performance Tuning.
• Created and ran sessions and workflows using Workflow Manager.
• Monitored the sessions and workflows using Workflow Monitor.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.

Environment: Informatica PowerCenter 7.1 (Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 9i, DB2, Sybase, Cobol files, MS SQL Server 2005, TOAD, UNIX, PL/SQL, SQL Loader, Windows 2000/XP

Database Developer

Confidential

Responsibilities:

• Written SQL Queries for handling data in the database.
• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during developmentof Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Maintained system security, control and monitor user access to database
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, and idle time and quota management on table-spaces.

Environment: Oracle 9i, SQL Plus, PL/SQL, T-SQL, Windows XP