Summary
Overview
Work History
Education
Skills
Languages
Languages
Timeline
Generic

Jitendra Sharma

Summary

Experienced Senior Tech Lead with 13+ years at Cognizant specializing in Informatica MDM and ETL/IDQ development. Proficient in software development, data integration, and data warehousing solutions. Skilled in Informatica PowerCenter, Oracle SQL, and performance tuning scripting for optimizing data flow efficiency. Adept at troubleshooting MDM solutions and consistently delivering results in high-volume projects.

Collaborative leader partners with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings.

Overview

14
14
years of professional experience

Work History

Manager Project - MDM/IDQ/ETL

Cognizant Technology Solutions
07.2023 - Current
  • Engineered Informatica IDQ solutions to overcome data quality challenges, enhancing ETL processes andimproving data accuracy
  • Experience working with AddressDoctor, External Data providers like D&B, StrikeIron tools
  • Hands-on in building and consuming web services from IDQ and Generate Data profiling Reports for concerned
  • Data sets
  • Experience in performance tuning of Informatica mappings and sessions to improve performance for the largevolume projects
  • Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow andevaluating transformations
  • Worked with Data architect to understand the Match needs, source system trust scores, data model and pre-landing/landing table structures
  • Configured Match & Merge process, Trust and Validations settings & provision IDD e360 screen
  • Worked in Secure Access Manager for enabling secure resources and Role settings for different users
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Creating landing tables, Staging tables and base objects
  • Involved in Independent Client Calls and presenting Daily Status report to client
  • Configuration of business rules configurations like trust settings, match and merge rules, involved in MDM Codemigration using Change List
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Created mappings to move the data to staging tables
  • Load the base objects and used Trust and Validation rules9764680017 jsharma3646@gmail.com linkedin.com/in/jitendra-sharma-23b52780/ India
  • Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD
  • Helped ETL Developers to create mappings with business rules to load data

Module Lead

Mphasis Ltd
03.2022 - 01.2023
  • Understand the business functionality of all the systems and understand the integration requirements
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Load the base objects and used Trust and Validation rules
  • Created mappings to move the data from landing tables to staging tables and Validating US & NON US
  • Addresses with help of MDM Address Doctor / IDQ Address Doctor
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Configuration of business rules configurations like trust settings, validation rules, match and merge rules
  • Experience in configuring MDM objects like landing, staging, base objects and cleanse functions
  • Configurations of reusable cleanse functions in Mappings
  • Configuration of business rules configurations like trust settings, match and merge rules and Delta detection isenabled logic

Assistant Manager

KPMG GLOBAL SERVICES PRIVATE LIMITED
12.2021 - 03.2022
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries,packages and query groups
  • Worked with Data architect to understand the Match needs, source system trust scores, data model and pre-landing/landing table structures
  • Created landing tables, base objects and stage and reference tables
  • Conducted analysis on the rejected records of the batch process and identify the root cause and resolve thesame
  • Experienced implementing data quality rules using Informatica DQ for a data mart or a data warehouse
  • Designed, developed, debugged ETL routines, MDM hub configurations, data quality services, and workflowsolutions
  • Experienced in data validation (pre and post-processing) for checking the accuracy and quality of data

Associate Tech Specialist

Tech Mahindra Ltd
02.2020 - 12.2021
  • Performing the data profiling on schema tables using Informatica Analyst tool and understanding the data
  • Involving in discussions with business people and technical supervisors to build requirements for the project
  • Worked on mapping spec to point out the data flow and relationships for the MDM schema
  • Building the party hierarchy data model and defining the relationships between entities in HM
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Creating landing tables, Staging tables and base objects
  • Involved in Independent Client Calls and presenting Daily Status report to client
  • Configuration of business rules configurations like trust settings, match and merge rules
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Created mappings to move the data from landing tables to staging tables
  • Load the base objects and used Trust and Validation rules
  • Worked with Informatica Data Director tool in set up, configuring and customizing data flow
  • Working knowledge of customizing screens, UI, business process and use of its metadata repository
  • Good experience in working on SQL Server and Oracle databases, stored procedures
  • Understanding of basic data modeling concepts and data flow, Understanding of data warehouse concepts
  • Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD
  • Helped ETL Developers to create mappings with business rules to load data
  • Experience in working with Informatica Data Director tool in set up, configuring and customizing data flow
  • Working knowledge of customizing screens, UI, business process and use of its metadata repository

Senior Consultant

Capgemini Technology Service India Ltd
12.2018 - 02.2020
  • Extracted the data from ETL tool and different source systems imported in oracle tables and transform the datato the landing tables
  • Configuration of business rules configurations like trust settings, match and merge rules
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Load the base objects and used Trust and Validation rules
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Created mappings to move the data from landing tables to staging tables
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Configuration of business rules configurations like trust settings, validation rules, match and merge rules
  • Experience in configuring MDM objects like landing, staging, base objects and cleanse functions
  • Configuration of business rules configurations like trust settings, match and merge rules
  • Configurations of reusable cleanse functions in Mappings
  • Experience in creating Informatica Mappings to load data in MDM tool
  • Experience in ActiveVOS workflow design, creation
  • Experience in managing ActiveVOS Central
  • Setup Identify Service on ActiveVOS Console
  • Deployment to ActiveVOS Console & Schedule ActiveVOS Automatic Processes

Sr. Software Engineer

