PROFESSIONAL SUMMARY:

• 9 years of Extensive experience in development and design of ETL(Extract, Transform and Loading data ) methodology for supporting data transformations and processing ETL Solutions using Informatica Power Center (9.x/8.x/7.x), Informatica MDM Hub(9.x).
• Extensively worked on Informatica Designer Components - Source Analyzer, target Designer, Transformations Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• 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.
• Strong expertise in installing and configuring the Informatica MDM components.
• Proficient in the development of solutions using Informatica (Siperian) MDM Hub.
• Configured Informatica Data Director (IDD) for Data Governance to be used by the Business users, IT Managers and DataStewards.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star, Snowflake Schemas.
• Experience in performance tuning of informatica mappings
• Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Experience in integration of various data sources like Oracle, SQL Server, Teradata and flat files into staging area.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, and Triggers.
• Excellent Knowledge in Apex Dataloader for data management in Salesforce.com to perform Insert, update, Export, delete Etc.
• Extensive experience in working with Salesforce.com
• Proficient in using pmcmd and pmrep commands
• Informatica B2B Data Transformation supports transformations and mappings, via XML, of most healthcare industry standards including HIPAA 275,277.
• Used Informatica PowerCenter to extract, transform and load data from heterogeneous systems(flat files,XML,Oracle and DB2) to Staging and Data warehouse.
• Used Teradata Utilities like fast load, multi load and fast export.
• Used Power Exchange Data Change Option(CDC) to Capture modified records.
• Performed data validation by Unit testing, integration testing and System Testing.
• Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Excellent analytical skills. Exhibits great ability to grasp newer technologies. Effective team player with excellent communication skills. Self starter, result oriented team player with an ability to manage multiple tasks simultaneously.

TECHNICAL SKILLS:

Data Warehousing: Informatica MDM 9.5.0,9.1.0, Informatica Power Center 9.x/8.x/7x, Informatica Power Exchange, Informatica Designer, Workflow Manager, Work flow Monitor, Autosys, Control M, SQL*Loader, Control Center, Oracle 11g/10g,Toad 12.6/9.7.2/8.6, PL/SQL.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin4.5/4.0, Oracle Designer, Visio.

Business Analysis/Data Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office, Visio

Databases: Oracle 11g/10g/9ix, MS SQL Server 2012/2008/2005, Sybase ASE 12/12.5.3.

Languages: SQL, T-SQL, PL/SQL, C, UNIX Shell Scripting.

Environment: Unix clones: - HP-UX10/9, WinSCP, Putty, Data Loader, LINUX, Windows95/98/2000/XP, WinNT4.0,Data Loader, Salesforce.com

PROFESSIONAL EXPERIENCE:

Confidential, St.Louis, MO

ETL Informatica/ MDM Developer

Responsibilities:

• Configured and installed Informatica MDM Hub server, Cleanse, resource kit, and Address Doctor
• Worked closely with ETL data architect for performing land batch process to populate data from external source system to landing tables in hub.
• Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool that was coming from various source systems .
• Created mappings and sessions to implement technical enhancements for data
• Data Loads to warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Involved in standardization of Data like of changing a reference data set to a new standard.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• 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 Dealer, Dealer Group, OEM, AD-Agency, Rental Car Company, Nameplate, Worker subject areas in IDD data tab.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages Oracle.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Provided support for the ETL jobs running in Production in order to meet the SLA's.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.6.1 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Worked with Project specific physical and logical data modeling.
• Integrate and managed workload of Power Exchange CDC.
• Responsible for End to End delivery of the work packet (includes coordination with SIT, UAT, Pre-prod testing, Production handover and User manual preparation).
• Developed Unix Shell Scripts and PL/SQL procedures.
• Developed scripts for creating tables, views, synonyms and materialized views in the datamart.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Used Power Exchange to source copybook definition and then to rowtest the data from data files, VSAM files.
• Involved in developing the logical and physical data models using Erwin.
• Designed and developed approaches to acquire data from new sources like Mainframe (DB2), and AS400 (DB2).
• Created Macros in Teradata to enable Change Data Capture (CDC) to identify the delta and maintain the data mart in sync with the source system.
• Copied the data from oracle database to an external directory in an XML format.
• Designed mappings to read data from various relational and file source systems such as Teradata, Oracle, flat files and XML files.

Environment: Informatica MDM 9.5.0,9.1.0, Informatica Power Center 9.6.1, Informatica Multi domain MDM 9.1 HF 6, Power Exchange 9.5, Oracle 11g, SQL, PL/SQL, TOAD 9.7.2, SQL * Loader, Windows NT/XP, XML file sources, ERWIN 7, Data Marts, MS Visio,Data Modeling, DB2, SQL Server 2012, Autosys,CA7,UNIX Shell Scripting.

