SUMMARY

• Having around 12 years of IT experience in Data Warehousing Development and migration projects in which, 6+yrs of experience in ETL (Informatica - powerCenter, Informatica developer, Abinitio) development, and around 6yrs exp in Informatica(PowerCenter/MDM) Administration.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse. Extensively used Abinitio and Informatica client tools - Source Analyzer, Warehouse designer, mapping designer.
• Designing, Installing Configuring core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• MDM Hub configurations - Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager.
• Customized/configured IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
• Worked extensively on BDD Config file to get the changes reflected on IDD.
• Designing developing multiple cleansing and standardization scenarios.
• Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
• Performing Data Standardization of addresses using Address Doctor and Informatica Data Quality.
• Profiling Data Sources using IDQ developer analyst .
• Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Working on transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generator, Slowly Changing Dimensions.
• Scheduling and Creating Workflows, sessions involved in the Performance Tuning of Mappings Sessions.
• SQL, UNIX, Shell Scripting, Data Relationships, Data extraction Validation.
• Debugging, troubleshooting, monitoring and performance tuning in SQL queries.
• Having Experience in Informatica Infrastructure administration.
• Familiar IaaS in salesforce, AWS-EC2 & S3, RDS, Cloud watch, Elastic IP’s and managing security groups on AWS.
• Having knowledge with AWS Cloud computing and launching Instances
• Having production support experience on Informatica PowerCenter, IDQ & MDM -Admin with UNIX/TERADATA environment
• Access management for conman and composer programme, involving the pwd management
• Hands-on experience in Informatica Power Center 9.5.1 Administration
• Strong experience on Deployment of Informatica objects from one environment to another.
• Regularly Coordinating with the onsite, offshore team and the client to understand requirements, analyze scripts provided by them and develop specifications.
• Having good knowledge on Tivoli 8.6.0.1
• Having exposure to Tivoli workload scheduler, Tivoli workload Console, Tivoli Workload Admin and experience on setting up Unix Jobs/ETL Jobs in Tivoli
• Prepared the work estimates, and managing the resources
• Prepared Business required documents, LLD for offshore team
• Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
• Experience in design and development of various frameworks and conducting POCs.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte - NC

Informatica IDQ Lead

Environment: Informatica PowerCenter9.6.1, Informatica Metadata Manager & Developer 9.6.1, Informatica MDM10x & MS Sql Server2012 & Unix

Responsibilities:

• Developed reports as per business use case and documented.
• Design and developing IDQ mappings in informatica developer
• Installed & configured MDM servers in all environment from Lab/Dev/SIT/UAT/BCP & PROD.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
• Configure, execute, and monitor the loading and linking of metadata
• Load Business Glossary and link glossary terms with technical metadata objects
• Installed & configured MDM10.1 servers and configured MDM Landing, staging & BO objects.
• Design and developing reusable mapplets for each rule.
• Integrated IDQ mappings with power center
• Developing the dash boards using informatica developer 9.6.1 & generated scorecards with profiling results on source data

Confidential, Chicago, IL

IDQ Analyst

Environment: Informatica Powercenter 9.1 & Developer 9.6.1, Oracle

Responsibilities:

• Designed the project execution frame work and provided the best solution in development.
• Analyzed in detail, existing data quality framework for eCDP and created detail documentation on process sequence with good data examples and integration points.
• Design and developing reusable mapplets for each rule.
• Integrated IDQ mappings with power center
• Developing the dash boards using informatica developer 9.6.1 & generated scorecards with profiling results on source data.
• Participated with the Informatica professional services’ team to complete the development and testing of close to 500 rules as part of the DQM and met deadlines
• Integrating IDQ rules with IPC, Created composite mapplet and mappings

Confidential

Environment: Informatica 9.5.1(powercenter & Developer), Oracle, Teradata, TWS

Responsibilities:

• Coordinating with clients, interfacing teams, database Administrators to get a detailed understanding of existing functionality and system requirements
• Working as Onshore Lead and managing offshore team for coordinating issues and helping resolves issues to the client
• Prepared the work estimates, and managing the resources Confidential onshore
• Prepared Business required documents, Prepared test plan documents, test cases, Test scripts for Development & Migration project and tested accordingly
• Design, implementation and management of security access roles and privileges for all types of metadata consumers.
• Design and development of Metadata Repository backup/recovery strategy.
• Development of processes and guidelines for Metadata management - change management, metadata access and sharing. This will include processes and capabilities for versioning all forms of metadata.
• Configuration of Landing, Staging and Loading processes, Trust and Validation rules, Match and Merge process
• Created Unix scripts to Execute Batch jobs and Batch Groups
• Created Unix scripts which will kick off the informatica workflows and scheduled them through TWS.
• Creation of Hierarchies, relationship type, packages and Profiles
• Analyze profiling results and make recommendations for improvements.
• Build profiling, cleansing and validation plans
• Sole developer building a process in IDQ for cleansing and migrating global customer data.
• Worked along with Tier 1/Tier2 support teams and managed multiple applications and worked on SLA related issues about 45-50 servers(Unix/Linux)
• Script review and porting to target environment.
• Support Data Migration activities, Provide post production support and consultancy.

Confidential, Irwing, TX

Environment: Informatica 9.1, Informatica MDM & Teradata

Responsibilities:

• Analyzing the requirement given by client and Responsible for design and development of Data Warehouse project leveraging Informatica Power Center ETL tool
• Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance.
• Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Sequence generator, Joiner transformations Created Test plan documents and test scripts and tested SIT/UAT Environment.
• Demonstrated experience with design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.
• Knowledge of IDQ 9.1 standards, guidelines and best practices.
• Knowledge of Data Profiling guidelines and best practice
• Carrying out User Acceptance Testing of the codes.
• Played key role in Development environment
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Providing daily status updates to the Onsite coordinator.

Confidential

Environment: Sql Server 2008, Informatica 8.5

Responsibilities:

• Designed and developed Process Code update mapping by using Informatica
• Designed and developed Domain Check mappings
• Created One shot file documents as per the new feed
• Created test plan documents and test scripts for one shot files and tested accordingly
• Regularly coordinating with Onsite and Offshore team

Confidential

Environment: Informatica 8.5 & Teradata, TWS

Responsibilities:

• Analysis of Functional Specification
• Designed and development of ETL mappings using Informatica.
• Testing and Test plan preparation
• Implement Indexing Technique on the Framework
• Tuning the mappings for better Performance (Implement session partition, Persistent Cache etc)
• Deployment of informatica objects from one environment to Another Best Practices Documentation
• Managing the Serena to follow up the issues, and promoting the new code from one environment to another environment.

Confidential

Environment: Ab intio2.14, co ops1.14, Unix

Contribution:

Responsibilities:

• Designed Data Element Mapping Document for Collections Phase-I.
• Prepared Data Validation Test Case Documents for Phase-I and Phase-II.
• Created Data Validation Test Scripts for Phase-I and Phase-II Validated files.
• As per business rule written many complex sql scripts for all Phases (DEV, SIT And UAT).
• Coordinated with Onsite and Offshore ETL Team Confidential the time of SIT and UAT.
• Validated the Data and generated the reports for user

Confidential

Environment: DataStage7.5, DTS on SQL Server 2000

Contribution

Responsibilities:

• Designed and developed Simple, Medium DTS Packages, and Complex Data Stage Jobs based on user requirements to lead data from subscribeV4 Data to SubscribeV6 structure.
• Prepared Test Plans for Unit Testing and tested packages with Unit test plan
• Strategies and prepared test result documents.
• Involved in SQL query optimization.
• Created Sql Scripts for Drop and Creating Indexes Dynamically.
• Created Sql Scripts for Disable and Enable Triggers Dynamically.
• Prepared Test Plans for Unit Testing for Pre and Post Validation Stream and tested Validation Scripts with Unit test plan.
• Prepared the Database change request document
• Strategies and prepared test result documents.
• Direct interaction with clients for change requests and modifications.
• Given knowledge Transfer on Data Stage for new team members.
• Written BCP commands for V4 to V6 Package.

Confidential USA

Environment: Informatica 7.1 & DB2, Oracle

Contribution:

Responsibilities:

• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to lead data from source and RDBMS tables to target tables.
• Ensuring project completion within specified time and in compliance with quality norms and delivering it to the Onsite team.
• Involved in detail design and development of mappings using Informatica.
• Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from source to target systems using Informatica.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table
• Used most of the Transformations such as Source Qualifier, Expression, Joiner, Router, Update Strategy, Filter, and Unconnected Lookups.