Etl Developer Resume
Columbus, OH
SUMMARY
- 7+ years of Information Technology Experience in building Data Marts and Data warehousing with Expertise in ETL tools Informatica Power Center.
- Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.
- Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets of Data Warehousing using ETL.
- Expertise in databases in Designing and developing the complex mappings from various Transformations like Oracle, SQL Server and MS - Access.
- Created complex mappings using Lookup, Joiner, Aggregator, Stored procedure, update strategy transformations.
- Good Exposure to Data warehousing concepts.
- Exposure to Various Domains like financial, medical, retail,insurance,and Banking.
- Extensive Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
- Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization. Experience in working with TOAD.
- Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
- Worked with team and as well as individually motivated.
- Excellent technical, logical, code debugging and problem solving capabilities and easy grasping of new things
TECHNICAL SKILLS
Operating Systems: MS-DOS, Windows NT, Windows 9x- 2k,XP.
ETL Tools: Informatica Power Center 9.1/8.6.1/7x,DataStage8.0.1
Database: Oracle, MS. Access, SQL Server, Visual FoxPro.
Languages: SQL, PL/SQL, HTML, C#.
PROFESSIONAL EXPERIENCE
Confidential, Minneapolis, MN
ETL Developer
Environment: Informatica power center 9.1,Oracle 11g/12i
Responsibilities:
- Developed mappings to load into staging tables and then to Dimensions and Facts.
- Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
- Created the Source and Target Definitions in Informatica Power Centre Designer
- Developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Update Strategy transformations.
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Created Reusable Transformations and Mapplets to use in Multiple Mappings.
- Modified existing mappings for enhancements of new business requirements.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
- Developed mapping parameters and variables to support SQL override.
- Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
- Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
Confidential, Columbus, OH
ETL Developer
Environment: Informatica power center 9.1/8.6.1,Oracle 10g/9i/8.0
Responsibilities:
- Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
- Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
- Extensively worked with Informatica - Source Analyzer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
- Performed extraction, transformation and loading of data from different sources like Flat Files, DB2 in accordance with requirements and specifications.
- Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
- Used Workflow manager to create and configure workflow and session task to load data.
- Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
- Involved in system testing, performance and System Integration testing stages of the project.
Confidential, Emeryville, CA
ETL Developer
Environment: Informatica power center 9.1/8.6.1,Oracle 10g/9i/8.0
Responsibilities:
- Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
- Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
- Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter,Aggregator,Store Procedure,Rank,Update Strategy, Router and Sequence generator.
- Created mapplets for reusing transformation logic in multiple mappings.
- Wrote the PL/SQL procedures for data extraction, transformation and loading.
Confidential, Houston, TX
ETL Developer
Environment: Informatica power center 8.6.1,Oracle 10g/9i/8.0
Responsibilities:
- Creating ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Marts and Data Warehouse.
- Understanding ETL basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation.
- Checking for missing data negatives and data consistency. Field-by-Field data verification can be done to check the consistency of source and target data.
- Creating reusable mapplets/transformations embedding business logic.
- Developing Mappings to load the data into Fact and Dimension Tables.
- Creating Unit Test Cases (UTC) for the Informatica mappings.
- Developing different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
- Playing a Role in Performance Tuning at Source Level, Mapping Level and Target Level.
Confidential, Pleasanton,CA
ETL Developer
Environment: Informatica7.x,Oracle 9i
Responsibilities:
- Created Informatica mappings, mapplets and reusable transformations.
- Designed and Development of Informatica mappings.
- Created various Transformations like Lookup, Joiner, Aggregate, Filter, Expression, Router, and Update Strategy.
- Performance tuning of mapping.
- Involved in preparation of unit test cases to perform testing of mapping.
- Preparation of ETL mapping documents