SUMMARY

• 12+ years of professional experience in different Informatica Tool set in Business Intelligence/ETL/Data Quality Solution and Designing using Informatica Power center and Informatica IDQ along with Informatica MDM.
• Solid experience in Informatica Power Center 9X/Data Stage, Data profiling/Data quality strategies using Informatica IDQ 9.X along with Informatica MDM 9.7.1
• Data Profiling/Data Quality/ETL: Extensive experience in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica Power Center/Data Stage, Data Quality (IDQ) from versions 9.x for Health Care, Insurance, Banking and Retail Industries in different Methodologies.
• Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, and Reference Data from Various source systems using Informatica Data Quality (IDQ) Toolkit.
• Worked with Address Doctor (Address Validations), Different matching algorithms Biagram / Jaro / Edit / Hamming / Reverse distance in IDQ.
• Worked with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Experienced in Migration of codes from Repository to Repository, wrote up Technical/Functional Mapping specification Documents for each Mapping along with unit testing for future development.
• Proficient in Designing, Configuration and scheduling the Automation Process of Workflows for load frequencies. Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor the system.
• Integrate Informatica MDM and IDQ to profile data and finalizing match rules for MDM hub.
• MDM Solution: with custom and party data model for Finance - Product, Security, Instrument, Account, Cost Center and Customer. HealthCare - Consumer, Provider. Retail - Customer, Vendor, Item.
• Data Governance, Metadata Management, Master Data Management, Reference Data Management, Business Rules Management, Information Knowledge Management, Information and Data Architecture, Database Design, Strategic Data Consulting.
• MDM Hub: Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Configured source systems collaboratively and performed Batch group with Stage and Load jobs.
• Implemented Landing Process for loading the customer Data Set into Informatica MDM from various source systems.
• Design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Data Warehousing: Dimensional modeling Kimball and Inmon’smethodology, Star Schema, Snowflake Schema. Extensive experience with ETL from disparate Data sources like RDBMS, COBOL, XML, main frame system into a common reporting and analytical Data Model.
• Using Scheduling tools Tidal, Control- M and Informatica tasks established the daily batch load.
• Proficient in applying business logic using PL/SQL packages, stored procedures, functions.
• Writing UNIX shell scripts and automating Informatica Jobs/procedure
• Experience working for Disaster Recovery (DR) Testing.
• Informatica ETL Certification (Developer Level) is completed.
• Informatica MDM Certification (HUB) is completed.
• Six Sigma Green Belt Certification is completed.
• Worked on Remedy Force Ticket (Incident, Service Request& Change Request) in SLA environment based out of salesforce platform.
• Experience with On-Site/Off- Shore Model of project delivery.
• Possesses excellent communication and interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS

BI Tools: Informatica Power center 9x/ Informatica Cloud, Informatica Developer (IDQ), Informatica MDM

Reporting Tools: BO Xi R2

Scripting Languages: UNIX Shell scripting

Databases: Oracle, SQL Server, Teradata

Database Tools: TOAD, SQL Developer

Loaders: SQL loader, Salesforce Data Loader, Fload, Mload, Bteq scripts

Testing tools/ALM: HP Quality center

Scheduling tools: Unix Cron Tab, Control-M

Operating systems: UNIX, Windows

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

Informatica Architect

Responsibilities:

• Requirements gathering, analysis and prepared BRD and TDD Document.
• Working with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Key Generator, Lookup etc.
• Address cleanup with the help of Address Validator transformation.
• Worked on profiling the source data to understand and perform Data quality checks and load the cleansed data to Veeva objects before MDM can master the accounts (HCO) and practitioner (HCP) attributes.
• Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.
• Worked on exception handling, and reporting and monitoring capabilities of IDQ.
• Experience in implementing the data rules in Mapplets and Exception record management.
• Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
• Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data.
• Create the test cases and perform for each scenario before mi

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Performed Requirements Analysis and prepared HLD, LLD Document preparation process for mass update and mass extend MDM new process for vendor domain.
• Worked with Informatica Data Quality Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.
• Worked on profiling the source data to understand and perform Data quality checks using Informatica Data Quality and load the cleansed data to landing tables before Informatica MDM can master the accounts and contacts attributes.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ.
• Experience in implementing the data rules in mapplets and Exception record management.
• Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
• Built the Logical Data Objects (LDO) and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
• Implemented Address Doctor as Address Validator transformation for address cleansing.
• Used Metadata Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments
• Experience using Metadata Manager for data lineage and Business Glossary to define business terms.
• Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.
• Create the test cases and Test plan for each scenario.
• Performed sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.
• Create the tasks that generate automated emails for each CRUD requests. Experience in load performance, query performance, archiving, etc.

Confidential, Troy, MI

Informatica Developer

