SUMMARY:

• 9years of total IT experience in the Business Requirements Analysis, Application Design, Enterprise data warehousedevelopment in Analysis, Design, Development, Implementation and Troubleshooting in the areas of Data Warehousing Methodologies using Informatica Power Center, Informatica Master Data Management(MDM), InformaticaData Quality(IDQ), Informatica Cloud, Teradataand Testing of software systems in various industries like, Insurance, Banking, Manufacturing and Pharma Domains
• Experience in Extraction, Transformation andloading (ETL) of data from various sources into Data Marts and Data Warehouses using Informatica Power Center Tools (Designer, Workflow manager, Workflow Monitor and Repository Manager).
• Vast experience in developing complex mappings using Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Sequence Generator and Lookup (Connected and UnConnected),Union transformations.
• Experience in creating Reusable and Non reusable sessions tasks, Command tasks, Emailtasks, Assignment Taskand Decision tasks, workflows using Workflow manager tool.
• Experience in the integration of various data sources such asOracle, Teradata and Flat files and XML files.
• Experience in Informatica MDM (Siperian) Hub, Informatica Data Director(IDD), designing of Cleanse functions and Match rules, MDM User Exits, SIF API Calls.
• Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD &Data Modeling.
• Experience in consulting, strategy formulation, direction setting, defining data governance and stewardship processes for MDM solutions.
• Experience in MDM Architecture, Creating Data Model, Defining Landing tables, stage tables and Base Objects.
• Experience in massive data profiling using Informatica Data quality(IDQ), Worked onAddress Validator, Match, Merge, Key generator, Expression, Filter, Consolidation, Standardizer and Association transformations for Source data profiling.
• Experience in Exporting IDQmapplets toInformatica Powercenter.
• Experience working with Informatica cloud, worked on Creating Data replication tasks, Data synchronization tasks, Data Configuration tasks and task flows for data synchronization and data replication to Sales force.
• CreatedCloud mappings using various transformations like Expression, Lookup, Filter, aggregator and update strategy transformation to push the data to sales force database.
• Experience in migrating the code from one environment to another environment in Informatica cloud.
• Extensively used tools of MLoad, BTeq, Fast Export and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Proficient in Writing SQL Scripting and PL SQL Programming.
• Proficient in UNIX Commands and shell scripting.
• Hands on experience on Autosys Scheduler Tool.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Data Vault, Oracle Designer and modeling tools like Erwin and Visio, SCD,Surrogate keys, Normalization/De normalization.
• Worked in a variety of Business domains which includes Banking, Insurance and Health Care.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Extensively worked on Push down optimization for better performance.
• Experience in designing ETL Specification documents from Business requirements for data warehouse development.
• Skilled in developing Test Plans, Creating and Executing Test Cases.
• Involved with every phase of the life cycle development, including feasibility studies, design, and coding for large and medium business intelligence projects and continually provided value-added services to the clients.
• Worked with Waterfall, Agile for SDLC project lifecycle.
• Experience in Agile Methodology (Scrum technique), involved in Scrum meetings, Sprintplanning, Sizing user stories and participate in retrospective meetings.
• Excellent Analytical, Written and Communication skills.

TECHNICAL SKILLS:

Data Warehousing ETL: InformaticaPowercenter 9.6/9.1.1/8.6, Informatica MDM 9.6,Informatica Data Quality(IDQ) 9.6, Informatica Cloud,Informatica.

Databases: Oracle 11g/10g/9i, Teradata V2R14/V2R13/V2R12, SQL Server 2008

Languages: UNIX Shell Scripts (Bourne & Korn Shell), PL/SQL, T-SQL, Transact SQL, ANSI SQL, SQL Scripting.

Dimensional Data Modeling: Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling

DB Programming&Tools: Views, Functions, Triggers, Clusters, Procedures, SQL*Plus, TOAD, SQL Navigator, Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, Fast Export.

Operating System: Windows NT, HP-UX, Sun Solaris, LINUX, UNIX, Windows XP Professional/2000/NT/98/95.

BI Tools: Tableau 10.

Scheduling tools: Control M, Autosys.

Other tools: Putty,WinSCP,MS Office suite,MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Skaneateles,NY