Tech Mahindra Ltd
07.2017 - 12.2018
  • Data profiling all source tables for good understanding of the source data to build data quality rules
  • Worked with Informatica Data Director tool in set up, configuring and customizing data flow
  • Working knowledge of customizing screens, UI, business process and use of its metadata repository
  • Configured Informatica Data Director; design workflow customizations for Data Stewards using IDD
  • MDM model was implemented in agile methodology
  • Created mappings to move the data from landing tables to staging tables
  • Worked under the architects supervision to provide MDM technical services using Informatica technology
  • Involved in Independent Client Calls and presenting Daily Status report to client
  • Helped ETL Developers to create mappings with business rules to load data
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Creating queries, packages and working with data manager to create display packages and custom packages
  • Involved in match merging process by using exact match and fuzzy match logic types
  • Load the base objects and used Trust and Validation rules
  • Worked with the QA teams to create test cases and help them throughout the various stages of the testing cycles
  • Extracted the data from ETL tool and different source systems imported in oracle tables and transform the data to the landing tables

Sr. Software Engineer

Tech Mahindra Ltd
07.2014 - 06.2017
  • Utilized Informatica to transform and load data from various sources into Data Warehouse Targets, achieving data accuracy and reduction in processing time
  • Created Informatica mappings to build business rules to load data
  • Most of the Transformations were used like the Source qualifier, Aggregators, lookups, Filters, Update and
  • Sorter & Sequence Generator
  • Developing Informatica mappings & tuning them when necessary
  • Gathered and analyses client requirements
  • Optimizing Query Performance, Session Performance
  • Unit and System Testing of developed mapping
  • Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks
  • Performing Data consistency checks to maintain the Data Quality
  • Transferred knowledge to the new members joining the team
  • Analyzing and Fixing the Issues in case of Load failures
  • Data analysis for checking the correctness of data provided by clients
  • Documentation to describe program development, logic, coding, testing, changes and corrections

Software Engineer

IBM
02.2014 - 07.2014
  • Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica
  • Created Informatica mappings to build business rules to load data
  • Most of the Transformations were used like the Source qualifier, Aggregators, lookups, Filters, Update and
  • Sorter & Sequence Generator
  • Developing Informatica mappings & tuning them when necessary
  • Optimizing Query Performance, Session Performance
  • Unit and System Testing of developed mapping
  • Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks
  • Performing Data consistency checks to maintain the Data Quality
  • Transferred knowledge to the new members joining the team
  • Analyzing and Fixing the Issues in case of Load failures
  • Data analysis for checking the correctness of data provided by clients
  • Documentation to describe program development, logic, coding, testing, changes and corrections

Informatica Developer

Global Health Pvt ltd
09.2010 - 01.2013
  • As part of the overall Medanta the Medicity professional multi-channel strategy, a Campaign Managementcapability is required to provide Medanta the Medicity's customers with various promotional tactics and servicesacross channels
  • Medanta Management System creates campaign data that will be available to other systems
  • Design various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator
  • Joiner, Aggregator, and Expression rank transformation
  • Involved in the design of Informatica workflows for implementing the business logic for the model execution
  • Involved in the creation of parameter file dynamically through ETL Mapping for all directories like source, target,and session logs
  • Developed mapping parameters, target load plan and mapping variables while loading data from source totarget
  • Interact with the Technology service group for code Promotion from one environment to another environment
  • Responsible for implement the SQL query to retrieve the data as per business logic by using mappingparameters in staging tables to load the data into fact tables
  • Review of unit test cases and integration test cases of all the assigned modules
  • Involved in preparation of unit testing documents and test cases for ETL Mappings.

Education

Master of Computer Applications -

Indira Gandhi National Open University
Gorakhpur, India

Bachelor of Computer Applications -

Indira Gandhi National Open University
Gorakhpur, India

Skills

  • Informatica MDM
  • Provisioning tool
  • Informatica IDQ
  • Informatica PowerCenter (ETL)
  • Informatica Power Exchange
  • Database and Scripting Skills
  • Oracle ,SQL ,Data warehouse, Data warehousing, Data Modeling
  • Toad, Azure Data Factory, Athena, Airflow
  • Microsoft SQL Server
  • UNIX , Shell Scripting
  • Control-M

Languages

  • English, Hindi
  • Languages

    English
    Bilingual or Proficient (C2)
    Hindi
    Bilingual or Proficient (C2)

    Timeline

    Manager Project - MDM/IDQ/ETL

    Cognizant Technology Solutions
    07.2023 - Current

    Module Lead

    Mphasis Ltd
    03.2022 - 01.2023

    Assistant Manager

    KPMG GLOBAL SERVICES PRIVATE LIMITED
    12.2021 - 03.2022

    Associate Tech Specialist

    Tech Mahindra Ltd
    02.2020 - 12.2021

    Senior Consultant

    Capgemini Technology Service India Ltd
    12.2018 - 02.2020

    Sr. Software Engineer

    Tech Mahindra Ltd
    07.2017 - 12.2018

    Sr. Software Engineer

    Tech Mahindra Ltd
    07.2014 - 06.2017

    Software Engineer

    IBM
    02.2014 - 07.2014

    Informatica Developer

    Global Health Pvt ltd
    09.2010 - 01.2013

    Master of Computer Applications -

    Indira Gandhi National Open University

    Bachelor of Computer Applications -

    Indira Gandhi National Open University
    Jitendra Sharma