SUMMARY

• Has more TEMPthan 10+ years of IT experience wif expertise in Architecting, Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling, and support for Data warehousing applications.
• 8+ years in Master Data Managementconcepts, Methodologies, and ability to apply this noledge in building MDM solutions.
• Experienced in Installing, Managing, and configuring Informatica MDM core component such asHub Server, Hub Store,Hub Cleanse,Hub Console, Cleanse Adapters, HubResource Kit.
• Experience in defining and configuring landing tables, staging tables, base objects, lookups, query groups,queries/custom queries, packages, hierarchies and foreign - key relationships,
• Expertise in Informatica MDM HubMatch and Merge Rules, Batch Jobs and Batch Groups.
• Designed &developed multiple cleanse function, Graph functionand standardization scenarios using Address Doctor.
• Configured JMS Message Queue in teh MDM hub Console.
• Configured Soap based SIF API calls by using Soap UI for performing multiple tasks in Informatica MDM Hub.
• Practical noledge on Git, AWS, Docker, Chef, Jenkins, Linux, Python, Java, Teradata, MySQL, Oracle and scripting.
• Used Python scripts to update content in teh database and manipulate files.
• Worked wif team of developers on Python applications for RISK management.
• Experience in configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool.
• Successfully, setup teh data and configured teh components needed by Hierarchy Manager for MDM HUB implementation which included implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Developed workflows to data domains for performing data extraction, data validation, data cleansing, data match, data load and required data related activities to support Customer’s MDM requirements.
• Experience in several facts of MDM implementations including Data Profiling, data migration, validation, reject processing and pre-landing processing.
• Experienced in troubleshooting installation issues, production issues and production support for projects.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.
• Involved in business requirement versus Technical specification documents.
• Worked wif Onsite- Offshore Model to delegate teh work and report it to customer.

PROFESSIONAL EXPERIENCE

Confidential, Mahwah, NJ

Senior Informatica MDM Consultant

Responsibilities:

• Led effort for gathering business requirements for teh data-warehouse as well as business-intelligence reports to be used by teh management.
• As an onsite lead I use to manage teh team from onshore.
• Point of contact from teh client perspective to gather teh requirements from client team and assign teh tasks to offshore resource.
• As a onsite lead use to create teh estimations for teh respective tasks and share teh same wif teh client.
• Did teh proof of concept to install and configure Informatica MDM 10.x on Azure Cloud.
• Did few test cases development to validate Informatica MDM 10.x on Azure Cloud.
• Did teh POC wif Salesforce Integration as part of Business Requirement.
• Work wif Architect in mapping teh different data sources like Dynamics CRM analyze teh data consistency and patterns
• Involved in implementing teh Land Process of loading teh customer data set into Informatica MDMHub that was coming from various source systems.
• Hands on executing MDM hub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups.
• Designed SQL Queries to pull out teh data which must be Matched & Merged coming from all teh source systems according to match & merge rules setup (to make sure consolidation process is configured).
• Used Informatica Power center and Power Exchange to extract, transform and load data from heterogeneous systems (Oracle EBS, Mainframe systems, flat files, SQL Server) to Staging and Data warehouse (MDM).
• Configured Match and Merge Rules in improving teh data quality by match analysis, analysis of teh MDM system performance and tuning teh performance by changing teh existing cleanse function, match rules etc.
• Developed Informatica Rest API connectors for ServiceNow and MS Dynamics.
• Created API Task Process to integrate MS Dynamics to ServiceNow.
• Use PostMan to develop/test Rest API process.
• Worked on IDD UI configuring subject areas for Customer Domain that assisted to search and edit master records that enabled client wif their sales process transformation
• Integrated ActiveVos in teh workflow manager as a primary workflow engine and working on a POC to get to no its functionality.
• Developing mappings using various cleanse functions and Address doctor functions to move data into Stage tables
• Worked on XML Parser transformation to read teh XSD file and build teh source definition and accordingly to read teh XML source file.
• Created Match Paths, Match Columns for Match and Merge Process in MDM.
• Defining Trust Score, Validation rules, Match rules and Merge settings
• Performed production support activities in Data Warehouse (Informatica) including monitoring and resolving production issues, pursue information, bug-fixes and supporting end users.
• Published teh records to downstream applications wif halp of ETL power center wif teh halp of message Queue.
• Created User exit features extending teh functionality and features of MDM HUB.
• Design and development test scenarios for unit and integration testing, as well as positive and negative testing and generating teh test data as per test cases.
• Preparation of test cases and code review document, debugging teh defects identified and fixing them.
• Updating teh code into production wif proper version.
• Configured IDD and Entity 360 application for teh Business users to create/update/read teh Wells, Boreholes and Fields
• Developed MDM WebServices application to publish teh Wells from MDM to SAP and tan update teh wells back in MDM using SIF APIs in Java Spring Boot application
• Created Business Entity Services External calls using Java and configured teh WSDL and SOAP Calls to add validations for business users in Entity 360.
• Configured Smart Search for teh business users to search and update teh records in Entity 360.
• Developed AVOS Business Entity tasks and displayed teh tasks assigned to each logged in user in Entity 360 start page.
• Configured teh Smart Search and Entity 360 in IDD for Product MDM.
• Worked closely wif teh Data Integration team to perform validations both on teh Informatica MDM hub and Entity 360.
• Modified MDM hub user exit and custom JAVA cleanse functions as per teh business requirements.
• Developed standalone java projects to implement business rules.
• Working noledge of java and eclipse based products (infrastructure product would be best, but prior experience supporting any product would halp).
• Responsible for ingesting large volumes of IOT data to Kafka.
• Wrote Kafka producers to stream teh data from external rest APIs to Kafka topics.
• Used Spring Kafka API calls to process teh messages smoothly on Kafka Cluster setup.
• Implemented Spring boot microservices to process teh messages into teh Kafka cluster setup.
• Has noledge on partition of Kafka messages and setting up teh replication factors in Kafka Cluster.