Senior InformaticaDeveloper

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• ETL Mapping Documents - Field mapping from the legacy system data sources to the staging database and then to the target database from the business requirements.
• Worked on Powercenter Designer client tools like Source Analyzer, Target Designer, Mapping Designer, mapplet Designer and Transformations Developer.
• Used ETL Informatica Mapping Designer to create mapping using different transformations like Expression, Source Qualifier, Expression, Filter, Router, Sorter, Aggregator, Update Strategy, Sequence Generator and lookuptransformations required to move data into Landing Tables.
• Involved in MDM Architecture, defined Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Experience code promotion using Repository manager from one environment to another environment.
• Performed massive data profiling using Informatica Data quality(IDQ), Worked onAddress Validator using Developer Tool.
• Experience in Exporting IDQ mapplets to Informatica Powercenter
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Developed Informatica Cloud mappings for Data synchronization and task flows.
• Used Various transformation like expression,filter,lookup,aggregator,update strategy transformations in Informatica cloud to create complex mappings to extract the data from sales force.
• Created Unit Test Case Documents.
• Created Session tasks, Command tasks in the work flows using workflow manager
• Provided production support by monitoring the daily running workflows or processes.
• Owned the Production Deployment Activity of ETL components and Database Activities.

Environment:: Informatica Powercenter9.6, IDQ 9.6, Oracle11g,Salesforce Workbench, JSON File,SQL Developer, Unix, Tidal, FileZilla.

Confidential, Philadelphia, PA

Senior Informatica Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.
• ETL Mapping Documents - Field mapping from the legacy system data sources to the staging database and then to the target database from the business requirements.
• Worked on Powercenter Designer client tools like Source Analyzer, Target Designer, Mapping Designer, mapplet Designer and Transformations Developer.
• Used ETL Informatica Mapping Designer to create mapping using different transformations like Expression, Source Qualifier, Expression, Filter, Router, Sorter, Aggregator, Update Strategy, Sequence Generator and lookuptransformations required to move data into Landing Tables.
• Involved in MDM Architecture, defined Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved in implementing Stage process by creating mappings using various cleanse functions to load the data into Stage tables.
• Configured Trust,match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Experience in writing queries and creating Packages.
• Experience in writing user exits for stage and load process.
• Experience in developing web services using SIF API’s.
• Experience in Creating applications using IDD.
• Experience code promotion using Repository manager from one environment to another environment.
• Performed massive data profiling using Informatica Data quality(IDQ), Worked onAddress Validator, Match, Merge, Key generator, Expression, Filter, Consolidation, Standardizer and Association transformations for Source data profiling.
• Experience in Exporting IDQ mapplets to Informatica Powercenter
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Developed Informatica Cloud mappings for Data replication and synchronization and task flows.
• Used Various transformation like expression,filter,lookup,aggregator,update strategy transformations in Informatica cloud to create complex mappings to push the data to sales force.
• Experience in creating resources using Informatica metadata manager for different databases like Oracle,SQL Server.
• Experience in loading resources to Informatica platform and creating glossary.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Proficient in writing complex SQL Scripts,Stored Procedures,Functions and Packages.
• Created Unit Test Case Documents.
• Created Session tasks, Command tasks in the work flows using workflow manager
• Provided production support by monitoring the daily running workflows or processes.
• Owned the Production Deployment Activity of ETL components and Database Activities.

Environment:: Informatica Powercenter9.6,Informatica MDM 9.6,IDQ 9.6,Informatica Cloud,Informatica metadata manager,Oracle 11g,DB2,Sales force Workbench,Flat Files, TOAD, UNIX, Autosys, WinSCP, Putty,soap.

Confidential, Carmel, IN

Sr. Informatica Developer

Responsibilities:

• Involved in analyzing business requirement and source system analysis based on business specification document.
• 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.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in MDM Architecture, defined Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved in implementing Stage process by creating mappings using various cleanse functions to load the data into Stage tables.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data
• Developed mappings in IDQ developer tool using Expression,Key generator, Match,Merge and AssociationConsolidation, Standardizer and Labeler transformations.
• Developed Informatica Cloud mappings for Data replication and synchronization of sales force database.
• Experience in creating resources using Informatica metadata manager for different databases like Oracle,SQL Server and Teradata.
• Experience in loading resources to Informatica platform and creating glossary.
• Created Dash boards,Pie charts,Bar charts,Line charts using tableau.
• Involved in manipulating the data in the view using filters and sorters using tableau.
• Performed Aggregate Calculations on report data, performed joins to pull the data from multiple tables into a single view.
• Handled technical and functional call across the teams.
• Proficient in writing complex SQL Scripts.
• Experience in writing Cursors,Functions,Stored Procedures and Packages using PL SQL.
• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Responsible for offshore Code delivery and review process.
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Involved in Design Review, code review, test review, and gave valuable suggestions.
• Created partitions for parallel processing of data and also worked with DBAs to enhance the data load during production.
• Involved in Informatica Code Migration across various Environments.

