Mohit Raj

Mohit raj

bookmark on deepenrich
location of Mohit RajRiyadh, Saudi Arabia
Followers of Mohit Raj2000 followers
  • Timeline

  • About me

    Master Data Management and Data Governance Senior Consultant || Informatica MDM Developer || Informatica Axon, EDC || IDMC || CDGC || MDM SaaS

  • Education

    • Galgotia's college of engineering and technology

      2012 - 2015
      Bachelor’s degree computer science

      Activities and Societies: App Development, Website Development

    • Government polytechnic ranchi

      2008 - 2012
      Diploma computer science

      Activities and Societies: Sponsorship Team, Management Team, Annual Festive Management Team

  • 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

  • Licenses & Certifications

    • Ethical hacking expert(level 2)

      Techdefence pvt. ltd
      Oct 2012
    • Sql, web tech.(html,css,js)

      Qspiders - software testing training institute
    • Java j2ee

      Jspiders - india
      Aug 2015
    • Axon integartion

      Informatica
      Nov 2023
    • Hands on snowflake - web ui essentials

      Snowflake
      Jun 2020
      View certificate certificate
    • Aws certified solution architech - associate

      Udemy
      Jun 2020
      View certificate certificate
    • Data quality fundamentals

      Udemy
      Jul 2021
      View certificate certificate
    • Ethical hacking expert(level 1)

      Techdefence pvt. ltd
      Oct 2012
    • Java j2ee

      Ducat education
      Jan 2014