Confidential, Moundsview, MN

ETL/Conversion Developer

Responsibilities:

• Developed ETL code using Informatica to reflect the business requirements.
• Communicated with business customers to discuss the requirements and enhancements.
• Created shell scripts to fine tune the ETL flow of the workflows.
• Did the Performance tuning at the functional level and at the mapping level and used SQL overrides to minimize data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, and relational connections.
• Actively involved in enhancements and maintenance activities of the DW including tuning, modifying of stored procedures for code enhancements.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Used Pre and post session assignment variables to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler and Autosys to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and troubleshooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Used User-defined and System defined exceptions to handle different types of Errors like NO DATA FOUND, TOO MANY ROWS.
• Identified problems in existing production data and developed adhoc scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica Power Center 9.6.1, Oracle 11 g, Autosys, Toad, Unix, Flat files, WinSCP, Putty, Data Loader, Salesforce.com

Confidential, Jacksonville, FL

Sr Informatica ETL Developer

Responsibilities:

• Analyzed the existing business rules and understood the client's new reporting requirements by interacting with the users in the LOB (Line of Business). Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the existing system and prepared and presented impact analysis. Developed ETL and coding standards document.
• Worked as part of a Scrum Development Team, effectively participated sprint planning, task estimates, task sequencing, task assignments, sprint reviews and retrospectives
• Designed, Developed, upgraded and tuned, new & existing workflows/sessions/mappings following client standards, which include configuration management, security and quality control in coding.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Created re- usable mapplets, worklets and used them in different mappings to streamline the process.
• Performed the Data quality checks in the Data warehouse.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Worked on writing stored procedures in SQL Server to maintain log details and batch processing for the ETL code.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Developed parameter files and used parameters and variables to support SQL override.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, target based commit interval and SQL overrides.
• Created batch scripts for automation of ETL processes.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Performance and Unit Testing of Informatica Sessions, Batches and Target Data. Resolved Remedy Tickets and work orders on Priority basis.
• Participated in Technical feasibility discussions, Peer reviews and in unit testing. Performed code reviews with peers.
• Managed the postproduction issues and delivered all assignments / projects within specified time lines.
• Created weekly project status report for senior management.
• Acted as the main point of contact to the Testing team infixing bugs raised by QA.
• Used PMCMD commands to communicate with the Informatica server.
• Used debugger in Informatica Designer to resolve the issues regarding data and reduced project delay.
• Extensively worked on impact analysis for Informatica mappings.

Environment: Informatica Power Center 9.1, Oracle, COGNOS, WinSCP, Filezilla, TOAD, SQL Developer, PL/SQL, SQL Server 2012, UNIX Shell Scripting.

Confidential, Minneapolis, MN

Informatica ETL Developer

Responsibilities:

• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Responsible for offshore Code delivery and review process
• Used Informatica to extract data from DB2, UDB, XML, Flat files and Excel files to load the data into the Teradata
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor
• Used Power Exchange to source copybook definition and then to row test the data from data files etc.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Involved in UNIX shell scripting and configuring cron-jobs and Control M jobs for ETL Loads.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Worked with data Extraction, Transformation and Loading data using BTEQ, Fast load, Multiload
• Used the Teradata fast load/Multiload utilities to load data into tables.
• Involved in writing a procedure to check the up-to-date statistics on tables.
• Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.
• Took part in migration of jobs from UIT to SIT and to UAT
• Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions
• Involved in Informatica Code Migration across various Environments.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, Power Exchange 9.1, Fast load, Multiload, Teradata SQL Assistant, MS SQL Server 2012/2008, Data Marts, SQL, PL/SQL, T-SQL, SQL*Plus, DB2, Data Modeling, TOAD, Erwin, UNIX Shell Scripting, AIX, Shell Scripts, Autosys, Unix.

Confidential

ETL Developer

Responsibilities:

• Analyzed the business requirements for ETL process.
• Created a few mappings and fixed existing mappings
• Worked closely with the project lead and other team members to understand the business requirement.
• Performed Adhoc queries to check for consistency of the data in the tables.
• Using ERWIN to identify Fact and Dimension Tables.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Created ETL design for a DB2 UDB data mart loading using Informatica Power Center.
• Worked extensively with mappings using expressions, aggregator, joiner, filters, lookup, router, and union and Update strategy.
• Developed PL/SQL stored procedures/functions and Unix Shell Scripts as a part of the project.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Wrote Shell Scripts, SQL statements and PL/SQL Stored Procedures.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly Loading of Data.
• Implemented Slowly Changing Dimensions Type 1 and Type 2

Environment: Informatica Power Center 7.1, Sybase ASE12, Oracle 9i, Control M, Toad, PL/SQL, UNIX Shell Scripting, SQL Server 2005, UNIX, DB2, Windows XP.