SUMMARY

• Around 7 years of total IT experience with Informatica Data Quality, Informatica MDM MDE, Customer 360 of versions 10.4, 10.3, 10.2, 10.1, 10.0, Master Data Management concepts, methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installing and configuring Databases like Oracle, MS SQL Server on premises as well as on AWS.
• Experience in installing and configuring JBoss application server both in standalone mode and clustered mode.
• Experience in installing and configuring Informatica MDM MDE, Active VOS on standalone application server or a clustered application server.
• Experience in installing and configuring Informatica MDM Customer 360.
• Experience in installing and configuring Informatica Server and IDQ services
• Experience in configuring repositories for Informatica services.
• Experience in configuring Address Doctor for IDQ and MDM.
• Experience in installing and configuring Elasticsearch server.
• Experience in configuring HTTPs and SSL settings for JBoss, Informatica Domain, Administrator Console, Informatica Services, Informatica MDM Hub Server, Process Servers, AVOS Server, Elastic Search servers, etc.
• Experience in configuring Landing Tables, Staging Tables, Base Objects, Reference Tables, Relationship Tables, primary - foreign-key relationships, staging lookups, Match/Merge setup, Trust and Validation Rules, Queries and Packages, Hierarchies, etc.
• Experience working with Informatica MDM C360 Data Model.
• Knowledge on Microsoft Dynamics CRM and Salesforce CRM data objects and model.
• Experience in working with Index Job for Smart Search.
• Experience in maintaining and debugging Active VOS.
• Experience in configuring Users for Informatica and Users and Roles for MDM Users.
• Experience in configuring and working with Provisioning Tool for Entity360.
• Experience in working with Business Entity Model and Business Entity Services.
• Experience in working with IDQ for data profiling, data enrichment and standardization, data cleansing.
• Experience in configuring and analyzing Profiles, Mappings, Mapplets, Rules and Transformations in IDQ.
• Working experience with SOAP and RESTful Web Services.
• Experience in SIF APIs for any Batch operations in MDM.
• Experience in working with various databases like Oracle, MS SQL Server, MySQL.
• Knowledge on triggers, cursors, exception handling in PL/SQL.
• Experience with Big Data technologies like Hadoop, HDFS, MapReduce, Spark, Hive, Sqoop, PIG, HQL, HBase, Scala, etc.
• Experience in installation and configuration of Hadoop clusters.
• Good knowledge of Hadoop architecture and the daemons of Hadoop
• Experience on working with Core Java and Java's Object-Oriented Programming Systems.
• Knowledge on different file formats like Text file, XML, Sequence file, AVRO and JSON.
• Working experience on Agile Scrum methodology and Waterfall Methodology.
• Experience in working with ticketing tools like ServiceNow, JIRA, etc.
• Experience working in different phases of project like Development, Testing and Production.
• Experience in handling business concerns, resolving production support tickets, handling change requests and necessary documentation.
• Good exposure to work culture and client interaction with diverse teams. Proven ability to learn quickly and apply new technologies.
• Good communication and written skills and can lead a team and work as a team member.

TECHNICAL SKILLS

Data Management Tools: Informatica MDM MDE, C 360 10.4/10.2/10.1/10.0

Data Quality Tools: Informatica Data Quality 10.4.1 (Developer Tool, Analyst Tool, Monitoring Tool, etc.)

BPM Tools: Active VOS

Databases: Oracle, MS SQL Server, MySQL, Snowflake Database

Cloud Computing Platform: Amazon Web Services (AWS)

Big Data Ecosystem: Apache Hadoop, HDFS, Sqoop, Spark, Spark Streaming, Flume, Oozie, Ambari, Kafka, HBase, Zookeeper, Hortonworks, Cloudera

Distributed Processing: MapReduce, Spark, Hive, PIG

NoSQL Databases: HBase

Programming Languages: Java, Python, Scala

Querying Languages: SQL, PL/SQL, HQL

Web Services: SOAP & RESTful Web Services

Development tools: SQL Developer, SQL Server Management Studio, SnowSQL, SOAP UI, Postman, Eclipse, IntelliJ

Application Servers: JBoss, WebLogic, WebSphere

Search Servers: Elasticsearch Server

Scripting: Linux/Unix Shell Scripting

Operating Systems: Ubuntu, CHD3, CHD5, Windows XP/7/8/10, Windows Server, Linux, Unix