Environment: Informatica MDM, IDD, Informatica power center9.5.1, Informatica Developer 9.5.1, Jboss 6.1, Flat files, ORACLE, UNIX Scripting, Putty, CTRL-M, Salesforce CRM, Remedy force.

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to Data Model for new requirements.
• Worked closely with Project Manager, Architects, Data Modelers and cross team (Salesforce) to understand the business process and functional requirements in an Agile environment.
• Created High level and low level design documents, ETL specification documents and unit test cases.
• Plan the efforts for the development team and assign the work as per scheduled project plan and provide technical guidance and supervision to the team. Also worked on Design and code reviews of ETL Jobs.
• Worked on profiling the source data to understand and perform Data quality checks using Informatica Data Quality and load the cleansed data to landing tables before Informatica MDM can master the accounts and contacts attributes.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ.
• Experience in using the IDQ specific transformations like key generator, labeler, Parser and standardizer transformation.
• Experience in implementing the data rules in mapplets and Exception record management.
• Expertise in Exporting IDQ mappings into Informatica designer and creating tasks in workflow manager and scheduling the mapping with scheduling tools to run these mappings.
• 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 implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Extensively used Informatica to develop jobs to extract, transform and load data from various source systems into the staging and landing tables.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Involved with Master Data Management (MDM) for Customer Data Integration using Siperian tool.
• Handled Mater Data Management (MDM) Hub Console configurations like Stage Process configuration, Load Process Configuration, Hierarchy Manager Configuration.
• Created Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules.
• Analyzed the background tables for the Data analysis purpose. Tables included Stage tables (RAW table, REJ Table, PRL table), XREF table, MTCH Table, HIS table, STRP table.
• Created cleansing functions for effective result set of mapping results.
• Implemented cleanse list functions and pre-defined functions.
• Created reusable cleanse components using Graph Function, Regular Expression function, cleanse list.
• Created queries and packages in the MDM (Master Data Management) HUB Console.
• Created Applications in the IDD (Informatica Data Director) and performed Match and Merge operations.
• Implemented Various user exit process.
• Integrated with the ETL team and developed a new approach for Initial Data loads

Confidential

Informatica consultant/BI Lead

Environment: Windows 7, Informatica 8.6, Informatica Cloud, Teradata, Sales Force (Veeva), Unix, HP Quality Center.

Responsibilities:

• Working as the ETL Architect to handle all kind of development, production Support as well as enhancement activities.
• Creating Integration Test and strategy document, Test Summary report document, Technical Design and mapping Documents.
• Conducting status meeting with client using traceability matrix.
• Doing estimation of new development work as well as for change in existing.
• Requirement gathering from client and ETL Specification creation as per the business requirement.
• Monitoring the daily scheduled jobs running.
• Resolving issues during data loading to sales force objects within the given time limit.
• Used Informatica Power center and Informatica cloud to Create, schedule and monitor Workflows/task flows.
• Develop, test and review mappings against any Change Request given by client or new one.

Confidential

Informatica consultant/BI Lead

Environment: Informatica 8.5, Oracle 9i, BOXI R2, Siebel

Responsibilities:

• Written some of the Batch File to FTP data from one server to another.
• Worked to handle all kind of development, production Support activities.
• Doing estimation of new development work as well as for change in existing.
• Requirement gathering from client and ETL Specification creation as per the business requirement.
• Monitoring the daily scheduled jobs running.

Confidential

Informatica Developer

Environment: Windows XP and Linux, Oracle 9i, Informatica 8.1, BO-XI

Responsibilities:

• Worked as a team member and attended status meeting with client.
• Help doing estimation to other team members of new development work.
• Create unit test cases and perform testing against them.
• Monitoring the daily scheduled jobs running.
• Resolving issues during data loading to warehouse within the given time limit.
• Used Informatica Power center to Create, schedule and monitor Workflows and Send the Messages in case of process failures.
• Develop, test and review mappings against any Change Request given by client or new one.
• Currently working in BOXI also. Creating reports in BO Info view, report migration, taking backup of reports and manage users as well.

Confidential

Informatica Developer

Environment: Windows XP, UNIX, Informatica 8.1, Oracle 9i, Seibel

Responsibilities:

• Worked as the Team member and handled the support and enhancement work successfully.
• Updating and monitoring the daily job monitoring sheet.
• Accepting client’s tickets for any issues and solving it within the given time limit.
• Used Informatica Power center to Create, Schedule, and Monitor the mappings and Send the Messages in case of process failures.
• Develop and test mapping against any Change Request given by client.
• Running the workflows through UNIX shell scripts.

Confidential

Informatica Developer

Environment: Windows 2000, UNIX, Informatica 8.1, Oracle 9i

Responsibilities:

• Designed the ETL processes using Informatica tool to load data from File system, and Oracle into the target Oracle 9i database.
• Developed mappings/sessions using Informatica power center for data loading.
• Used Informatica Workflow Manager & Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.
• Test mapping to assure that data is loaded as per ETL Specification.
• Performed testing as per UTC & FTC.

Confidential

Informatica Developer

Environment: Windows 2000, UNIX, Informatica 7.1, Cognos 6.5, Erwin 4.1, Oracle 9i

Responsibilities:

• Designed the ETL processes using Informatica tool to load data from File system, and Oracle into the target Oracle 9i database.
• Developed mappings/sessions using Informatica power center for data loading.
• Used Informatica Workflow Manager & Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.
• Test mapping to assure that data is loaded as per ETL Specification.
• Performed testing as per UTC.