Etl Lead Resume
3.00/5 (Submit Your Rating)
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 .