Microsoft Office Suite: MS Word/Excel/PowerPoint/Outlook

Methodologies Used: Agile (Scrum), Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Informatica IDQ/MDM Engineer

Responsibilities:

• Installed and configured of Informatica Server, Domain and Services for Data Quality (IDQ) v10.4.1.
• Configuring Gateway Nodes and Worker Nodes
• Created backend database schema/repositories required for IDQ services
• Configured HTTPs for admin console, domain and all the informatica services
• Configured LDAP authentication and assigned required privileges to the users and user groups
• Installed and configured JBoss Application Server.
• Installed and Configured informatica MDM 10.4 HF 1 and Active VOS Server.
• Installed and configured Informatica MDM C360 Application
• Made necessary changes to JBoss and MDM properties files as per the requirements for the setup
• Installed and configured Elasticsearch server.
• Configured HTTPs for JBoss Application Server, AVOS Server, Hub Server, Process Server and Elasticsearch.
• Configured LDAP Authentication for MDM and MDM applications.
• Configured Address Doctor for IDQ and MDM.
• Applied the required population/identity match files as per the project fuzzy match criteria requirements.
• Installed Informatica Core Accelerator 10.4.1 and USA/CAN Accelerator 10.4 which added contents like rules, mapplets for address, phone, etc. to IDQ.
• Configured required connections with source and targets systems in IDQ for Extraction and Load processes.
• Conducted data analysis and data quality analysis, data model analysis, p-key source object analysis as needed.
• Created Physical Data Objects, performed Data Profiling on them, analyzed the profiling results and reviewed them with the business.
• Cleansing and Standardizing Name, phone, email, URL, address in IDQ.
• Configured mappings and mapplets as needed.
• Worked with different types of in-built standardizers like joiner, lookup, case converter, labeler, normalizer, parser, aggregator, expression, filter, custom java standardizers, etc.
• Extracted, Transformed and Loaded data from multiple sources to MDM Landing Tables using IDQ.
• Configured Landing, Staging tables for C360 Base Object entities.
• Configured source systems, trust scores and validation rules.
• Created mappings and used address doctor cleanse functions to cleanse and standardize address.
• Configured match path columns, match-key, and exact and fuzzy match rules as per the business requirements.
• Executed Stage, Load, Tokenize, Index, Match and Merge batch jobs.
• Configured additional custom attributes for MDM C360 Base Objects following the informatica guidelines.
• Configured provisioning tool like business entities, views, relationship entities, elastic search cluster, layouts for e360 page, etc.
• Conducted peer reviews during the process of development, designed test scenarios and conducted test sessions.
• Analyzed and reviewed datasets at different stages of integration with business and setting the expectations.
• Worked with Informatica support whenever required by raising cases or support tickets.
• Updated the informatica servers with patches and configuring additional drivers and properties for any additional functionalities.
• Participated in business meetings and strategy meetings to understand the problems, suggest the solutions and set the expectations.
• Worked with SIF APIs to perform any batch operations like creating, updating and deleting a record in base objects.
• Created roles and configured the privileges in MDM Hub.
• Created users in MDM for developers, businesspeople, etc. and assigned the appropriate roles when requested.
• Worked with sales team, financial team, Microsoft dynamics CRM team, Salesforce team, etc.
• Developed documents for installations, infrastructure configurations and changes, development work and production support (issues and solutions).
• Demonstrated IDQ and MDM capabilities, functionalities with proof-of-concept to the business.
• Reviewed the BVT datasets from MDM with stakeholders and business.
• Handling Production Support tickets, Change requests, etc.

Environment: s: Informatica MDM 10.4 HF 1, Informatica Server/DQ 10.4.1, MS SQL Server 13.0.x, 14.0.x; JBOSS EAP 7.2.0, Address Doctor 5, Provisioning Tool, Entity 360, Elastic Search, Active VOS 9.2.4.6, SOAP UI, Postman, Eclipse, Windows Server OS, Snowflake, Microsoft Dynamics CRM, Salesforce.

Confidential, Hillsboro, OR

Informatica MDM Engineer

Responsibilities:

• Assisted with MDM strategy, Process Design, high level MDM architecture requirement and the implementation plan.
• Collaborated with various businesses as well as technical teams for Development, Quality Assurance Testing, Production Support operations, etc.
• Designed, installed and configured Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Server, Cleanse Server and Resource Kit.
• Analyzed the raw data and developing a data model for Informatica MDM.
• Analyzed the data from different source systems and performing data profiling, data quality and data standardization.
• Configured the System and Trust scores based on the data and the input from the business.
• Created and configured the Landing tables and importing batch data region wise.
• Created and configured the Staging tables for multiple source systems.
• Configured Mappings and cleanse functions to transform and standardize the data during the Staging process.
• Worked with in-built cleanse functions and custom JAVA cleanse functions as well for data cleansing and data standardization.
• Performed the staging process by moving the data from landing tables to staging tables and analyzing the rejected records in the REJ table.
• Created and configured Base Objects and performed the loading process by loading the data from Staging tables to base objects.
• Configured Hierarchy and Hierarchy Manager to maintain the record level relationships.
• Configured the Queries and Packages for hierarchies and IDD.
• Used MDM Composite Services so that the real time transactional data directly flows into MDM.
• Configured Fuzzy and Exact Match keys, Match Columns and Match rule sets on Base Object.
• Configured the address doctor to the MDM. for address validation.
• Performed Tokenization process to create fuzzy tokens which help in the Match process.
• Performed Match and Auto-merge processes and reviewing the matched and unmatched data.
• Performance tuning the Match rule sets by analyzing the support tables for matched and unmatched data.
• Configured the Users and Roles for MDM and IDD.
• Configured users and assigning roles to the technical and business individuals depending on the business policies with valid approvals.
• Configured Business Entities, BE Views, transformations, Entity360 page layouts, etc. using Provisioning Tool.
• Configured Entity 360 view to display the data of the root node of the composite objects.
• Configured unique layout for a role using Entity 360.
• Configured IDD and Used Entity 360 to display the records that match the entity.
• Configured Message / Event Trigger, so that MDM sends a notification to the downstream systems whenever a new record(value) is created or updated in the MDM Base Objects.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Involved in Data Profiling using Informatica Data Quality (IDQ).
• Worked with and supporting the Active VOS workflows by promoting the pending x-refs whenever a workflow is faulted.
• Worked with shell script and windows scheduler to identify the Active VOS failed workflows and send an email notification to the team.
• Worked extensively with the upstream and downstream systems’ teams for understanding the requirements.
• Coordinated with other teams for conducting end-to-end testing.
• Coordinated with the offshore team and helping them understand the requirements and deliverables.
• Worked across with functional and operational teams to ensure continuous integration and continuous deployments of build and test systems.
• Handled and managed all the business processes and documentation for testing and change deployments.
• Worked with SOAPUI to use SIF APIs to perform required operations on the base objects.
• Worked as a Production Support Lead by resolving and handling all the incidents and change requests for the application.
• Querying the backend support tables to track the changes made to the records whenever required.
• Writing complex SQL Queries joining multiple tables when resolving the production tickets.
• Reviewing the MDM log files and providing information to the business whenever there occur errors or failures.
• Worked with JSON and XML file formats which are used for data transferring.
• Migrated the Java Code, MDM code to different environments like from Development to QA, then QA to Production.
• Provided end to end production support whenever required irrespective of time and day and continuous monitoring of the production environment and logs to avoid any major issues and to provide best and fast solutions to the errors / failures occurred.
• Worked as the main point of contact for Informatica MDM to Business in case of any questions or concerns.
• Attended the CAB meeting and making sure that MDM deployments does not affect any other teams and vice versa as well.
• Prepared detailed business documentation as well as technical documentation about the application for future reference and for knowledge transfer purposes.
• Prepared detailed documentation for production support activities which help to resolve the issues.
• Able to understand the concepts of Oracle Fusion which was used as a middle ware to move data from source systems to MDM to target systems.
• Worked with the business operation tools like VersionOne, JIRA, ServiceNow, etc.
• Worked extensively in the AGILE work environment.

Environment: s: Informatica MDM 10.0 & 10.3, Oracle DB, Address Doctor, IDD, Provisioning Tool, Entity 360, Active VOS, SQL, PL/SQL, Apache Nifi, Apache Kafka, Oracle Fusion, WebLogic, Java 1.7 45+, SOAP UI, Eclipse, WinSCP, Linux and Windows

Confidential, Atlanta, GA

Informatica MDM Consultant

Responsibilities:

• Installed and Configured Informatica MDM Hub Server, Cleanse Server, Resource Kit, Cleanse adapter, IDD and Active VOS BPM.
• Worked with ETLDevelopersin creating External Batches to execute mappings to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of InformaticaMDMHub.
• Created and configured Base Objects, associated staging tables, mappings and transformations as per business requirements.
• Configured mapping with cleanse functions including Address Doctor before running the stage job.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved in designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages inMDM.
• Configured hierarchy system tables and user defined tables and configured entity types and relationship types.
• Configured match paths, match columns, match rule sets and match rules according to the requirement.
• Used Data manager and merge manager tools under Data Steward workbench to manually merge and unmerge records.
• Configured Active VOS BPM withMDMIDD for One Step Approval Workflow process for Product (style hierarchy) approval by Managers/Data Steward team.
• Defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT). Configured match rule set property by enabling search by rules inMDMaccording to Business Rules.
• Increased performance and improved convenience for business users by configuring IDD.
• Integrated SIF and configured SoapUI code for API calls to access hub data.
• Developed Java code for User Exits and SIF.
• Developed XML scripts in SoapUI for cleaning staging tables and base objects as and when required.

Environment: s: Informatica MDM 10.1, Oracle 11g, Address Doctor, Informatica Power Center/Analyst 9.5.1, WebLogic, Java 1.7 45+, SOAP UI, Eclipse, Linux and Windows

Confidential, Irving, TX

Informatica MDM Consultant

Responsibilities:

• Involved in gathering business requirements for the MDM HUB configuration.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Implemented the Land Process of loading the customer Data Set into Informatica MDM Hub's Landing tables.
• Created and configured the Base objects, Staging tables, foreign key relationships, lookups, queries, packages and query groups.
• Configured Entity Objects, Entity Types, Hierarchy and Relationship Types for Contract, Product, Party Hierarchical view in IDD.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• 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 process on data.
• Reviewed all the supporting tables whenever required for change tracking of the data.
• Configured Supply Chain IDD Application for use by Data Stewards.
• Configured Subject Area Groups for Supplier, Manufacture, Product and Contract.
• Used Metadata manager for validation, promotion, importing and exporting the ORS repositories to Development, QA, Pre-prod and prod environment.
• Created mappings using Informatica Designer, Sessions & Workflows using Workflow Manager.
• Worked with ETL team to schedule Batch Groups for all the domains and are called via ETL workflows which calls corresponding MDM SIF API’s.
• Installed and configured JBOSS, Hub, Cleanse server, Address Doctor on Production.
• Worked with Informatica Support for MDM issues and upgrades
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role.
• Finally, Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Multi-domain MDM, SQL Server, IDD, Address Doctor, SOAP UI, Linux

Confidential

Informatica MDM Developer

Responsibilities:

• Installed and configured JBoss Application Server.
• Installed and Configured Informatica MDM Hub Server and Cleanse Server.
• Analyzed the data available in the data sources, performed the data profiling, understood the behavior of the data.
• Gathered the business requirements and needs and set the estimations.
• Designed data model as per the requirements.
• Configured source systems, Trust and also configured validation rules.
• Configured Landing Tables, Staging Tables ad Base Objects as per the designed data model.
• Configured Lookup / Reference tables.
• Configured relationships between parent - child base objects
• Configured hierarchies, queries and packages, etc.
• Configured Mappings, cleanse functions, standardization functions as per the requirements.
• Configured Fuzzy Match Keys, Match paths, Match Columns, Match Rule Sets, Fuzzy Match rules, Exact match Rules, Filtered Match Rules, etc.
• Performance tuned the match rules to get the desired output and meet the business needs.
• Created roles and assigned privileges for the roles
• Created Users and assigned roles in MDM for developers, data stewards, business users, etc.
• Configured Address Doctor in MDM for address standardization and validation.
• Performed Landing, Staging, Tokenization, Loading, Matching and Merging jobs.
• Analyzed the system tables and repos tables to review the data flow and batch processes in MDM.
• Worked with SAM tool in MDM to manage Users and roles.
• Worked with SIF APIs to perform batch operations as required.
• Prepared functional and technical documentation, installation documentation, presentations, test scenarios, etc.

Environment: Informatica Multi-domain MDM, Oracle Database, Address Doctor, SOAP UI, Linux.