PROFESSIONAL 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

Lead

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 at 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

Module Lead

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

Data Analyst

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

Confidential

Data Analyst

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

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 at the time of SIT and UAT.
• Validated the Data and generated the reports for user

Confidential

Sr Developer

Environment: DataStage7.5, DTS on SQL Server 2000

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

Sr Developer

Environment: Informatica 7.1 & DB2, Oracle

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.