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
Sr. Executive Support at Cognizant technology Solutions, Cognizant Technology SolutionsSr. Executive Support at Cognizant technology Solutions, Cognizant Technology Solutions