SUMMARY

• 7 years of IT experience in Software Analysis, Development, and Implementation of business applications.
• Experience in IT with proven technical proficiency in Informati Confidential like Metadata Manager, Business Glossary, Master Data Management and PowerCenter, Informatica Data Quality.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Pharmaceutical, Financial, Insurance, Health care domains.
• Experience in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica with Oracle, SQL Server, DB2, Teradata databases.
• Experience in developing ETL mappings using Informatica Power Center.
• Experience working on Data quality tools like Informatica IDQ, Informatica MDM.
• Experience in Informatica MDM where data Cleansing, De - duping and Address correction were performed.
• Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, writing and customizing user exits, customizing/configuring Data Director.
• Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data Cleansing, and Data Validation.
• Very good understanding of Metadata Manager (MM) architectures and business processes.
• Proficient in Metadata Manager configuration - Customizing models, Integrating various models.
• Experience in creating business glossary using Informatica Metadata Manager.
• Excellent skills in gathering requirements and creating a Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and Power Designer.
• Expertise in working with various sources such as Oracle, SQL Server, DB2, Teradata, Flat/XML files.
• Experience in using Toad Xpert v11.6, Oracle 11g, SQL Developer, PL/SQL, SQL*Plus.
• Good experience in Relational Database Concepts, Entity relational Diagrams.
• Excellent in writing SQL queries using SQL, SQL*Plus, PL/SQL, Procedures/Functions, and Triggers.
• Utilized AUTOTRACE and EXPLAIN PLAN for monitoring the SQL query performance.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using shell scripting.
• Experience in implementing MDM software solutions with Informatica MDM formerly, Siperian, Strong exposure to working on scheduling tools like AutoSys and Control-M.
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches.
• Proficient in implementing complex business rules by creating re-usable transformations, Workflows/Worklets and Mappings/Mapplets.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys, Tidal, Control-M, Tivoli, Maestro scripts.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.
• Strong in Designing, Development (coding), Testing, Implementation and Documentation as per Industry standards.
• Knowledge on Agile tools and Scrum methodologies.
• Involved in testing debugging, bugs fixing and documentation of the system. Participated in design and code reviews and verified compliance with the projects plan.
• Coordination with business users for user acceptance testing, sign-offs and implementation.

TECHNICAL SKILLS

Informatica Tools: Informatica Power Center, Informatica MDM HUB, Informatica IDQ, Informatica Data Directory, Informatica Metadata Manager and Business Glossary(9.5.1, 9.6.0,9.6.1)

Data Modeling: Erwin, Power Designer

Databases: Oracle, SQL Server, Teradata, DB2

DB Tools: Toad, SQL Developer

Programming: SQL, PL/SQL, Shell Scripting

Other Tools: JIRA, PuTTy, MS Visio, MS Project, Word, Excel, PowerPoint, HPQC- ALM, CA Workload Automation, Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Informatica Consultant

Responsibilities:

• Interacted with business representatives for Requirement Analysis and to define Business and Functional Specifications.
• Involved in MDM architecture and design discussions with the teams.
• Gathering the functional and technical requirements for MDM work stream.
• Teamed up with Enterprise Information Quality & Governance Office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
• Successfully imported various type resources (Data models, Databases, ETL, Reporting Metadata etc.) and harvested enterprise level data lineage.
• Experience in creating Metadata Catalogue and Data Lineage using INFA Metadata Manager
• Used Informatica Metadata Manager to relate business terms to technical metadata and other business terms.
• Experience in creating business glossary using Informatica Metadata Manager.
• Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.
• Experience in Match Rule Creation and Performance Tuning of Match rules, Trust Score optimization.
• Participated in and led the requirement gathering/solution architecture for MDM initiatives.
• Documented at a functional level how the procedures work within the data quality applications
• Worked on various Informatica PowerCenter components like Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Developmentand coordination with team oncustomizedJavalogicand rules to leverage MDM services.
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files and Mainframe files.
• Involved in the design, development and implementation of the MDM HUB decommissioning project using Informatica PowerCenter that reduced development and implementation cost and time.
• Good at handling end to end MDM Development for Data Loading and Data Remediation Tasks.
• Worked as a part of team on the web service integration for UI (IDD) with MDM Hub’s Service Integration Framework.
• Extensively used XML Parser, XML Generator and XML Source Qualifier transformations where applicable.
• Provide input to Data modelling and physical database development standards with the Data Modelling Team. Assist in the review of database structures of proposed business application purchases.
• Created reference/pass-through ports in XML Transformations to correlate the parsed data.
• Extensively worked with Web Services Consumer Transformation to retrieve data from web services applications and web oriented systems.
• Designed and developed client centric Master Data Management (MDM) HUB solution.
• Proficient in configuring and creating IDD application.
• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM HUB implementation.
• Expertise in creating roles and users, assigning roles to the users based on the requirement, and configuring data masking in IDD.
• Used user defined functions to minimize the overhead of coding and enhanced reusability of the same.
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for create sources, targets and views.
• Production support for the Informatica process, troubleshoot and debug any errors.
• Worked with Informaticatools IDQ (Data Analyst, Developer) with various data profiling techniques to cleanse, match/remove duplicate data.
• Worked with cleanse, parse, standardization, validation, scorecard transformations.
• Worked on XML generated files as targets.
• Created test cases and completed unit, integration and system tests for Data Warehouse and Data mart.

