SUMMARY

• Over 7+ years of ETL experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing solutions using Informatica Power center and Informatica MDM.
• Extensive experience in Informatica Power center 9.x, 8.x and Informatica MDM 9x.
• Over 5+ years of IT experience in developing client - server applications using Oracle10g, 11g in very large scale database environment, developing several PL/SQL procedures, queries and UNIX Shell Scripts.
• Technical Expertise in Data Quality using Informatica Data Quality / IDQ and Informatica Power Center.
• Highly proficient in Informatica client tools Power Center Designer, Workflow Manager and Workflow Monitor.
• Creating ETL mappings using Informatica Power Center to move data from multiple sources such as XML, DB2, Teradata, MS SQL Server, Oracle, Fixed Width and Delimited Flat Files, SQL Server, Informix, Sybase into ODS.
• Extensively used ETL methodologies for supporting data extraction, transformation and loading process, in a corporate wide ETL Solution using Informatica Power Center (8.6/9.1/9.5).
• Proficient in designing and developing complex mappings from varied transformations like Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Unconnected and Connected lookups, Union, Sequence Generator, Sorter, Update Strategy, Normalizer etc.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Efficient in optimizing Informatica Mappings and Sessions to improve the performance.
• Expertise in Job Automation, Query Analyzing, performance tuning of Informatica mappings.
• Extensively worked on slowly changing Dimensions based on the requirements.
• Good understanding in entity relationship and Data Models.
• Excellent understanding of Data modeling (Dimensional & Relational) on Star-schema, Snowflake schema using fact and dimension tables and relational databases, MS Access, client and server applications.
• Experience working with Software Development Life cycle (SDLC) and implementing Agile methodologies.
• Extensively Worked on Informatica Master Data Management.
• Extensive knowledge in MDM design documents including detailed steps and Visio diagrams that described the data processes and scenarios.
• Proficient on setting up new ORS, creating users and assigning Permissions to the Users in MDM.
• Worked on Data Model Elements (Landing, Base Objects and Staging tables) and Data Model Implementation.
• Worked Extensively on Data Flow process like Stage Process and Load Process
• Tuned Initial data load, Subsequent data loads and match rules for better performance.
• Worked extensively on Match Process and Merge Process and also on IDD to display data to users.
• Worked on Task Assignment Process to assign the task to the Users using IDD and hub console.
• Performed Administrative tasks such as daily backup of Hub and IDD code. Migrated Hub and IDD code on a regular basis from Development to other environments.
• Worked on Security Access Manager configuration to create the Roles and setup the Permissions to the roles
• Worked on Fine tuning of Stage, Load and Match Process.
• Strong Knowledge on Data Ware Housing concepts.
• Accustomed with PL/SQL for various software Applications in client-server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems.
• Experience in using SQL tools like SQL Developer / SQL*Plus to run SQL Queries and validate the data.
• Proficient in working with PL/SQL for improving the performance of SQL queries by writing stored procedures, functions, and triggers.
• Extensive experience in production support involving in extensive data analysis, data pump implementation, troubleshoot and maintain different servers.
• Troubleshooting and problem solving applications withInformaticaDebugger.
• Strong knowledge and experience in Health care & Insurance domains.
• Expert knowledge and understanding of Support, technology and business issues in different domains for identifying the client requirements for improvement of the product.
• Excellent problem solving skills and interpersonal skills.
• Quick learner and an excellent team player.

TECHNICAL SKILLS

Databases: Oracle11g,10g, MS SQL server, MS Access,Teradata,Vertica, DB2, My-SQL.

ETL/MDM Tools: Informatica Power Center 9.x, 8.x, Informatica Data Quality 9.x, Informatica Power Exchange 9.x, Informatica MDM 9.x/10, Data stage 8.x

Reporting and Data modelling tools: Business Objects XI, Tableau, Cognos, OBIEE, SSIS, SSRS, Erwin 4.0/7.1, MS Visio.

Operating System: Windows, UNIX, LINUX, Sun Solaris, FEDORA

Languages and Web Technologies: C, C++, C#, SQL, PLSQL, T-SQL, UNIX Shell Scripting, XML, HTML, Java Script.

Other Tools: MS Office, SPSS, SQL*PLUS, PL/SQL Developer, Toad, Sybase,Autosys.

PROFESSIONAL EXPERIENCE

Confidential, Rocky hill, Connecticut

ETL Developer

Responsibilities:

• Involved in Business Discussions and prepared HLD documents for ETL Process.
• Coordinating and maintenance of source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design.
• Informatica client tools -Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager and monitor are put to wide use.
• Worked extensively using look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations.
• Developed mappings to implement type 2 slowly changing dimensions.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts for gathering requirements, business analysis and designing of the data warehouse.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Worked on Different set of sources like Flatfiles, data bases and XML.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows in the development of ETL procedures for moving data from source to target systems.
• Hands-On experience in bulk loading the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Determined bottlenecks at various points like targets, sources, mappings and sessions and worked on the accordingly so as improve their performance.
• Extensively used various Performance tuning Techniques like Optimized Query Performance, Session Performance, Reliability, Partitioning, etc.
• Actively involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Used style sheets to read the XML data and convert the result into XML form.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installation and Documentation of Informatica Power Center setup on multiple environments.
• Involved in identifying the bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to business needs.

Environment: Informatica Power Center 9.5, Erwin 4.0, Oracle 10g, SQL, PL/SQL, TOAD, SQL * Loader, UNIX /LINUX Shell Scripting, Microsoft SQL Server.

Confidential, Pleasanton, California

Sr. ETL/MDM Developer

Responsibilities:

• Analyze the business requirements and the functional specifications.
• Used Informatica power Center 9.5 for extraction, transformation and load (ETL) of data in the data warehouse.
• Worked with multiple source systems such as Flat files, XML, SQL server and Oracle database.
• Developed mappings by implementing the High Level Design Document, was involved in discussions in preparing the low level design document and used several transformations such as Expression, Aggregator, Connected and Unconnected Look-up, Router, Joiner, Store Procedure Transformations.
• Populated the Data Warehouse Dimension tables by applying SCD Type Dimension concept.
• Unit Testing will be done extensively with comprehensive test cases and scenarios to validate the data in the DW tables. It will be documented at every stage of the code for the tables.
• Developed mappings for Customers, Investments and Risk analysis.
• Used Parameter files to define the database connections for these DW tables.
• Used Informatica Scheduler to schedule these mappings as a daily run process.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance and used various mechanisms such as indexing, partitioning, SQL tuning from both Informatica as well as database standpoint.
• Worked as an active team player to validate workflows, source and target tables, connectivity of databases, pre and post SQL commands, record counts on tables upon migration to upgraded Informatica version.
• Worked on upgrading Informatica, part of which involved table data comparisons between the old and the upgraded Development and Production environments and migrating code from Informatica 8.5 to Informatica 9.5.1.
• Worked on developing monthly scheduled delimited flat files that involved sourcing in data from database tables.
• Developed data dictionary tables mappings, sourced in data from flat files stored in source directories to populate database target tables.
• Extensively worked with CTE (Common Table Expression) queries to develop database and flat files using business defined designed mappings.
• Worked on Production Support issues such as validation of SQL query, data-type mismatches, checking for database connectivity and stored procedure connectivity, dropping indexes in independent session and re-creating them in different sessions.
• Worked on developing XML files from excel file data using the XML target definition that was developed using the XSD file.
• Used XML parser to parse the XSD generated and load the data accordingly.
• Worked on impact analysis of different transformations, targets and sources by querying the Informatica Repository OPB tables.
• Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.
• Worked on setting up new ORS, Creating users and assigning Permissions to the Users in MDM
• Worked on Data Model Elements (Landing, Base Objects and Staging tables) and Data Model Implementation.
• Developed validation Rules, Match and Merge Setup the Match paths, Columns and rules (Exact and Fuzzy) in the Match and Merge Process.
• Created Unit test Case documents, technical design documents, Informatica MDM Hub batch process, Informatica Hub and IDD migration request documents.
• Provided technical assistance by responding to inquired regarding errors, problems or questions with programs or interfaces.

Environment: Informatica PowerCenter 9.5.1/8.1, Informatica MDM 9.5, IDD, SQL server 2008, Oracle, Toad, XML,UNIX, Informatica Scheduler.

Confidential, Chicago, Illinois

Informatica/MDM Developer

Responsibilities:

• Extensively used all the features of Informatica 9.1 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Involved in Requirement Gathering, Design & Development, Testing and Documentation.
• Created Informatica Mappings, Sessions and Workflows using Informatica PowerCenter Tools to load the data from Sources such as DB2, Oracle, XML and Flat Files into various targets.
• Involved in parsing HL7 messages from Medipac ADT and inserting into the database using B2B DT Studio
• Performed ETL testing using SQL queries to test and validate that the HL7 messages had been parsed correctly.
• Developer the ETL processes to handle complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Union etc.
• Extensively worked on mapping Variables, Mapping parameters and session parameters.
• Developed and tested complex mappings for Slowly changing dimensions and Change data capture based on requirements using Power Exchange 9.0.1.
• Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ.
• Used Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Expert in creation of Informatica MDM mappings, data cleansing and standardization using the cleanse functions.
• Involved in development of Hub components like Creation of Base Objects, landing table, staging table and mappings.
• Familiar with the Siperian Metadata Manager for Exporting, Importing and promoting schemas.
• Experienced with Trust configuration and Validation rules.
• Formulated foreign key relationships and lookup information.
• Executed and tested match rules on basis of application performance.
• Experienced in Informatica Data director configuration.
• Provided assistance for Siperian object migration and modified Informatica MDM hub.
• Tuned SQL, PL/SQL Queries in Source Qualifier Transformation for better performance.
• Extensive hands on experience in SQL and PL/SQL in creation of database tables, sequences, functions, procedures, packages and triggers.
• Created UNIX scripts for automation of ETL process.
• Loaded data into interface tables or staging table using SQL loader from flat file.
• Provided data loads for QA testing and worked on resolving the defects and used various debugging techniques to debug the mappings.
• Documented mappings, functions specifications and technical requirements.

