SUMMARY

• Certified Informatica Master Data Management and Data quality practitioner with around 12 years of IT experience. Have been performing key roles in core Enterprise data management practices and leading the data management, quality and governance tasks for Insurance, Pharmaceutical and Manufacturing domains.
• Informatica certified Multidomain MDM 10.3: Developer, Specialist and single point of contact for all MDM and IDQ related effort in current assignment.
• Lead development initiatives in master data management, data quality and ETL space and contribute to data management solutions and proposals for multiple clients.
• Have successfully implemented 4 complete life cycles of MDM projects and multiple ETL and data quality assignments.
• Over the last 2 years working an engagement lead for the MDM and data governance tracks at large Insurance companies. Served as a single point of contact for the customers with respect to Enterprise Data Management tracks.
• Proficient in MDM Installation, Configuration and Administration in AWS EC2 RHEL7 Instance.
• Strong expertise in Informatica MDM Hub configurations, MuleSoft integration for landing data to MDM and publishing data out from MDM to Salesforce through BES endpoint API using MuleSoft and customizing/configuring Customer360 , E360, Informatica Data Director (IDD) applications and ActiveVOS approval workflows.
• Have been leading strategic proposals end - end and contributing to technical solution perspective in Data Management, DQ and ETL space. Play a key role in technical solution approach, effort estimation and approvals.
• Good knowledge in building Hierarchies , User Exits , configuring SIF APIs , JMS Message Queues for data consumption, working with Informatica Address Doctor to validate, transform and streamline Customer, Agent and Site addresses, worked with D&B data and utilising APIs to fetch D&B data for Match Merge rules and Customer360 views.
• Strong expertise in creating IDQ profiles , dashboards, Developer mappings , calling DNB web services , Automating Workflows and enabling notification on workflow status.
• Proficient with Informatica ETL Designer Components - Web Services Designer, Mapping & Mapplet Designer, SCD Type I/II/III mappings and Workflow Manager.
• Good Exposure on Tableau Desktop, AWS Cloud , Apache Hadoop Hive , Sqoop , HQL and Distribute Applications and HDFS. Expertise in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Strong skills in Core Java, Shell scripting , SQL, Control-M, UC4, UNIX , SAP BO and Data Warehousing Concepts.

TECHNICAL SKILLS

MDM Tools: Informatica MDM 9.7/10.2/10.3 HF1, Customer 360, IDD, E360, ActiveVOS

Big Data Technologies: HDFS, Hive 2.6/3.1, Sqoop, OOZIE

DQ Tools: Informatica Data Quality IDQ 10.2, Informatica Address Doctor

ETL Tools: IICS, Informatica 9.5.1/10.1.1 , SSIS, BODS

BI Tools: Tableau V8/V9, SSRS

DBMS: Oracle 10g/11g/12c, Teradata 13.0/14.0, SQL Server 2012

Operating Systems: UNIX, Windows 7/8, RHEL7

Programming language: Core Java, Shell Scripting, PL/SQL, HQL and SQL

Scheduling Tools: UC4, OOZIE and Control-M

Software Tools: Informatica AXON, Toad 11.2/12.0, Nexus 9.1, CA Rally, Microsoft TFS, QC10, SQL Developer, Tortoise SVN, GIT Lab

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica MDM Architect/Developer

Responsibilities:

• All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre-landing processing.
• Effectively managed off-shore and on-shore project teams and designed and developed MDM solutions for publishing and Incremental data loads.
• Performed requirement gathering, analysis, design development, testing implementation, support and maintenance phases of MDM and Data Quality aspects in the project
• Profiling data sets from different sources using IDQ and designed data quality rules, Trusted source systems and Match & Merge conditions
• Coordinated with MuleSoft integrations team to identify data elements to be loaded into MDM using SOAP calls.
• Created BES endpoint API using Provisioning tool to publish data out of MDM to Salesforce using MuleSoft middleware.
• Created Landing, Base Objects, Staging tables, cleanse functions, Mappings in HUB and configured Trust, Validation and Match & Merge processes
• Developed real time integration of data from different source systems using SIF APIs and loaded the data to MDM
• Validated and corrected address for all incoming Agency/Broker data using Pitney Bowes data cleansing integrators
• Worked with D&B data to fetch Corporate and Business Entities and DUNS number for Match and Merge rules and Customer360 views
• Created Match and Merge Setups like Match path, Match columns, and Match rules and tuning of Match Rules and created Packages for Customer360 screens
• Created JMS queues to send Insert/Update/Merged golden data elements out of MDM.
• Created Hierarchies and Merge manager configurations for Data Stewards and developed Post Staging User Exits
• Created Web services in IDQ for reference data to be accessed by different downstream source system
• Developed ActiveVOS one step approval workflow for all changes to Master records
• Worked on Repository manager for validating, promoting, importing and exporting repositories from development environment to testing environment and higher environments
• Developing Message Queues to push data into downstream applications with all the new and updated records
• Developed Customer360 views and layouts to present 360-degree view of Agency/Broker data
• Prepared test cases and code review document, debugging the defects identified and fixing them
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Confidential

Sr Informatica MDM Architect/Developer

Responsibilities:

• Installed and Configured Informatica MDM 10.2 HF1 in Dev, QA and Prod environments.
• Designed and developed MDM solution to master securities and Investment account data.
• Performed Admin role in designing access roles and user creation and data security for Informatica MDM.
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Worked on Informatica AXON to maintain business CDE and glossary for enterprise.
• Applied the DQ, Metadata rules and profiled the source and target tables data using IDQ
• Worked on different environments with different source and target databases like Hive, Oracle, Sybase IQ, and SQL server
• Created Sqoop HQL queries and loaded data from Hive to landing tables of Informatica MDM Hub and Sqoop scripts to import Golden records from MDM to Hive.
• Designed and created BO, staging tables, mappings, cleanse functions as per business requirements.
• Used Repository manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Created tasks in IDD assigned tasks to users and Data Stewards implemented Task managements and Workflows in ActiveVOS workflow engine.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Used Hierarchies tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.
• Created Shell scripts to automate batch processing for MDM and ETL jobs in Control-M