Experience

• 

  Bharat sanchar nigam limited

  Oct 2011 - Nov 2011

  Internship
• 

  Saffron e-services

  Jun 2014 - Jul 2014

  Summer internship

  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.

• 

  Jspiders - india

  Aug 2015 - Mar 2016

  Java trainee
• 

  Cognizant

  Apr 2016 - May 2019

  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. Show less Project Name: McAfee Prod OBI BW & MDM Skill 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). Show less • 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. Show less

  • Associate

    Apr 2019 - May 2019

  • Program Analyst

    Jul 2016 - Mar 2019

  • Program Analyst Trainee

    Apr 2016 - Jul 2016
• 

  Itc infotech

  May 2019 - May 2021

  Associate it consultant

  • 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. Show less

• 

  Htc global services

  May 2021 - Jan 2024

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

  • Associate Manager

    Feb 2023 - Jan 2024

  • Senior Engineer

    Oct 2022 - Feb 2023

  • Senior Engineer

    May 2021 - Sept 2022
• 

  Aielements

  Feb 2024 - now

  Senior data governance and mdm consultant

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