Environment: Informatica Powercenter 9.6, Informatica Data Quality9.6(IDQ),Informatica MDM9.6,Informatica Cloud, Informatica metadata manager,Salesforce, Teradata 14,Oracle 11g,sales force Workbench,UNIX,WinSCP,Putty,Autosys.

Confidential, ohio,CO

Sr. ETL Developer

Responsibilities:

• Extensively worked on Informatica Client Tools like Repository Manager, PowerCenter Designer, Workflow Manager and Workflow Monitor.
• Experience in requirement gathering, analysis, design, development, testing, debugging, deployment, documentation and production support.
• Extracted data from various heterogeneous sources like Oracle10g, Flat filesand Teradata.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Filter, Expression, Router, Sorter, Normalizer, Joiner, Lookup, Update Strategy, Union, Aggregator, SequenceGenerator and Transactional Control transformations.
• Created Sessions, Tasks and Workflows using Workflow Manager.
• Implemented Full Pushdown optimization for Confidential Sessions.
• Followed Informatica recommended naming standards and the best practices for ETL development.
• Analyzed and Debugged the procedures and packages using TOAD and SQL Developer.
• ImplementedSCD Type 2 Slowly Changing Dimension Mappings using Lookup and Update Strategy transformations.
• Created pre-SQL and post-SQL queries in Source Qualifier transformation to improve the performance of data extraction.
• Used debugger to monitor the data movement in the transformations and troubleshoot the mappings.
• Extensively used parameter files, mapping variables, mapping parameters and session parameters.
• Developed mappings in IDQ developer tool using Expression, Key generator, Match, Merge and Association Consolidation, Standardizer and Labeler transformations.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved in implementing Stage process by creating mappings using various cleanse functions to load the data into Stage tables.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Extensively used tools of MLoad, BTeq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning

Environment: Informatica Powercenter9.1, Informatica MDM 9.1, IDQ 9.1,Teradata 13, Teradata SQL Assistant, UNIX, Control-M, WinSCP, Putty

Confidential, Denver,CO

Senior Associate Consultant

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica workflow Manager.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) Teradata tables.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Involved in MDM Architecture, defined Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved in implementing Stage process by creating mappings using various cleanse functions to load the data into Stage tables.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Created user exists for stage post load,pre load and prost load process
• Workflow Manager used for creating and maintaining the Sessions, Monitor, edit, schedule, copy, abort and delete the session.
• Involved Working on Functional testing, Integration System testing, Regression testing, And User Acceptance Testing.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Extensively used tools of MLoad, BTeq, FastExport and FastLoad to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Thorough knowledge in Teradata Architecture.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test matrix and test cases for manual and automated testing.

Environment: InformaticaPower Center 9.1,Informatica MDM9.1, Oracle 10g,Teradata 12,UNIX,Putty,WinSCP,Control-M, TOAD, Teradata SQL Assistant.

Confidential

Associate Consultant

Responsibilities:

• Analyzed the existing Stored Procedures and Functions and created Mapping Specification Documents for ETL.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, Union, Normalizer and update strategy.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created mapplets using Informatica developer tool with various transformations like address validator, key generator, match, merge, consolidation and association transformation for source data profiling.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Developed Informatica Cloud mappings for Data replication and synchronization of sales force database.
• Created Complex mappings in Informatica cloud using expression,aggregator,lookup,filter,update strategy to load the data into sales force using Informatica Cloud.

Environment: InformaticaPowercenter 8.6 Informatica Data quality 8.6,Informatica Cloud, Sales force workbench,Oracle 9i,DB2, Windows2000, Autosys.

Confidential, Chattanooga, TN

Sr Software Engineer

• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into databases.

• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, Union, Normalizer and update strategy.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Created unit test cases to verify and validate the report data by running SQL queries.

Environment: Informatica Powercenter 8.6, SSIS,SSRS,SSAS,SQL Server 2008,Oracle 9i,Putty,WinSCP,Unix,Autosys.