Environment: Informatica Power Center 9.5.1/9.0.1 , Power Exchange 9.0.1, Informatica MDM Multi-domain Edition 9.x, Informatica IDQ 9.5.1, SQL Server 2008 express, Oracle SQL Developer, Unix Shell Scripting, Flat files, XML Files, MS Visio, Toad 7.0,Windows.

Confidential, Dallas, Texas

Informatica Developer

Responsibilities:

• Extensively used Informatica PowerCenter 8.6 for Extraction, Transformation and Loading process.
• Involved in ETL design strategy to populate the multiple staging tables, Landing tables and Staging tables leading up to the Dimension table.
• Analyzed the source data coming from Oracle, Flat Files, XML and MS Excel coordinated with data warehouse team in developing Dimensional Models.
• Imported various heterogeneous source files using Source Analyzer in the designer.
• Involved in analyzing logical model of source and target.
• Involved in identifying the sources for various dimensions and facts for different data marts according to star schema and snowflake schema design patterns.
• Designed and developed complex Informatica mappings, mapplets, reusable transformations, workflows and worklets using various tasks to facilitate daily, weekly and monthly loading of data.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner transformation in the mapping.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Involved in migrating data from Staging to Data warehouse and Scheduling jobs.
• Created Connected, Unconnected and Dynamic lookup transformation for better performance and increased the Cache file size based on the size of the lookup data.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions.
• Used Debugger and various debugging techniques to test the mappings and fix the bugs.
• Created Unit Testing Document for Informatica ETL routines.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
• Created various SQL and PL/SQL scripts for verification of the required functionalities.

Environment: Informatica Power Center 8.6, Erwin 7.1, Oracle, SQL, PL/SQL, Toad, Windows Server.

Confidential

ETL Developer

Responsibilities:

• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking data stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Developed Metadata repository, configured metadata the Presentation Layer, Business Model Layer & Physical Data Model.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Most important reports are sourced from Portfolio Subject Area to manage the overall portfolio risk and sector concentrations.
• Deployed SSRS reports to reporting server and assisted in troubleshooting deployment problems.
• Provided ETL Design, Estimates for EDW Source of data stage process.
• Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Flat Files, Excel Files and dumped it into a centralized Data mart.
• Developed mappings using Informatica Power Center to load data from various source systems to target database.
• Study and comprehend business requirements, constant interaction with business and come up with a detailed technical specification document.
• Functioned as an ETL designer and SSIS package developer for the entire Health project
• Developed high-visibility and high-priority Interactive Reporting dashboards for online reporting.
• Responsible for the management and migration of SSIS packages in the staging and pre-production environments.
• Generated Dynamic reports from Cubes using Report Builder and SSRS.
• Developed Variance reports using Reporting Services (SSRS)
• Designed developed and tested complex ETL mappings for application integration using IBM - Info Sphere Data Stage.
• Study and comprehend business requirements, constant interaction with business and come up with a detailed technical specification document.
• Provide suggestions to ETL team for performance improvement.
• Implementation to production and supporting business checkout.
• Constant interactions with the DBA and Infrastructure support teams to maintain dev/test environments space requirements and access issues.

Environment: Erwin, Teradata, Toad, Data Stage, Informatica 8.1.1, Sun Solaris, Windows, SSIS, SSRS, Oracle 10g.

Confidential

Database Developer

Responsibilities:

• Created database objects including tables, indexes, roles, clusters, sequence and privileges.
• Involved in documenting the modifications and intended functionalities of the interface.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created and maintained triggers, packages, functions and procedures.
• Extensively Involved in Knowledge Transfer for documentation team for development activities.
• Written PL/SQL programs for generating reports from Oracle Database.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Used SQL Loader and Export, Import utilities for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Extensively involved in developing new database objects such as Tables, Views, Procedures, Functions and Packages as per the business requirements.
• Developed validation packages using PL/SQL package.
• Defining and reviewing the coding standards, besides reviewing the code.
• Involved in developing, modifying numerous forms, reports using Forms Builder and Reports Builder.
• Helped in creating technical specifications by mapping the interface tables with the base tables.
• Helped Project Lead to develop various reports as needed by management.

Environment: PL/SQL, Microsoft SQL Server, DB2, MS Excel.