Environment: InformaticaMDM10.2,InformaticaDataDirector10.0,InformaticaActiveVos 9.2,InformaticaPower Center 10,Azure, Jboss 5.0, Oracle 12c, SQL Developer, Address Doctor 5, IDQ 9.5

Senior Informatica MDM Consultant

Responsibilities:

• Interacted wif teh Business Users & Enterprise Data Architects in teh analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets teh business requirements and supports teh product capabilities.
• Performed data profiling of reference data for large data sets using Informatica Data Analyst tool.
• Worked w/ ETL team in configuring teh landing tables' structure according to standardization of teh Client.
• Configured Base Object Tables in schema and relationship tables in hierarchies according to data-model.
• Configured Landing Tables, Staging Tables, Look- Confidential, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.
• Configured Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, query groups, packages and custom cleanse functions.
• Defined System Trust and Validation rules for base object column.
• Worked in implementation of Profiling, Score Card, Classifier models, Probabilistic models, Human task and Exception record management as part of IDQ process.
• Experienced in customizing error messages displayed on teh IDD screen.
• Configured Search Strategy, Match rule sets, Match Columns for Match and Merge Process in improving data quality by match analysis.
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS.
• Created Queries, Query Groups and packages in MDM Hub Console.
• Configured Informatica Data Director (IDD) in reference to teh Data Governance of users, IT Managers & Data Stewards.
• Used Metadata manager for validation, promotion, importing and exporting teh ORS repositories to different environments.
• Performed testing on data validation, Batch Jobs and Batch groups.

Environment: Informatica MDM 9.5.0, Informatica MDM Data Director 9.1.0, Informatica Data Quality (IDQ) 9.5.0, Informatica Power Center 9.1.0, AQT 9.0, Erwin Jboss, HP Quality Center 9.2, Windows XP.

Confidential, Richmond, VA

Senior Informatica Administrator/Developer

Responsibilities:

• Performed Informatica administration wifin DEV, TEST, PROD and DR environments for both dedicated and multi-tenant client deployments.
• Configured High Availability, Setup grid environment & upgraded repositories from 8.x to later versions.
• Built and maintained Informatica Data Exchange/Data Transformation (DX/DT) environments.
• Installed / configured IDQ 9 components (Content Basic, Content Accelerator & Content MO).
• Scheduled Informatica jobs. Monitoring, troubleshooting, and optimizing teh entire Data Warehouse system stretching from teh source data to NetApp storage (I/O).
• Created and maintained Nodes and Grids. Configured Master Node and Backup Nodes under High Availability Environment.
• Involved in creating a project of 500 + table in HDFS and schedule using tidal scheduler.
• Customized teh standard Informatica Meta Model to accommodate a full range of metadata as defined for teh collection and storage of enterprise Metadata.
• Worked wif Teradata SQL statements for storing, retrieving, and manipulating data in a relational database.
• Performed Informatica capacity planning and ongoing monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed to comply wif SLAs and avoid impacting users.
• Worked wif Control M for creating Batch Jobs and monitor Jobs in Batches.
• Provided Informatica Application Support such as troubleshooting teh issues for workflow failures.
• Created and maintained users, groups, roles and privileges and assigned them to user groups.
• Provided 24/7 supports for teh applications and databases. Optimized nightly ETL jobs to meet SLA.
• Scheduled Informatica sessions and work flows using Control M.
• Schedule daily backup of Informatica environment, restore Informatica environment when required.
• Coordinated wif Informatica global support team to resolve outstanding issue wif Informatica Installations and Performance issue.
• Monitoring Informatica Servers and apply hot patches.
• Create automated scripts for migrations and clean up metadata components needed as part of maintenance.
• Binding user to database connections, Installing and configuring Hot Fixes and Emergency Bug Fixes.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Created documents and manuals for Informatica Installation, Configuration, Migration procedures ETL Architecture and Naming Standards.
• Trained people on Informatica PowerCenter 8.6 on Administration and Development.
• Extraction, Transformation and Loading of teh data using Informatica.
• Designed teh target load process based on teh requirements documents.
• Developed SCD Type 1/2/3 mappings.
• Develop Mappings and Workflows to load teh data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading teh data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Involving in extracting teh data from Oracle and Flat files.
• Implemented performance tuning techniques by identifying and resolving teh bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding teh Functional Requirements.
• Create users, groups and assign permissions in informatica Adminconsole.
• Created connections and folders in Repository manager.
• Deployed Objects from dev to QA and PROD.
• Startup and shutdown teh Informatica services.
• Creating ODBC and Oracle connection in Workflow Manager.
• Creating teh documents for RCA.
• Developing, Testing and debugging teh mappings in Informatica.
• Preparing teh documents for test data loading.

Environment: Informatica MDM 9.1, Informatica Power Center 9.1,8.6, Flat Files, Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, Windows XP, SQL Server 2008, Unix.