ETL/Informatica Developer Resume

SUMMARY:

ETL Developer experience in Software Development Life Cycle (SDLC) within Design, Coding Testing, Development and implementation of Data Warehousing/Data Mart. Extensive ETL experience with Informatica PowerCenter.
Excellent concepts with technical expertise in development, design of ETL for supporting data transformations and processing solutions.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

ETL/Informatica Developer

Perform root cause analysis on all processes in order to resolve production issues and validate all data.
Designed an inventory application that saved the company in labor costs.
Develop test and tune database code resulting in improved database performance maximizing the use of system resources for greater efficiency.
Work closely with project analysts to ensure that designs meet business and data requirements.
Create mapping documents to outline data flow from sources to targets.
Develop mapping parameters and variables to support SQL override.
Prepare migration documents to move the mappings from development to testing and then to production repositories.

Confidential

SQL Developer

Extracted and collected data to create needed reports.
Upgraded over 20 SQL servers to the latest service pack level in a 3 - month period.
Created and optimized diverse SQL queries as per business requests.
Improved vital processing jobs by reducing process duration by 60%.
Created complex mappings using Unconnected lookup, Sorter, Aggregator, newly changed dynamic lookup and Router transformations for populating target table in efficient manner.
Creating the Staging Area and loading raw data to cleanse it over there.
Developed mappings, sessions and workflows (ETL) for SCD types I and II to meet the above requirements.

Confidential

Junior SQL Developer

Validated accuracy of data to ensure database integrity.
Enrolled users, maintained system security, controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time.
Managed customer expectations proactively to maintain high satisfaction.
Ability to interface and communicate effectively with team members and provide the guidance in the development activity.
Created basic and aggregate levels of Fact Table mapping and optimized them for incremental Extraction and Aggregation using Parameters and variables to pass values during workflow execution.
Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads) performing Tuning of Sessions and Mappings.