We provide IT Staff Augmentation Services!

Etl Lead Resume

Mason, OhiO

EXPERIENCE SUMMARY:

  • Almost 12 years of experience in Information Technology industry, 9 years with Confidential and 2.5 years with CMC Limited including ETL, Master Data Management (MDM) and the various tools/utilities associated with it.
  • Having great knowledge of working in the Analysis, design, development, testing and Implementation of Business Intelligence solutions, Maintenance, Production Support of various Healthcare domain projects and Life Science domain projects.
  • Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Possess diversified technical background having good knowledge on Software Development Life Cycle (SDLC), Production Environment handling, Data Migration etc.

COMPUTER KNOWLEDGES: -

ETL : Informatica Power Center 9.6.1 & 10.1

MDM Tool: Informatica MDM 9.5.1

Databases: Oracle 10g, 11g &12c

Other Skills: SQL, PL/SQL, Toad, SQL Developer

Unix: Unix - Shell Script

WORK EXPERIENCE:

Confidential

ETL Lead, Mason, Ohio

Operating System(s): Unix, Windows

Responsibilities:

  • Understand the Functional requirement and Business Rules to create Technical Design Doc
  • Design and Develop the ETL process
  • Delivered Analysis, Design, Coding & Unit Testing of ETL and database components
  • New source System Data Analysis to integrate into MDM.
  • Implemented new source Confidential to the existing MDM system.
  • Involved in building the ETL architecture and Source to Target mapping to load data.
  • Extracted the data from the flat files into staging area and populated onto Member DB.
  • Used existing ETL standards to develop these mappings.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Performed technical and functional reviews for all test cases.

Confidential

ETL Lead

Operating System: Unix, Windows

Responsibilities:

  • Understand the Functional requirement and Business Rules to create Technical Design Doc
  • Design and Develop the ETL process
  • Delivered Analysis, Design, Coding & Unit Testing of ETL and database components
  • Source System Data Analysis to integrate into MDM.
  • Involved the ETL architecture and Source to Target mapping to load data.
  • Extracted the data from the flat files into staging area and populated into MDM.
  • Used existing ETL standards to develop the mappings.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Performed technical and functional reviews for all test cases.

Confidential

ETL Lead

Operating System(s): Unix, Windows

Responsibilities:

  • Understand the Functional requirement and Business Rules to create Technical Design Doc
  • Design and Develop the ETL process
  • Delivered Analysis, Design, Coding & Unit Testing of ETL and database components
  • New source System Data Analysis to integrate into MDM.
  • Implemented new source GBD Facets to the existing MDM system.
  • Involved in building the ETL architecture and Source to Target mapping to load data.
  • Extracted the data from the flat files into staging area and populated onto MDM.
  • Used existing ETL standards to develop these mappings.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Performed technical and functional reviews for all test cases.

Confidential

Technical Lead

Operating System(s): Unix, Windows

Responsibilities:

  • Understand the Functional requirement and Business Rules to create Technical Design Doc
  • Design and Develop the ETL process
  • Delivered Analysis, Design, Coding & Unit Testing of ETL and database components
  • New source System Data Analysis to integrate into MDM.
  • Implemented new source FADB and VEEVA to the existing MDM system.
  • Involved in building the ETL architecture and Source to Target mapping to load data.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto MDM.
  • Used existing ETL standards to develop the ETL mappings.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Performed technical and functional reviews for all testing cases.

Confidential

MDM Lead

Operating System(s): Unix, Windows

Responsibilities:

  • Understand the Functional Design and Business Rules to create Data Model and Technical Design Doc
  • Design, Develop and Test ETL batch components
  • Delivered Analysis, Design, Coding & Testing of ETL, MDM & PL/SQL components
  • HCO and HCP source System Data Analysis to integrate into MDM.
  • Implemented new sources to the existing MDM system.
  • Match Rule Tuning for new Managed/Non-Managed Accounts.
  • Better Cleansing for new Account attributes in party.
  • Performed system and UAT testing and created test scripts.
  • Performed technical and functional reviews for all testing functions.
  • Knowledge transferred to ADM Support team.
  • Created new cleanse functions to cleanse and standardize the Source system.
  • After source Data Cleansed, compared the data and proved that data is significantly more improved after cleansing.
  • Analyzed the standardized addresses and proved with statistics that addresses are more standardized and clean.
  • Configured and tuned Match Rules and Validation Rules
  • New Best source address data are routed to downstream systems.
  • Worked with different transformations to implement the business logics. Transformation like Source/Target Transformations, Lookup transformation, Stored Procedure transformation, Expression Transformation, Joiner, Aggregator, sorter, Normalizer, Rank and Sequence Transformations are extensively used
  • Tuned the existing mappings for improving the load time
  • Found the bottlenecks for the existing mappings to improve the performance of the mappings

Confidential

Technical Lead

Operating System(s): Unix, Windows

Responsibilities:

  • Understand the Functional Design and Business Rules to create Data Model and Technical Design Doc
  • Design, Develop and Test ETL batch components
  • Delivered Analysis, Design, Coding & Testing of ETL & PL/SQL components
  • HCO and HCP source System Data Analysis to integrate into MDM.
  • Implemented new sources to the existing MDM system.
  • Performed system and UAT testing and created test scripts.
  • Performed technical and functional reviews for all testing functions.
  • Complete Source System Data Analysis to integrate into MDM.
  • Ran Batch process to load Source Affiliation data to MDM .

Hire Now