SUMMARY

• 6+ years of experience in Informatica MDM, Informatica Power center, IDQ, Oracle and data warehouse.
• Experience leading an offshore and onshore team
• Onshore Customer facing experience as team as well as single source.
• Hands - on experience in implementing end to end MDM solutions from scratch.
• Having Experience in Informatica MDM. Design, develop, test and review & optimize Informatica MDM (Siperian).
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties.
• Expertise in Batch viewer jobs and Batch Group creation, auto command batch execution and scheduling.
• Expertise in Provisioning tool/IDD and Business Entity creation and customization queries, Packages and relationships etc.
• Expertise in SIF services implementing and testing in SoapUI.
• Expertise in BES Both SOAP and REST services with JSON and XML coding for BES composite services like WADL/WSDL in SoapUI and creating documentation.
• Expertise in REST services JSON coding.
• User exists development by using eclipse.
• Having experience in Message queue & Address Doctor configuration.
• Pleasant experience on Technical Document Design for end to end review and all kind of documentation for development implementations.
• Configuring Informatica Data Director (IDD), Provisioning UI, Entity 360 and Customer 360 to meet Data Governance objectives in many project life cycles.
• Migrating the code between different enviornments and supporting offshore Java and Etl teams.
• Having experience in IDQ developer, analyst and administrator tools, such as IDQ installation and administrator configurations and loading data from Flat files and from different databases.
• Working experience in IDQ mappings, workflows, sessions and applications and Platform staging configuration etc.
• Worked on scheduling the jobs from IDQ administrator, Running and monitoring the jobs from IDQ.
• Involved in analyzing the data by using IDQ profiling in developer as well as analyst tool.
• And involved in Power center mappings and session workflow creation and data loads for MDM prospective etc.
• I was trained and having experience on Agile methodology and Jira dashboard.
• Having experience in training internal and giving KT for client team.
• Trained on Informatica Cloud Real Time (ICRT) integration.
• Excellent communication, interpersonal, analytical and technical skills.

TECHNICAL SKILLS

Tools: Informatica MDM, Power Center and IDQ

Servers: Web logic and JBoss Server

Supporting Tools: Remedy, Fresh Desk and Service now

Process Tools: JIRA, Monday

Data Modelling: Microsoft Visio

Languages: Json, Restfull, SIF and SOAP

PROFESSIONAL EXPERIENCE

Confidential

Software Specialist

Responsibilities:

• Handling as a single resource for end development and support for MDM solution.
• Exclusively working from POC to requirement gather, planning, uat, Deployment end to end in all three technologies I;e Power center and IDQ and Informatica MDM and Provisioning tool.
• Sole responsible for MDM development and support.
• Working on IDQ Profiling, Mapping administrator configuration, migrations and scheduling jobs etc.
• Power center development and support for MDM requirements.
• Active vos support and co ordinating with business.
• SIF real time integrating for downstream system to ingrate real time data loads.

Confidential

Software Developer

Responsibilities:

• Developing POC as per the major challenges faced by the customer.
• Developing MDM solutions like creating landing, staging tables, base object and queries and packages.
• IDQ Implementation.
• Developing ETL (PoweCenter) solutions.
• Documentation of landing, staging, mappings and JSON code.
• Migration tasks from one environment to the other.
• Preparing for the initial/incremental loads along with the reference lookup data.
• Configuring Match and Merge rules.
• Hierarchy configuration.
• Provisioning UI implementation such Business entity creation and customizing.
• Creating SIF and BES composite services in both SOAP and REST calls i;e WSDL and WADL.
• Creating, update, searching and matching & merging data in Customer 360 .
• Helping the testing team to execute the test cases for loaded data in Customer 360.
• Collaboration with the clients spread across geographies and sharing the knowledge on daily basis and giving KT to internal team.

Confidential

Software Consultant

Responsibilities:

• Create Landing, staging and Base Objects.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Using Informatica MDM Hub to run Batch jobs
• Loading data from Informatica MDM Landing to Stage
• Configuring the mappings between landing to staging and applying cleanse functions.
• Define requirements for data matching and merging rules, and data stewardship workflows.
• Provided Trainings to Team members.
• Designing data hierarchy management for Informatica MDM.
• Technical document design.
• Executing jobs in Batch Viewer and Batch Group.
• The Mappings were Unit tested to check for the expected results.
• SIF services and troubleshooting and sending report to the concern team if any job fails and analyzing the errors and rejected reasons.
• User groups and roles creating and assigning to groups.
• Migrating one ORS to another ORS.
• Loading the reference data through data manager.
• Creating queries and packages and customization and privileges for IDD.
• IDD Configuration and migration and design.

Confidential

Informatica MDM Offshore Lead

Responsibilities:

• Responsible for offshore MDM deliverables.
• Create Landing, staging and Base Objects.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Using Informatica MDM Hub to run Batch jobs
• Loading data from Informatica MDM Landing to Stage
• Configuring the mappings between landing to staging and applying cleanse functions.
• Define requirements for data matching and merging rules, and data stewardship workflows.
• Provided Trainings to Team members.
• Designing data hierarchy management for Informatica MDM.
• Technical document design.
• Executing jobs in Batch Viewer and Batch Group.
• The Mappings were Unit tested to check for the expected results.
• SIF services and troubleshooting and sending report to the concern team if any job fails and analyzing the errors and rejected reasons.
• User groups and roles creating and assigning to groups.
• Migrating one ORS to another ORS.
• Loading the reference data through data manager.
• Creating queries and packages and customization and privileges for IDD.