Confidential, New York, NY

Informatica Consultant

Responsibilities:

• Involved in Preparing the High Level Design (HLD) and Low Level Design (LLD) documents for ETL Informatica process.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Utilized InformaticaIDQ (Data Analyst, Developer) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Implemented MDM HUB in testing the data quality services and good working knowledge on MDM HUB.
• Involved in checkingData accuracystandards for NULLS, Comparison, key generator and labeler usingreference table manager in PWHand rolled based on statistics throughThreshold value and Score Cardsapplied the Data cleansing process in Model Repository on same domain and merged to Power center.
• Worked onMappletsand createdparameter fileswherever necessary to facilitatereusability
• Developed several generic Informatica jobs which can be reused for several processes.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation.
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional Data modeling using star and snowflake schemas.
• Extensively used Informatica FunctionsLTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and datefunctions in Transformations.
• Extensively used Informatica XML transformations like XML Source Qualifier, XML Parser and XML Generator to load data from XML files to DWH
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Developed complex mapping logic using various transformations like EXPRESSION, LOOKUP, JOINER, FILTER, SORTER, ROUTER, UPDATE STRATEGY, SEQUENCE GENERATOR, JAVA, RANK, AGGREGATOR, SQL, XML, AND NORMALIZER.
• Work closely with Data modeling team to finalize the staging area and base dimension and fact tables.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, depending on data load requirements
• Created shell scripts to kickoffInformatica workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Created Tidal jobs to schedule Informatica Workflows. Executed workflows using Tidal schedule.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Confidential

Informatica Consultant

Responsibilities:

• Interacting with end users to get business Requirements and reporting needs. Created Business Requirement Document based on the client requirement and existing application.
• Worked on Informatica Power Center 9.1 tool- Source Analyzer, Target designer, Mapping Designer, Transformation Developer, Mapplet Designer
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Involved in creation of Informatica mappings to build complex business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Connected and Unconnected Lookups, Filter, Router, Rank, Mapplet Input, Mapplet output, Update Strategy, Normalizer, Java, Stored procedure, and Sequence generator transformations.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Extensively worked on Mapplets, Reusable Transformations, and Worklets there by providing the flexibility to developers in next increments.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented SCD Type 1 and SCD Type 2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.

Confidential, Buffalo, NY

Informatica Consultant

Responsibilities:

• Converting the business requirements to design document.
• Extensively used Power Designer tool for creation of Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Provided the Production Support by running the jobs and fixing the bugs.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Implemented SCD Type 1 and SCD Type 2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Creation of Review documents for specification document and test cases.
• Created the Autosys JOB Creation documents and send them to Command Center (CC) team to schedule Informatica Jobs and Unix Scripts accordingly.
• Extensively worked on Performance tuning of targets, sources, mappings and sessions.
• Worked on creation of Oracle Tables, Views, Materialized Views and Synonyms.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively worked on Informatica Code Migration processes across the DEV/QAR and PROD environments by maintaining Version Control (Check in/Check Out) using Tortoise SVN tool.
• Prepared documents like Deployment Doc, Estimation Reports, Run Book Doc, Tractability Reports, Development tracking report and weekly status reports (WSR).

Confidential

Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Responsible for dimensional modelling of the data warehouse to design the business process.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence
• Created the Source and Target Definitions in Informatica Power Centre-Designer
• Designed and developed Informatica Mapping for data load and data cleansing
• Extracted source data from VSAM files using Informatica, and loaded into DB2 targets.
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Implemented design improvements to increase scalability of the target data mart to avoid duplicate records. These included the increased parallelism to allow sessions to be spread across all available processors. This scalability proved crucial in allowing enterprise wide usage of the data mart.
• Used Informatica repository manager to backup and migrate metadata in development, test systems.

Confidential

Informatica ETL Developer

Responsibilities:

• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications using Erwin Tools.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Developing PL/SQL programs for data manipulation.
• Installation of Oracle client tools and establishing connectivity to databases.
• Creating table spaces, tables, indexes, users and Implemented table partitioning to improve performance and data management.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Written Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Worked with various kinds of input source files ranging from flat file to DB2 tables.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.
• Worked in offshore onshore model project.