Informatica Cloud Data Governance and Catalog, MDM SaaS, CGDC, IDMC, CDI, CAI, CDQ, Data Profiling, Metadata Command Centre

Project Name: Riyad Bank EDMClient: Riyad BankInformatica Axon, EDC, Informatica MDM

• Understanding Business requirements and mapping them into technical terms.• Designed and created BO, staging tables, transformations as per business requirements.• New Development Project from scratch.• Defined and configured schema, staging tables, and base objects foreign-key Relationships, • 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.• Worked on Informatica PowerCenter mappings.• Tested Informatica code and validated results.EnvironmentInformatica MDM 10.3, Informatica Power Center 9.6.1, Provisioning Tool, IDQ, SQL Developer, PostMan.

Project Name : McAfee MDM - Intel SecurityCompany : Cognizant Technology Solutions, BangaloreRole: Informatica MDM DeveloperProject DescriptionMDM Solution provides master records with an eye to ensuring that systems like SAP, SBL, SFC and DNB can benefit from a single version of truth and its relationships, thereby optimizing performance, minimizing risk and enhancing data governance. Solution is based on Informatica MDM and Real Time Synchronization with applications through SIF. Mainly we were dealing with Accounts and prospect account of McAfee marketing.Responsibilities• Understanding Business requirements and mapping them into technical terms.• Impact analysis due to changes or issues.• Preparing insert scripts for reference data load and loading the data to the ref base objects.• MDM Application health checks monitoring.• Responsible for resolving tickets and communicate same to users.• Performing unit testing.• Nullifying the defects, troubleshooting, providing technical and business support to other downstream systems.• Involved in real time error debug and handling batch jobs.EnvironmentInformatica MDM 10.1, Informatica Power Center 9.6.1, SQL Developer.

Project Name: McAfee Prod OBI BW & MDM - Dec 2016 - till dateSkill Set - Informatica MDM 10.1,PL/SQL, Oracle SQL,Java,Informatica PowerCenter 9.6.1, IDDUnix FundamentalsROLES AND RESPONSIBILITIES:-⦁ Informatica and Oracle Developer⦁ Involved in Analysis, Database Design, Coding and Implementation⦁ Worked on Informatica MDM Hub configurations - Data modeling Data Mappings(Landing, staging and Base Objects), Data validation, Match and Merge rules, writing andcustomizing user exits using Java and Service Integration Framework (SIF)⦁ Designed and developed SQL Queries, views, materialized views, PL/SQL packages,stored procedure, functions and database triggers⦁ Developed Informatica ETL mappings, Extract and Transform data with business rules,Sessions, mapplets and workflows⦁ Created UNIX shell scripts, SQL Scripts and windows batch scripts for custom reportsand job processing.⦁ Worked as a primary developer and developed codes for many data sources.⦁ Understanding Clients Requirements and mapping them to Business Requirements through Detailed Design Specifications.⦁ Used Informatica ETL to create PRE-LANDING Mappings and Workflows to extract Account and Prescriber data from 3 data sources and applying business transformation andvalidation rules in the Mappings.⦁ Created STAGING Mappings and Cleanse Lists to map data from LANDING to STAGING Tables.⦁ Leading day to day support activities from offshore. Coordinating with Business teams for variousissues.⦁ Leading weekly customer calls to discuss ongoing issues and plan future enhancements.⦁ Maintain code, release documents in central repository (SVN).

• Successfully completed 3 months trainee program for corporate offices and the FF trainee program in Big Data development & Testing.• Completed CCA Certification in Informatica.• Learnt ETL concepts, Informatica and Teradata within the Cognizant Academy.• Successfully completed the assessments for SQL, Informatica, Teradata and UNIX.• Completed designing and mappings in Mapping Designer in Informatica for the project allocated.Project Name:- Investors Bank (Enterprise Data Warehouse for Investors Bank) - June 2016 - December 2016Skill Set :- Informatica ETLBig Data TestingBig Data and HadoopANSI SQL BasicsData WarehouseCCA CertifiedInformatica Skill CertificationUnix FundamentalsTera DataAcceptable USe Policy (AUP)Project Description:-Aims to capture requirements for the project and the system “Enterprise Data Warehouse for Investors Bank” to be developed.The Enterprise Data Warehouse for Investors Bank is an independent software system developed to store the history on all activities happening in five departments of the bank – savings accounts, credit cards, loans, investments and insurance.Retrieve the information from flat files and stores it in the Datamarts. SCD2 is applied on every dimension- credit card, insurance, investment, loan and account.New data is received as a source for transaction fact.All the requirements are solved using explicit mapping for each requirement.

Worked on the project "MY TUBE" using JAVA Technology. Where anyone can watch, upload, and download videos. The project is YouTube Clone. It can be further extended as a on-line virtual e-learning platform.